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 origin_from_address = lower('0xc0f2bACAfbc928be652cB6fbd3CaF75D651329b8')

and type = 'CALL'

and input = '0x'

and value > 0

--AND block_number<4000000

SELECT

date_trunc('minute', block_timestamp) as dmin

, COUNT(distinct wallet) as users

, COUNT(distinct tx_hash) as txns

, MAX(tx_hash) as sample1

, 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