-- forked from Sei STPM @ https://flipsidecrypto.xyz/edit/queries/26ea51e2-c36e-4787-9959-150d1449ee8a

select

-- date_trunc(day, block_timestamp) as date,

count(distinct tx_from) as DAU,

count(distinct tx_id) as tx_count

-- 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