boomer77Price THOR, RUNE, XRUNE
Updated 2021-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with other as (select hour, price, symbol
from ethereum.token_prices_hourly
where symbol in ('THOR', 'XRUNE', 'RUNE') and hour > '2021-11-06'),
rune as (select hour, avg(price) over (order by hour rows between 29 preceding and current row) as price, 'RUNE_MA_30' as symbol
from ethereum.token_prices_hourly
where symbol = 'RUNE' and hour > '2021-11-06')
select * from other
union
select * from rune
order by 1 asc
Run a query to Download Data