Yousefi_1994New swapper after loss the funds
    Updated 2022-08-15
    with swapper_before_loss_funds as (
    select
    origin_from_address as wallet_address
    from optimism.velodrome.ez_swaps
    where block_timestamp::date <= '2022-08-04'
    group by wallet_address
    ),
    swapper_after_loss_funds as (
    select
    origin_from_address as wallet_address
    from optimism.velodrome.ez_swaps
    where block_timestamp::date > '2022-08-04'
    group by wallet_address
    ),
    total_wallet_address as (
    select
    count(distinct origin_from_address) as number_of_total_wallet_address
    from optimism.velodrome.ez_swaps
    ),
    new_swapper as (
    select
    count(distinct wallet_address) as number_of_new_wallet
    from swapper_after_loss_funds
    where wallet_address not in (select wallet_address from swapper_before_loss_funds)
    )

    select
    number_of_total_wallet_address,
    number_of_new_wallet
    from total_wallet_address, new_swapper
    Run a query to Download Data