Legacy Price Tables

Legacy Tables

Modern Alternatives

prices.usd / prices.usd_daily

prices.usd_latest

Legacy Table Structure

Historical price tables - still functional but no new tokens will be added

USD Prices (Legacy)

Dune Docs

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

Learn to analyze daily DEX trading volumes across different blockchains

Create your first query

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

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

Web App

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

Create Dashboards

Mint Dashboards on Dune to Support Wizards

Mint Dashboards

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

Found a security issue within our application?

Bug Bounty

Explains how Dune tracks contributions across queries and dashboards.

Measuring User Activity

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

Query Engine

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

Overview of the data types supported in DuneSQL.

Datatypes

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

Overview of binary operators and functions in DuneSQL.

Binary

Bitwise

Helper functions for linking to chain explorers and transactions.

Chain Utility Functions

Comparisons

Guide to CASE, IF, and other conditional logic in DuneSQL.

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

Use SVM-based classifiers and regressors directly within DuneSQL.

Machine learning functions

Quantile digest functions

Regular expression functions

Functions for computing set digests and HyperLogLog structures.

Set Digest functions

Explanation of the SS58 address encoding scheme used in Substrate chains.

SS58 functions

Helpers for encoding and decoding TON blockchain addresses.

TON address functions

Utilities for working with TRON's custom address format.

Tron address functions

String functions and operators

System information

T-Digest functions

Teradata functions

URL functions

UUID functions

Varbinary functions (DuneSQL)

Reference guide to string helper functions in Dune SQL.

Varchar Utility Functions

Documentation for ranking and analytic window functions.

Window functions

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

Data Catalog

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

The Dune Index is a comprehensive indicator of blockchain adoption across the industry.

Introduction

Dune Index

Understanding transaction fees and their relationship to transaction costs in blockchain networks

Transactions Fees

Understanding net USD transferred as a component of the Dune Index

Net Transfers

Net USD Transferred

Understanding transactions as a foundational component of the Dune Index

Transactions

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

Curated Data Overview

EVM Overview

Dune API Overview

Authentication

Client SDKs

Rate Limits

Troubleshooting Errors

Billing

Create custom API endpoints from Dune queries

Custom Endpoints

You can access all of Dune's data via the Snowflake data marketplace.

Snowflake Datashare Overview

Interested in Dune Datashare? Test out our data on Snowflake!

Getting Started

Getting Started with Datashare

Frequently Asked Questions about Dune Datashare

FAQs

Datashare FAQs

Empower Your Blockchain with the Leading Data Platform.

Dune Catalyst

Get Started

SQL API Reference

Datashare

Blockchain Integrations

Start building

Support

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

Visualize and trace all tables, views, and nested query dependencies within a query to understand data relationships efficiently.

Query Lineage

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

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

How decoding contracts works in a multichain universe.

Multichain Decoding

New kid (chain) on the block (Dune)? Here’s what you need to know to submit your chain's protocol contracts to Dune.

Survivor's Kit for Contract Submission

Curated EVM data tables providing simplified access to blockchain data across all EVM networks

EVM Curated Data

Curated Solana data tables providing simplified access to Solana blockchain data

Solana Curated Data

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

Table	Description
`prices.usd`	Historical prices with timestamps
`prices.usd_daily`	Daily historical prices
`prices.usd_latest`	Latest available price per token

Column name	Data type	Description
`contract_address`	varbinary	The unique identifier of the token
`symbol`	varchar	The identifier of the asset (ticker, cashtag)
`price`	double	The price of the asset in USD
`timestamp`	timestamp	The timestamp for which this price is reported
`blockchain`	varchar	The blockchain on which the asset exists

Column name	Data type	Description
`contract_address`	varbinary	The unique identifier of the token
`symbol`	varchar	The identifier of the asset (ticker, cashtag)
`price`	double	The latest price of the asset in USD
`blockchain`	varchar	The blockchain on which the asset exists

Dune Index

Curated Data

EVM Networks

Other Networks

Community Data

USD Prices (Legacy)

Legacy Price Tables

Legacy Tables

Modern Alternatives

Legacy Table Structure

prices.usd / prices.usd_daily

prices.usd_latest

Dune Index

Curated Data

EVM Networks

Other Networks

Community Data

​Legacy Price Tables

​Legacy Tables

​Modern Alternatives

​Legacy Table Structure

​prices.usd / prices.usd_daily

​prices.usd_latest

Legacy Price Tables

Legacy Tables

Modern Alternatives

Legacy Table Structure

prices.usd / prices.usd_daily

prices.usd_latest