Query editor
withlatest_deposit_updates as (selectcontract_address,collateral_type,depositor,block_time,block_number,new_deposit,snapshot_p,snapshot_s,snapshot_b,stashed_coll,row_number() over (partition by contract_address, collateral_type, depositororder by block_number desc, tx_index desc) as rnfromquery_6370356 -- Stability Pools Deposits Updated-- where new_deposit > 0),depositor_age as (selectdepositor,created_time,casewhen (to_unixtime(now()) - to_unixtime(created_time)) / (7 * 24 * 60 * 60) <= 1 then '1 week'else concat(cast(cast(ceil((to_unixtime(now()) - to_unixtime(created_time)) / (7 * 24 * 60 * 60)) as integer) as varchar), ' weeks')end as depositor_agefrom (selectdepositor,min(block_time) as created_timefromlatest_deposit_updatesgroup by 1)),latest_multipliers as (selectcollateral_type,-- Find the latest non-zero value for snapshot_p(select snapshot_pfrom query_6370356where collateral_type = t.collateral_typeand snapshot_p > 0order by block_number desc, tx_index desclimit 1) as latest_p,-- Find the latest non-zero value for snapshot_s(select snapshot_sfrom query_6370356where collateral_type = t.collateral_typeand snapshot_s > 0order by block_number desc, tx_index desclimit 1