SELECT
DATE_TRUNC('DAY', block_timestamp) as DATE,
COUNT(asset_receiver) as Number_receiving_addresses,
COUNT(tx_id) as Number_rewards
FROM
algorand.asset_transfer_transaction
WHERE
sender = 'ZW3ISEHZUHPO7OZGMKLKIIMKVICOUDRCERI454I3DB2BH52HGLSO67W754'
AND asset_id = '27165954'
AND asset_amount > 0
GROUP BY 1
ORDER BY 1