Query editor
/*Table(s): erc20_ethereum.evt_TransferReason: Based on standards mentionedTable(s): prices.usdReason: Curated dataset recommendationsTable(s): floki_ethereum.FLOKI_evt_Transfer, floki_bnb.FLOKI_evt_TransferReason: Based on contract addresses or possible project names*/WITH token_prices AS (SELECTDATE_TRUNC('month', minute) AS month,symbol,AVG(price) AS avg_priceFROM prices.usdWHERE(symbol = 'FLOKI'AND contract_address = TRY_CAST(FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e') AS VARBINARY)AND blockchain = 'ethereum')OR (symbol = 'SHIBA' AND blockchain = 'solana')OR (symbol = 'BONK' AND blockchain = 'solana')OR (symbol = 'DOGE' AND blockchain = 'dogecoin')GROUP BY1,symbol)SELECTmonth,symbol,avg_priceFROM token_pricesORDER BYmonth,symbol