-- date_trunc(day, block_timestamp) as date,

count(distinct tx_from) as DAU,

count(distinct tx_id) as tx_count,

tx_count/count(distinct block_timestamp::date) as tx_per_day,

DAU/count(distinct block_timestamp::date) as AVG_DAU

-- sum(DAU) over (order by date) as cumu_DAU,

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

from sei.core.fact_transactions

where tx_succeeded = TRUE

-- and block_timestamp >= '2023-08-01'