Query editor
withconstants as (select0.998076443575628800 as minute_decay),range_start as (selectdate_trunc('hour', evt_block_time) + interval '1' hour as hourfromliquity_v2_ethereum.collateralregistry_legacy_evt_baserateupdatedorder byevt_block_number,evt_indexlimit1),range as (selectt.timefromrange_start,unnest (sequence(cast(range_start.hour as timestamp),cast(date_trunc('hour', now()) as timestamp),interval '1' hour)) t (time)),updates as (selectevt_block_time as time,cast(max(_baseRate) as double) / 1e18 as base_rate,cast(sum(bold_redeemed_from_eth_branch) as double) / 1e18 as bold_redeemed_from_eth_branch,cast(sum(bold_redeemed_from_wsteth_branch) as double) / 1e18 as bold_redeemed_from_wsteth_branch,cast(sum(bold_redeemed_from_reth_branch) as double) / 1e18 as bold_redeemed_from_reth_branchfrom(selectevt_block_time,_baseRate,0 as bold_redeemed_from_eth_branch,0 as bold_redeemed_from_wsteth_branch,0 as bold_redeemed_from_reth_branchfromliquity_v2_ethereum.collateralregistry_legacy_evt_baserateupdatedunion allselectevt_block_time,null,_actualBoldAmount,0,0fromliquity_v2_ethereum.trovemanager_weth_legacy_evt_redemptionunion allselectevt_block_time,null,0,