Query editor
WITH sot AS (SELECT collateral_type, price_symbolFROM query_6231640),get_prices AS (SELECTs.collateral_type,s.price_symbol,max_by(p.price, p.timestamp) AS latest_price,max_by(p.timestamp, p.timestamp) AS price_timestampFROM sot sLEFT JOIN prices.day pON p.symbol = s.price_symbolAND p.blockchain = 'flare'GROUP BYs.collateral_type,s.price_symbol)SELECT *FROM get_pricesORDER BY collateral_type;