FROM algorand.account_asset

WHERE EXISTS (SELECT CAST(block_timestamp as DATE) as Daily

from algorand.account AS Acc,

algorand.block AS BLO

where BLO.block_id = Acc.created_at

and daily BETWEEN '2022-01-20' and '2022-01-31' ) AND asset_name <> 'null'

group by asset_name

order by Total_Address DESC