MIN(price) as min_price_usd,

MAX(price) as max_price_usd,

AVG(price) as avg_price_usd,

STDDEV(price) as price_volatility_usd,

(SELECT price

FROM bitcoin.price.ez_prices_hourly

WHERE symbol = 'BTC'

AND blockchain = 'bitcoin'

AND is_native = TRUE

AND hour >= DATEADD('day', -30, CURRENT_TIMESTAMP())

ORDER BY hour DESC

LIMIT 1) as current_price_usd,

((SELECT price

FROM bitcoin.price.ez_prices_hourly

WHERE symbol = 'BTC'

AND blockchain = 'bitcoin'

AND is_native = TRUE

AND hour >= DATEADD('day', -30, CURRENT_TIMESTAMP())

ORDER BY hour DESC

LIMIT 1) - MIN(price)) / MIN(price) * 100 as price_increase_from_min_pct

FROM bitcoin.price.ez_prices_hourly

WHERE symbol = 'BTC'

AND blockchain = 'bitcoin'

AND hour >= DATEADD('day', -30, CURRENT_TIMESTAMP())

AND is_native = TRUE;