SELECT

DATE_TRUNC('month', block_timestamp) AS month,

COUNT(DISTINCT origin_from_address) AS total_users

FROM avalanche.core.ez_decoded_event_logs

WHERE

tx_status = 'SUCCESS'

AND event_name = 'Submitted'

AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'

GROUP BY 1

),

user AS (

SELECT

origin_from_address AS users,

MIN(block_timestamp::date) AS min_date

FROM avalanche.core.ez_decoded_event_logs

WHERE

tx_status = 'SUCCESS'

AND event_name = 'Submitted'

AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'

GROUP BY users

),

new_user AS (

SELECT

DATE_TRUNC('month', min_date) AS stake_date,

COUNT(users) AS new_staker

FROM user

GROUP BY DATE_TRUNC('month', min_date)

new_user.stake_date,

new_user.new_staker,

staker.total_users

FROM new_user

JOIN staker ON new_user.stake_date = staker.month

ORDER BY new_user.stake_date;