TO_VARCHAR(count(DISTINCT tx_id), '999,999,999,999') as "Total taps",

signers[0] as "In-game address",

round(count(DISTINCT tx_id) / count(DISTINCT date_trunc('second', block_timestamp))) as avg_sec,

round(count(DISTINCT tx_id) / count(DISTINCT date_trunc('minute', block_timestamp))) as avg_min,

round(count(DISTINCT tx_id) / count(DISTINCT date_trunc('hour', block_timestamp))) as avg_hour,

max(block_timestamp::date) as "last playing date"

FROM eclipse.core.fact_transactions

WHERE signers[0] = '7hR58qNCFb9dd73y2DSNdi8LWb9nsZCP5P9FqSekQJxW'

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

AND SUCCEEDED = 'TRUE'

GROUP BY signers[0]

ORDER BY 1 DESC;