flipside

    Weekly Average Fee Volume Per Flashloan Weekly Total Volume Paid in Flashloan Fees Weekly Average Volume Borrowed Per Flashloan Weekly Total Volume B
    vendettaWeekly Average Fee Volume Per Flashloan Weekly Total Volume Paid in Flashloan Fees Weekly Average Volume Borrowed Per Flashloan Weekly Total Volume B
    Updated 2023-02-12
    select
    date_trunc('week', block_timestamp) as "date",
    sum(FLASHLOAN_AMOUNT_USD) as "Total Flashloan Volume USD",
    avg(FLASHLOAN_AMOUNT_USD) as "Average Flashloan Size USD",
    sum(PREMIUM_AMOUNT_USD) as "FlashLoan Fee Volume USD",
    avg(PREMIUM_AMOUNT_USD) as "Average Flashloan Fee USD"

    from ethereum.aave.ez_flashloans
    where FLASHLOAN_AMOUNT_USD < 1e9
    and PREMIUM_AMOUNT_USD < 1e9
    group by 1

    Run a query to Download Data