Query editor
withtimeline as (select timestamp as dayfrom utils.dayswhere timestamp >= timestamp '2025-07-25'and timestamp <= (select max(timestamp)from prices.daywhere blockchain = 'solana'and contract_address in (select from_base58(account_mint)from jupiter_solana.liquidity_call_init_token_reserve)))------------------------------------------------------------------------ Lending side: balance-change intervals from f-token snapshots.----------------------------------------------------------------------, juplend_instances as (select * from "query_7538195"), lending_tokens as (selectinst.instance_name, i.account_f_token_mint as f_token_mintfrom jupiter_solana.lending_call_init_lending as ileft join juplend_instances as inston i.call_executing_account = inst.lending), lending_balance_changes as (selectb.day, t.instance_name, t.f_token_mint as mint, b.token_balance_owner as user, b.token_balance as balancefrom solana_utils.daily_balances bjoin lending_tokens ton b.token_mint_address = t.f_token_mintwhere b.month >= timestamp '2025-07-01')-- Each change row becomes an interval [day, next_change_day - 1] per-- (user, instance, mint); the latest change extends to current_date.-- LEAD runs once per sparse change row, not once per (user, day) tuple., lending_balance_intervals as (selectuser, instance_name, mint, balance, day as start_day, coalesce(lead(day) over (partition by user, instance_name, mint order by day) - interval '1' day, current_date) as end_day