apostleoffinanceUntitled Query
    Updated 2022-10-20
    SELECT COUNT(*) AS total_transaction,
    CASE WHEN AAVE_VERSION = 'Aave v2' then 'v2'
    ELSE 'V1' END AS aave_versions
    FROM ethereum.aave.ez_flashloans
    GROUP BY 2
    ORDER BY 1;


    -- there 59526 flashloan transactions on aave deployed on ethereum
    Run a query to Download Data