STDDEV(ep.price) AS price_volatility_usd

FROM

aptos.price.ez_prices_hourly AS ep

JOIN

aptos.core.dim_tokens AS dt ON ep.token_address = dt.token_address

WHERE

dt.symbol = 'GUI'

AND ep.hour >= DATEADD({{Period}}, -1, CURRENT_DATE);