farid-c9j0VMETH vs stETH price
Updated 2022-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tab1 as (select date_trunc('day', hour) as day, avg(price) as eth_price
from ethereum.token_prices_hourly_v2
where day>'2021-01-01' and symbol='ETH'
group by 1
order by 1 desc),
tab2 as (select date_trunc('day', hour) as day, avg(price) as STETH_price
from ethereum.token_prices_hourly_v2
where day>'2021-01-01' and token_address='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
group by 1
order by 1 desc)
select tab1.day, tab1.ETH_price, tab2.STETH_price, (tab1.ETH_price-tab2.STETH_price) as difference
from tab1
left join tab2
on tab1.day=tab2.DAY
order by 1 desc
Run a query to Download Data