Query editor
WITH-- Source of collaterals, includes aps_per_hour and stability_poolsot AS (SELECT *FROM query_6231640 -- Use your SoT table or CTE-- This should include: collateral_type, stability_pool, aps_per_hour),-- Get APS token prices from prices.dayaps_prices AS (SELECTtimestamp AS day,price AS aps_price_usdFROM prices.dayWHERE symbol = 'APS'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.aps_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.aps_per_hour * 24 AS daily_aps_total, -- APS per day from SoTap.aps_price_usd,(b.aps_per_hour * 24) * COALESCE(ap.aps_price_usd, 0) AS daily_rewards_usdFROM balances bLEFT JOIN aps_prices apON b.day = ap.day),