scottincryptoAAVE Sell Pressure
Updated 2022-11-20
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with dex_sales as (
select
date_trunc('day', block_timestamp) as block_date
, sum(amount_in) as aave_sold
from crosschain.defi.ez_swaps
where token_in = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'
and block_timestamp > current_date - interval '60 days'
group by 1
)
, aave_liqs as (
select
date_trunc('day', block_timestamp) as block_date
, sum(liquidated_amount) as aave_liquidations
from ethereum.aave.ez_liquidations
where collateral_asset = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'
and block_timestamp > current_date - interval '60 days'
group by 1
)
, ctoken_exchange as (
select
date_trunc('day', block_timestamp) as block_date
, sum(ctoken_price) / sum(token_price) as exchange_rate
from ethereum.compound.ez_market_stats
where 1=1
and ctoken_address = '0xe65cdb6479bac1e22340e4e755fae7e509ecd06c'
and block_timestamp > current_date - interval '60 days'
and ctoken_price is not null
and token_price is not null
group by 1
)
, comp_liqs_raw as (
select
date_trunc('day', block_timestamp) as block_date
Run a query to Download Data