Query editor
select symbol, decimals, price, minutefrom (selectrow_number () over (partition by symbol order by minute desc) as row_num, --窗口函数,按symbol分组,按minute降序,并生成排序号*fromprices.usdwhere symbol in ('WETH', 'WBTC', 'USDC')and blockchain = 'ethereum'and minute >= now() - interval '6' hourorder by minute desc) pwhere row_num = 1