Query editor
withconstants as (select0.998076443575628800 as minute_decay),range_start as (selectdate_trunc('hour', evt_block_time) + interval '1' hour as hourfrom(select * from asymmetry_finance_ethereum.usdaf_v2_collateralregistry_evt_baserateupdated)order 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_ysybold_branch) as double) / 1e18 as bold_redeemed_from_ysybold_branch,cast(sum(bold_redeemed_from_scrvusd_branch) as double) / 1e18 as bold_redeemed_from_scrvusd_branch,cast(sum(bold_redeemed_from_susds_branch) as double) / 1e18 as bold_redeemed_from_susds_branch,cast(sum(bold_redeemed_from_sfrxusd_branch) as double) / 1e18 as bold_redeemed_from_sfrxusd_branch,cast(sum(bold_redeemed_from_tbtc_branch) as double) / 1e18 as bold_redeemed_from_tbtc_branch,cast(sum(bold_redeemed_from_wbtc_branch) as double) / 1e18 as bold_redeemed_from_wbtc_branchfrom(selectevt_block_time,_baseRate,0 as bold_redeemed_from_ysybold_branch,0 as bold_redeemed_from_scrvusd_branch,0 as bold_redeemed_from_susds_branch,0 as bold_redeemed_from_sfrxusd_branch,0 as bold_redeemed_from_tbtc_branch,0 as bold_redeemed_from_wbtc_branchfrom(select * from asymmetry_finance_ethereum.usdaf_v2_collateralregistry_evt_baserateupdated)union allselectevt_block_time,null,_actualBoldAmount,0,0,