Query editor
WITH flr_rewards AS (SELECT *FROM query_6381582 -- precomputed rFLR incentives),aps_rewards AS (SELECT *FROM query_6381639 -- precomputed APS protocol rewards),combined_apr AS (SELECTf.day,f.collateral_type,f.apy_1d AS apr_rflr,a.apy_1d AS apr_aps,COALESCE(f.apy_1d, 0) + COALESCE(a.apy_1d, 0) AS apr_totalFROM flr_rewards fLEFT JOIN aps_rewards aON f.day = a.dayAND f.collateral_type = a.collateral_type)SELECT *FROM combined_aprORDER BY day DESC, collateral_type;