MIN_PRICE | MAX_PRICE | CURRENT_PRICE | LAST24PRICE | ATH_PRICE_CHANGE | CURRENT_CHANGE | TWENTYFOURH_CHANGE | SEVEND_CHANGE | |
|---|---|---|---|---|---|---|---|---|
1 | 0.004106040405 | 2.01 | 0.24809 | 0.2701 | 48852.270360408 | 5942.000943733 | -8.149944465 | 5.896087487 |
HitmonleeCryptoAny Asset Price
Updated 2025-02-12
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 assetPrice as (
SELECT
hour AS recorded_Hour,
price AS asset_Price
FROM solana.price.ez_prices_hourly
WHERE
token_address = '{{Token_Address}}'
)
,minimum as (
select
min(asset_Price) as Min_Price
from assetPrice
where asset_Price > 0
),
maximum as (
select
max(asset_Price) as Max_Price
from assetPrice
),
current_priceT as (
select
asset_Price as current_Price
from assetPrice
order by recorded_hour DESC
limit 1
),
last24 as (
select
asset_Price as last24price
from assetPrice
where 1=1
and recorded_hour > current_timestamp - interval '24 hours'
order by recorded_hour asc
limit 1
),
last7 as (
Last run: 2 months ago
1
94B
4s