select date_trunc(day, block_timestamp) as date,

count(*) as tx_count,

count(distinct from_address) as unique_address,

sum(tx_count) over (order by date) as cumu_tx,

sum(unique_address) over (order by date) as cumu_address,

tx_count/unique_address as tx_addr_ratio,

cumu_tx/cumu_address as cumu_tx_addr_ratio

from polygon.core.fact_transactions where block_timestamp::date >= '2022-07-01' and status = 'SUCCESS'

and block_timestamp::date < CURRENT_DATE

group by date