with raw as (select

EVENT_CONTRACT ,

min (block_timestamp)::date as first_use

from

flow.core.fact_events

group by 1) ,

new_contracts as (

select

distinct EVENT_CONTRACT

from

raw

select

count(distinct tx_id) as number_of_tx,

count(distinct proposer) as users,

number_of_tx /users as tx_per_user

from flow.core.fact_transactions tx inner join flow.core.fact_events e using (tx_id)

where EVENT_CONTRACT in (select * from new_contracts)