with a as ( Select

EVENT_DATA:"from" as user,

min(block_timestamp) as first_transaction_stamp

from flow.core.fact_events

where TX_SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP::date>='2022-07-10' and BLOCK_TIMESTAMP::date<='2022-08-10' group by 1

)

select e.EVENT_TYPE,

--e.EVENT_CONTRACT,

count(a.user) as num_new_users

from flow.core.fact_events e join a on (a.user=e.EVENT_DATA:"from" )

group by 1--,2

order by 2 desc