Query editor
SELECTSUM(CASEWHEN block_time >= date_add('day', -1, date_trunc('day', CURRENT_TIMESTAMP))AND block_time < date_trunc('day', CURRENT_TIMESTAMP)THEN amount_usdELSE 0END) AS volume1d,COUNT(DISTINCT CASEWHEN block_time >= date_add('day', -1, date_trunc('day', CURRENT_TIMESTAMP))AND block_time < date_trunc('day', CURRENT_TIMESTAMP)THEN takerEND) AS users1d,COUNT(CASEWHEN block_time >= date_add('day', -1, date_trunc('day', CURRENT_TIMESTAMP))AND block_time < date_trunc('day', CURRENT_TIMESTAMP)THEN 1END) AS swaps1d,SUM(amount_usd) AS total_volume,COUNT(DISTINCT taker) AS total_users,COUNT(*) AS total_swapsFROM (SELECT * FROM sushiswap_agg.tradesUNION ALLSELECT * FROM dune.sushi_labs.result_rp_trades_spellbook_pr)