shadilAssets that swappers hold
Updated 2022-07-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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