Query editor
WITHtime_seq AS (SELECTsequence(CAST('2024-11-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)),daily_rates AS (SELECT*,lead(day, 1, current_timestamp) OVER (PARTITION BY trove_id, collateral_type ORDER BY day ASC) AS next_dayFROM (SELECTdate_trunc('day', block_time) AS day,trove_id,collateral_type,max_by(interest_rates, (block_number, tx_index)) AS interest_ratesFROMquery_6370673GROUP BY 1, 2, 3)),filled_rates AS (SELECTd.day,c.trove_id,c.collateral_type,c.interest_ratesFROMdaily_rates cINNER JOINdays dON c.day <= d.dayAND d.day < c.next_day),daily_debts AS (SELECT*,lead(day, 1, current_timestamp) OVER (PARTITION BY trove_id, collateral_type ORDER BY day ASC) AS next_dayFROM (SELECTdate_trunc('day', block_time) AS day,trove_id,collateral_type,max_by(debt, (block_number, tx_index)) AS debtFROM