Total taps | In-game address | AVG_SEC | AVG_MIN | AVG_HOUR | last playing date | |
---|---|---|---|---|---|---|
1 | 4,059,915 | 4beaZ4KgbZxHjX8Rw9QsetLNnC9ZDsrykGBaDYB7PCoy | 13 | 478 | 16305 | 2025-01-20 00:00:00.000 |
2 | 3,385,288 | DuXPK1DznL94cDDwEqeJcePQ6S5rWXdtUksaW1KW8fZs | 4 | 159 | 8338 | 2025-01-20 00:00:00.000 |
3 | 3,206,771 | C366eBRYtmVV1caib2VxxrQqqsQ7Sh5ZHJYD5GNRutBp | 9 | 211 | 7174 | 2025-01-26 00:00:00.000 |
4 | 3,115,031 | GWkzBdMKjk2Akv2XXrRfEU6GwNmALPVHB3caCa5X4E6F | 5 | 146 | 5380 | 2025-01-24 00:00:00.000 |
5 | 3,086,977 | FMgSWdg3BpwG51ydGxSCmuHi9vExsX4VpGPcQThG6bLu | 4 | 138 | 6800 | 2025-01-23 00:00:00.000 |
6 | 3,002,667 | HGU4jDP13yXE1hENtwGrsAGgYGpwyDadXwG47c1rYsEP | 6 | 210 | 8072 | 2025-01-19 00:00:00.000 |
7 | 2,965,421 | 6mqEFHtzz7cV6dtoM1PHYTtjs29cXJkfX8M3TbsnkgMx | 9 | 209 | 10226 | 2025-01-20 00:00:00.000 |
8 | 2,854,668 | 2xMMhuouhnhgQvu6CJW4qFeKEnJSZ82xzBuzAgkeTjKx | 4 | 153 | 5779 | 2025-01-26 00:00:00.000 |
9 | 2,724,029 | 4DL34JUzTQ5uVYJtHSUPy4bqH3roiiKYev1G6PrF5hw2 | 5 | 182 | 7942 | 2025-01-26 00:00:00.000 |
10 | 2,602,591 | DGG7MDko9wLcdgcdHnLVkU92vxGLRPBZ7rQ3r67vhJYo | 4 | 165 | 7959 | 2025-01-26 00:00:00.000 |
11 | 2,542,805 | GgYVRoqAW5xHG11vYRPbEzm6yzs4PP63Di8HcmzeHrfe | 6 | 108 | 5045 | 2025-01-26 00:00:00.000 |
12 | 2,412,784 | 6yWRb7MA4PTputZS2GgQ1BKQHC5pu1124HqpKroLs2LG | 6 | 162 | 6235 | 2025-01-26 00:00:00.000 |
13 | 2,411,858 | 58VRQbj4NfkzcG2bV7Gf73MQvyBys9dwPFtDraoutuGw | 5 | 214 | 10049 | 2025-01-26 00:00:00.000 |
14 | 2,379,232 | EymWUr3z1efxqMqLJwx2Nr8SNvbEfevSbBNMvtbroQUC | 5 | 182 | 7060 | 2025-01-18 00:00:00.000 |
15 | 2,330,283 | 2BEUyNpkzo4cpcL7RDLpXsxWjhq2iTafdk8auKs2tfQ3 | 4 | 115 | 5133 | 2025-01-26 00:00:00.000 |
16 | 2,288,852 | 474exJdF1wbNWytvKbSPy52tNgArGfFUwvMNF2pqD3Yy | 5 | 141 | 6484 | 2025-01-26 00:00:00.000 |
17 | 2,282,688 | 4pqRK67YYgtKu6SQ59N6LKnmV77qeX5paQN9bkUen1ta | 3 | 116 | 5321 | 2025-01-26 00:00:00.000 |
18 | 2,249,658 | 3BtWv8uGQ2KHFQqMk5XPSR7PK8zZZvVK88hAdCG4ifVm | 5 | 158 | 7784 | 2025-01-11 00:00:00.000 |
19 | 2,186,903 | 6aykxxJhpZitkxtmH1586oGxQYudkRWj7vwKLqE27aKi | 7 | 169 | 6394 | 2025-01-25 00:00:00.000 |
20 | 2,183,661 | traNBSTQKsND8F6Zo9d2W87nHGzDTmoDvnUgKbureHX | 13 | 419 | 11740 | 2025-01-24 00:00:00.000 |
Hessishtabtrb - pls ldrb new
Updated 2025-01-26
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
›
⌄
SELECT
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] in ( SELECT
DISTINCT SIGNERS[1]
from eclipse.core.fact_transactions
where
block_timestamp::date >= '2024-12-01' and
SUCCEEDED = 'TRUE'
and LOG_MESSAGES[0] like '%turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN%'
and LOG_MESSAGES[1] = 'Program log: Instruction: GrantClicker'
) and
block_timestamp::date >= '2024-12-01'
and SUCCEEDED = 'TRUE'
GROUP by all
order by 1 desc
limit 50000
Last run: 20 days ago
...
50000
5MB
1011s