Links

Prices

These tables allow you to get the price of almost all relevant erc20 tokens.
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.

Prices from third party data providers

We pull price data from the coinpaprika and coingecko APIs.
The Price is the volume-weighted price based on real-time market data, translated to USD.

prices.usd

This table supports a range of erc20.tokens. If the token you desire is not listed in here, please make a pull request to our github repository **** or use the decentralized price feed dex.view_token_prices.
column name
description
contract_address
the contract address of the erc20 token
symbol
the identifier of the asset (ticker, cashtag)
price
the price of the asset in any given minute
minute
the resolution for this table is by minute
Note that WETH can be used for ETH price as it trades at virtually the same price.

prices.layer_1usd

This table supports layer 1 assets on other blockchains.
contract_address
the contract address of the erc20 token
symbol
the identifier of the asset (ticker, cashtag)
price
the price of the asset in any given minute
minute
the resolution for this table is by minute