Total taps | Main wallet address | In-game address | AVG_SEC | AVG_MIN | AVG_HOUR | # days being active | last playing date | first playing date | |
|---|---|---|---|---|---|---|---|---|---|
1 | 232,387 | FJ4e5N9yghdnHysjDAbUwVzbfAfgVPkfZ4H272bzJyA1 | 81qHN8swAA9bMoQqy6FHBmfERfSypykEAsazwRjtt2tE | 6 | 97 | 1889 | 32 | 2025-04-11 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 5 days 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
block_timestamp as timestamp,
tx_id as tx,
signers[0] as Main_acc,
signers[1] as playing_acc
FROM eclipse.core.fact_transactions
where signers[0] = '{{Enter_wallet_address_here}}'
and block_timestamp::date >= '2024-01-01'
AND ARRAY_CONTAINS('Program log: Instruction: GrantClicker'::VARIANT, log_messages)
AND succeeded = 'TRUE'
)
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'
Last run: 5 days ago
2
360B
364s