Query editor
WITH weekly_prices AS (SELECTDATE_TRUNC('week', minute) AS time,symbol,AVG(price) AS weekly_priceFROM prices.usdWHERE symbol IN ('BTC', 'ETH', 'SOL', 'BNB', 'AVAX', 'TRX', 'SEI', 'SUI', 'APT', 'ICP', 'NEAR', 'TON')GROUP BY 1,2)SELECTtime,symbol,weekly_price,((weekly_price / LAG(weekly_price, 7) OVER (PARTITION BY symbol ORDER BY time)) - 1) * 100 AS weekly_price_changeFROM weekly_pricesWHERE time > TRY_CAST('2023-12-31' AS TIMESTAMP)ORDER BY time