Total taps | Main wallet address | In-game address | AVG_SEC | AVG_MIN | AVG_HOUR | # days being active | last playing date | first playing date | |
|---|---|---|---|---|---|---|---|---|---|
1 | 51,101 | FJ4e5N9yghdnHysjDAbUwVzbfAfgVPkfZ4H272bzJyA1 | 81qHN8swAA9bMoQqy6FHBmfERfSypykEAsazwRjtt2tE | 6 | 131 | 1310 | 21 | 2025-03-26 00:00:00.000 | 2025-02-14 00:00:00.000 |
2 | 19,924 | FJ4e5N9yghdnHysjDAbUwVzbfAfgVPkfZ4H272bzJyA1 | BVXPimkd9Zs5VdWQ7jV8i4nXKK6CuA1tzjmoifJ4XNL3 | 5 | 92 | 906 | 10 | 2025-03-02 00:00:00.000 | 2025-01-12 00:00:00.000 |
Hessishttap check
Updated 10 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
acc_mapping as ( SELECT
SIGNERS[0] as main_acc, SIGNERS[1] as playing_acc
from eclipse.core.fact_transactions
where
block_timestamp::date >= '2024-12-01' and
SIGNERS[0] = '{{Enter_wallet_address_here}}' and
SUCCEEDED = 'TRUE'
and LOG_MESSAGES[0] like '%turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN%'
and LOG_MESSAGES[1] = 'Program log: Instruction: GrantClicker'
)
SELECT
TO_VARCHAR(count(DISTINCT tx_id) , '999,999,999,999') as "Total taps",
Main_acc as "Main wallet address",
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,
COUNT(DISTINCT block_timestamp::date) AS "# days being active",
max(block_timestamp::date) as "last playing date",
min(block_timestamp::date) as "first playing date"
from
eclipse.core.fact_events
join acc_mapping on "In-game address" = playing_acc
where Main_acc = '{{Enter_wallet_address_here}}' and
block_timestamp::date >= '2024-12-01'
and PROGRAM_ID = 'turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN'
and SUCCEEDED = 'TRUE'
Last run: about 10 hours ago
2
361B
159s