jackguyAave Flashloan Activity 3
    Updated 2023-04-13

    SELECT
    -- date_trunc('week', block_timestamp) as week,
    SYMBOL,
    sum(FLASHLOAN_AMOUNT_USD) as flashloan_volume_usd,
    sum(PREMIUM_AMOUNT_USD) as fee_volume_usd,
    COUNT(DISTINCT tx_hash) as events,
    count(DISTINCT INITIATOR_ADDRESS) as users
    FROM ethereum.aave.ez_flashloans
    WHERE FLASHLOAN_AMOUNT_USD < 100000000000
    GROUP BY 1
    Run a query to Download Data