​
Overview

Dune provides curated data tables for EVM networks that make it easier to analyze and understand blockchain activity. These tables are built and maintained by Dune and the community to provide clean, standardized data that’s ready for analysis across multiple EVM-compatible networks.

​
Available Datasets

Asset Tracking

Track native tokens andERC20, ERC721 and ERC1155 tokens and NFTs

DEX

Analyze decentralized exchange activity including DEX trades across protocols, aggregator trades, and sandwich attacks

NFT

Track NFT market activity including NFT trades, NFT mints, and wash trading detection

​
Asset Tracking Tables

The asset tracking tables provide comprehensive data about tokens and NFTs:

TableDescription
tokens.transfersTransfer events for ERC20 tokens and native currencies
tokens.erc20Metadata for ERC20 tokens including name, symbol, decimals
tokens_<chain>.balancesCurrent token balances by address
nft.transfersTransfer events for ERC721 and ERC1155 tokens

​
DEX Tables

The DEX tables capture decentralized exchange activity:

TableDescription
dex.tradesIndividual trades across DEX protocols
dex_aggregator.tradesTrades routed through aggregators
dex.sandwichesDetected sandwich attack trades
dex.sandwichedVictims of sandwich attacks

​
NFT Market Tables

The NFT tables track NFT market activity:

TableDescription
nft.tradesNFT sales across marketplaces
nft.mintsNFT minting events
nft.wash_tradesDetected wash trading activity

​
Example Query

Here’s a simple query to analyze daily DEX trading volume:

SELECT 
    blockchain,
    date_trunc('day', block_time) as date,
    COUNT(*) as num_trades,
    SUM(amount_usd) as volume_usd
FROM dex.trades
WHERE block_time >= NOW() - INTERVAL '30' day
GROUP BY 1, 2
ORDER BY 2 DESC, 1

​
Resources

Spellbook Models

View the source code for EVM curated data models

​
Coverage and Limitations

The EVM curated tables aim to provide comprehensive coverage of on-chain activity, but there are some limitations to be aware of:

  • Token transfers are captured through standard ERC20/721/1155 events
  • Some non-standard token implementations may not be fully captured
  • DEX coverage includes major protocols but may not capture all DEX activity
  • Data is typically available with a short delay after on-chain finality
  • Coverage may vary by chain and protocol

For the most up-to-date coverage information, please check the documentation for each specific table.

Was this page helpful?

OverviewOverview