HOUR | TOKENS_MINTED | TOTAL_TOKENS_MINTED | |
|---|---|---|---|
1 | 2025-04-05 13:00:00.000 | 5 | 4972 |
2 | 2025-04-05 11:00:00.000 | 1 | 4967 |
3 | 2025-04-05 09:00:00.000 | 1 | 4966 |
4 | 2025-04-05 07:00:00.000 | 1 | 4965 |
5 | 2025-04-05 05:00:00.000 | 1 | 4964 |
6 | 2025-04-05 02:00:00.000 | 1 | 4963 |
7 | 2025-04-04 20:00:00.000 | 1 | 4962 |
8 | 2025-04-04 12:00:00.000 | 1 | 4961 |
9 | 2025-04-04 11:00:00.000 | 1 | 4960 |
10 | 2025-04-04 10:00:00.000 | 1 | 4959 |
11 | 2025-04-04 09:00:00.000 | 2 | 4958 |
12 | 2025-04-04 06:00:00.000 | 1 | 4956 |
13 | 2025-04-04 04:00:00.000 | 1 | 4955 |
14 | 2025-04-04 00:00:00.000 | 1 | 4954 |
15 | 2025-04-03 22:00:00.000 | 1 | 4953 |
16 | 2025-04-03 18:00:00.000 | 1 | 4952 |
17 | 2025-04-03 16:00:00.000 | 1 | 4951 |
18 | 2025-04-03 13:00:00.000 | 1 | 4950 |
19 | 2025-04-03 11:00:00.000 | 1 | 4949 |
20 | 2025-04-03 05:00:00.000 | 1 | 4948 |
Pine Analyticsfight_horse
Updated 2025-04-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
date_trunc('hour', block_timestamp) as hour,
count(*) as tokens_minted,
sum(tokens_minted) over (order by hour) as total_tokens_minted
FROM (
SELECT
t.*,
f.value as log_message,
f.index as log_index
FROM eclipse.core.fact_transactions t,
LATERAL FLATTEN(input => LOG_MESSAGES) f
WHERE log_message LIKE '%InitializeMint2%'
AND block_timestamp > '2024-11-10'
and log_messages[0] like 'Program 7X3YmPcRu4V5GKxeFvC9MQq4bemCdR5MWea5tVs62bM9 invoke [1]'
and SUCCEEDED
and not signers[0] like '2SpeaLUs5SUBauC3xDwDyArz28buhi44QP4RBQq3Gn4E'
)
GROUP BY 1
order by hour DESC
Last run: 20 days ago
...
1808
61KB
226s