Query editor
WITH floki_price AS (SELECTday,AVG(price) AS avg_priceFROM prices.usd_dailyWHEREcontract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2eAND blockchain = 'ethereum'GROUP BYday), sol_avg_price AS (SELECTday,AVG(price) AS avg_priceFROM prices.usd_dailyWHEREsymbol = 'SOL'GROUP BYday)SELECTCOALESCE(floki_price.day, sol_avg_price.day) AS day,floki_price.avg_price AS floki_avg_price,sol_avg_price.avg_price AS sol_avg_priceFROM floki_priceFULL OUTER JOIN sol_avg_priceON floki_price.day = sol_avg_price.dayORDER BYday