SELECT
block_timestamp::date AS day,
COUNT(sender) AS number_of_wallets,
SUM(amount) AS total_daily_donation_amount
FROM algorand.payment_transaction
WHERE
receiver = '2XBL47CKYWTNAIVUQCTAMFBL75EXXRT3TBG2ZK7SOG7MDBER7Q3XNL77XQ'
AND amount IS NOT NULL
GROUP BY day
ORDER BY day