Data Models

Suggest Edits

For detailed information on ZettaBlock's data models, please visit our Data Catalog.

ZettaBlock tables

In this section, you can find descriptions of all ZettaBlock tables and supported chains at different levels of abstraction.

Here is an overview the tables available:

  • Raw/Decoded data - blocks, transactions, logs and traces
    • Raw and decoded data are merged and supported under the raw data tags (see above) as of 2022/12/02
  • Metadata Tables - erc20, nft_tokens, includes names, ids, symbols, decimals
  • Offchain Abstraction data - token prices
  • Core event data - erc721.ERC721_evt_Transfer, erc20.ERC20_evt_Transfer, erc1155.ERC1155_evt_TransferSingle
  • dApp specific data - such as opensea.WyvernExchange_evt_OrdersMatched, opensea.WyvernExchange_call_atomicMatch_
  • DEX - pools, swaps, liquidity actions
  • NFT - mints, trades overall and by marketplace
  • ENS - ENS names, Twitter handles, owners, and more, for each ENS Registration and Renewal event
  • Bridges - bridge name, chain_id and inflow (bool) for Ethereum

Available Chains

For an up-to-date overview on which chains are available on ZettaBlock, please refer to the For detailed information on ZettaBlock's data models, please visit our [Data Catalog](https://docs.zettablock.com/page/data-catalog).Data Catalog.

How Tables are Generated from Raw Data

The diagram blow showcases a high level overview of ZettaBlock's approach to creating tables from raw data. As shown below, the hierarchy is split into 3 levels of tables - bronze, silver an gold. Bronze tables are derived from raw on-chain data that is then combined with decoded on-chain data and funnelled to create the silver layer of tables.

As an example work flow for a user, imagine following the flow of data from the transaction of buying an NFT on OpenSea. This interaction with the OpenSea contract results in transfer events that are pulled into our Bronze tables and through data modelling eventually create our abstraction or gold level tables. A visualization of this flow is shown below.

For detailed information on ZettaBlock's data models, please visit our Data Catalog.

Updated 4 months ago