MIN_PRICE | MAX_PRICE | CURRENT_PRICE | PERCENT_DIFF_MIN_TO_MAX | PERCENT_DIFF_MIN_TO_CURRENT | |
|---|---|---|---|---|---|
1 | 3.971919367e-8 | 0.00198506 | 0.00062155058 | 4997634.89 | 1564762.03 |
alfredfx10Price
Updated 2025-02-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH PriceData AS (
SELECT PRICE, HOUR, ROW_NUMBER() OVER (ORDER BY HOUR DESC) AS rn -- current price
FROM base.price.ez_prices_hourly
WHERE TOKEN_ADDRESS = LOWER('0xAC1Bd2486aAf3B5C0fc3Fd868558b082a531B2B4')
)
SELECT MIN(PRICE) AS min_price, MAX(PRICE) AS max_price, MAX(CASE WHEN rn = 1 THEN PRICE END) AS current_price,
-- % difference between minimum and maximum price
CASE WHEN MIN(PRICE) > 0 THEN ROUND(((MAX(PRICE) - MIN(PRICE)) / MIN(PRICE)) * 100, 2)
ELSE 0
END AS percent_diff_min_to_max,
-- % difference between minimum and current price
CASE WHEN MIN(PRICE) > 0 THEN
ROUND(((MAX(CASE WHEN rn = 1 THEN PRICE END) - MIN(PRICE)) / MIN(PRICE)) * 100, 2)
ELSE 0
END AS percent_diff_min_to_current
FROM PriceData;
Last run: 2 months ago
1
65B
1s