token_address,

symbol,

decimals,

AVG(CASE

WHEN hour > current_timestamp - INTERVAL '1 YEAR'

THEN price

ELSE NULL

END) AS avg_price_usd

FROM

aptos.price.ez_prices_hourly

GROUP BY

token_address,

symbol,

decimals;