Query editor
withinterest_rewards as (selectcasewhen to = 0x0Dd6daab4cB9A0ba6707Cf59DBfbc28cc33CA24A then 'WFLR'when to = 0x2c817F7159c08d94f09764086330c96Bb3265A2f then 'FXRP'when to = 0xE6B23B97A9058B88e6d068d57d8a69Fb07ab2A61 then 'SFLR'when to = 0x3FAEC256DCFDB9eBa882b5F71e020FA128081f56 then 'STXRP'end as collateral_type,date_trunc('day', evt_block_time) as day,sum(value/1e18) as bold_amountfrom query_6370694where to in (0x2c817F7159c08d94f09764086330c96Bb3265A2f, 0x0Dd6daab4cB9A0ba6707Cf59DBfbc28cc33CA24A, 0xE6B23B97A9058B88e6d068d57d8a69Fb07ab2A61, 0x3FAEC256DCFDB9eBa882b5F71e020FA128081f56)and "from" = 0x0000000000000000000000000000000000000000group by 1, 2),liquidation_rewards as (selectcollateral_type,date_trunc('day', block_time) as day,sum(collateral_sent_sp * _price/1e18 - debt_offset_sp) as liquidation_rewardsfromquery_6370531group by 1, 2),time_seq AS (selectsequence(CAST('2025-01-01' as timestamp),date_trunc('day', cast(now() as timestamp)),interval '1' day) as time),days AS (selecttime.time as dayfrom time_seqcross join unnest(time) as time(time)),collaterals as (selectcollateral_typefrom (values('FXRP'), ('WFLR'), ('STXRP'), ('SFLR')) as tmp (collateral_type)),get_all_collaterals as (selectd.day,c.collateral_typefromdays d