SELECT

decoded_log:user AS Users,

MIN(block_timestamp::date) AS first_stake_date

FROM avalanche.core.ez_decoded_event_logs

WHERE

tx_status = 'SUCCESS'

AND event_name = 'Submitted'

AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'

AND block_timestamp::date >= '2024-01-01'

GROUP BY 1

),

Returning_Stakers AS (

SELECT

decoded_log:user AS Users,

block_timestamp::date AS date

FROM avalanche.core.ez_decoded_event_logs

WHERE

tx_status = 'SUCCESS'

AND event_name = 'Submitted'

AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'

AND block_timestamp::date >= '2024-01-01'

SELECT

date_trunc('day', first_stake_date) AS date,

'New Stakers' AS staker_type,

COUNT(DISTINCT users) AS num_stakers

FROM

New_Stakers

GROUP BY 1

UNION ALL

SELECT