select date(block_timestamp) as date, sum(amount) as amount from flipside_prod_db.algorand.payment_transaction

where receiver = '2XBL47CKYWTNAIVUQCTAMFBL75EXXRT3TBG2ZK7SOG7MDBER7Q3XNL77XQ'

group by date

),

sent as (

select date(block_timestamp) as date, sum(amount) as amount from flipside_prod_db.algorand.payment_transaction

where sender = '2XBL47CKYWTNAIVUQCTAMFBL75EXXRT3TBG2ZK7SOG7MDBER7Q3XNL77XQ'

and amount > 0

group by date

),

every_date as (

select distinct(date(block_timestamp)) as date from flipside_prod_db.algorand.payment_transaction

select every_date.date, donations.amount as donated, sent.amount as sent from every_date full outer join sent on sent.date = every_date.date

full outer join donations on donations.date = every_date.date

where donated is not null or sent is not null

order by every_date.date