DAY | DAILY_CLOSING_PRICE | |
|---|---|---|
1 | 2025-03-13 00:00:00.000 | 0.28701 |
2 | 2025-03-12 00:00:00.000 | 0.261219 |
3 | 2025-03-11 00:00:00.000 | 0.261386 |
4 | 2025-03-10 00:00:00.000 | 0.272387 |
5 | 2025-03-09 00:00:00.000 | 0.278502 |
6 | 2025-03-08 00:00:00.000 | 0.286329 |
7 | 2025-03-07 00:00:00.000 | 0.300319 |
8 | 2025-03-06 00:00:00.000 | 0.307982 |
9 | 2025-03-05 00:00:00.000 | 0.306646 |
10 | 2025-03-04 00:00:00.000 | 0.299767 |
11 | 2025-03-03 00:00:00.000 | 0.358483 |
12 | 2025-03-02 00:00:00.000 | 0.362505 |
13 | 2025-03-01 00:00:00.000 | 0.315465 |
14 | 2025-02-28 00:00:00.000 | 0.287968 |
15 | 2025-02-27 00:00:00.000 | 0.292756 |
16 | 2025-02-26 00:00:00.000 | 0.297219 |
17 | 2025-02-25 00:00:00.000 | 0.302553 |
18 | 2025-02-24 00:00:00.000 | 0.333756 |
19 | 2025-02-23 00:00:00.000 | 0.335087 |
20 | 2025-02-22 00:00:00.000 | 0.338276 |
permaryxlm price
Updated 7 days ago
9
1
2
3
4
5
6
7
8
9
›
⌄
select
date_trunc('day', hour) as day,
max(price) as daily_closing_price
from stellar.price.ez_prices_hourly
where blockchain = 'stellar'
and is_native = true
and hour >= date_trunc('day', current_date) - interval '12 months'
group by date_trunc('day', hour)
order by day desc;
Last run: 7 days ago
...
366
13KB
2s