Query editor
WITH-- ============================-- 1) Load data, convert to days-- ============================usdt_p1 AS (SELECTdate_trunc('day', time) AS day,cumulative_amount AS tvl,'USDT Phase 1' AS strategyFROM query_6235797),frxusd_p1 AS (SELECTdate_trunc('day', time) AS day,cumulative_amount AS tvl,'frxUSD Phase 1' AS strategyFROM query_6240130),usdc_p2 AS (SELECTdate_trunc('day', time) AS day,cumulative_amount AS tvl,'USDC Phase 2' AS strategyFROM query_6209868),all_data AS (SELECT * FROM usdt_p1UNION ALLSELECT * FROM frxusd_p1UNION ALLSELECT * FROM usdc_p2),-- ============================-- 2) Find full calendar range-- ============================date_bounds AS (SELECTMIN(day) AS min_day,MAX(day) AS max_real_dayFROM all_data),calendar AS (SELECT dayFROM UNNEST(sequence((SELECT CAST(min_day AS DATE) FROM date_bounds),DATE '2025-12-08',INTERVAL '1' DAY)) AS t(day)),strategies AS (SELECT DISTINCT strategy FROM all_data),-- =========================================