Query editor
withget_latest as (selecttrove_id,collateral_type,max_by(debt, (block_number, tx_index)) as debt,max_by(collateral, (block_number, tx_index)) as collateral,max_by(interest_rates, (block_number, tx_index)) as interest_rates,min(block_time) as created_time,max(block_time) as last_modified_timefromquery_5720005group by 1, 2),get_debt as (selectsum(debt) as debt,collateral_typefromget_latestwhere debt > 0group by 2),balances as (selectday,casewhen address = 0x5721cbbd64fc7ae3ef44a0a3f9a790a9264cf9bf then 'WETH'when address = 0x9502b7c397e9aa22fe9db7ef7daf21cd2aebe56b then 'wstETH'when address = 0xd442e41019b7f5c4dd78f50dc03726c446148695 then 'rETH'end as collateral_type,token_balance as bold_supplyfromquery_5155107where address in (0x5721cbbd64fc7ae3ef44a0a3f9a790a9264cf9bf, 0x9502b7c397e9aa22fe9db7ef7daf21cd2aebe56b, 0xd442e41019b7f5c4dd78f50dc03726c446148695)and day = current_date)selectcasewhen b.collateral_type = 'WETH' then 'ETH'else b.collateral_typeend as collateral_type,gd.debt - b.bold_supply as outside_detfrombalances binner joinget_debt gdon b.collateral_type = gd.collateral_type