Query editor
SELECTblock_date AS day,SUM(amount_usd) AS dex_stable_volume_usd,COUNT(*) AS dex_stable_trades,SUM(amount_usd) / NULLIF(COUNT(*), 0) AS avg_trade_size_usdFROM dex.tradesWHERE block_month >= date_trunc('month', CURRENT_DATE - INTERVAL '120' DAY)AND block_date >= CURRENT_DATE - INTERVAL '120' DAYAND blockchain IN ('ethereum','base','arbitrum','optimism','bnb')AND amount_usd IS NOT NULLAND (token_bought_symbol IN ('USDT','USDC','DAI','USDE')OR token_sold_symbol IN ('USDT','USDC','DAI','USDE'))GROUP BY 1ORDER BY 1