This video covers all important topics around data tables.
Dune's Table Structure
Dune aggregates blockchain data into an accessilbe PostgreSQL database. The schema can be understood in the following way:
1) Low-level data (raw transaction data) provides detailed records of all activities on the blockchain
2) Decoded Data tables use the Application binary interface of the respective smart contract to turn the encoded data into decoded data.
You can signal to us that you need decoded data for a smart contract via this part of our website. Read more about contract submission in "Adding new contracts"
3) Abstractions are higher-level created tables that return aggregated/standarized data on sectors/topics. The scripts to generate these tables are available in this github repository.
You can currently query data from Ethereum, Polygon, Binance Smart Chain, Optimism and Gnosis Chain.
How do I find the data I need?
This section aims to guide you in the process of finding the right data tables to work on your project.
Different Use Cases of Dune require different data tables to pull data from, study these carefully and you'll recognize what significance each of the data table types has for your Queries and Dashboards.
Most of the tables on Dune are populated by Dune and are just a translation of the blockchain data to SQL tables, but in the case of abstractions and dune_user_generated tables you can actually create your own tables that aggregate or modify the dataset to your need.