Query editor
/*WOOFi Swap Net Fee = Staking + TreasuryStaking: Fee transfer to vaultManagerTreasury: Fee transfer to treasuryDate Range: [start_time, end_time)e.g. start_time = 2024-04-02 00:00:00, end_time = 2024-07-02 00:00:00means Net Fee from 2024-04-01 to 2024-06-30*/WITHbnb_daily_net_fee AS (SELECTdate_trunc('day', evt_block_time - interval '1' day) AS "date",sum(value) / 1e18 AS net_feeFROMerc20_bnb.evt_transferWHEREcontract_address = 0x55d398326f99059ff775485246999027b3197955AND "from" = 0xc45b55032cafeaff3b8057d52758d8f8211da54dAND to IN (0x32a1d9b2a85f2ef0516daabaa9c34325bc774cac,0x4f0eda7fa34f24d0dc6a32ccc91c3454f2cf5257)AND evt_block_time >= CURRENT_DATE - INTERVAL '30' DAYAND evt_block_time < CURRENT_DATEGROUP BY1ORDER BY1),avalanche_c_daily_net_fee AS (SELECTdate_trunc('day', evt_block_time - interval '1' day) AS "date",sum(value) / 1e6 AS net_feeFROMerc20_avalanche_c.evt_transferWHEREcontract_address = 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6eAND "from" = 0xc45b55032cafeaff3b8057d52758d8f8211da54dAND to IN (0x32a1d9b2a85f2ef0516daabaa9c34325bc774cac,0x4c64a166ab22ca5d0fb3c1070ff91ef46b93f152)AND evt_block_time >= CURRENT_DATE - INTERVAL '30' DAYAND evt_block_time < CURRENT_DATEGROUP BY1ORDER BY1),polygon_daily_net_fee AS (SELECTdate_trunc('day', evt_block_time - interval '1' day) AS "date",sum(value) / 1e6 AS net_feeFROMerc20_polygon.evt_transferWHEREcontract_address = 0x3c499c542cef5e3811e1192ce70d8cc03d5c3359AND "from" = 0xc45b55032cafeaff3b8057d52758d8f8211da54d