MetiocreSushi vs btc price
Updated 2022-05-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with sushi as (
select hour::date as date, avg(price) as price
from flipside_prod_db.ethereum_core.fact_hourly_token_prices
where hour::date >='2022-01-01'
and
token_address in (
'0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' --sushi
)
group by 1
),
btc as (
select hour::date as date, avg(price) as price
from flipside_prod_db.ethereum_core.fact_hourly_token_prices
where hour::date >='2022-01-01'
and
token_address in (
'0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' --btc,
)
group by 1
)
select sushi.date as date, sushi.price as sushi_price, btc.price as btc_price
from
sushi inner join btc using (date)
Run a query to Download Data