Query editor
WITH sot AS (SELECT *FROM query_6231640),-- Step 6 results: rewardsinterest_rewards AS (SELECTs.collateral_type,date_trunc('day', t.block_time) AS day,SUM(t.bold_amount) AS bold_amountFROM query_6235737 tJOIN sot sON t.to_address = s.stability_poolWHERE t.from_address = 0x0000000000000000000000000000000000000000GROUP BY 1, 2),liquidation_rewards AS (SELECTs.collateral_type,date_trunc('day', l.block_time) AS day,SUM(l.collateral_sent_sp * l.price/1e18 - l.debt_offset_sp) AS liquidation_rewardsFROM query_6235684 lJOIN sot sON l.contract_address = s.trove_managerGROUP BY 1, 2),-- Merge interest + liquidation rewardsrewards_with_prices AS (SELECTCOALESCE(ir.day, lr.day) AS day,COALESCE(ir.collateral_type, lr.collateral_type) AS collateral_type,COALESCE(ir.bold_amount, 0) AS bold_rewards,COALESCE(lr.liquidation_rewards, 0) AS liquidation_rewardsFROM (SELECT day, collateral_type, bold_amountFROM interest_rewards) irFULL OUTER JOIN (SELECT day, collateral_type, liquidation_rewardsFROM liquidation_rewards) lrON ir.day = lr.dayAND ir.collateral_type = lr.collateral_type),-- Get pricesget_prices AS (SELECTdate_trunc('day', p.timestamp) AS day,s.collateral_type,max_by(p.price, p.timestamp) AS priceFROM prices.day pJOIN sot sON p.symbol = s.price_symbolAND p.blockchain = 'flare'WHERE p.timestamp >= date '2025-11-10'GROUP BY 1, 2