Query editor
WITH-- Source of collaterals, includes rflr_per_hour and stability_poolsot AS (SELECT *FROM query_6231640 -- Use your SoT table or CTE-- This should include: collateral_type, stability_pool, rflr_per_hour),-- Get FLR token prices from prices.dayflr_prices AS (SELECTtimestamp AS day,price AS flr_price_usdFROM prices.dayWHERE symbol = 'FLR'AND blockchain = 'flare'AND timestamp >= date '2025-11-24'),-- Generate daily time seriestime_seq AS (SELECT sequence(CAST('2025-11-24' AS timestamp),date_trunc('day', CAST(now() AS timestamp)),interval '1' day) AS time),days AS (SELECT time.time AS dayFROM time_seqCROSS JOIN UNNEST(time) AS time(time)),-- Get BOLD balances from StabilityPool using SoTbalances AS (SELECTb.day,s.collateral_type,b.token_balance AS bold_supply,s.rflr_per_hourFROM query_6359081 bINNER JOIN sot sON b.address = s.stability_poolWHERE b.day >= date '2025-11-24'),-- Compute daily incentivesdaily_incentives AS (SELECTb.day,b.collateral_type,b.bold_supply,b.rflr_per_hour * 24 AS daily_rflr_total, -- FLR per day from SoTap.flr_price_usd,(b.rflr_per_hour * 24) * COALESCE(ap.flr_price_usd, 0) AS daily_rewards_usdFROM balances bLEFT JOIN flr_prices apON b.day = ap.day),