select sum(amount), date(block_timestamp) as date from algorand.payment_transaction where receiver='RXI3PCQNQKI3WJ2XM4ORAJRLXLYYYJFZVCO4F3LIZD56RPPZLGX2UVQ5LU'
and date(block_timestamp) >='2022-03-31 12:00:00' and date(block_timestamp) <='2022-04-14 6:00:00'
group by date