Query editor
/*Table(s): dex.tradesReason: Based on general keywordsTable(s): dex_solana.tradesReason: Curated dataset recommendationsTable(s): solana_oms_proxy_solana.solana_oms_proxy_call_swapwhirlpoolReason: Based on contract addresses or possible project names*/SELECTDATE_TRUNC('day', block_time) AS day,project,COUNT(*) AS trade_count,SUM(amount_usd) AS total_volume_usdFROM dex_solana.tradesGROUP BY1,projectORDER BYday DESC,total_volume_usd DESC