2844Luna Price
Updated 2023-01-25
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
avg(CLOSE) as price, date_trunc('hour',RECORDED_HOUR) as "DAY",
case
when "DAY" >= '2023-01-14' then 'After the Station Luanch'
when "DAY" <'2023-01-14' then 'Before the Station Luanch'
End as Status
from
crosschain.core.fact_hourly_prices
where RECORDED_HOUR >= '2023-01-01' and RECORDED_HOUR <= '2023-01-21' and
ID = 'terra-luna-2'
group by "DAY"
Order By "DAY"
Run a query to Download Data