jackguyAave Flashloan Activity 7
    Updated 2023-02-24
    SELECT
    *,
    sum(new_users) over (ORDER by week) as toal_users

    FROM (
    SELECT
    first_week as week,
    count(*) as new_users

    FROM (
    SELECT
    INITIATOR_ADDRESS,
    min(date_trunc('week', block_timestamp)) as first_week
    FROM ethereum.aave.ez_flashloans
    GROUP BY 1
    ) GROUP BY 1
    )
    Run a query to Download Data