Query editor
WITH tac_bridged_minted AS (SELECTdate_trunc('hour', block_time) AS trade_day,SUM(amount) AS tac_bridged_mintedFROM tokens.transfersWHERE contract_address = 0x1219c409fabe2c27bd0d1a565daeed9bd9f271deAND "from" = 0x0000000000000000000000000000000000000000AND block_time >= TIMESTAMP '2026-07-07 06:00:00'AND block_time < TIMESTAMP '2026-07-08 00:00:00'GROUP BY 1),tac_sold AS (SELECTdate_trunc('hour', evt_block_time) AS trade_day,SUM(CASEWHEN amount0 > 0 THEN CAST(amount0 AS DOUBLE)ELSE 0END) / 1e18 AS tac_soldFROM pancakeswap_v3_bnb.pancakev3pool_evt_swapWHERE contract_address = 0xd2cd331e493a325dd5634cfeb93852389c0aaeceAND evt_block_time >= TIMESTAMP '2026-07-07 06:00:00'AND evt_block_time < TIMESTAMP '2026-07-08 00:00:00'GROUP BY 1)SELECTCOALESCE(s.trade_day, m.trade_day) AS trade_day,COALESCE(s.tac_sold, 0) AS tac_sold,COALESCE(m.tac_bridged_minted, 0) AS tac_bridged_mintedFROM tac_sold sFULL OUTER JOIN tac_bridged_minted mON s.trade_day = m.trade_dayWHERE COALESCE(s.tac_sold, 0) > 0OR COALESCE(m.tac_bridged_minted, 0) > 0ORDER BY trade_day DESC;