MLDZMNFBBA1
Updated 2023-04-28
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
HOUR::date date,
avg(PRICE) avg_price,
max(PRICE) max_price,
min(PRICE) min_price,
avg(avg_price)over(order by date rows between 7 preceding and current row) as "7 days mov avg"
from ethereum.core.fact_hourly_token_prices
where TOKEN_ADDRESS ilike '0x5283D291DBCF85356A21bA090E6db59121208b44'
and HOUR::date > CURRENT_DATE - 45
group by 1
Run a query to Download Data