NAME,

SYMBOL,

PRICE,

HOUR

FROM ethereum.price.ez_prices_hourly

WHERE LOWER(TOKEN_ADDRESS) = LOWER('0xaaeE1A9723aaDB7afA2810263653A34bA2C21C7a')

AND HOUR::date<=CURRENT_DATE()-1

ORDER BY HOUR DESC

LIMIT 50;