select *, date_trunc('day', b.block_timestamp) as date from flipside_prod_db.algorand.account a

left join algorand.block b on a.created_at = b.block_id where closed_at is null

and date >= '2022-05-01' and date < '2022-05-31'),

assets as ( select count(*) as count, asset_name

from flipside_prod_db.algorand.account_asset

where address in (select address from new_wallets) group by 2 )

select * from assets order by 1 desc limit 20