date_trunc('day', block_timestamp) as day,

count(distinct tx_id) as daily_txs,

sum(daily_txs) over (order by day) as cum_txs,

count (distinct tx_from) as daily_users,

sum(daily_users) over (order by day) as cum_users

from sei.core.fact_transactions

where block_timestamp::date <= current_date

and tx_succeeded = 'true'

group by 1

order by 1 DESC