Query editor
-- Daily AMM revenue by chainSELECTDATE_TRUNC('day', evt_block_time) AS date,chain,SUM(usd_amount) AS total_usdFROM dune.sushi_labs.result_stablecoin_revenueWHERE evt_block_time < DATE_TRUNC('day', CURRENT_TIMESTAMP)AND recipient_type = 'AMM'GROUP BY 1,2ORDER BY date