with flipside as (SELECT * from algorand.payment_transaction
where amount < 10000 and sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE')
SELECT date(block_timestamp) as day, sum(amount) as total_algo, sum(total_algo) over (order by day) as cumulative_algo
from flipside
GROUP by 1