shadil1M New Algorand Wallets In May - swappers
    Updated 2022-05-15
    with new_wallets as (
    select
    sender
    from (
    select
    sender,
    min(date(block_timestamp)) as min_date
    from algorand.transactions
    group by sender
    )
    where min_date BETWEEN '2022-05-04' and '2022-05-10'
    GROUP by sender
    ),
    all_new_wallets as (
    SELECT COUNT(DISTINCT sender) as new_wallets FROM new_wallets
    ),
    new_swappers as (
    SELECT COUNT(DISTINCT swapper) as swappers
    from flipside_prod_db.algorand.swaps
    where SWAPPER in (SELECT sender FROM new_wallets)
    and date(BLOCK_TIMESTAMP) >= '2022-05-04'
    ),
    all_swappers as (
    SELECT COUNT(DISTINCT swapper) as swappers
    from flipside_prod_db.algorand.swaps
    where date(BLOCK_TIMESTAMP) >= '2022-05-04'
    )

    SELECT
    nsw.swappers as new_wallet_swappers, aw.new_wallets, asw.swappers as all_swappers,
    (nsw.swappers/aw.new_wallets) * 100 as percent_new_wallet_swapped_to_new, -- what percent of new wallets, have at least one swapper
    (nsw.swappers/asw.swappers) * 100 as percent_new_wallet_swapped_to_all -- what percent of all swappers are from the new wallets
    from new_swappers nsw
    join all_new_wallets aw
    join all_swappers asw

    Run a query to Download Data