• Glossary
  • Support
  • Downloads
  • DataStax Home
Get Live Help
Expand All
Collapse All

DataStax Astra DB Serverless Documentation

    • Overview
      • Release notes
      • Astra DB FAQs
      • Astra DB glossary
      • Get support
    • Getting Started
      • Grant a user access
      • Load and retrieve data
        • Use DSBulk to load data
        • Use Data Loader in Astra Portal
      • Connect a driver
      • Build sample apps
      • Use integrations
    • Planning
      • Plan options
      • Database regions
    • Securing
      • Security highlights
      • Security guidelines
      • Default user permissions
      • Change your password
      • Reset your password
      • Authentication and Authorization
      • Astra DB Plugin for HashiCorp Vault
    • Connecting
      • Connecting private endpoints
        • AWS Private Link
        • Azure Private Link
        • GCP Private Endpoints
        • Connecting custom DNS
      • Connecting Change Data Capture (CDC)
      • Connecting CQL console
      • Connect the Spark Cassandra Connector to Astra
      • Drivers for Astra DB
        • Connecting C++ driver
        • Connecting C# driver
        • Connecting Java driver
        • Connecting Node.js driver
        • Connecting Python driver
        • Drivers retry policies
      • Connecting Legacy drivers
      • Get Secure Connect Bundle
    • Migrating
      • Components
      • FAQs
      • Preliminary steps
        • Feasibility checks
        • Deployment and infrastructure considerations
        • Create target environment for migration
        • Understand rollback options
      • Phase 1: Deploy ZDM Proxy and connect client applications
        • Set up the ZDM Proxy Automation with ZDM Utility
        • Deploy the ZDM Proxy and monitoring
        • Configure Transport Layer Security
        • Connect client applications to ZDM Proxy
        • Leverage metrics provided by ZDM Proxy
        • Manage your ZDM Proxy instances
      • Phase 2: Migrate and validate data
      • Phase 3: Enable asynchronous dual reads
      • Phase 4: Change read routing to Target
      • Phase 5: Connect client applications directly to Target
      • Troubleshooting
        • Troubleshooting tips
        • Troubleshooting scenarios
      • Glossary
      • Contribution guidelines
      • Release Notes
    • Managing
      • Managing your organization
        • User permissions
        • Pricing and billing
        • Audit Logs
        • Bring Your Own Key
          • BYOK AWS Astra DB console
          • BYOK GCP Astra DB console
          • BYOK AWS DevOps API
          • BYOK GCP DevOps API
        • Configuring SSO
          • Configure SSO for Microsoft Azure AD
          • Configure SSO for Okta
          • Configure SSO for OneLogin
      • Managing your database
        • Create your database
        • View your databases
        • Database statuses
        • Use DSBulk to load data
        • Use Data Loader in Astra Portal
        • Monitor your databases
        • Export metrics to third party
          • Export metrics via Astra Portal
          • Export metrics via DevOps API
        • Manage access lists
        • Manage multiple keyspaces
        • Using multiple regions
        • Terminate your database
      • Managing with DevOps API
        • Managing database lifecycle
        • Managing roles
        • Managing users
        • Managing tokens
        • Managing BYOK AWS
        • Managing BYOK GCP
        • Managing access list
        • Managing multiple regions
        • Get private endpoints
        • AWS PrivateLink
        • Azure PrivateLink
        • GCP Private Service
    • Astra CLI
    • Astra Block
      • Quickstart
      • FAQ
      • Data model
      • About NFTs
    • Developing with Stargate APIs
      • Develop with REST
      • Develop with Document
      • Develop with GraphQL
        • Develop with GraphQL (CQL-first)
        • Develop with GraphQL (Schema-first)
      • Develop with gRPC
        • gRPC Rust client
        • gRPC Go client
        • gRPC Node.js client
        • gRPC Java client
      • Develop with CQL
      • Tooling Resources
      • Node.js Document API client
      • Node.js REST API client
    • Stargate QuickStarts
      • Document API QuickStart
      • REST API QuickStart
      • GraphQL API CQL-first QuickStart
    • API References
      • DevOps REST API v2
      • Stargate Document API v2
      • Stargate REST API v2
  • DataStax Astra DB Serverless Documentation
  • Astra Block
  • Data model

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:

  • Ethereum data model

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.

Running example queries in the Astra CQL Console
  1. Log into the Astra Portal.

  2. Click Databases in the left-hand navigation menu and navigate to your Block-enabled database.

  3. Click the CQL Console tab.

  4. At the cqlsh prompt, set the keyspace for the current session (in this case ethereum).

    USE ethereum;
  5. Copy an example query from one of the sections below and paste it into the console to see the results.

  6. (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

  • Block numbers by date

  • Contract ABIs

  • Contracts

  • Dashboard analytics

  • ETH blocks

  • Event signatures

  • Logs

  • Logs by date

  • NFTs

  • Reorg blocks

  • Sorted NFTs

  • Token transfers

  • Token transfers by token address

  • Tokens

  • Traces

  • Traces by date

  • Transactions

  • Transactions by address

  • Transactions by date

  • Transactions by hash

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.

Table schema
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

Search asset historical balances by wallet or contract address
SELECT * FROM assets where address='0xa53a13a80d72a855481de5211e7654fabdfe3526' LIMIT 1;
Search asset historical balances by wallet or contract address
@ 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.

Table schema
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

Search for the first block number that occurred on a date
SELECT * FROM block_numbers_by_date WHERE date='2023-01-27' ORDER BY block_number ASC LIMIT 1;
Search for the first block number that occurred on a date
@ Row 1
-----------------+---------------------------------
 date            | 2023-01-27
 block_number    | 16494436
 block_timestamp | 2023-01-27 00:00:11.000000+0000

(1 rows)
  • Query

  • Result

Search for the last block number that occurred on a date
SELECT * FROM block_numbers_by_date WHERE date='2023-01-27' LIMIT 1;
Search for the last block number that occurred on a date
@ Row 1
-----------------+---------------------------------
 date            | 2023-01-27
 block_number    | 16501588
 block_timestamp | 2023-01-27 23:59:59.000000+0000

(1 rows)

Contract ABIs

Table schema
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).

