maybeyonassushi_other_dex_prices
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with prices as (
select
date(hour) as date,
symbol,
-- token_address,
avg(price) as price
-- case when symbol='UNI' and price<1 then null else price end as price
from ethereum.token_prices_hourly
where symbol in (
'UNI','SUSHI','PSP','1INCH','CRV','BNT','BAL','ZRX','KNC','DYDX'
)
group by 1,2
)
select * from prices
where price is not null
and year(date) >= 2021
order by date desc
limit 20000
Run a query to Download Data