Query editor
SELECTDATE_TRUNC('day', evt_block_time) AS evt_date,chain,SUM(1) AS num_tradesFROM woofi_multichain.wooppv2_evt_wooswapWHEREevt_block_time >= DATE_TRUNC('day', CURRENT_DATE) - INTERVAL '1' month - INTERVAL '1' dayGROUP BYDATE_TRUNC('day', evt_block_time),chain