Query editor
1SELECT 2 block_date as day,3 COUNT(*) as number_of_trades,4 SUM(token_bought_amount) as total_bought,5 SUM(token_sold_amount) as total_sold6FROM dex.trades7WHERE token_pair IN ('USDC-WETH', 'WETH-USDC')8GROUP BY 19ORDER BY 1
SELECT
block_date as day,
COUNT(*) as number_of_trades,
SUM(token_bought_amount) as total_bought,
SUM(token_sold_amount) as total_sold
FROM dex.trades
WHERE token_pair IN ('USDC-WETH', 'WETH-USDC')
GROUP BY 1
ORDER BY 1