Query editor
SELECTproject,COUNT(*) AS total_trades,COUNT(DISTINCT tx_id) AS unique_transactions,SUM(amount_usd) AS total_volume_usdFROM dex_solana.tradesWHERE project IN ('raydium', 'whirlpool', 'meteora', 'phoenix', 'pumpdotfun')AND block_time > now() - interval '365' dayGROUP BY projectORDER BY total_volume_usd DESC;