Trading

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.

​

Tables

​

Key Features

The trading tables provide essential data for analyzing Solana’s DEX ecosystem:

• Comprehensive coverage of major DEX protocols
• Detailed trade execution data including amounts, prices, and USD values
• Aggregator-specific data for Jupiter trades
• Transaction and block details for each trade

​

Common Use Cases

These datasets enable various types of trading analysis:

• Track trading volume across different DEX protocols
• Monitor market activity for specific token pairs
• Analyze price impact and slippage in trades
• Compare performance between different DEXs and aggregators
• Identify trading patterns and trends

​

Sample Query

Here’s a simple query to get started analyzing DEX trading volume:

SELECT 
    DATE_TRUNC('day', block_time) as date,
    project,
    COUNT(*) as num_trades,
    SUM(amount_usd) as volume_usd
FROM dex_solana.trades
WHERE block_time >= NOW() - INTERVAL '30' day
GROUP BY 1, 2
ORDER 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.