Query editor
WITH 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" = 0xa392aEbf2505E6028dA05b3F8d3f58de51961A28AND "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 = 0xa392aEbf2505E6028dA05b3F8d3f58de51961A28AND "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" = 0xa392aEbf2505E6028dA05b3F8d3f58de51961A28AND "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" = 0xa392aEbf2505E6028dA05b3F8d3f58de51961A28AND "from" <> 0x0000000000000000000000000000000000000000AND "to" <> 0x0000000000000000000000000000000000000000),daily_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),