t1 as (

select

distinct tx_signer,

min(block_timestamp) as debut

from near.core.fact_transactions

where tx_succeeded = 'true'

group by 1

),

t2 as (

SELECT

distinct tx_signer from t1 where debut >=CURRENT_DATE-INTERVAL '1 MONTH'

)

select

trunc(x.block_timestamp,'day') as date,

case when method_name ='{"owner_id": "roysun.near", "total_supply": "1000", "metadata": {"spec": "ft-1.0.0", "name": "Guan Dian Wang", "symbol": "GDW", "decimals": 8, "icon": "https://icons8.com/icon/112275/iota" }}'

then '{}' else method_name end as method_names,

count(distinct x.tx_hash) as actions,

sum(actions) over (partition by method_names order by date) as cum_actions

from near.core.fact_transactions x

join near.core.fact_actions_events_function_call y on x.tx_hash = y.tx_hash

where tx_signer in (select tx_signer from t2) and date between CURRENT_DATE-INTERVAL '1 MONTH' and CURRENT_DATE-1

group by 1,2

order by 1 asc