Query editor
-- Step 1: Your existing logic for all transfersWITH all_chains AS (SELECT"to" AS user,value / 1e18 AS amount,evt_block_time,date_trunc('day', evt_block_time) AS block_dateFROM erc20_sonic.evt_transferWHERE "contract_address" = 0x4F75ffeC480587Ef994C8204F55f9f5d71e980f4AND "from" = 0x0000000000000000000000000000000000000000UNION ALLSELECT"from" AS user,-(value / 1e18) AS amount,evt_block_time,date_trunc('day', evt_block_time) AS block_dateFROM erc20_sonic.evt_transferWHERE contract_address = 0x4F75ffeC480587Ef994C8204F55f9f5d71e980f4AND "to" = 0x0000000000000000000000000000000000000000UNION ALLSELECT"to" AS user,value / 1e18 AS amount,evt_block_time,date_trunc('day', evt_block_time) AS block_dateFROM erc20_sonic.evt_transferWHERE "contract_address" = 0x4F75ffeC480587Ef994C8204F55f9f5d71e980f4AND "from" <> 0x0000000000000000000000000000000000000000AND "to" <> 0x0000000000000000000000000000000000000000UNION ALLSELECT"from" AS user,-(value / 1e18) AS amount,evt_block_time,date_trunc('day', evt_block_time) AS block_dateFROM erc20_sonic.evt_transferWHERE "contract_address" = 0x4F75ffeC480587Ef994C8204F55f9f5d71e980f4AND "from" <> 0x0000000000000000000000000000000000000000AND "to" <> 0x0000000000000000000000000000000000000000),-- Calculate per-user daily cumulative balances on actual transaction daysdaily_balances AS (SELECTuser,block_date,SUM(amount) OVER (PARTITION BY user ORDER BY block_date) AS balanceFROM all_chains),calendar AS (SELECT d AS block_dateFROM (SELECT sequence(CAST(MIN(block_date) AS date),