Query editor
WITH pool_info AS (SELECTpool,blockchain,token0,token1FROM dex.poolsWHERE pool = {{pool_address}}), token_list AS (SELECT token0 AS token_address, blockchain FROM pool_infoUNION ALLSELECT token1 AS token_address, blockchain FROM pool_info), token_prices AS (SELECTt.token_address,t.blockchain,e.symbol,e.name,p.price,ROW_NUMBER() OVER (PARTITION BY t.token_address, t.blockchain ORDER BY p.timestamp DESC) AS rnFROM token_list tLEFT JOIN tokens.erc20 e ON t.token_address = e.contract_addressLEFT JOIN prices.hour p ON t.token_address = p.contract_address AND t.blockchain = p.blockchain)SELECTtoken_address,symbol,name,priceFROM token_pricesWHERE rn = 1