with donations as (
SELECT
tx_id,
block_timestamp::date as date,
receiver as GILBERT_THE_GOANNA_ADDRESS,
amount as donation_volume
FROM algorand.payment_transaction
where receiver = '2XBL47CKYWTNAIVUQCTAMFBL75EXXRT3TBG2ZK7SOG7MDBER7Q3XNL77XQ'
order by date
)
select sum(donation_volume) as total_donation from donations