We construct customs tables which cover the entirety of a type of activity on the blockchain and thereby enable you to effortlessly aggregate lots of data with as little friction as possible.
Our docs are now available at dune.com/docs. We'll keep this around as a reference, but we won't update them and eventually plan to deprecate.

Abstractions are custom tables that are maintained by Dune and our community. They allow you to gain access to more complex SQL operators like creating your own tables, looping through values or other operations that are more catered towards database administration. This sometimes is necessary to aggregate the on-chain data or simplify the process of querying for data.
This public github repository hosts the logic to construct the tables and views which make up our abstractions.

You can check for existing abstractions in our public github repository. You can generally divide them into 2 distinct categories:

Sector Abstractions are tables like dex.trades, erc20.stablecoins, lending.borrow etc.
These abstractions take in data from multiple contracts and projects, standardize the data across them and therefore make it very easy to query for this data and compare the metrics of different projects with each other.
Most of the sector Dashboards depend on sector abstractions. This introduces an interesting dynamic in which projects can easily get their data into these dashboards by making a pull request to our public github repo. Team Dune and the community are always improving on these sector abstractions, all new additions to existing ones are always welcome.

Projects can assemble their data into one neat table that has all the data they need in one place. To do this, you can construct views or tables in our abstractions.
The main advantage here over just constructing a view is that you are able to deal with bigger amounts of data in our abstractions since we can run them automatically in the background every few hours.

Our abstractions are open to all teams and projects in general, but we do reserve the right to reject pull requests.
If you do choose to contribute to abstractions please make sure your addition actually works and produces the intended results. Furthermore please give us a short summary about what you are trying to achieve and what your project does.
If applicable please construct a view in which you show us that your addition produces the intended results.
Last modified 12d ago
Copy link
On this page
What are abstractions?
Which abstractions are there?
Sector Abstractions
Project Abstractions
Contributing to abstractions