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

b.SIGNERS[0] as "Main wallet address",

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

round(

count(DISTINCT a.tx_id) / count(DISTINCT date_trunc('second', a.block_timestamp))

) as avg_sec,

round(

count(DISTINCT a.tx_id) / count(DISTINCT date_trunc('minute', a.block_timestamp))

) as avg_min,

round(

count(DISTINCT a.tx_id) / count(DISTINCT date_trunc('hour', a.block_timestamp))

) as avg_hour,

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

from

eclipse.core.fact_transactions a

join eclipse.core.fact_transactions b

on a.SIGNERS[0] = b.SIGNERS[1]

where

a.block_timestamp::date >= '2024-12-01'

and b.LOG_MESSAGES[0] like '%turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN%'

and b.LOG_MESSAGES[1] = 'Program log: Instruction: GrantClicker'

and a.SUCCEEDED = 'TRUE'

GROUP by all

order by 1 desc

limit 30000