SELECT
date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
Sum(AMOUNT) AS donations_amount,
COUNT( DISTINCT SENDER) AS donators
FROM algorand.payment_transaction
WHERE RECEIVER='2XBL47CKYWTNAIVUQCTAMFBL75EXXRT3TBG2ZK7SOG7MDBER7Q3XNL77XQ'
GROUP BY 1
ORDER BY 1 ASC