About the Astra Block data model
Data model overview
Each supported blockchain has an accompanying dataset stored in the primary Astra Block database. A dataset contains all of the data from the associated blockchain’s entire history through to the present moment. This data is stored within a set of table schemas that have been evaluated and tested by DataStax to conform to a data model that is ideal both for querying blockchain data and for leveraging the capabilities of Astra and its underlying Cassandra architecture.
The table schemas within a dataset have been specifically tailored to best suit the dataset’s associated blockchain. Therefore it can be said that each dataset has its own data model. When a Block-enabled database is created, it gets automatically configured with the table schemas of the selected dataset.
How to use this page
The rest of the top-level sections on this page are organized by blockchain dataset. Within each of these sections you’ll find descriptions of the dataset’s table schemas and how those schemas support the data model. Example queries are also provided to show how you might query each table.
The following blockchain datasets are described on this page:
The table schemas for each dataset have been included on this page for reference purposes. You do not need to create these tables since Block-enabled databases are pre-configured with all of the necessary tables already created for you. |
Using query examples
Several CQL query examples are provided on this page to help you start using your blockchain data. The Astra CQL Console provides a quick and easy way to experiment with running these queries.
-
Log into the Astra Portal.
-
Click Databases in the left-hand navigation menu and navigate to your Block-enabled database.
-
Click the CQL Console tab.
-
At the
cqlsh
prompt, set the keyspace for the current session (in this caseethereum
).USE ethereum;
-
Copy an example query from one of the sections below and paste it into the console to see the results.
-
(Optional) To make query results easier to read within the console, you can configure the shell to format results vertically by running the following command:
EXPAND ON;
All subsequent queries that you run during the current session will now have their results formatted vertically.
Ethereum data model
The Ethereum dataset contains the following table schemas:
Assets
This table is designed for monitoring user and contract token balances over time. The primary key is the address of a wallet or contract address.
Two rows are inserted into the assets table anytime there is ether sent in a transaction or an erc20, erc721, or erc1155 token transfer takes place. A row is created for the address sending the token and a row for the address receiving the transaction. The balance parameter in this table is a historical snapshot of the user’s balance at the block where the transaction took place.
CREATE TABLE ethereum.assets (
address text,
token_address text,
token_id text,
block_number bigint,
transaction_hash text,
log_index bigint,
balance text,
is_contract boolean,
token_name text,
token_standard text,
PRIMARY KEY (address, token_address, token_id, block_number, transaction_hash, log_index)
) WITH CLUSTERING ORDER BY (token_address ASC, token_id ASC, block_number DESC, transaction_hash ASC, log_index ASC);
Example queries
-
Query
-
Result
SELECT * FROM assets where address='0xa53a13a80d72a855481de5211e7654fabdfe3526' LIMIT 1;
@ Row 1
------------------+--------------------------------------------------------------------
address | 0xa53a13a80d72a855481de5211e7654fabdfe3526
token_address | 0x0000000000000000000000000000000000000000
token_id | 0
block_number | 16580615
transaction_hash | 0x63fdf3d5caef8be475992c0cbb022ebba648709ee2866978224864cfd30045e3
log_index | -1
balance | 1001086683542075852
is_contract | False
token_name | ether
token_standard | null
(1 rows)
Block numbers by date
Given a date written as YYYY-MM-DD, you can query the block numbers that occurred on that date.
CREATE TABLE ethereum.block_numbers_by_date (
date date,
block_number bigint,
block_timestamp timestamp,
PRIMARY KEY (date, block_number)
) WITH CLUSTERING ORDER BY (block_number DESC);
Example queries
-
Query
-
Result
SELECT * FROM block_numbers_by_date WHERE date='2023-01-27' ORDER BY block_number ASC LIMIT 1;
@ Row 1
-----------------+---------------------------------
date | 2023-01-27
block_number | 16494436
block_timestamp | 2023-01-27 00:00:11.000000+0000
(1 rows)
-
Query
-
Result
SELECT * FROM block_numbers_by_date WHERE date='2023-01-27' LIMIT 1;
@ Row 1
-----------------+---------------------------------
date | 2023-01-27
block_number | 16501588
block_timestamp | 2023-01-27 23:59:59.000000+0000
(1 rows)
Contract ABIs
CREATE TABLE ethereum.contract_abis (
contract_address text PRIMARY KEY,
events text,
functions text,
is_proxy boolean,
proxy_address text
);
Contracts
When a smart contract is deployed on the blockchain, a row is inserted into the table.
Important info is the bytecode
and the function signatures (function_sighashes
).
CREATE TABLE ethereum.contracts (
address text,
block_number bigint,
block_hash text,
block_timestamp timestamp,
bytecode text,
function_sighashes text,
is_erc1155 boolean,
is_erc20 boolean,
is_erc721 boolean,
PRIMARY KEY (address, block_number)
) WITH CLUSTERING ORDER BY (block_number ASC);
Example queries
-
Query
-
Result
SELECT * FROM contracts WHERE address='0xfdeed771e8b00eb1e72243acbd309ed83ad45f6e' AND block_number=9578734;
@ Row 1
--------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
address | 0xfdeed771e8b00eb1e72243acbd309ed83ad45f6e
block_number | 9578734
block_hash | 0xa03ddfe29cecee563882203f20d18219dc90417d5bfd3d44c8368c68fdc37a0f
block_timestamp | 2020-02-29 12:49:45.000000+0000
bytecode | 0x60806040526004361061006c5763ffffffff7c010000000000000000000000000000000000000000000000000000000060003504166344439209811461006e5780638da5cb5b1461008f578063d0679d34146100c0578063e6d66ac8146100e4578063e8edc8161461010e575b005b34801561007a57600080fd5b5061006c600160a060020a0360043516610123565b34801561009b57600080fd5b506100a4610172565b60408051600160a060020a039092168252519081900360200190f35b3480156100cc57600080fd5b5061006c600160a060020a036004351660243561018a565b3480156100f057600080fd5b5061006c600160a060020a03600435811690602435166044356101dc565b34801561011a57600080fd5b506100a461028c565b337365b0bf8ee4947edd2a500d74e50a3d757dc79de01461014357600080fd5b6000805473ffffffffffffffffffffffffffffffffffffffff1916600160a060020a0392909216919091179055565b7365b0bf8ee4947edd2a500d74e50a3d757dc79de081565b600054600160a060020a031633146101a157600080fd5b604051600160a060020a0383169082156108fc029083906000818181858888f193505050501580156101d7573d6000803e3d6000fd5b505050565b600054600160a060020a031633146101f357600080fd5b82600160a060020a031663a9059cbb83836040518363ffffffff167c01000000000000000000000000000000000000000000000000000000000281526004018083600160a060020a0316600160a060020a0316815260200182815260200192505050600060405180830381600087803b15801561026f57600080fd5b505af1158015610283573d6000803e3d6000fd5b50505050505050565b600054600160a060020a0316815600a165627a7a7230582005c585170eb1ba497a4e0bc053a662a46f16fd200c85c37e4f8319d8ca9e93ab0029
function_sighashes | 0x8da5cb5b,0xd0679d34,0xe6d66ac8,0xa9059cbb
is_erc1155 | False
is_erc20 | False
is_erc721 | False
(1 rows)
Dashboard analytics
There is only one entry in this table and it is updated with metadata about the network periodically. The data can be seen in use on the home page of the Ethereum Explorer sample app.
CREATE TABLE ethereum.dashboard_analytics (
id bigint PRIMARY KEY,
block_number bigint,
chart_data text,
difficulty text,
ether_price_btc text,
ether_price_usd text,
hashrate text,
latest_blocks_group bigint,
market_cap_usd text,
med_gas_price text,
network_base_fee text,
network_priority_fee text,
previous_24h_block_number bigint,
price_percentage_change text,
sum_of_burnt_fees text,
total_transactions text,
tps text,
transactions_history_chart text
);
Example queries
-
Query
-
Result
SELECT * FROM dashboard_analytics WHERE id=1;
@ Row 1
----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
id | 1
block_number | 16577305
chart_data | [[1658935317000,1487.41],[1658935879000,1485.56],[1658938022000,1486.34],[1658939665000,1514.78],[1658939827000,1515.07],[1658940835000,1499.59],[1658942358000,1492.59],[1658945378000,1543.01],[1658947526000,1579.28],[1658948093000,1587.26],[1658948246000,1581.3],[1658948706000,1590.96],[1658949288000,1590.14],[1658952888000,1595.38],[1658956489000,1602.42],[1658960089000,1625.22],[1658963690000,1629.05],[1658964875000,1627.79],[1658966307000,1637.2],[1658967519000,1622.65],[1658968820000,1618.22],[1658970981000,1608.32],[1658974581000,1614.12],[1658975138000,1611.39],[1658975491000,1614.13],[1658975916000,1620.49],[1658978955000,1662.32],[1658981034000,1649.44],[1658982293000,1643.03],[1658985358000,1630],[1658988958000,1642.94],[1658989910000,1645.82],[1658990357000,1646.51],[1658993958000,1628.58],[1658995795000,1617.1],[1658999396000,1621.47],[1659002996000,1621.45],[1659006596000,1625.66],[1659007924000,1627.21],[1659009623000,1640.95],[1659010060000,1642.85],[1659013661000,1633.47],[1659017261000,1617.82],[1659020862000,1653.68],[1659024463000,1723.99],[1659025667000,1737.89],[1659028152000,1728.58],[1659031752000,1729.23],[1659034515000,1722.84],[1659038115000,1720.63],[1659039349000,1735.6],[1659042949000,1760.1],[1659046550000,1734.14],[1659048325000,1746.66],[1659051925000,1722.06],[1659054989000,1720.57],[1659057237000,1721.63],[1659060838000,1719.47],[1659064438000,1718.64],[1659065094000,1720.75],[1659065215000,1718.73],[1659065670000,1721.06],[1659066982000,1728.43],[1659067196000,1728.68],[1659067648000,1726.83],[1659068954000,1730.28],[1659069007000,1732.28],[1659070837000,1739.76],[1659071859000,1725.79],[1659075460000,1724.75],[1659079060000,1715.18],[1659080267000,1720.53],[1659080709000,1716],[1659084310000,1721.25],[1659085730000,1716.35],[1659086360000,1723.29],[1659088203000,1723.3],[1659091210000,1724.6],[1659094810000,1685.14],[1659098411000,1668.78],[1659099283000,1669.41],[1659099950000,1662.16],[1659102254000,1688.43],[1659102423000,1697.48],[1659102692000,1705.44],[1659106292000,1732.48],[1659109893000,1722.94],[1659113493000,1691.01],[1659113975000,1692.82],[1659115553000,1679.22],[1659119085000,1730.33],[1659120292000,1724.04],[1659120444000,1727.79],[1659121225000,1724.53],[1659121544000,1726.29],[1659125145000,1719.28],[1659128746000,1735.26],[1659132346000,1717.41],[1659132487000,1717.39],[1659135190000,1739.44],[1659136375000,1751.89],[1659139655000,1722.04],[1659140703000,1731.29],[1659144304000,1722.9],[1659144446000,1725.6],[1659145011000,1728.64],[1659148449000,1701.77],[1659149465000,1712.4],[1659153066000,1704.49],[1659156666000,1706.68],[1659156782000,1703.38],[1659160383000,1703.51],[1659161668000,1708.62],[1659161801000,1706.84],[1659163637000,1710.86],[1659163851000,1713.02],[1659164081000,1714.17],[1659166886000,1715.05],[1659170487000,1713.29],[1659173795000,1713.32],[1659176395000,1687.46],[1659179803000,1688.3],[1659180068000,1690.75],[1659182114000,1708.96],[1659185715000,1716.03],[1659186399000,1731.18],[1659190000000,1723.28],[1659193600000,1722.38],[1659195193000,1739.09],[1659198793000,1731.38],[1659199740000,1735.04],[1659203341000,1724.89],[1659204802000,1727.83],[1659208402000,1723.05],[1659209862000,1711.49],[1659213462000,1699.72],[1659213953000,1701.35],[1659217539000,1707.24],[1659219096000,1676.06],[1659222697000,1701.95],[1659223523000,1685.63],[1659223916000,1688.19],[1659227516000,1701.12],[1659228308000,1706.99],[1659229873000,1704.77],[1659233473000,1704.77],[1659235140000,1695.81],[1659238740000,1695.16],[1659242341000,1702.16],[1659243610000,1703.48],[1659244444000,1703.3],[1659245544000,1696.03],[1659248114000,1693.38],[1659248267000,1695.08],[1659251867000,1706.42],[1659253454000,1696.89],[1659254371000,1698.09],[1659256926000,1693.91],[1659257027000,1693.51],[1659258871000,1694.6],[1659259903000,1697.83],[1659262004000,1700.92],[1659263682000,1702.65],[1659265540000,1713.11],[1659269140000,1717.82],[1659272741000,1719.73],[1659273539000,1713.67],[1659274379000,1706.28],[1659277979000,1718.83],[1659280128000,1707.81],[1659283728000,1714.29],[1659287329000,1710.58],[1659290929000,1726.45],[1659293996000,1707.34],[1659295273000,1720.99],[1659298873000,1716.03],[1659299018000,1716.98],[1659302619000,1723.11],[1659303726000,1707.43],[1659303904000,1707],[1659305061000,1699.81],[1659308662000,1682.65],[1659312262000,1679.11],[1659315227000,1689.76],[1659315971000,1686.67],[1659319298000,1697.53],[1659322296000,1694.63],[1659323554000,1692.35],[1659327154000,1692.06],[1659329195000,1694.38],[1659329597000,1695.63],[1659329939000,1697.21],[1659331515000,1690.5],[1659335115000,1685.4],[1659337825000,1685.25],[1659338466000,1676.25],[1659339995000,1687.9],[1659342056000,1690.99],[1659345656000,1691.47],[1659349257000,1681.5],[1659352858000,1658.14],[1659356177000,1664.78],[1659358800000,1657.1],[1659359142000,1651.84],[1659359418000,1653.02],[1659363019000,1685.48],[1659365132000,1680.3],[1659368733000,1672.16],[1659370119000,1666.47],[1659373720000,1652.99],[1659375015000,1633.8],[1659375879000,1629.39],[1659377164000,1628.6],[1659377585000,1629.45],[1659378342000,1628.63],[1659381943000,1623.82],[1659385543000,1629.57],[1659389144000,1624.6],[1659392744000,1617.41],[1659394987000,1634.46],[1659398587000,1630.77],[1659401993000,1633.32],[1659405152000,1605.78],[1659407680000,1585.9],[1659408274000,1593.91],[1659411752000,1577.5],[1659415353000,1575.29],[1659418953000,1585.01],[1659419490000,1584.07],[1659423090000,1586.85],[1659426691000,1594.14],[1659427128000,1593.16],[1659430577000,1580.47],[1659434178000,1562.21],[1659436630000,1577.26],[1659440204000,1592.22],[1659442129000,1584.71],[1659443905000,1575.21],[1659447506000,1574.8],[1659451106000,1584.63],[1659452014000,1633.18],[1659452413000,1624.63],[1659453227000,1617.96],[1659456827000,1645.12],[1659459944000,1675.25],[1659460771000,1673.42],[1659461684000,1656.28],[1659462539000,1647.3],[1659463354000,1652.91],[1659464261000,1659.02],[1659467862000,1629.03],[1659471016000,1643.11],[1659473959000,1651.52],[1659477560000,1654.95],[1659479740000,1643.53],[1659483341000,1647.31],[1659485552000,1633.6],[1659489152000,1597.95],[1659490582000,1610.22],[1659492106000,1614.58],[1659492884000,1615.87],[1659494489000,1615.42],[1659498090000,1613.61],[1659501690000,1616.99],[1659505291000,1627.96],[1659506258000,1630.17],[1659507635000,1640.25],[1659507924000,1640.23],[1659510376000,1633.72],[1659513976000,1635.89],[1659517577000,1648.56],[1659521177000,1653.67],[1659523027000,1653.87],[1659526628000,1666.24],[1659529382000,1677.83],[1659530246000,1662.36],[1659532605000,1661.64],[1659533205000,1655.19],[1659536805000,1657.94],[1659540406000,1658.39],[1659540613000,1658.46],[1659543438000,1650],[1659543864000,1655.92],[1659546561000,1666.18],[1659546773000,1660.11],[1659549512000,1660.37],[1659550501000,1658.68],[1659551546000,1666.12],[1659552283000,1666.16],[1659555883000,1663.97],[1659559484000,1639],[1659561505000,1641.03],[1659562583000,1646.75],[1659564785000,1635.09],[1659566014000,1627.45],[1659569615000,1616.84],[1659573215000,1636.21],[1659573244000,1637.19],[1659576845000,1651.85],[1659577293000,1655.16],[1659577727000,1653.45],[1659578450000,1650.45],[1659580771000,1651.36],[1659582196000,1654.29],[1659585592000,1649.3],[1659586485000,1655.74],[1659588246000,1656.4],[1659591846000,1649.9],[1659595447000,1625.29],[1659599048000,1629.33],[1659601427000,1621.58],[1659604101000,1618.93],[1659607702000,1627.39],[1659610141000,1616.85],[1659610907000,1615.73],[1659613698000,1619.07],[1659617298000,1616.46],[1659620134000,1627.04],[1659620156000,1626.14],[1659621087000,1639.11],[1659624688000,1609.92],[1659625100000,1613.76],[1659626444000,1614.36],[1659627030000,1609.62],[1659627609000,1605.51],[1659629000000,1615.91],[1659632600000,1591.97],[1659633054000,1591.31],[1659635781000,1596.4],[1659638765000,1595.31],[1659640783000,1608.72],[1659641108000,1604.93],[1659642815000,1589.91],[1659643425000,1593.57],[1659644180000,1594.53],[1659644899000,1596.57],[1659646777000,1591.57],[1659648846000,1594.78],[1659649825000,1593.11],[1659650191000,1589.89],[1659651044000,1588.45],[1659652370000,1595.21],[1659654130000,1597.05],[1659654752000,1603.41],[1659656314000,1602.77],[1659659778000,1610.51],[1659661124000,1609],[1659661614000,1611.66],[1659662007000,1613.81],[1659664799000,1646.62],[1659668400000,1662.24],[1659670334000,1660.47],[1659673935000,1658.62],[1659675402000,1656.6],[1659675616000,1656.01],[1659679140000,1659.36],[1659680068000,1667.54],[1659682138000,1664.62],[1659685739000,1666.1],[1659687361000,1665.2],[1659687434000,1661.82],[1659689994000,1657.37],[1659690064000,1656.57],[1659690532000,1656.12],[1659693428000,1664.81],[1659693627000,1663.22],[1659693988000,1660.72],[1659694200000,1664.5],[1659695316000,1665.98],[1659695796000,1668.13],[1659699397000,1697.04],[1659702066000,1715.86],[1659705667000,1674.6],[1659706396000,1681.01],[1659707365000,1681.79],[1659710965000,1704.44],[1659712824000,1680.69],[1659714921000,1676.76],[1659717859000,1665.21],[1659718893000,1673.09],[1659721029000,1671.8],[1659722694000,1668.38],[1659723572000,1670.03],[1659723796000,1670.69],[1659725093000,1667.81],[1659726874000,1676.27],[1659727906000,1673.73],[1659731507000,1676.38],[1659735107000,1704.84],[1659738390000,1704.1],[1659741991000,1722.17],[1659745591000,1737.14],[1659747302000,1735.97],[1659750903000,1737.57],[1659754501000,1735.92],[1659756067000,1735.18],[1659759668000,1735.07],[1659761679000,1731.25],[1659765267000,1723.93],[1659766659000,1721.38],[1659770259000,1720.84],[1659773860000,1723.15],[1659773933000,1723.58],[1659773963000,1723.68],[1659775501000,1709.8],[1659777728000,1712.13],[1659781329000,1714.59],[1659782842000,1718.88],[1659784927000,1721.46],[1659786997000,1713.08],[1659790461000,1711.07],[1659791242000,1717.9],[1659794843000,1710.04],[1659798444000,1713.77],[1659802044000,1714.18],[1659802829000,1717],[1659805250000,1700.78],[1659806583000,1707.57],[1659809786000,1705.19],[1659811660000,1715.68],[1659813433000,1713.83],[1659813884000,1715.31],[1659817485000,1711.12],[1659819281000,1713.55],[1659821449000,1716.01],[1659821752000,1714.83],[1659822085000,1714.53],[1659822530000,1716.56],[1659822691000,1717.11],[1659824460000,1711.08],[1659824788000,1712.68],[1659826853000,1712.06],[1659827101000,1710.25],[1659829669000,1694.84],[1659833269000,1692.46],[1659834516000,1676.15],[1659835037000,1673.99],[1659838638000,1678.39],[1659841465000,1688.71],[1659843017000,1681.2],[1659844159000,1683.47],[1659847760000,1681.23],[1659848084000,1674.97],[1659849150000,1680.08],[1659851885000,1681.01],[1659854132000,1684.12],[1659854312000,1683.89],[1659857912000,1685.62],[1659861512000,1680.46],[1659861520000,1680.67],[1659862577000,1678.87],[1659863580000,1677.87],[1659863882000,1680.23],[1659864555000,1679.75],[1659866940000,1683.51],[1659870142000,1684.78],[1659870238000,1685.54],[1659872592000,1684.42],[1659876193000,1695.79],[1659878370000,1706.27],[1659881906000,1705.82],[1659882947000,1697.7],[1659884042000,1702.81],[1659884641000,1702.94],[1659885374000,1703.23],[1659887411000,1701.27],[1659891012000,1705.06],[1659893176000,1711.53],[1659895029000,1712.91],[1659898629000,1707.34],[1659902230000,1708.47],[1659905831000,1720.96],[1659905953000,1722.51],[1659908940000,1716.31],[1659911219000,1712.28],[1659911407000,1711.31],[1659911643000,1707.84],[1659915244000,1696.53],[1659916616000,1698.59],[1659916770000,1700.45],[1659920371000,1707.35],[1659922385000,1698.52],[1659923903000,1700.4],[1659924544000,1704.11],[1659928145000,1712.27],[1659931745000,1711.89],[1659932365000,1710.01],[1659932743000,1710.07],[1659935644000,1715.87],[1659936067000,1718.97],[1659936407000,1722.06],[1659937057000,1720.28],[1659940657000,1732.39],[1659944258000,1734.75],[1659945833000,1735.07],[1659947880000,1741.77],[1659951481000,1771.46],[1659952152000,1772.78],[1659953767000,1770.63],[1659955786000,1773.62],[1659956218000,1772.6],[1659958141000,1771.25],[1659959936000,1787.35],[1659963536000,1807.55],[1659964028000,1799.28],[1659967160000,1802.54],[1659970761000,1795.19],[1659971198000,1798.41],[1659973522000,1773.52],[1659977122000,1768.65],[1659980071000,1771.88],[1659980986000,1766.03],[1659982776000,1768.25],[1659986377000,1769.68],[1659989977000,1785.08],[1659993578000,1773.12],[1659997178000,1773.23],[1660000779000,1788.96],[1660004379000,1781.99],[1660006572000,1778.75],[1660010173000,1763.64],[1660013413000,1772.59],[1660016060000,1779.03],[1660019661000,1775.25],[1660020067000,1780.62],[1660021195000,1780.56],[1660022727000,1775.75],[1660023023000,1775.21],[1660025682000,1770.36],[1660029005000,1787.48],[1660029793000,1782.73],[1660030913000,1780.89],[1660034513000,1776.26],[1660038114000,1759.15],[1660041409000,1721.23],[1660042959000,1717.49],[1660046559000,1703.3],[1660048781000,1713.92],[1660052382000,1713.46],[1660053594000,1685.2],[1660057195000,1685.14],[1660057273000,1684.28],[1660059055000,1691.89],[1660059585000,1691.18],[1660059623000,1691],[1660063223000,1689.16],[1660066824000,1689.79],[1660068316000,1693.4],[1660068575000,1692],[1660069961000,1686.15],[1660070207000,1689.32],[1660073807000,1687.7],[1660074798000,1689.39],[1660078398000,1695.66],[1660079243000,1702.15],[1660082843000,1708.24],[1660083377000,1711.88],[1660086978000,1708.56],[1660089745000,1700.29],[1660090521000,1700.05],[1660094121000,1687.21],[1660097722000,1680.25],[1660099515000,1675.86],[1660102220000,1671.57],[1660105820000,1673.23],[1660109126000,1679.12],[1660112726000,1679.04],[1660114201000,1681.33],[1660117122000,1689.24],[1660118120000,1688.36],[1660121721000,1703.78],[1660125321000,1696.32],[1660128922000,1692.73],[1660130530000,1700.86],[1660131742000,1701.77],[1660135342000,1773.77],[1660138943000,1826.08],[1660141777000,1829.95],[1660145377000,1843.1],[1660145758000,1845.11],[1660146265000,1840.74],[1660149866000,1828.86],[1660151147000,1826.71],[1660152196000,1831.33],[1660155797000,1826.4],[1660159398000,1822.48],[1660161158000,1816.92],[1660163374000,1822.69],[1660166975000,1874.48],[1660168901000,1865.41],[1660171256000,1854.35],[1660172351000,1849.57],[1660173367000,1853.99],[1660176968000,1857.85],[1660177728000,1853.68],[1660181329000,1891.98],[1660184930000,1868.45],[1660186241000,1875.36],[1660189841000,1882.93],[1660191799000,1885.45],[1660192940000,1886.36],[1660193420000,1885.72],[1660196273000,1905.27],[1660199873000,1886.33],[1660200912000,1890.33],[1660202447000,1894.28],[1660203555000,1890.9],[1660203662000,1887.47],[1660204333000,1872.71],[1660206676000,1882.18],[1660208743000,1889.69],[1660212343000,1884.29],[1660215944000,1890.44],[1660217324000,1896.5],[1660217828000,1895.67],[1660221429000,1919.95],[1660223035000,1922.2],[1660226635000,1914.96],[1660230236000,1901.56],[1660230865000,1899.57],[1660232709000,1897.34],[1660234153000,1893.59],[1660237754000,1902.41],[1660238708000,1905.71],[1660240267000,1901.42],[1660240768000,1903.2],[1660241585000,1887.39],[1660242303000,1889.05],[1660245903000,1887.24],[1660249504000,1887.8],[1660252034000,1901.64],[1660255635000,1893.79],[1660256802000,1889.56],[1660260403000,1873.41],[1660262697000,1881.44],[1660263852000,1867.51],[1660267453000,1886.96],[1660271053000,1877.62],[1660271253000,1883.47],[1660273853000,1901.95],[1660274867000,1900.96],[1660275833000,1903.66],[1660276648000,1904.86],[1660277056000,1905.6],[1660278510000,1897.7],[1660278539000,1898.65],[1660280061000,1892.97],[1660281548000,1899.74],[1660283839000,1892.19],[1660284315000,1895.9],[1660287810000,1888.17],[1660291411000,1888.38],[1660292490000,1894.81],[1660292677000,1894.98],[1660295248000,1888.25],[1660298849000,1890.99],[1660299813000,1889.08],[1660303414000,1875.29],[1660303465000,1875.41],[1660307065000,1883.15],[1660307707000,1881.15],[1660308521000,1882.8],[1660309355000,1882.27],[1660312956000,1876.85],[1660316556000,1883.24],[1660318344000,1901.78],[1660321944000,1895.25],[1660325416000,1897.83],[1660329017000,1903.96],[1660330693000,1916.75],[1660332102000,1926.72],[1660332641000,1927.28],[1660333855000,1923.44],[1660335298000,1923.83],[1660338899000,1929.28],[1660341432000,1924.34],[1660345032000,1931.33],[1660345978000,1933.42],[1660348956000,1956.9],[1660352557000,1966.7],[1660356158000,1963.04],[1660359758000,1975.13],[1660363359000,1992.87],[1660366959000,1992.35],[1660370560000,2002.01],[1660372193000,2015.94],[1660372492000,2013.31],[1660373672000,2000.17],[1660377272000,1995.61],[1660380873000,1988.86],[1660382684000,1998.17],[1660382959000,1996.98],[1660386132000,1997.55],[1660387186000,1999.91],[1660390787000,1983.86],[1660390972000,1980.06],[1660390995000,1978.4],[1660394596000,1972.89],[1660398196000,1987.38],[1660401797000,1983.02],[1660401961000,1980.38],[1660405562000,1986.4],[1660409162000,1988.69],[1660410033000,1988.96],[1660410109000,1987.98],[1660410460000,1989.53],[1660411676000,1993.3],[1660415277000,1987.11],[1660415329000,1989.28],[1660415390000,1989.87],[1660417277000,1984.87],[1660419303000,1978.2],[1660422564000,1983.43],[1660423237000,1985.93],[1660424927000,1989.86],[1660428528000,1990.29],[1660430758000,1984.17],[1660431107000,1981.6],[1660431146000,1982.07],[1660432329000,1984.62],[1660432962000,1983.89],[1660436562000,1983.74],[1660437903000,1987.31],[1660440857000,1978.93],[1660441059000,1983.26],[1660441703000,1984.18],[1660445304000,1988.54],[1660448764000,1989.06],[1660450110000,1987.13],[1660451308000,1983.71],[1660454909000,1991.13],[1660455373000,1989.57],[1660457445000,1995.89],[1660459060000,1992.36],[1660461401000,1995.49],[1660465001000,2010.56],[1660468602000,2005.36],[1660469149000,2005.39],[1660470505000,2009.98],[1660473867000,1997.66],[1660477468000,1987.02],[1660479473000,1986.91],[1660483074000,1978.13],[1660486675000,1984.71],[1660487153000,1984.62],[1660490753000,1983.61],[1660492834000,1983.61],[1660496434000,1943.04],[1660499666000,1930.93],[1660503267000,1930.15],[1660504156000,1930.75],[1660507757000,1932.28],[1660511357000,1942.21],[1660514604000,1944.23],[1660516436000,1939.56],[1660517439000,1940.96],[1660517592000,1941.98],[1660521193000,1939.13],[1660522869000,1932.78],[1660525081000,1956],[1660525887000,1954.67],[1660529002000,1974.12],[1660531279000,2006.35],[1660532431000,2001.12],[1660535146000,1982.66],[1660538260000,1982.42],[1660541861000,1971.77],[1660545450000,1916.26],[1660549050000,1905.26],[1660552318000,1902.33],[1660552637000,1907.69],[1660556238000,1896.34],[1660557714000,1909.38],[1660559636000,1901.94],[1660563236000,1899.37],[1660566837000,1895.09],[1660567135000,1894.98],[1660568321000,1882.46],[1660569127000,1899.17],[1660572728000,1911.19],[1660576328000,1896.95],[1660576355000,1895.74],[1660577970000,1910.28],[1660578233000,1909.46],[1660580484000,1912.3],[1660581577000,1913.47],[1660583751000,1926.47],[1660587351000,1896.67],[1660589101000,1898.42],[1660592702000,1891.77],[1660595691000,1900.21],[1660599292000,1905.75],[1660602893000,1912.62],[1660604768000,1882.31],[1660605324000,1879.87],[1660608924000,1897.01],[1660610131000,1893.46],[1660613732000,1911.55],[1660614368000,1910.26],[1660615792000,1905.07],[1660617267000,1903.67],[1660618506000,1892.23],[1660619177000,1883.16],[1660622777000,1891.08],[1660622827000,1892.65],[1660623963000,1880.45],[1660625848000,1874.6],[1660628797000,1863.39],[1660630704000,1875.51],[1660630977000,1877.34],[1660631996000,1879.62],[1660635596000,1884.21],[1660639197000,1881.44],[1660641982000,1892.06],[1660643061000,1896.36],[1660645336000,1893.64],[1660646529000,1892.6],[1660649366000,1901.44],[1660652967000,1907.88],[1660653675000,1898.53],[1660654366000,1885.72],[1660657381000,1888.19],[1660660982000,1875.9],[1660662606000,1874.75],[1660665404000,1889.76],[1660665613000,1887.58],[1660668658000,1869.54],[1660672259000,1879.7],[1660675859000,1859.22],[1660676590000,1869.51],[1660677146000,1874.58],[1660678046000,1876.58],[1660679146000,1876.1],[1660682747000,1881.05],[1660683681000,1884.7],[1660687282000,1879.32],[1660689607000,1873.42],[1660693208000,1878.29],[1660693801000,1879.57],[1660697402000,1892.43],[1660701002000,1889.29],[1660704563000,1895.69],[1660708163000,1897.92],[1660711616000,1904.06],[1660715216000,1918.99],[1660718183000,1947.95],[1660721784000,1901.19],[1660725385000,1894.23],[1660728068000,1884.77],[1660730109000,1889.39],[1660733709000,1873.27],[1660734537000,1879.68],[1660735380000,1878.71],[1660735402000,1879.25],[1660736386000,1874.79],[1660737226000,1874.72],[1660740693000,1876.01],[1660742532000,1863.9],[1660745931000,1830.05],[1660749532000,1835.34],[1660749895000,1837.8],[1660751924000,1828.82],[1660752208000,1830.23],[1660755809000,1837.91],[1660759409000,1853.28],[1660763010000,1852.99],[1660764540000,1837.57],[1660764645000,1841.52],[1660768246000,1850.57],[1660769156000,1849.47],[1660771016000,1843.14],[1660774617000,1834.59],[1660778217000,1831.77],[1660778391000,1829.69],[1660781991000,1835.88],[1660785039000,1845.94],[1660785201000,1843.72],[1660785905000,1847.65],[1660786459000,1849.92],[1660790060000,1848.73],[1660793661000,1852.28],[1660795328000,1849.58],[1660798929000,1844.76],[1660800315000,1850.56],[1660801199000,1850.19],[1660802481000,1843.86],[1660805829000,1839.54],[1660807479000,1842.66],[1660807652000,1844.89],[1660811086000,1844.78],[1660813991000,1846.95],[1660814576000,1848],[1660816613000,1853.88],[1660820213000,1849.91],[1660821603000,1850.36],[1660822605000,1859.48],[1660826206000,1860.3],[1660829457000,1866.88],[1660833058000,1857.8],[1660836659000,1869.72],[1660839415000,1867.13],[1660843015000,1871.48],[1660843721000,1873.32],[1660847321000,1863.78],[1660848281000,1861.66],[1660851094000,1872.54],[1660854695000,1874.33],[1660855102000,1876.45],[1660858703000,1871.99],[1660862303000,1871.13],[1660865772000,1855.53],[1660867281000,1846.84],[1660868546000,1817.02],[1660872147000,1815.53],[1660875747000,1822.4],[1660879348000,1820.27],[1660881423000,1820.49],[1660881587000,1818.85],[1660882144000,1819.26],[1660884755000,1820.42],[1660887814000,1817.88],[1660890123000,1809.22],[1660891501000,1759.46],[1660893864000,1746.52],[1660894393000,1742.73],[1660897994000,1722.1],[1660899305000,1739.26],[1660901299000,1735.92],[1660904835000,1740.26],[1660906824000,1730.56],[1660909375000,1697.41],[1660912802000,1690.74],[1660913642000,1701.76],[1660914960000,1698.84],[1660918561000,1688.87],[1660920154000,1695.27],[1660920246000,1697.17],[1660923846000,1696.02],[1660925107000,1698.05],[1660926291000,1705.17],[1660926868000,1720.08],[1660929891000,1717.18],[1660933491000,1696.37],[1660937092000,1708.59],[1660940692000,1694.62],[1660942511000,1686.45],[1660944910000,1685.06],[1660948511000,1638.38],[1660952111000,1624.02],[1660955712000,1634.06],[1660956592000,1631.69],[1660958669000,1626.91],[1660962269000,1626.83],[1660964794000,1630.55],[1660966049000,1623.73],[1660968996000,1630.67],[1660970869000,1632.59],[1660971775000,1638.19],[1660973448000,1645.77],[1660975637000,1634.71],[1660977931000,1641.94],[1660981343000,1651.87],[1660981822000,1648.92],[1660983806000,1647.76],[1660987406000,1630.88],[1660989764000,1633.65],[1660990747000,1627.24],[1660992353000,1625.22],[1660993300000,1630.28],[1660996901000,1631.35],[1660998757000,1633.22],[1661001002000,1627.3],[1661004207000,1642.77],[1661007371000,1631.75],[1661010827000,1634.93],[1661012694000,1632.21],[1661016295000,1615.47],[1661019894000,1616.67],[1661023495000,1570.17],[1661027095000,1578.68],[1661027818000,1574.8],[1661028673000,1565.6],[1661030825000,1550.25],[1661032776000,1569.72],[1661034439000,1572.54],[1661038039000,1584.09],[1661038490000,1576.33],[1661038576000,1575.54],[1661041394000,1590.84],[1661043482000,1577.27],[1661047083000,1597.07],[1661050684000,1597.91],[1661052498000,1590.79],[1661053328000,1585.99],[1661054001000,1581.83],[1661057038000,1587.81],[1661060638000,1582.04],[1661062762000,1582.13],[1661065860000,1569.79],[1661066787000,1570.68],[1661068318000,1584.96],[1661071918000,1593.44],[1661075519000,1619.59],[1661076641000,1612.56],[1661080241000,1619.78],[1661083842000,1635.94],[1661083847000,1636.25],[1661087448000,1623.64],[1661090721000,1607.62],[1661094322000,1616.45],[1661097923000,1623.57],[1661101057000,1624.9],[1661103440000,1627.35],[1661103574000,1627.57],[1661107175000,1621.58],[1661107512000,1622.76],[1661111112000,1625.95],[1661111824000,1624.38],[1661115424000,1627.33],[1661117200000,1642.85],[1661120800000,1599.78],[1661124401000,1620.12],[1661124596000,1620.07],[1661126061000,1618.09],[1661126863000,1608.97],[1661127044000,1602.87],[1661130248000,1612.02],[1661130977000,1604.69],[1661132953000,1603.03],[1661135612000,1598.55],[1661139213000,1606.03],[1661139286000,1606.1],[1661141346000,1590.44],[1661144721000,1605.56],[1661148321000,1597.19],[1661149370000,1599.39],[1661152970000,1583.26],[1661153243000,1579.31],[1661155868000,1546.25],[1661159469000,1563.73],[1661160282000,1559.19],[1661160801000,1553.75],[1661161427000,1559.84],[1661162798000,1558.77],[1661166398000,1570.44],[1661169475000,1567.69],[1661172184000,1565.04],[1661173434000,1565.35],[1661173925000,1561.82],[1661175490000,1558.9],[1661179091000,1569.65],[1661179877000,1566.98],[1661182900000,1576.73],[1661186500000,1577.84],[1661190101000,1575.55],[1661192193000,1566.1],[1661195794000,1565.75],[1661199395000,1577.31],[1661202995000,1575.17],[1661204737000,1571.38],[1661206597000,1577.75],[1661210198000,1594.01],[1661212331000,1619.43],[1661215931000,1622.44],[1661216884000,1625.9],[1661220242000,1624.05],[1661221696000,1620.61],[1661222083000,1619.88],[1661225174000,1628.94],[1661226874000,1621.71],[1661230474000,1613.07],[1661232716000,1584.58],[1661236317000,1571.7],[1661237864000,1573.41],[1661241302000,1597.37],[1661241996000,1604.81],[1661244382000,1609.85],[1661247983000,1601.98],[1661248208000,1620.89],[1661251809000,1608.09],[1661255409000,1622.14],[1661256452000,1623.09],[1661258302000,1610.92],[1661261902000,1631.99],[1661262038000,1627.43],[1661264276000,1643.47],[1661267877000,1643.98],[1661271478000,1633.25],[1661273157000,1635.02],[1661274752000,1635.54],[1661275794000,1639.52],[1661277980000,1635.31],[1661281581000,1659.12],[1661285182000,1654.05],[1661288782000,1649.9],[1661292383000,1654.87],[1661292727000,1657],[1661296327000,1661.93],[1661297761000,1662.85],[1661300722000,1655.25],[1661304322000,1629.05],[1661307642000,1629.26],[1661311242000,1614.94],[1661314275000,1612.55],[1661317876000,1623.01],[1661320162000,1643.41],[1661323762000,1640.92],[1661324603000,1648.53],[1661328204000,1628.04],[1661329665000,1640.11],[1661332566000,1638.83],[1661332761000,1637.37],[1661334718000,1636.14],[1661337734000,1638.22],[1661339041000,1632.96],[1661339940000,1641.11],[1661342334000,1650.89],[1661343656000,1656.54],[1661347256000,1651.25],[1661348718000,1654.43],[1661352319000,1647.16],[1661354428000,1662.26],[1661356733000,1684.78],[1661358692000,1678.29],[1661362292000,1672.1],[1661365893000,1672.58],[1661369493000,1682.46],[1661370918000,1681.65],[1661371424000,1679.71],[1661375024000,1680.94],[1661375780000,1679.23],[1661379072000,1673.4],[1661382270000,1662.68],[1661382841000,1663.08],[1661386442000,1659.63],[1661390042000,1668.15],[1661391142000,1676.79],[1661392666000,1676.75],[1661395519000,1672.85],[1661395609000,1672.52],[1661399210000,1668.69],[1661402810000,1674.43],[1661406411000,1676.68],[1661407041000,1678.77],[1661408352000,1694.97],[1661410667000,1700.98],[1661411415000,1705.58],[1661415016000,1710.09],[1661416038000,1709.08],[1661417910000,1709.31],[1661421511000,1706.36],[1661422233000,1700.98],[1661425833000,1698.91],[1661426469000,1703.88],[1661428722000,1711.4],[1661428840000,1709.78],[1661432441000,1704.49],[1661432655000,1704.47],[1661433362000,1701.39],[1661436963000,1706.04],[1661439670000,1713.08],[1661440368000,1710.41],[1661441958000,1700.14],[1661444179000,1696.35],[1661447631000,1697.74],[1661450631000,1708.35],[1661454232000,1703.51],[1661457833000,1704.62],[1661461433000,1708.1],[1661462739000,1705.48],[1661464361000,1699.56],[1661467962000,1695.26],[1661471562000,1695.73],[1661474550000,1686.2],[1661478151000,1682.49],[1661481751000,1684.99],[1661485197000,1689.63],[1661488797000,1680.07],[1661490545000,1679.84],[1661494145000,1661.59],[1661495627000,1664.78],[1661497150000,1660.05],[1661500118000,1654.42],[1661500717000,1658.96],[1661501535000,1657.38],[1661502536000,1656.22],[1661506136000,1663.18],[1661509737000,1657.26],[1661512921000,1631.23],[1661514164000,1629.36],[1661517384000,1659.35],[1661520985000,1681.52],[1661524586000,1654.43]]
difficulty | 11970664912883764
ether_price_btc | 0.07131778
ether_price_usd | 1641.56
hashrate | 919552118365851.1
latest_blocks_group | 166
market_cap_usd | 197278460036
med_gas_price | 26
network_base_fee | 24
network_priority_fee | 2
previous_24h_block_number | 16143404
price_percentage_change | 0.66574
sum_of_burnt_fees | 2.7888058748465755850959520553548046558306e+24
total_transactions | 1812076613
tps | 12.472199074074075
transactions_history_chart | [306295,235265,403680,209681,149777,58326,42633,223294,87362,523609,773190,462835,376844,197501,534828]
(1 rows)
ETH blocks
An entry is created for each new block that is mined. The entry contains high-level metadata about the block.
CREATE TABLE ethereum.eth_blocks (
blocks_group bigint,
number bigint,
hash text,
base_fee_per_gas text,
block_timestamp timestamp,
blocks_difficulty double,
blocks_total_difficulty double,
burnt_fees text,
difficulty decimal,
extra_data text,
gas_limit bigint,
gas_target_percentage text,
gas_used bigint,
gas_used_percentage text,
int_txn_count bigint,
logs_bloom text,
mine_time bigint,
miner text,
miners_name text,
nonce text,
parent_hash text,
receipts_root text,
reward text,
sha3_uncles text,
size bigint,
state_root text,
timestamp text,
total_difficulty decimal,
transaction_count bigint,
transactions_root text,
txn_fees text,
uncle_reward text,
uncles_count bigint,
PRIMARY KEY (blocks_group, number, hash)
) WITH CLUSTERING ORDER BY (number DESC, hash ASC);
Example queries
-
Query
-
Result
SELECT * FROM eth_blocks WHERE blocks_group=134 LIMIT 1;
@ Row 1
-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
blocks_group | 134
number | 13400000
hash | 0x75eb2a65c6d3ab1d46fd4eec97a27e7ff1217cc6d9b664bb7f2291d31f8e2033
base_fee_per_gas | 0.000000109078100635
block_timestamp | null
blocks_difficulty | 9.6916e+15
blocks_total_difficulty | 3.2241e+22
burnt_fees | 1.7985069927950388
difficulty | 9691630208547392
extra_data | 0xe4b883e5bda9e7a59ee4bb99e9b1bc1f0221
gas_limit | 30058619
gas_target_percentage | 9.707302254970543
gas_used | 16488250
gas_used_percentage | 54.85365112748527
int_txn_count | null
logs_bloom | 0xf1b17142653d0ab175b8be88f035177fe90255a90e8618840311a58ad8a6070387d694871684dab838226743c4c455c87a09b10009b2391196414a70d37e65845a0a9329592bc9984d9f77ee2b01ce67429f60e2264035dd1612ab17ffe59af34f57b881dbaac89c485d500c003a4ba94648c1474cdd7e438ee96515fc8bf646531545314ac4eb0d91e9ba9905812427efb6bcf501809c49ea53c848c2933c707398e92d0fb32eb23ac17bf09d0aaa80506441959220924635fb014f90e1db59419ee33265a201f1ac1cd8ab9683755f2f754d11073a09bab008a1db0427f6b5945961c9c2909a030d95c1eb7724c1e994c907542122607b5ec6790a54afaa43
mine_time | null
miner | 0x829bd824b016326a401d083b33d092293333a830
miners_name | null
nonce | 0x8db57646dab694b8
parent_hash | 0x551402942e540688e0f536dd9f2e811c10ec1fa979517727aacd3743de7ea6c0
receipts_root | 0x02c1fd52b6f73391f3f36d18350ab9864ee792077d8b5f544f5d77500c765e3a
reward | 2.1856474863008994
sha3_uncles | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347
size | 86265
state_root | 0xa88d6ec498cb846d374e050466f29bb2c1613060e5870c1c4fe53077fe9b4f63
timestamp | 0x6164bc77
total_difficulty | 3.2240625945634960000
transaction_count | 229
transactions_root | 0xb9b3f700096e09a405e7180a3e68d6891211d81ce0c578f45287010f77a9cf62
txn_fees | 1.984154479095938
uncle_reward | 0
uncles_count | 0
(1 rows)
-
Query
-
Result
SELECT * FROM eth_blocks WHERE blocks_group=154 AND number=15399999 AND hash='0x25201aacfffd0ffd04e63e02ef82b2e15149f1c5b2430e338c32bb8520d107d9';
@ Row 1
-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
blocks_group | 154
number | 15399999
hash | 0x25201aacfffd0ffd04e63e02ef82b2e15149f1c5b2430e338c32bb8520d107d9
base_fee_per_gas | 0.000000008075644681
block_timestamp | null
blocks_difficulty | 0
blocks_total_difficulty | 8.1298e+12
burnt_fees | 0.05142579416069949
difficulty | 0
extra_data | 0xe4b883e5bda9e7a59ee4bb99e9b1bc470821
gas_limit | 29999972
gas_target_percentage | -57.5465537101168
gas_used | 6368011
gas_used_percentage | 21.2267231449416
int_txn_count | null
logs_bloom | 0x002000841112ac2100208300a218012b420022000058000a08c39d7b34a2a4543e20304b252164040c368a000091010612a480013e0333808004801101b720281000080004438a286958420d512090a1b2b2c0ac8f67150018621897bc122020522385010342401020c0ca0801aab8606012000014080c2d82a010d05809401603200140003613528c4880c030000020044305810963a04c0c245563409214008a280109300b644108c1468317010002403448c12984800204a0054e903840081000214a3012811a04a088000048411c01440262804208910004096318406829121ba028c00c60009501144b41840a07800813000d088c60084c2030e0006082
mine_time | null
miner | 0x829bd824b016326a401d083b33d092293333a830
miners_name | null
nonce | 0xb23ee451824b93ae
parent_hash | 0x140ade9c9ca4737cf17bac396d823db363345f07f691cea575d3cef229bfc182
receipts_root | 0x19518be52144ebba36281335d80a15b83937b873ad050f0ac9b60c34319e7160
reward | 2.0301165692940004
sha3_uncles | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347
size | 25357
state_root | 0x9242774a50573b52346921dca7fdefb0c4d9e8f76835718f8238067796413436
timestamp | 0x63057e46
total_difficulty | 8129838888477
transaction_count | 64
transactions_root | 0x288a134d564d867e846493ca90eb73423b5bfbd323d1141dd49aada147f584dd
txn_fees | 0.08154236345470005
uncle_reward | 0
uncles_count | 0
(1 rows)
Event signatures
When an Ethereum transaction emits an event (log), it does not emit the text name of the event. It instead emits a hashed value of the event signature. The intent of this table is to provide a human-readable version of the event signature.
CREATE TABLE ethereum.event_signatures (
event_hex text PRIMARY KEY,
event_name text,
event_signature text
);
Example queries
-
Query
-
Result
SELECT * FROM event_signatures WHERE event_hex='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef';
@ Row 1
-----------------+--------------------------------------------------------------------
event_hex | 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef
event_name | Transfer
event_signature | Transfer(address,address,uint256)
(1 rows)
Logs
CREATE TABLE ethereum.logs (
block_number bigint,
transaction_hash text,
log_index bigint,
address text,
block_hash text,
block_timestamp timestamp,
data text,
decoded_data text,
topic0 text,
topic1 text,
topic2 text,
topic3 text,
transaction_index bigint,
PRIMARY KEY (block_number, transaction_hash, log_index)
) WITH CLUSTERING ORDER BY (transaction_hash ASC, log_index ASC);
Example queries
-
Query
-
Result
SELECT * FROM logs WHERE transaction_hash = '0xd81829eef1642054fad5077a3ca234654771187af5c6dc3b8bd6a9d2ddc7078a' and block_number = 15832763 and log_index = 44;
@ Row 1
-------------------+---------------------------------------------------------------------------------
block_number | 15832763
transaction_hash | 0xd81829eef1642054fad5077a3ca234654771187af5c6dc3b8bd6a9d2ddc7078a
log_index | 44
address | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2
block_hash | 0xd35d9e02a1ea86d02807efd155b1e5173b7b099f66082cd5245fe81fb1fe4712
block_timestamp | 2022-10-26 14:11:47.000000+0000
data | 0x00000000000000000000000000000000000000000000000008f713163340167a
decoded_data | {"src":"0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45","wad":"646006057621001850"}
topic0 | 0x7fcf532c15f0a6db0bd6d0e038bea71d30d808c7d98cb3bf7268a95bf5081b65
topic1 | 0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45
topic2 | null
topic3 | null
transaction_index | 15
(1 rows)
-
Query
-
Result
SELECT decoded_data FROM logs WHERE transaction_hash = '0xd81829eef1642054fad5077a3ca234654771187af5c6dc3b8bd6a9d2ddc7078a' and block_number = 15832763 and log_index = 44;
@ Row 1
--------------+---------------------------------------------------------------------------------
decoded_data | {"src":"0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45","wad":"646006057621001850"}
(1 rows)
Logs by date
CREATE TABLE ethereum.logs_by_date (
date date,
block_number bigint,
transaction_hash text,
log_index bigint,
address text,
block_hash text,
block_timestamp timestamp,
data text,
decoded_data text,
topic0 text,
topic1 text,
topic2 text,
topic3 text,
transaction_index bigint,
PRIMARY KEY (date, block_number, transaction_hash, log_index)
) WITH CLUSTERING ORDER BY (block_number DESC, transaction_hash ASC, log_index ASC);
NFTs
A row is inserted into this table each time an erc721 or erc1155 is transferred. The row contains relevant NFT metadata and the current owner.
CREATE TABLE ethereum.nfts (
contract_address text,
token_id text,
block_number bigint,
metadata text,
name text,
owner_of text,
symbol text,
token_standard text,
token_uri text,
PRIMARY KEY (contract_address, token_id)
) WITH CLUSTERING ORDER BY (token_id ASC);
Example queries
-
Query
-
Result
SELECT * FROM nfts WHERE contract_address='0x7A8cE4BeFfE38f431A2f12e1a8B7d7dAE62DF359' AND token_id='100';
@ Row 1
------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
contract_address | 0x7A8cE4BeFfE38f431A2f12e1a8B7d7dAE62DF359
token_id | 100
block_number | 14896695
metadata | {"name":"Tom #100","image":"ipfs://QmdyTDeo42DGV8UGhj5uwA1gGdoKaXPnEAcBPHPkCvpvTz","attributes":[{"trait_type":"Background","value":"White Chalkboard"},{"trait_type":"Body","value":"Noise Tom"},{"trait_type":"Eyes","value":"Closed"},{"trait_type":"Clothes","value":"Puffer Jacket"},{"trait_type":"Mouth","value":"Smile"},{"trait_type":"Head","value":"Green Mohawk"},{"trait_type":"Accessory","value":"Parrot"}]}
name | 10K Toms
owner_of | 0x0000000000000000000000000000000000000000000000000000000000000000
symbol | 10KTOMS
token_standard | ERC721
token_uri | https://10ktoms.io/api/metadata/100
(1 rows)
Reorg blocks
CREATE TABLE ethereum.reorg_blocks (
blocks_group bigint,
number bigint,
hash text,
base_fee_per_gas text,
blocks_difficulty double,
blocks_total_difficulty double,
burnt_fees text,
correct_block_hash text,
difficulty decimal,
extra_data text,
gas_limit bigint,
gas_target_percentage text,
gas_used bigint,
gas_used_percentage text,
int_txn_count bigint,
logs_bloom text,
mine_time bigint,
miner text,
miners_name text,
nonce text,
parent_hash text,
receipts_root text,
reward text,
sha3_uncles text,
size bigint,
state_root text,
timestamp timestamp,
total_difficulty decimal,
transaction_count bigint,
transactions_root text,
txn_fees text,
uncle_reward text,
uncles_count bigint,
PRIMARY KEY (blocks_group, number, hash)
) WITH CLUSTERING ORDER BY (number DESC, hash ASC);
Sorted NFTs
A row is inserted into this table each time an erc721 or erc1155 is transferred. The row contains relevant NFT metadata and the current owner.
CREATE TABLE ethereum.sorted_nfts (
block_number_hour bigint,
block_number bigint,
contract_address text,
token_id text,
metadata text,
name text,
owner_of text,
symbol text,
token_standard text,
token_uri text,
PRIMARY KEY (block_number_hour, block_number, contract_address, token_id)
) WITH CLUSTERING ORDER BY (block_number DESC, contract_address ASC, token_id ASC);
Token transfers
This table contains data about erc20, erc721, and erc1155 token transfers, indexed by the transaction hash.
CREATE TABLE ethereum.token_transfers (
transaction_hash text,
block_number bigint,
log_index bigint,
from_address text,
is_erc1155 boolean,
is_erc20 boolean,
is_erc721 boolean,
to_address text,
token_address text,
token_id text,
token_transfer_value text,
value decimal,
PRIMARY KEY (transaction_hash, block_number, log_index)
) WITH CLUSTERING ORDER BY (block_number ASC, log_index ASC);
Example queries
-
Query
-
Result
SELECT * FROM token_transfers WHERE transaction_hash='0x463396d2690820c2895df4838445d0dc009aa7f61ca09ba09298377d4da041b2' AND block_number=4967992 AND log_index=123;
@ Row 1
----------------------+--------------------------------------------------------------------
transaction_hash | 0x463396d2690820c2895df4838445d0dc009aa7f61ca09ba09298377d4da041b2
block_number | 4967992
log_index | 123
from_address | 0x0000000000000000000000001c60faf0c9db419d85dc4a1280d6266e34214c9a
is_erc1155 | False
is_erc20 | True
is_erc721 | False
to_address | 0x0000000000000000000000001aebc2b33731520749cdeab8943df5b8110af41e
token_address | 0xb64ef51c888972c908cfacf59b47c1afbc0ab8ac
token_id | null
token_transfer_value | null
value | 90628965
(1 rows)
Token transfers by token address
This table contains data about erc20, erc721, and erc1155 token transfers, indexed by the by the token’s address.
CREATE TABLE ethereum.token_transfers_by_token_address (
token_address text,
block_number bigint,
transaction_hash text,
log_index bigint,
block_timestamp timestamp,
from_address text,
is_erc1155 boolean,
is_erc20 boolean,
is_erc721 boolean,
to_address text,
token_id text,
token_transfer_value text,
value decimal,
PRIMARY KEY (token_address, block_number, transaction_hash, log_index)
) WITH CLUSTERING ORDER BY (block_number DESC, transaction_hash ASC, log_index ASC);
Example queries
-
Query
-
Result
SELECT * FROM token_transfers_by_token_address WHERE token_address='0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' LIMIT 1;
@ Row 1
----------------------+--------------------------------------------------------------------
token_address | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
block_number | 16582643
transaction_hash | 0x10b503aa6b59854a6ba42f968aeed7bea8064509ad8fe09608d61974db1f5b89
log_index | 114
block_timestamp | 2023-02-08 07:42:47.000000+0000
from_address | 0xf16e9b0d03470827a95cdfd0cb8a8a3b46969b91
is_erc1155 | False
is_erc20 | True
is_erc721 | False
to_address | 0xe5e431449538be7c05977e3bca03cd60be12b6b1
token_id | null
token_transfer_value | 2000000000
value | 2000000000
(1 rows)
Tokens
A row is inserted into this table whenever an erc20 token is created. The row contains basic metadata about the token.
CREATE TABLE ethereum.tokens (
address text,
block_number bigint,
block_hash text,
block_timestamp timestamp,
decimals int,
name text,
symbol text,
total_supply text,
PRIMARY KEY (address, block_number)
) WITH CLUSTERING ORDER BY (block_number ASC);
Example queries
-
Query
-
Result
SELECT * FROM tokens WHERE block_number=12613232 AND address='0x17c5134461f501b4c00ac8082d2d5a3ff0ba2d3e';
@ Row 1
-----------------+--------------------------------------------------------------------
address | 0x17c5134461f501b4c00ac8082d2d5a3ff0ba2d3e
block_number | 12613232
block_hash | 0xd125a86fd8bb9364fffaf66bbe277f1d4f2dec429ab73ac753b4cc819e8b1e80
block_timestamp | 2021-06-11 12:24:53.000000+0000
decimals | 18
name | YUANZE
symbol | YUANZE
total_supply | 100000000000000000000000000000
(1 rows)
Traces
This table contains data for internal transactions that occur in a block, indexed by the block number. An internal transaction is when a smart contract calls a different smart contract in the same transaction.
CREATE TABLE ethereum.traces (
block_number bigint,
transaction_hash text,
internal_transaction_index bigint,
block_hash text,
block_timestamp timestamp,
call_type text,
error text,
from_address text,
gas_limit bigint,
gas_used bigint,
input text,
output text,
status decimal,
to_address text,
type_trace_address text,
value decimal,
PRIMARY KEY (block_number, transaction_hash, internal_transaction_index)
) WITH CLUSTERING ORDER BY (transaction_hash ASC, internal_transaction_index ASC);
Traces by date
This table contains data for internal transactions that occur in a block, indexed by the date the block was mined on. Date queries are formatted as YYYY-MM-DD. An internal transaction is when a smart contract calls a different smart contract in the same transaction.
CREATE TABLE ethereum.traces_by_date (
date date,
block_number bigint,
transaction_hash text,
internal_transaction_index bigint,
block_hash text,
block_timestamp timestamp,
call_type text,
error text,
from_address text,
gas_limit bigint,
gas_used bigint,
input text,
output text,
status decimal,
to_address text,
type_trace_address text,
value decimal,
PRIMARY KEY (date, block_number, transaction_hash, internal_transaction_index)
) WITH CLUSTERING ORDER BY (block_number DESC, transaction_hash ASC, internal_transaction_index ASC);
Transactions
This table contains high-level transaction metadata, indexed by block_hash
.
CREATE TABLE ethereum.transactions (
block_hash text,
transaction_index bigint,
hash text,
base_fee text,
block_number bigint,
block_timestamp text,
burnt_fee text,
from_address text,
gas bigint,
gas_price text,
input text,
max_fee text,
max_priority_fee text,
"method" text,
nonce bigint,
receipt_contract_address text,
receipt_cumulative_gas_used bigint,
receipt_gas_used bigint,
receipt_root text,
receipt_status bigint,
timestamp timestamp,
to_address text,
transaction_fees text,
transaction_value text,
txn_savings text,
txn_type text,
value decimal,
PRIMARY KEY (block_hash, transaction_index, hash)
) WITH CLUSTERING ORDER BY (transaction_index ASC, hash ASC);
Example queries
-
Query
-
Result
SELECT * FROM transactions WHERE block_hash='0x57d1ad19c25804ab3941baccaa588a4ea0e6cd44b965a6ec4204c60b9e7ce34f' AND transaction_index=4 AND hash='0x1ffc4aff0d7b32694bd3e430f2a6b02621c3f9662f70b0b88afe558358fa0ee4';
@ Row 1
-----------------------------+--------------------------------------------------------------------
block_hash | 0x57d1ad19c25804ab3941baccaa588a4ea0e6cd44b965a6ec4204c60b9e7ce34f
transaction_index | 4
hash | 0x1ffc4aff0d7b32694bd3e430f2a6b02621c3f9662f70b0b88afe558358fa0ee4
base_fee | null
block_number | 3040924
block_timestamp | 0x588433a6
burnt_fee | null
from_address | 0xb67b8ef0ff89df9f0ce013781a601ab29557c10b
gas | 21000
gas_price | 0.00000002
input | 0x
max_fee | null
max_priority_fee | null
method | transfer
nonce | 14
receipt_contract_address | null
receipt_cumulative_gas_used | 131650
receipt_gas_used | 21000
receipt_root | null
receipt_status | 0
timestamp | null
to_address | 0x91337a300e0361bddb2e377dd4e88ccb7796663d
transaction_fees | 0.00042
transaction_value | null
txn_savings | null
txn_type | null
value | 900
(1 rows)
Transactions by address
This table contains high-level transaction metadata, indexed by the address that originated the transaction.
CREATE TABLE ethereum.transactions_by_address (
from_address text,
block_number bigint,
hash text,
transaction_index bigint,
base_fee text,
block_hash text,
block_timestamp text,
burnt_fee text,
gas bigint,
gas_price text,
input text,
max_fee text,
max_priority_fee text,
"method" text,
nonce bigint,
receipt_contract_address text,
receipt_cumulative_gas_used bigint,
receipt_gas_used bigint,
receipt_root text,
receipt_status bigint,
timestamp timestamp,
to_address text,
transaction_fees text,
transaction_value text,
txn_savings text,
txn_type text,
value decimal,
PRIMARY KEY (from_address, block_number, hash, transaction_index)
) WITH CLUSTERING ORDER BY (block_number DESC, hash ASC, transaction_index ASC);
Example queries
-
Query
-
Result
SELECT * FROM transactions_by_address WHERE from_address='0xa53a13a80d72a855481de5211e7654fabdfe3526' LIMIT 1;
@ Row 1
-----------------------------+--------------------------------------------------------------------------------------------------------------------------------------------
from_address | 0xa53a13a80d72a855481de5211e7654fabdfe3526
block_number | 16580615
hash | 0x63fdf3d5caef8be475992c0cbb022ebba648709ee2866978224864cfd30045e3
transaction_index | 152
base_fee | 30081978711000000000
block_hash | 0x0f1da9aecd6643b5471a923026cde6b6a7e0835a6a8572029e33a1a8004dae1a
block_timestamp | 0x63e2f313
burnt_fee | 2751027035099661
gas | 101195
gas_price | 0.000000030353688502
input | 0x6e553f65000000000000000000000000000000000000000000003f870857a3e0e3800000000000000000000000000000a53a13a80d72a855481de5211e7654fabdfe3526
max_fee | 39.087318878
max_priority_fee | 0.271709791
method | deposit(uint256,address)
nonce | 11158
receipt_contract_address | null
receipt_cumulative_gas_used | 21056935
receipt_gas_used | 91451
receipt_root | null
receipt_status | 1
timestamp | null
to_address | 0x3835a58ca93cdb5f912519ad366826ac9a752510
transaction_fees | 0.002775875167196402
transaction_value | null
txn_savings | 0
txn_type | 2 (EIP-1559)
value | 0
(1 rows)
Transactions by date
This table contains high-level transaction metadata, indexed by the date that block was mined on (formatted YYYY-MM-DD).
CREATE TABLE ethereum.transactions_by_date (
date date,
block_number bigint,
hash text,
base_fee text,
block_hash text,
block_timestamp text,
burnt_fee text,
from_address text,
gas bigint,
gas_price text,
input text,
max_fee text,
max_priority_fee text,
"method" text,
nonce bigint,
receipt_contract_address text,
receipt_cumulative_gas_used bigint,
receipt_gas_used bigint,
receipt_root text,
receipt_status bigint,
timestamp timestamp,
to_address text,
transaction_fees text,
transaction_index bigint,
transaction_value text,
txn_savings text,
txn_type text,
value decimal,
PRIMARY KEY (date, block_number, hash)
) WITH CLUSTERING ORDER BY (block_number DESC, hash ASC);
Example queries
-
Query
-
Result
SELECT * FROM transactions_by_date WHERE date='2023-01-27' LIMIT 1;
@ Row 1
-----------------------------+--------------------------------------------------------------------
date | 2023-01-27
block_number | 16501588
hash | 0x00b8c67f7ceb8ffeec50ba385bc0b475d52f6712ca541438ac903c8fac190df9
base_fee | 13018936536000000000
block_hash | 0x7786a2df03cd7426550d210de107c73d602d5cabc3bbca33dfe57c45ba9947b5
block_timestamp | 0x63d4657f
burnt_fee | 506215309329288
from_address | 0x7a7f78a2af5aef01a889e8713083ab77dcc9fc9b
gas | 90000
gas_price | 0.000000052
input | 0x9ac84414
max_fee | null
max_priority_fee | null
method | sweepEth()
nonce | 29840
receipt_contract_address | null
receipt_cumulative_gas_used | 24467307
receipt_gas_used | 38883
receipt_root | null
receipt_status | 1
timestamp | null
to_address | 0x175ceca0add1f3bed8afc762e2761eb5ca4f1b05
transaction_fees | 0.002021916
transaction_index | 1
transaction_value | null
txn_savings | 0
txn_type | 0 (Legacy)
value | 0
(1 rows)
Transactions by hash
This table contains high-level transaction metadata, indexed by the transaction hash.
CREATE TABLE ethereum.transactions_by_hash (
hash text,
transaction_index bigint,
block_number bigint,
base_fee text,
block_hash text,
block_timestamp text,
burnt_fee text,
from_address text,
gas bigint,
gas_price text,
input text,
max_fee text,
max_priority_fee text,
"method" text,
nonce bigint,
receipt_contract_address text,
receipt_cumulative_gas_used bigint,
receipt_gas_used bigint,
receipt_root text,
receipt_status bigint,
timestamp timestamp,
to_address text,
transaction_fees text,
transaction_value text,
txn_savings text,
txn_type text,
value decimal,
PRIMARY KEY (hash, transaction_index, block_number)
) WITH CLUSTERING ORDER BY (transaction_index ASC, block_number ASC);
Example queries
-
Query
-
Result
SELECT * FROM transactions_by_hash WHERE hash='0x0c25a6099b2e9ae1858946ba017e3f12d01c124157b3ec4635fd71410deb421a';
@ Row 1
-----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
hash | 0x0c25a6099b2e9ae1858946ba017e3f12d01c124157b3ec4635fd71410deb421a
transaction_index | 90
block_number | 16580433
base_fee | 37981398169000000000
block_hash | 0xc2b0ce160a4d21f64db7bd850b9090c12ad5c6e9078b42c1528721c2549b2a37
block_timestamp | 0x63e2ea7f
burnt_fee | 5487096630679092
from_address | 0xa53a13a80d72a855481de5211e7654fabdfe3526
gas | 231343
gas_price | 0.000000038294891283
input | 0xef55f6dd00000000000000000000000000000000000000000000000000000000000000400000000000000000000000006b7a87899490ece95443e979ca9485cbe7e715227b40dc85b02c274f8304bf37860c5259ba5c6d04fc05ebbc195d8e949225d7450000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000000010000000000000000000000007ea2be2df7ba6e54b1a9c70676f668455e329d29000000000000000000000000a53a13a80d72a855481de5211e7654fabdfe352600000000000000000000000000000000000000000000000000000045cfb71c0800000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a6d756c7469636861696e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e7472616e73666572746f2e78797a000000000000000000000000000000000000
max_fee | 49.871379605
max_priority_fee | 0.313493114
method | 0xef55f6dd
nonce | 11152
receipt_contract_address | null
receipt_cumulative_gas_used | 8316973
receipt_gas_used | 144468
receipt_root | null
receipt_status | 1
timestamp | null
to_address | 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae
transaction_fees | 0.005532386353872444
transaction_value | null
txn_savings | 0
txn_type | 2 (EIP-1559)
value | 0
(1 rows)