COUNT(DISTINCT t.sender) AS total_unique_players,

COUNT(DISTINCT e.tx_hash) AS total_unique_transactions,

COUNT(DISTINCT CASE WHEN t.block_timestamp >= DATEADD(DAY, -30, CURRENT_DATE) THEN t.sender END) AS total_active_players_30d

FROM

aptos.core.fact_events e

JOIN

aptos.core.fact_transactions t

ON

e.tx_hash = t.tx_hash

WHERE

e.event_address = '0x8afb046f44dd0cb9c445458f9c2e424759cd11f4a270fe6739dcffc16a4db8e';