MIN_PRICE_USD | MAX_PRICE_USD | AVG_PRICE_USD | PRICE_VOLATILITY_USD | CURRENT_PRICE_USD | PRICE_INCREASE_FROM_MIN_PCT | |
|---|---|---|---|---|---|---|
1 | 90791 | 106376 | 96453.793871866 | 2793.467823666 | 99664 | 9.772995121 |
winnie-fsmarvellous-teal
Updated 2025-01-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
SELECT
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;
Last run: 3 months ago
1
65B
2s