Query editor
SELECTblock_date,blockchain,project,COUNT(*) AS number_of_trades,SUM(amount_usd) AS trading_volume_usdFROM dex.tradesWHEREblock_date >= NOW() - INTERVAL '30' dayAND project = 'uniswap'GROUP BY1, 2, 3ORDER BY1 DESC, 5 DESC;
Query editor
1SELECT2block_date,3blockchain,4project,5COUNT(*) AS number_of_trades,6SUM(amount_usd) AS trading_volume_usd7FROM dex.trades8WHERE9block_date >= NOW() - INTERVAL '30' day10AND project = 'uniswap'11GROUP BY121, 2, 313ORDER BY141 DESC, 5 DESC;