MufasaNew Ethereum Dex users on daily basis
    Updated 2022-12-07
    with min_eth_users as (
    SELECT sender, min(to_date(block_timestamp)) as date_minimum
    FROM ethereum.core.ez_dex_swaps
    WHERE amount_in_usd < 1000000000
    GROUP BY sender
    ), data_one as (
    select date_minimum, count(*) as users_new,
    CASE WHEN date_minimum > '2022-11-08' THEN 'After FTX Event' ELSE 'Before FTX Event' END as event
    from min_eth_users
    group by date_minimum, 3
    ), cum_users as (
    select *, sum(users_new) over (order by date_minimum) as cummulative_new_users
    from data_one
    HAVING date_minimum > CURRENT_DATE - 120
    )
    select * from cum_users;
    Run a query to Download Data