select
date_trunc('day', block_timestamp) as day,
date_trunc('week', block_timestamp) as week,
date_trunc('month', block_timestamp) as month,
monthname(month),
count(distinct(from_address)) as unique_wallets,
count(distinct(tx_hash)) as num_tx,
num_tx/unique_wallets as avg_tx_per_wallet,
--sum(xdai_value) as xdai_transferred,
--sum(xdai_transferred) over (order by day) as cumulative_sales_volume,
sum(num_tx) over (order by day) as cumulative_num_tx
from gnosis.core.fact_transactions
where block_timestamp >= '2022-05-17'
group by 1,2,3
order by 1 desc