Afonso_DiazToken Price
Updated 2025-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('{{ period }}', hour) as date,
avg(price) as token_price_usd,
avg(avg(price)) over (
order by date_trunc('{{ period }}', hour)
rows between 6 preceding and current row
) as token_price_7d_ma
from
avalanche.price.ez_prices_hourly
where
token_address = '0xffff003a6bad9b743d658048742935fffe2b6ed7'
group by 1
order by 1
QueryRunArchived: QueryRun has been archived