Delamir-601401-price012-1
Updated 2023-02-02
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc(week,HOUR) as date,
case when date >= CURRENT_DATE-60 then 'Last 2 months' else 'Other days' end as timespan,
avg(price) as Price_MATIC,
avg(Price_MATIC) over (order by date rows between 8 preceding and current row) as MA_9,
avg(Price_MATIC) over (order by date rows between 25 preceding and current row) as MA_26
from ethereum.core.fact_hourly_token_prices
where symbol = 'MATIC'
group by 1
Run a query to Download Data