Skip to content

Tables

Dune enables you to query data on our supported chains at different levels of abstraction.

To start with, you have access to the raw tables for each supported blockchain, with tables like blocks and transactions. This is the most flexible option.

To make it easier to work with smart contracts, Dune also provides decoded data as individual, human readable tables. We use the ABI for smart contracts and the interface standard for standardized token smart contracts (ERC20, ERC721 etc.). We've indexed over 280k contracts as of writing, and you can submit new contracts.

On top of that, we're building a set of Spells for common use cases (e.g. NFTs or DEX) and third party datasets.

Here is an overview what is available:

  • Raw data: unedited, raw and encoded blockchain data
  • Decoded data: (most popular) view the decoded calls and events made to smart contracts
  • Spells: custom tables that are maintained by Dune and our community
  • Community: partnering with select organizations for off-chain data
  • Prices: prices from third party data providers
  • User generated: construct your own view, function or table inside of our database

Available Chainsยถ

Learn about the chains we have available for Querying here:

How Tables are Generated from Raw Ethereum Dataยถ

There are three main tables in Dune generated from raw Ethereum data, which are the source truth for everything else on the platform.

token data to dune tables graph

The rest of Dune's tables are built from these three:

tables levels of abstraction graph

If you can't figure out the table to query from, you'll need to dig through an example transaction hash on the relevant chain's blockchain explorer to figure out the call/evt Contract.

Essentially go tx_hash โ†’ contract in "to" โ†’ code and pull the contract name from there. If it's a proxy, the blockchain explorer should link you to an implementation address.

Dune V2 data also has a handy Lineage Graph that lets you explore how all of Dune's data tables are related to each other - learn more about that in the Lineage Graph section here.

what should a trade table look like

You should always try to use the Decoded or Spell tables when you can as these are human-readable and pre-organized so they're much easier to use.