Query editor
WITH users AS(select "to" as userfrom tokens_mantle.transferswhereblock_month >= date('2023-07-01')and contract_address = 0xDeadDeAddeAddEAddeadDEaDDEAdDeaDDeAD0000group by 1),mint as(select block_date as dt,symbol,amount,"to" as userfrom tokens_mantle.transferswhereblock_month >= date('2023-07-01')-- and "from" = 0x0000000000000000000000000000000000000000and contract_address = 0xDeadDeAddeAddEAddeadDEaDDEAdDeaDDeAD0000union allselect block_date,symbol,-amount,"from"from tokens_mantle.transferswhere block_month >= date('2023-07-01')-- and "to" = 0x0000000000000000000000000000000000000000and contract_address = 0xDeadDeAddeAddEAddeadDEaDDEAdDeaDDeAD0000),dates as (SELECT dtFROM UNNEST(SEQUENCE(DATE('2023-07-01'),CURRENT_DATE,INTERVAL '1' DAY)) AS t(dt)),t1 as (select a.dt,b.user-- ,sum(amount) amount,SUM(SUM(COALESCE(amount,0))) OVER (PARTITION BY b.user ORDER BY a.dt) AS balancefrom dates across join users bleft join mint c on a.dt = c.dt and b.user = c.usergroup by 1,2)select * from t1