Query editor
SELECTsymbol,blockchain,contract_address,AVG(price) AS avg_priceFROMprices.usd_latestWHERE((symbol = 'SOL' AND blockchain = 'solana') OR(symbol = 'TRX') ORcontract_address IN (0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2, -- WETH0xbb4CdB9CBd36B01bD1cBaEBF2De08d9173bc095c -- BNB))AND minute >= CURRENT_TIMESTAMP - INTERVAL '30' DAYGROUP BYsymbol, blockchain, contract_address;