with all_txs as (select date_trunc('hour',block_timestamp) as time,

tx_id as mining_txs,

SIGNERS[0] as miners

from eclipse.core.fact_events

where --tx_id = 'TY4VvvG3jhf6KGiai6moKytc1GqnCrmtbG5KbjyGFkcFqhC61wcjMyVKHEHoykzwZgfSnKMonEvZQCPHaxVg7pH'

PROGRAM_ID = 'F1ULBrY2Tjsmb1L4Wt4vX6UtiWRikLoRFWooSpxMM6nR'

and SUCCEEDED = 'TRUE'),

f_txs as (SELECT

distinct miners as f_mne, min(time) as f_date

FROM all_txs

group by 1),

f_u as (select f_date, count(distinct f_mne) as "New usersx"

from f_txs

group by 1)

select round(avg("New usersx")) as avg_n_

from f_u