with gas_base as (

SELECT

block_timestamp

, tx_hash

, to_address as wallet

, VALUE as amount

--, row_number() OVER (partition by to_address ORDER BY tx_hash DESC) as rank

from monad.testnet.fact_traces

WHERE 1=1

--AND tx_hash = '0xdac05244373d466d547690ecaf151b3a3a1d6365a520c68528e8a83681dc7351'

AND from_address = '0x9fb480a193c250bf8ece39df5d9d728e21026b34'

AND TX_SUCCEEDED

AND trace_index>=1

--AND block_number<4000000

SELECT

date_trunc('minute', block_timestamp) as dmin

, COUNT(distinct wallet) as users

, COUNT(distinct tx_hash) as txns

, SUM(amount) as total_mon

, SUM(total_mon) OVER (ORDER BY dmin ASC) as mon_cumulative

, SUM(users) OVER (ORDER BY dmin ASC) as users_cumulative

, SUM(txns) OVER (ORDER by dmin ASC) as txns_total

from gas_base

GROUP BY 1

ORDER BY 1 ASC