reservoir.collections

Dune Docs

Get Started

Web App

Query Engine

Data Catalog

SQL API Reference

Developer API Reference

Datashare

Blockchain Integrations

Start building

Support

Collections

Dune is a web-based platform that allows you to query public blockchain data and aggregate it into beautiful dashboards.

Welcome

Quickstart

Navigate the Ever-Expanding World of Web3 Data with Ease, from Beginners to Experts

Web3 Data Resources

How to write a query to find out the monthly $ gas spent for your wallet

Create your first query

How to craft AI-assisted queries with ease

Create AI-Assisted Queries

Dune AI Prompt Engineering

Create New Content

How to create a combination bar chart and line chart to visualize the monthly $ gas spent for your wallet

Create your first visualization

Navigate the Query Editor

Find Datasets on Dune

How to build a Farcaster Frame using Frog and Dune API

Build a Frame with Dune API

Streamline tracking of your crypto transactions, including profit and loss calculations and determining cost basis, using Dune.

2023 Crypto Profits and Losses with Dune API

Export Data Out of Dune

A step-by-step guide to creating and managing team accounts on Dune.

Create and Manage Teams on Dune

What is the credit system on Dune and how credits work on Dune

Understanding Credits on Dune

How to efficiently search for content on Dune

Search for Content on Dune

Share Dune Content

How to share your query result and charts with others

Share your query

How to transfer ownership of your creations

Transfer Ownership

Dune has built the perfect tools to efficiently extract information from blockchain data.

Overview

The query editor allows you to query blockchain data using DuneSQL.

Writing Queries

The Data Explorer allows you to search for blockchain and other data to use in your Queries. Here's how it works.

Finding Tables

Parameters allow you to implement variables in certain parts of your Query. This is useful if you want to create a Query that you can reuse with different parameters.

Using Parameters

Learn how to leverage the power of query scheduling for a more reliable and up-to-date dashboard display!

Scheduling Queries

Queries have a version history, where you can compare and revert to previous query versions.

Version History

Charts are good for condensing data points into a Visualization.

Create Graphs

Counters give you a way to display a single number prominently.

Create counters

Tables are a way to display your data in a tabular format.

Formatting Tables

Dashboards are where Dune's content lives and gets discovered.

Create Dashboards

Instead of working with the logs and traces in their raw states, on Dune we decode smart contract activity into nice human-readable tables.

Decoding Contracts

Dune Teams are shared workspaces for Wizards to collaborate within.

Teams on Dune

Wand is a beta suite of tools for writing SQL queries with the help of large language models.

Dune AI

Upload Data

Embeds allow you to enjoy beautiful, updating Dune charts across the web!

Share your work

Get the most out of Dune's powerful content search functionality

Search content

Alerts allow you to receive notifications based on any query

Alerts

DuneSQL, a Trino fork, is fine-tuned for blockchain analytics.

When and how do queries on Dune get executed?

Executions

The "Query View" feature in DuneSQL allows you to use an existing query as a view in another query. This powerful functionality enables you to create reusable queries, build complex queries, and take advantage of existing queries as views.

Query Views

Materialized tables are a way to store the results of a query in a table that can be queried like any other table. This is useful when you have a query that takes a long time to run, or when you want to use the results of a query in another query.

Materialized Views

Get the most out of DuneSQL by writing efficient queries.

Writing Efficient Queries

The following table lists all of the keywords that are reserved in DuneSQL, along with their status in the SQL standard. These reserved keywords must be quoted (using double quotes) in order to be used as an identifier.

Reserved keywords

DuneSQL supports a wide range of built-in functions and operators.

Aggregate functions

Array functions and operators

Base58 functions

Binary

Bitwise

Comparisons

Conditional expressions

Conversions

Date and time functions and operators

Decimal functions and operators

Functions to decode raw EVM events and function calls in DuneSQL.

EVM Decoding Functions

HyperLogLog functions

JSON functions

Lambda expressions are anonymous functions which are passed as arguments to higher-order SQL functions.

Lambda expressions

LiveFetch functions send HTTP requests to a specified URL.

LiveFetch functions

Logical operators

Map functions and operators

Mathematical functions and operators

Machine learning functions

Quantile digest functions

Regular expression functions

Set Digest functions

SS58 functions

Tron address functions

String functions and operators

System information

T-Digest functions

Teradata functions

URL functions

UUID functions

Varbinary functions (DuneSQL)

Window functions

Dune's extensive data catalog provides detailed analytics for a wide range of blockchains.

Understand the frequency of updates for various data types on Dune.

Data Freshness

Dune offers several ways to bring your data to the platform.

Bring your Data

Curated data Tables are the easiest way to gain insights on Dune

Curated Data Overview

The `dex.trades` table captures detailed data on decentralized exchange (DEX) trades, recording all raw trade events across various  protocols and blockchains.

DEX Trades

dex.trades

The `dex_aggregator.trades` table captures data on actions taken on aggregators - recording all events across various aggregators and blockchains.

DEX Aggregator Trades

dex_aggregator.trades

Description of the nft.trades table on Dune

NFT Trades

nft.trades

Prices

Labels provide valuable context and clarity to blockchain addresses, enhancing the readability and understanding of blockchain transaction data.

Labels Data

Description of the labels.ens table on Dune

labels.ens

Description of the labels.addresses table on Dune

All labels

labels.addresses

Exploring the landscape of digital assets on the blockchain.

Tokens

Balances

Token Balances

EVM Overview

Arbitrum One Overview

Avalanche C-Chain Overview

Base Overview

Blast Overview

BNB Chain Overview

BOB Overview

Celo Overview

degen Overview

Ethereum Overview

Fantom Overview

Gnosis Chain Overview

Linea Overview

Mantle Overview

Mode Overview

Optimism Overview

Polygon PoS Network Overview

Polygon zkEVM Overview

Scroll Overview

Sei Overview

Sepolia Testnet Overview

zkSync Overview

Zora Overview

Aptos is a next-generation blockchain designed for scalability, security, and reliability.

Column name	Type	Description
id	string	Internal collection id
slug	string	Collection slug
name	string	Collection name
description	string	Collection description
token_count	bigint	Id of the token in the collection
contract	string	Contract address
day1_rank	bigint	Ranking in the previous day
day7_rank	bigint	Ranking in the previous 7 days
day30_rank	bigint	Ranking in the previous 30 days
all_time_rank	bigint	All time ranking
day1_volume	decimal	Trade volume in the previous day
day7_volume	decimal	Trade volume in the previous 7 days
day30_volume	decimal	Trade volume in the previous 30 days
all_time_volume	decimal	All time trade volume
day1_volume_change	double	Trade volume change in the previous day
day7_volume_change	double	Trade volume change in the previous 7 days
day30_volume_change	double	Trade volume change in the previous 30 days
floor\ask_value	decimal	Current floor sale price (native currency)
day1_floor_sale_value	decimal	Floor sale price in the previous day
day7_floor_sale_value	decimal	Floor sale price 7 days ago
day30_floor_sale_value	decimal	Floor sale price 30 days ago
day1_floor_sale_change	double	Floor sale price change from previous day
day7_floor_sale_change	double	Floor sale price change from 7 days ago
day30_floor_sale_change	double	Floor sale price change from 30 days ago
created_at	timestamp	Timestamp the collection was created
updated_at	timestamp	Timestamp the collection was updated

Curated Data

EVM Networks

other Networks

Community Data

Collections

reservoir.collections

Curated Data

EVM Networks

other Networks

Community Data

​reservoir.collections

reservoir.collections