DATE | MINING_TXS | MINERS | |
|---|---|---|---|
1 | 2025-04-11 00:00:00.000 | 954 | 8 |
2 | 2025-04-12 00:00:00.000 | 3309009 | 14023 |
3 | 2025-04-13 00:00:00.000 | 5514732 | 15973 |
4 | 2025-04-14 00:00:00.000 | 5519679 | 10684 |
5 | 2025-04-15 00:00:00.000 | 5456558 | 7725 |
6 | 2025-04-16 00:00:00.000 | 4854657 | 6104 |
7 | 2025-04-17 00:00:00.000 | 3904986 | 4877 |
8 | 2025-04-18 00:00:00.000 | 3016056 | 3772 |
9 | 2025-04-19 00:00:00.000 | 2404191 | 3089 |
10 | 2025-04-20 00:00:00.000 | 2190829 | 2622 |
11 | 2025-04-21 00:00:00.000 | 1879686 | 2329 |
12 | 2025-04-22 00:00:00.000 | 1665520 | 2063 |
13 | 2025-04-23 00:00:00.000 | 1528247 | 1818 |
14 | 2025-04-24 00:00:00.000 | 1447900 | 1617 |
15 | 2025-04-25 00:00:00.000 | 1459730 | 1518 |
16 | 2025-04-26 00:00:00.000 | 1272079 | 1332 |
17 | 2025-04-27 00:00:00.000 | 1084557 | 1217 |
18 | 2025-04-28 00:00:00.000 | 969316 | 1178 |
19 | 2025-04-29 00:00:00.000 | 867261 | 1046 |
20 | 2025-04-30 00:00:00.000 | 837510 | 912 |
mamad-5XN3k3BITZ 2
Updated 2025-05-16
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
›
⌄
⌄
select
date_trunc('day', block_timestamp) as date,
count(distinct tx_id) as mining_txs,
count(distinct SIGNERS[0]) as miners
--min(BLOCK_TIMESTAMP) as min_date,
--max(BLOCK_TIMESTAMP) as max_date,
--count(distinct tx_id) / TIMESTAMPDIFF('HOUR', MIN(BLOCK_TIMESTAMP), MAX(BLOCK_TIMESTAMP)) AS avg_minted_per_hour
from eclipse.core.fact_events
where PROGRAM_ID = 'F1ULBrY2Tjsmb1L4Wt4vX6UtiWRikLoRFWooSpxMM6nR'
and SUCCEEDED = 'TRUE'
group by 1
order by 1 asc
/*
select
distinct TX_FROM,
count(distinct tx_id) as txs,
count(distinct tx_to) as users,
sum(AMOUNT/pow(10,decimal)) as vol,
from eclipse.core.fact_transfers
where MINT = '64mggk2nXg6vHC1qCdsZdEFzd5QGN4id54Vbho4PswCF'
and TX_FROM = 'Feh8eCUQaHGfdPyGEARmVse3m4NBGgaVYwMiKE3CdcPz'
and SUCCEEDED = 'TRUE'
group by 1
order by 2 desc
*/
Last run: about 1 month ago
36
1KB
10s