Query editor
with changed_balances as (selectblockchain,day,address,token_symbol,token_address,token_standard,token_id,balance,lead(cast(day as timestamp)) over (partition by token_address,address,token_id order by day asc) as next_update_dayfrom tokens_base.balances_daily_aggwhere day < date(date_trunc('day',now())) and token_standard = 'erc20' and token_address = 0x0bbbead62f7647ae8323d2cb243a0db74b7c2b80), days as (select *from unnest(sequence(cast('2015-01-01' as date), date(date_trunc('day',now())), interval '1' day)) as foo(day)), forward_fill as (selectblockchain,cast(d.day as timestamp) as day,address,token_symbol,token_address,token_standard,token_id,balancefrom days dleft join changed_balances bON d.day >= b.dayand (b.next_update_day is null OR d.day < b.next_update_day) -- perform forward fill--where d.day >= date '2015-01-01'), balances as (selectb.*from(select * from forward_fillwhere balance > 0) b)select * from balances binner join query_4787975 kt on b.address = kt.address_varbinaryand kt.network = 'base'where day > CURRENT_DATE - INTERVAL '1' day