with main_t as (select BLOCK_TIMESTAMP::date as date,

tx_hash, sender

from aptos.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2023-01-01' and

PAYLOAD_FUNCTION ilike '%0xf9552a68230e0f4c0aa4ff3521b622ccabd8a8f07d17e453fe6fa3c091c8d495%'

and SUCCESS = 'TRUE'),

x as (SELECT

DISTINCT sender, min(date) as f_time

from main_t

group by all),

x1 as (SELECT f_time, count(DISTINCT sender) as usersx

from x

GROUP by all) ,

x2 as (SELECT date, count(DISTINCT sender) as users

from main_t

GROUP by all),

final as (SELECT date, users-usersx as "Existing players" , usersx as "New players", users as "Total players"

from x2 join x1 on date=f_time)

SELECT round(avg("New players")) from final