Query editor
WITHusdc_prices_usd AS (SELECTsymbol,price AS close_price,hourFROM(SELECTsymbol,price,minute,date_trunc('hour', minute) AS hour,ROW_NUMBER() OVER (PARTITION BYdate_trunc('hour', minute)ORDER BYminute DESC) AS rnFROMprices.usdWHEREblockchain = 'ethereum'AND symbol = 'USDC'AND minute >= CAST('2024-01-01' AS DATE)AND minute < CAST('2024-04-01' AS DATE))WHERErn = 1),usdt_prices_usd AS (SELECTsymbol,price AS close_price,hourFROM(SELECTsymbol,price,minute,date_trunc('hour', minute) AS hour,ROW_NUMBER() OVER (PARTITION BYdate_trunc('hour', minute)ORDER BYminute DESC) AS rnFROMprices.usdWHEREblockchain = 'ethereum'AND symbol = 'USDT'AND minute >= CAST('2024-01-01' AS DATE)AND minute < CAST('2024-04-01' AS DATE))WHERErn = 1),eth_prices_usd AS (