shadilAssets that swappers hold
    Updated 2022-07-05
    select asset, total_wallets
    from (select count(distinct address) as total_wallets,
    asset_name as asset
    from flipside_prod_db.algorand.account_asset join (select swapper as wallet_address
    from flipside_prod_db.algorand.swaps das
    where date_trunc('day', das.block_timestamp) >= '2022-05-01' -- Since May
    and date_trunc('day', das.block_timestamp) < '2022-07-01') as joined_table1
    on address = joined_table1.wallet_address
    where amount != 0
    group by asset)
    where asset is not null
    and total_wallets > 1000

    Run a query to Download Data