Analyzing trading activity across Solana’s decentralized exchanges.
The Solana blockchain hosts various decentralized exchanges (DEXs) and trading protocols that facilitate token swaps and trading activities. Dune provides comprehensive trading data through prepared tables that capture trades across different DEX protocols and aggregators on the Solana network.
Here’s a simple query to get started analyzing DEX trading volume:
Copy
Ask AI
SELECT DATE_TRUNC('day', block_time) as date, project, COUNT(*) as num_trades, SUM(amount_usd) as volume_usdFROM dex_solana.tradesWHERE block_time >= NOW() - INTERVAL '30' dayGROUP BY 1, 2ORDER BY 1 DESC, 4 DESC
These datasets provide valuable insights into trading activity across the Solana ecosystem, enabling users to understand market dynamics and analyze trading patterns on the network.