select block_timestamp::date as dt,
count(distinct tx_hash) as num_txs,
count(distinct from_address) as unique_address,
sum(num_txs) over (order by dt asc) as cumulative_num_txs,
sum(unique_address) over (order by dt asc) as cumulative_unique_address
from polygon.core.fact_transactions
where block_timestamp::date >= '2022-07-01'
group by 1