hieukolFlashloans
    Updated 2021-10-20
    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