TAPS | AVG_SEC | AVG_MIN | AVG_HOUR | PLS | AVG_PLR_TP | AVG_MIN_PL | AVG_HOUR_PL | |
---|---|---|---|---|---|---|---|---|
1 | 9386711175 | 1744.058818 | 100501.195677 | 5956035.009518 | 287575 | 32640.915153 | 3.078994 | 182.471447 |
Hessishtab-trb tot
Updated 2 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 valid_signers AS (
SELECT DISTINCT SIGNERS[1] AS tapper
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'
),
event_data AS (
SELECT
TX_ID,
block_timestamp,
signers[0] AS signer
FROM eclipse.core.fact_events
JOIN valid_signers ON signer = tapper
WHERE block_timestamp::date >= '2024-12-01'
AND PROGRAM_ID = 'turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN'
AND SUCCEEDED = 'TRUE'
),
aggregated_data AS (
SELECT
COUNT(TX_ID) AS taps,
COUNT(DISTINCT signer) AS pls,
COUNT(DISTINCT date_trunc('second', block_timestamp)) AS distinct_seconds,
COUNT(DISTINCT date_trunc('minute', block_timestamp)) AS distinct_minutes,
COUNT(DISTINCT date_trunc('hour', block_timestamp)) AS distinct_hours
FROM event_data
)
SELECT
taps,
CASE WHEN distinct_seconds = 0 THEN 0 ELSE taps / distinct_seconds END AS avg_sec,
CASE WHEN distinct_minutes = 0 THEN 0 ELSE taps / distinct_minutes END AS avg_min,
CASE WHEN distinct_hours = 0 THEN 0 ELSE taps / distinct_hours END AS avg_hour,
pls,
CASE WHEN pls = 0 THEN 0 ELSE taps / pls END AS avg_plr_tp,
CASE WHEN distinct_minutes = 0 THEN 0 ELSE pls / distinct_minutes END AS avg_min_pl,
Last run: about 2 hours ago
1
95B
605s