binhachonASA Dex Degens - the distribution of the number of ASAs a wallet has swapped for
    Updated 2022-03-19
    with swap_stats as (
    select
    swapper,
    count(distinct swap_from_asset_id) as number_of_ASAs
    from algorand.swaps
    where swap_from_amount > 0
    and block_timestamp::date >= '2022-01-01'
    group by swapper
    )
    select
    round(number_of_ASAs, 0) as rounded_frequency,
    count(*) as number_of_wallets
    from swap_stats
    group by rounded_frequency
    Run a query to Download Data