Table schema
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

Search contracts by address and block number
SELECT * FROM contracts WHERE address='0xfdeed771e8b00eb1e72243acbd309ed83ad45f6e' AND block_number=9578734;
Search contracts by address and block number
@ 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.

Table schema
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

Search by ID
SELECT * FROM dashboard_analytics WHERE id=1;
Search by ID
@ 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.

Table schema
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

Search one ETH block entry from Block Group 134
SELECT * FROM eth_blocks WHERE blocks_group=134 LIMIT 1;
Search one ETH block entry from Block Group 134
@ 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

Search ETH blocks by block number
SELECT * FROM eth_blocks WHERE blocks_group=154 AND number=15399999 AND hash='0x25201aacfffd0ffd04e63e02ef82b2e15149f1c5b2430e338c32bb8520d107d9';
Search ETH blocks by block number
@ 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.

Table schema
CREATE TABLE ethereum.event_signatures (
    event_hex text PRIMARY KEY,
    event_name text,
    event_signature text
);

Example queries

  • Query

  • Result

Search for human-readable event signatures by event hash
SELECT * FROM event_signatures WHERE event_hex='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef';
Search for human-readable event signatures by event hash
@ Row 1
-----------------+--------------------------------------------------------------------
 event_hex       | 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef
 event_name      | Transfer
 event_signature | Transfer(address,address,uint256)

(1 rows)

Logs

Table schema
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

Search logs by block number, transaction hash, and log index
SELECT * FROM logs WHERE transaction_hash = '0xd81829eef1642054fad5077a3ca234654771187af5c6dc3b8bd6a9d2ddc7078a' and block_number = 15832763 and log_index = 44;
Search logs by block number, transaction hash, and log index
@ 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

Search for decoded data by block number, transaction hash, and log index
SELECT decoded_data FROM logs WHERE transaction_hash = '0xd81829eef1642054fad5077a3ca234654771187af5c6dc3b8bd6a9d2ddc7078a' and block_number = 15832763 and log_index = 44;
Search for decoded data by block number, transaction hash, and log index
@ Row 1
--------------+---------------------------------------------------------------------------------
 decoded_data | {"src":"0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45","wad":"646006057621001850"}

(1 rows)

Logs by date

Table schema
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.

Table schema
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

Search NFTs by contract address and token ID
SELECT * FROM nfts WHERE contract_address='0x7A8cE4BeFfE38f431A2f12e1a8B7d7dAE62DF359' AND token_id='100';
Search NFTs by contract address and token ID
@ 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

Table schema
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.

Table schema
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.

Table schema
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

Search token transfers by transaction hash, block number, and log index
SELECT * FROM token_transfers WHERE transaction_hash='0x463396d2690820c2895df4838445d0dc009aa7f61ca09ba09298377d4da041b2' AND block_number=4967992 AND log_index=123;
Search token transfers by transaction hash, block number, and log index
@ 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.

Table schema
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

Search token transfers by token address:
SELECT * FROM token_transfers_by_token_address WHERE token_address='0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' LIMIT 1;
Search token transfers by token address:
@ 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.

Table schema
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

Search ERC20 tokens by block number and address
SELECT * FROM tokens WHERE block_number=12613232 AND address='0x17c5134461f501b4c00ac8082d2d5a3ff0ba2d3e';
Search ERC20 tokens by block number and address
@ 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.

Table schema
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.

Table schema
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.

Table schema
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

Search transactions by block hash, transaction index, and hash
SELECT * FROM transactions WHERE block_hash='0x57d1ad19c25804ab3941baccaa588a4ea0e6cd44b965a6ec4204c60b9e7ce34f' AND transaction_index=4 AND hash='0x1ffc4aff0d7b32694bd3e430f2a6b02621c3f9662f70b0b88afe558358fa0ee4';
Search transactions by block hash, transaction index, and hash
@ 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.

Table schema
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

Search transactions by transaction sender
SELECT * FROM transactions_by_address WHERE from_address='0xa53a13a80d72a855481de5211e7654fabdfe3526' LIMIT 1;
Search transactions by transaction sender
@ 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).

Table schema
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

Search transactions by date
SELECT * FROM transactions_by_date WHERE date='2023-01-27' LIMIT 1;
Search transactions by date
@ 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.

Table schema
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

Search transactions by hash
SELECT * FROM transactions_by_hash WHERE hash='0x0c25a6099b2e9ae1858946ba017e3f12d01c124157b3ec4635fd71410deb421a';
Search transactions by hash
@ 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)
FAQ About NFTs

General Inquiries: +1 (650) 389-6000 info@datastax.com

© DataStax | Privacy policy | Terms of use

DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Kubernetes is the registered trademark of the Linux Foundation.

landing_page landingpage