nitsAAVE and UNI prices
Updated 2022-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with aave_prices as
(SELECT hour as hr_aave, price as price_aave
from ethereum.token_prices_hourly
where token_address = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9' ) ,
uni_prices as
(SELECT hour as hr_uni, price as price_uni
from ethereum.token_prices_hourly
where token_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' )
SELECT * from aave_prices
inner join uni_prices on hr_aave = hr_uni
order by hr_aave
-- limit 100
--0x1f9840a85d5af5bf1d1762f925bdaddc4201f984 uni
--0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9 aave
--0x6b3595068778dd592e39a122f4f5a5cf09c90fe2 SUSHI
--0xc00e94cb662c3520282e6f5717214004a7f26888 COMP