Query editor
WITH btc_price AS (SELECTDATE_TRUNC('day', minute) AS day,symbol,AVG(price) AS btc_priceFROM prices.usdWHEREsymbol = 'BTC'AND blockchain IS NULLAND DATE_TRUNC('day', minute) > TRY_CAST('2023-01-01 00:00:00' AS TIMESTAMP)GROUP BY1,2ORDER BYday DESC), ordi_price AS (SELECTDATE_TRUNC('day', minute) AS day,symbol,AVG(price) AS ordi_priceFROM prices.usdWHEREsymbol = 'ORDI'GROUP BY1,2ORDER BYday DESC)SELECTb.day,b.btc_price,o.ordi_priceFROM btc_price AS bLEFT JOIN ordi_price AS oON b.day = o.dayORDER BYb.day DESC