SELECT

block_timestamp,

case when t.tx_signer = l.address then t.tx_receiver else tx_receiver end as recipient,

t.tx_hash

FROM near.core.fact_transactions t

INNER JOIN near.core.dim_address_labels l

ON (t.tx_signer = l.address or t.tx_receiver = l.address)

WHERE l.project_name = 'sweat'

AND l.label_type = 'games'

AND t.tx_succeeded = TRUE

AND t.block_timestamp >= '2024-11-05'

AND t.block_timestamp < CURRENT_DATE

,

active_users_u as (

SELECT

date_trunc('day', block_timestamp) as date,

count(DISTINCT recipient) as active_users

FROM eventTb

GROUP BY date

, new as (

SELECT

date_trunc('day', first_tx) as date,

count(DISTINCT user) as new_user

FROM (

SELECT

recipient as user,

min(block_timestamp) as first_tx

FROM eventTb

GROUP BY 1

GROUP BY 1