Mrftispecified-aquamarine
    Updated 15 hours ago
    with tbl as
    (select
    FLASHLOAN_TOKEN,
    FLASHLOAN_TOKEN_SYMBOL,
    count (distinct tx_hash) as "Total Flashloans",
    count (distinct ORIGIN_FROM_ADDRESS) as "Total Uniuqe Borrowers",
    sum (FLASHLOAN_AMOUNT_USD) as "Total Flashloan (USD)"
    from avalanche.defi.ez_lending_flashloans
    group by 1,2)

    select
    case
    when FLASHLOAN_TOKEN='0x5c49b268c9841aff1cc3b0a418ff5c3442ee3f3b' then 'MAI'
    else FLASHLOAN_TOKEN_SYMBOL
    end as "Borrowed Token",
    "Total Flashloans", "Total Uniuqe Borrowers", "Total Flashloan (USD)"
    from tbl
    order by 4 desc
    Last run: about 15 hours agoAuto-refreshes every 12 hours
    Borrowed Token
    Total Flashloans
    Total Uniuqe Borrowers
    Total Flashloan (USD)
    1
    USDC258792775511817552.38
    2
    WAVAX413963707489719706.21
    3
    DAI.e79001593246307908.21
    4
    USDC.e56431057211499357.8
    5
    WETH.e126561821180956301.24
    6
    WBTC.e33471258102092704.96
    7
    BTC.b5774108188568686.98
    8
    USDt6198137180424290.4
    9
    sAVAX196135147379613.56
    10
    AUSD3041103199705.55
    11
    LINK.e12473183009462.62
    12
    USDT.e7171652462499.13
    13
    AAVE.e6582331462551.16
    14
    FRAX21588148455.49
    15
    MAI4019183
    15
    459B
    1s