select
date_trunc('day',block_timestamp) as day,
count (distinct tx_id) as total_tx,
sum (event_amount) as total_Amount,
sum(total_tx) over (order by day) as cum_tx
from terra.classic.ez_transfers
where tx_status = 'SUCCEEDED'
and event_currency = 'LUNA'
and block_timestamp >= '2022-05-01'
and event_amount > 0
group by 1