with prize_pool as (

select

AMOUNT_PRECISE as win_amount,

TO_ADDRESS as user,

from near.core.ez_token_transfers

where contract_address = '17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1'

and FROM_ADDRESS = 'aa-harvest-moon.near'

and block_timestamp::date >= '2024-11-17'

and transfer_type = 'nep141'

),

users_start_playing_date as (

select TO_ADDRESS as player, block_timestamp as start_playing_date

from near.core.ez_token_transfers

where block_timestamp::date >= '2024-04-01'

and CONTRACT_ADDRESS = 'aa-harvest-moon.near'

row_number() over (partition by player order by block_timestamp ASC) = 1

),

moon_users as (

select

DISTINCT to_address as moon_user

from near.core.ez_token_transfers

where block_timestamp::date >= '2024-04-01'

and CONTRACT_ADDRESS = 'aa-harvest-moon.near'

),

traders as (

select DISTINCT user as Unique_participants

from prize_pool

),