HOUR | TOKENS_MINTED | TOTAL_TOKENS_MINTED | |
|---|---|---|---|
1 | 2025-05-22 21:00:00.000 | 1 | 5155 |
2 | 2025-05-21 06:00:00.000 | 2 | 5154 |
3 | 2025-05-21 04:00:00.000 | 1 | 5152 |
4 | 2025-05-19 22:00:00.000 | 1 | 5151 |
5 | 2025-05-19 10:00:00.000 | 1 | 5150 |
6 | 2025-05-18 18:00:00.000 | 1 | 5149 |
7 | 2025-05-18 04:00:00.000 | 1 | 5148 |
8 | 2025-05-11 21:00:00.000 | 1 | 5147 |
9 | 2025-05-11 18:00:00.000 | 1 | 5146 |
10 | 2025-05-10 18:00:00.000 | 1 | 5145 |
11 | 2025-05-09 11:00:00.000 | 1 | 5144 |
12 | 2025-05-09 10:00:00.000 | 1 | 5143 |
13 | 2025-05-09 07:00:00.000 | 1 | 5142 |
14 | 2025-05-09 06:00:00.000 | 1 | 5141 |
15 | 2025-05-09 05:00:00.000 | 1 | 5140 |
16 | 2025-05-08 15:00:00.000 | 1 | 5139 |
17 | 2025-05-08 12:00:00.000 | 1 | 5138 |
18 | 2025-05-08 11:00:00.000 | 1 | 5137 |
19 | 2025-05-07 19:00:00.000 | 1 | 5136 |
20 | 2025-05-07 13:00:00.000 | 1 | 5135 |
Pine Analyticsfight_horse
Updated 6 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
›
⌄
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: 6 days ago
...
1941
66KB
355s