boomer77liquidations AAVE
Updated 2021-09-29
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
›
⌄
with v2 as (select date_trunc('week',block_timestamp) as block_week, sum(fee_usd) as Fees_USD, sum(tx_fee) as Fees_ETH, case when sum(fee_usd) is not null then 'V2' else '' end as version
from ethereum.transactions
where tx_id in (select tx_id
from aave.liquidations
where aave_version = 'Aave V2'
and block_timestamp >= CURRENT_DATE - 365)
group by 1),
v1 as (select date_trunc('week',block_timestamp) as block_week, sum(fee_usd) as Fees_USD, sum(tx_fee) as Fees_ETH, case when sum(fee_usd) is not null then 'V1' else '' end as version
from ethereum.transactions
where tx_id in (select tx_id
from aave.liquidations
where aave_version ='Aave V1'
and block_timestamp >= CURRENT_DATE - 365)
group by 1),
amm as (select date_trunc('week',block_timestamp) as block_week, sum(fee_usd) as Fees_USD, sum(tx_fee) as Fees_ETH, case when sum(fee_usd) is not null then 'AMM' else '' end as version
from ethereum.transactions
where tx_id in (select tx_id
from aave.liquidations
where aave_version ='Aave AMM'
and block_timestamp >= CURRENT_DATE - 365)
group by 1)
select * from v2
UNION
select * from v1
UNION
select * from AMM
Run a query to Download Data