Query editor
WITH hour_series AS (SELECTDATE_TRUNC('day', time) AS day,DATE_TRUNC('month', time) AS monthFROM UNNEST(sequence(CAST('2023-04-20 00:00' AS timestamp), -- Set minimum date to April 20, 2023 at 00:00CAST(DATE_TRUNC('day', CURRENT_TIMESTAMP) AS timestamp),INTERVAL '1' day)) AS t(time)),burn_events AS (SELECTDATE_TRUNC('day', evt_block_time) AS evt_day,SUM(CAST(value AS double) / pow(10, 18)) AS tokens_burnedFROMerc20_polygon.evt_TransferWHEREcontract_address = 0xAC0F66379A6d7801D7726d5a943356A172549AdbANDto = 0x000000000000000000000000000000000000deadANDevt_block_time > CAST('2023-04-20 00:00' AS timestamp)GROUP BY 1),sol_burn_events AS (SELECTDATE_TRUNC('day', block_time) AS evt_day,SUM(CAST(amount AS double) / pow(10, 9)) AS tokens_burnedFROMtokens_solana.transfersWHEREto_token_account = '5SBfxBdqsCM1SJZGQkf9Y74EFmUfzs8LGDjBZUjZGnED'ANDblock_time > CAST('2025-10-31 00:00' AS timestamp)ANDtoken_mint_address = '7JA5eZdCzztSfQbJvS8aVVxMFfd81Rs9VvwnocV1mKHu'GROUP BY 1),raw_prices AS (SELECTAVG(median_price) AS price,DATE_TRUNC('day', hour) AS day,DATE_TRUNC('month', hour) AS monthFROMdex.pricesWHEREblockchain = 'polygon'ANDcontract_address = 0xac0f66379a6d7801d7726d5a943356a172549adbANDhour > CAST('2023-04-20 00:00' AS timestamp)GROUP BY 2, 3),price_data_with_imputation AS (SELECThs.day,hs.month,COALESCE(rp.price,LAG(rp.price) OVER (ORDER BY hs.day),