select
date_trunc('day',block_timestamp) as Date,
(count(DISTINCT(sender))) as Wallets,
sum(asset_amount)/1000000 as Total_Amount
from algorand.asset_transfer_transaction
WHERE
asset_receiver = 'ABQHZLNGGPWWZVA5SOQO3HBEECVJSE3OHYLKACOTC7TC4BS52ZHREPF7QY' AND
asset_id = 31566704 AND
date(block_timestamp) > '2021-12-16' and date(block_timestamp) < '2022-02-02'
group by Date
order by Date