Mrftispecified-aquamarine
    Updated 20 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 20 hours agoAuto-refreshes every 12 hours
    Borrowed Token
    Total Flashloans
    Total Uniuqe Borrowers
    Total Flashloan (USD)
    1
    USDC259272779512357745.53
    2
    WAVAX414133708489864270.87
    3
    DAI.e79001593246307908.21
    4
    USDC.e56431057211499357.8
    5
    WETH.e126641821181405383.11
    6
    WBTC.e33471258102092704.96
    7
    BTC.b5776108188586704.02
    8
    USDt6202137180429830.7
    9
    sAVAX196235247394650.75
    10
    AUSD3051103203659.41
    11
    LINK.e12483183009465.65
    12
    USDT.e7171652462499.13
    13
    AAVE.e6582331462551.16
    14
    FRAX21588148455.49
    15
    MAI4019183
    15
    459B
    2s