Learn to analyze daily DEX trading volumes across different blockchains
dex.trades
table. This table contains standardized trading data across multiple DEXes and blockchains.
block_date
: Groups all trades into daily bucketsblockchain
: Helps us compare activity across Ethereum, Polygon, Arbitrum, etc.COUNT(*)
: Gives us the trading frequencySUM(amount_usd)
: Shows the total value traded in USDWHERE block_date >= NOW() - INTERVAL '30 days'
: Focuses on recent activityGROUP BY 1, 2, 3
: Combines trades by day, blockchain, and DEXORDER BY 1 DESC, 5 DESC
: Shows newest and highest volume trades firstproject
as a parameter to make the analysis interactive:
trading_day
trading_volume_usd
blockchain