KARTODDefi saver
Updated 2021-10-13
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 defi_saver_addresses as (
select *
from (values
-- Etherscan: DeFi Saver
('0xaed662abcc4fa3314985e67ea993cad064a7f5cf'),
('0xa5d330f6619d6bf892a5b87d80272e1607b3e34d'),
('0x64c5cc449bd253d7fd57751c9080accd0216126d'),
('0x93efcf86b6a7a33ae961a7ec6c741f49bce11da7'),
('0x47d9f61badec4378842d809077a5e87b9c996898'),
('0x83152caa0d344a2fd428769529e2d490a88f4393'),
('0xc45d4f6b6bf41b6edaa58b01c4298b8d9078269a'),
('0x0528a32fda5bedf89ba9ad67296db83c9452f28c'),
('0xe05b162cd6571e825484ae95a93bfac02e64b05a')
) as defi_saver_addresses (address)
),
flashloans_with_interfaces as (
select
*,
case
when initiator_address in (select * from defi_saver_addresses)
then 'Defi Saver'
when target_address in (select * from defi_saver_addresses)
then 'Defi Saver'
else 'Other'
end as via_defi_saver
from aave.flashloans
)
select
DATE_TRUNC('day', BLOCK_TIMESTAMP) as "day",
via_defi_saver,
count(distinct tx_id) as count_tx,
count(distinct tx_id) * 100.00 / (select count (distinct tx_id) from aave.flashloans) as pct_tx_over_all,
sum(flashloan_amount_usd) as sum_flashloan_amount_usd,
sum(flashloan_amount_usd) * 100.00 / (select sum(flashloan_amount_usd) from aave.flashloans) as pct_flashloan_amount_usd_over_all
Run a query to Download Data