select
blocktime,
amount_usd,
sum(amount_usd) over (order by blocktime) as total_usd
from (
select
date_trunc('day', block_timestamp) as blocktime,
sum(event_amount_usd) as amount_usd
from terra.transfers
where event_to = 'terra1zxtczmxtw8mk8xncvr8lcq2qmvk4dz88ek6f79'
group by blocktime
)