ATH_PRICE | DAYS_SINCE_ATH | ATL_PRICE | DAYS_SINCE_ATL | CURRENT_PRICE | PCT_CHANGE_FROM_ATH | PCT_CHANGE_FROM_ATL | |
|---|---|---|---|---|---|---|---|
1 | 0.00023061 | 106 | 0.00001437 | 3 | 0.00001927 | -91.64 | 34.1 |
zyroqprice metrics 2
Updated 2025-05-10
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
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH data AS (
SELECT
price,
CAST(hour AS DATE) AS date
FROM
aptos.price.ez_prices_hourly
WHERE
token_address = '0x96baeee6d7a4a8cd712144d1225cfcb6c26d0c6fefd463bd77a878e4526c7411::hair_coin::HairCoin'
),
ath_data AS (
SELECT
price AS ath_price,
date AS ath_date
FROM
data
QUALIFY ROW_NUMBER() OVER (ORDER BY price DESC) = 1 -- Fetch the row with the highest price
),
atl_data AS (
SELECT
price AS atl_price,
date AS atl_date
FROM
data
QUALIFY ROW_NUMBER() OVER (ORDER BY price ASC) = 1 -- Fetch the row with the lowest price
),
current_price AS (
SELECT
price AS current_price
FROM
data
QUALIFY ROW_NUMBER() OVER (ORDER BY date DESC) = 1 -- Fetch the latest price
)
SELECT
ath_data.ath_price,
DATEDIFF('day', ath_data.ath_date, CURRENT_DATE) AS days_since_ath,
atl_data.atl_price,
Last run: 21 days ago
1
54B
2s