​
Overview

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

​
Available Datasets

Asset Tracking

Track tokens, NFTs and their movements across the Solana network:

  • Token accounts and balances
  • Token transfers
  • NFT transfers and metadata

Trading

Analyze trading activity on Solana DEXs:

  • DEX trades across protocols
  • Jupiter aggregator trades

​
Asset Tracking Tables

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

TableDescription
solana.token_accountsCurrent state of all SPL token accounts
solana.token_metadataMetadata for SPL tokens including name, symbol, etc.
solana.token_transfersTransfer events for SPL, Token22 tokens and native SOL transfers
solana.nft_metadataMetadata for Solana NFTs
solana.nft_transfersTransfer events for Solana NFTs

​
Trading Tables

The trading tables capture decentralized exchange activity:

TableDescription
solana.dex_tradesTrades across Solana DEX protocols
solana.jupiter_tradesTrades routed through Jupiter aggregator

​
Example Query

Here’s a simple query to get started analyzing Solana token transfers:

SELECT 
    date_trunc('day', block_time) as date,
    COUNT(*) as num_transfers,
    COUNT(DISTINCT from_address) as unique_senders
FROM solana.token_transfers
WHERE block_time >= NOW() - INTERVAL '30' day
GROUP BY 1
ORDER BY 1 DESC

​
Resources

Spellbook Models

View the source code for Solana curated data models

​
Coverage and Limitations

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

  • Token and NFT transfers are captured through standard SPL token program 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

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

Was this page helpful?

NFT Wash TradesOverview