Moebeefy prc copy
Updated 2023-09-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
HOUR::date date,
avg(PRICE) as token_price,
avg(token_price)over( order by date rows between 6 preceding and current row) as Mov_avg7,
avg(token_price)over( order by date rows between 29 preceding and current row) as Mov_avg30
from
avalanche.core.fact_hourly_token_prices
where
TOKEN_ADDRESS ilike '0xb279f8dd152b99ec1d84a489d32c35bc0c7f5674'
and
hour between '2023-01-01' and current_date
group by 1
Run a query to Download Data