hieukolFlashloans
Updated 2021-10-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
›
⌄
Select (select
count(tx_id) as total_contract
from
aave.flashloans
where
initiator_address in (lower('0xAED662abcC4FA3314985E67Ea993CAD064a7F5cFf'), lower('0xa5d330F6619d6bF892A5B87D80272e1607b3e34D'),
lower('0x64C5cc449bD253D7fd57751c9080ACcd0216126d'), lower('0x93Efcf86b6a7a33aE961A7Ec6C741F49bce11DA7'), lower('0x47d9f61bADEc4378842d809077A5e87B9c996898')
, lower('0x83152CAA0d344a2Fd428769529e2d490A88f4393'), lower('0xc45d4f6b6bf41b6edaa58b01c4298b8d9078269a'), lower('0x0528a32fda5bedf89ba9ad67296db83c9452f28c'),
lower('0xe05b162cd6571e825484ae95a93bfac02e64b05a'))) / count(tx_id) as defi_ms_quantity,
(select
sum(flashloan_amount)
from
aave.flashloans
where
initiator_address in (lower('0xAED662abcC4FA3314985E67Ea993CAD064a7F5cFf'), lower('0xa5d330F6619d6bF892A5B87D80272e1607b3e34D'),
lower('0x64C5cc449bD253D7fd57751c9080ACcd0216126d'), lower('0x93Efcf86b6a7a33aE961A7Ec6C741F49bce11DA7'), lower('0x47d9f61bADEc4378842d809077A5e87B9c996898')
, lower('0x83152CAA0d344a2Fd428769529e2d490A88f4393'), lower('0xc45d4f6b6bf41b6edaa58b01c4298b8d9078269a'), lower('0x0528a32fda5bedf89ba9ad67296db83c9452f28c'),
lower('0xe05b162cd6571e825484ae95a93bfac02e64b05a'))) / sum(flashloan_amount) as defi_ms_amount
from aave.flashloans
Run a query to Download Data