Query editor
with events as (select * from query_5720005),daily_trove_snapshots as (selectdate_trunc('day', block_time) as day,collateral_type,trove_id,max_by(debt, (block_number, tx_index)) as debtfrom eventsgroup by 1, 2, 3),date_spine as (select date_add('day', x, min_day) as dayfrom (select min(date_trunc('day', block_time)) as min_dayfrom events)cross join unnest(sequence(0,date_diff('day',(select min(date_trunc('day', block_time)) from events),date_trunc('day', now())))) as t(x)),troves as (select distinct trove_id, collateral_typefrom events),trove_days_with_values as (selectd.day,t.trove_id,t.collateral_type,s.debtfrom date_spine dcross join troves tleft join daily_trove_snapshots son d.day = s.dayand t.trove_id = s.trove_idand t.collateral_type = s.collateral_type),trove_daily_filled as (selectday,trove_id,collateral_type,last_value(debt) ignore nulls over (partition by trove_id, collateral_typeorder by dayrows between unbounded preceding and current row) as debtfrom trove_days_with_values),