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),-- Get weETH price from Ethereum mainnetweeth_price AS (SELECTprice as weeth_price_usdFROM prices.usd_latestWHERE blockchain = 'ethereum'AND contract_address = 0xCd5fE23C85820F7B72D0926FC9b05b43E359b7ee -- weETH on EthereumLIMIT 1),-- Get ezETH price from Ethereum mainnetezeth_price AS (SELECTprice as ezeth_price_usdFROM prices.usd_latestWHERE blockchain = 'ethereum'AND contract_address = 0xbf5495Efe5DB9ce00f80364C8B423567e58d2110 -- ezETH on EthereumLIMIT 1),-- Get rsETH price from Ethereum mainnet (for wrsETH/rsETH on Ink)rseth_price AS (SELECTprice as rseth_price_usdFROM prices.usd_latestWHERE blockchain = 'ethereum'AND contract_address = 0xA1290d69c65A6Fe4DF752f95823fae25cB99e5A7 -- rsETH on EthereumLIMIT 1),-- Get WETH price from Ethereum mainnetweth_price AS (SELECTprice as weth_price_usdFROM prices.usd_latestWHERE blockchain = 'ethereum'AND contract_address = 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2 -- WETH on EthereumLIMIT 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),