Query editor
WITH btc_price AS (SELECTsymbol,DATE_TRUNC ('day', minute) AS day,AVG (price) AS daily_priceFROM prices.usdWHERE symbol = 'BTC'GROUP BY 1,2),btc_price_changes AS (SELECTsymbol,day,daily_price,LAG(daily_price) OVER (PARTITION BY symbol ORDER BY day) AS prev_price,(daily_price - LAG(daily_price) OVER (PARTITION BY symbol ORDER BY day)) /LAG(daily_price) OVER (PARTITION BY symbol ORDER BY day) AS daily_returnFROM btc_price),eth_price AS (SELECTsymbol,DATE_TRUNC ('day', minute) AS day,AVG (price) AS daily_priceFROM prices.usdWHERE symbol = 'ETH'GROUP BY 1,2),eth_price_changes AS (SELECTsymbol,day,daily_price,LAG(daily_price) OVER (PARTITION BY symbol ORDER BY day) AS prev_price,(daily_price - LAG(daily_price) OVER (PARTITION BY symbol ORDER BY day)) /LAG(daily_price) OVER (PARTITION BY symbol ORDER BY day) AS daily_returnFROM eth_price),sol_price AS (SELECTsymbol,DATE_TRUNC ('day', minute) AS day,AVG (price) AS daily_priceFROM prices.usdWHERE symbol = 'SOL'GROUP BY 1,2),sol_price_changes AS (SELECTsymbol,day,daily_price,LAG(daily_price) OVER (PARTITION BY symbol ORDER BY day) AS prev_price,(daily_price - LAG(daily_price) OVER (PARTITION BY symbol ORDER BY day)) /LAG(daily_price) OVER (PARTITION BY symbol ORDER BY day) AS daily_returnFROM sol_price),bnb_price AS (SELECTsymbol,