GAS_FEE | UNIQUE_MINTING_WALLETS | TOTAL_MINTS | |
|---|---|---|---|
1 | 1.82329 | 44 | 44 |
2 | 1.281 | 1 | 1 |
3 | 0.325 | 1 | 1 |
4 | 0.15 | 1 | 1 |
5 | 0.12525 | 2 | 2 |
6 | 0.092309751 | 1 | 1 |
7 | 0.0675 | 78 | 78 |
8 | 0.05 | 4 | 4 |
9 | 0.040666626 | 1 | 1 |
10 | 0.034890356 | 1 | 1 |
11 | 0.031982748 | 1 | 1 |
12 | 0.031980304 | 1 | 1 |
13 | 0.031752636 | 15 | 15 |
14 | 0.018929874 | 1 | 1 |
15 | 0.0185587 | 11 | 11 |
16 | 0.0185572 | 3 | 3 |
17 | 0.0184251 | 22 | 22 |
18 | 0.014970648 | 7 | 7 |
19 | 0.014969504 | 2 | 2 |
20 | 0.014862936 | 16 | 16 |
JeffersPublic minting analysis
Updated 2025-03-08
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 mint_data as
(
select *
from monad.testnet.fact_event_logs
where contract_address = lower('0xE8F0635591190Fb626F9D13C49b60626561Ed145')
and topic_1 = lower('0x0000000000000000000000000000000000000000000000000000000000000000')
and block_timestamp >= '2025-02-19 16:00:00'
),
public_mint as
(
select
m.tx_hash,
m.contract_address AS nft_contract,
m.origin_from_address AS minter_wallet,
m.origin_to_address AS minting_contract,
t.block_timestamp,
t.from_address,
t.to_address,
t.value as MON_value,
t.tx_fee as gas_fee,
from mint_data m
join monad.testnet.fact_transactions t
on m.tx_hash = t.tx_hash
where m.block_timestamp >= '2025-02-20 15:59:00'
order by m.block_timestamp
)
SELECT
gas_fee,
COUNT(DISTINCT minter_wallet) AS unique_minting_wallets,
COUNT(*) AS total_mints
FROM public_mint
GROUP BY gas_fee
ORDER BY gas_fee DESC;
Last run: about 2 months ago
25
421B
10s