Query editor
WITH-- Get kBTC price using WBTC as proxykbtc_price AS (SELECTprice as kbtc_price_usdFROM prices.usd_latestWHERE blockchain = 'ethereum'AND contract_address = 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 -- WBTCLIMIT 1),-- All Wednesday snapshot dateswednesdays AS (SELECT snapshot_date, week_numberFROM (VALUES(DATE '2025-10-22', 1),(DATE '2025-10-29', 2),(DATE '2025-11-05', 3),(DATE '2025-11-12', 4),(DATE '2025-11-19', 5),(DATE '2025-11-26', 6),(DATE '2025-12-03', 7),(DATE '2025-12-10', 8),(DATE '2025-12-17', 9),(DATE '2025-12-24', 10),(DATE '2025-12-31', 11),(DATE '2026-01-07', 12),(DATE '2026-01-14', 13),(DATE '2026-01-21', 14),(DATE '2026-01-28', 15),(DATE '2026-02-04', 16),(DATE '2026-02-11', 17),(DATE '2026-02-18', 18),(DATE '2026-02-25', 19),(DATE '2026-03-04', 20)) AS t(snapshot_date, week_number)WHERE snapshot_date <= CURRENT_DATE),-- Get all reserve tokens from Tydroreserve_tokens AS (SELECT DISTINCTs.reserve as token_address,t.symbol,t.decimalsFROM tydro_ink.l2poolinstance_evt_supply sINNER JOIN tokens.erc20 tON t.contract_address = s.reserveAND t.blockchain = 'ink'WHERE t.symbol IN ('USD₮0', 'GHO', 'USDG', 'kBTC', 'WETH')),-- All combinations of weeks and tokensweek_token_combos AS (SELECTw.snapshot_date,w.week_number,rt.token_address,