Query editor
withtroves as (selectdate_trunc('day', block_time) as day,collateral_type,max_by(collateral_balance, (block_number, tx_index)) as balancefromquery_4400255group by 1, 2),missing_days as (select*,lead(day, 1, current_timestamp) over (partition by collateral_type order by day asc) as next_dayfromtroves),time_seq AS (selectsequence(CAST('2025-01-01' as timestamp),date_trunc('day', cast(now() as timestamp)),interval '1' day) as time),days AS (selecttime.time as dayfrom time_seqcross join unnest(time) as time(time)),active_pools as (selectday,collateral_type,sum(balance) as balancefrom (selectd.day,c.collateral_type,c.balancefrommissing_days cinner joindays don c.day <= d.dayand d.day < c.next_day)where balance > 0group by 1, 2),ethereum_prices as (select