HOURLY | MINTED_TRANSACTIONS | MINTERS | AVG_MINT_TXS_PER_MINTER | |
|---|---|---|---|---|
1 | 2025-03-27 07:00:00.000 | 5659 | 3460 | 1.64 |
2 | 2025-03-26 03:00:00.000 | 9702 | 5723 | 1.7 |
3 | 2025-03-28 02:00:00.000 | 5233 | 3503 | 1.49 |
4 | 2025-03-27 00:00:00.000 | 9461 | 5320 | 1.78 |
5 | 2025-03-26 11:00:00.000 | 6267 | 3581 | 1.75 |
6 | 2025-03-26 21:00:00.000 | 10604 | 5983 | 1.77 |
7 | 2025-03-28 22:00:00.000 | 3434 | 2627 | 1.31 |
8 | 2025-03-29 14:00:00.000 | 2510 | 1309 | 1.92 |
9 | 2025-03-26 14:00:00.000 | 5607 | 4123 | 1.36 |
10 | 2025-03-27 01:00:00.000 | 10254 | 5690 | 1.8 |
11 | 2025-03-29 06:00:00.000 | 3957 | 2362 | 1.68 |
12 | 2025-03-29 12:00:00.000 | 5294 | 3382 | 1.57 |
13 | 2025-03-26 16:00:00.000 | 5617 | 3497 | 1.61 |
14 | 2025-03-29 00:00:00.000 | 2411 | 1638 | 1.47 |
15 | 2025-03-26 22:00:00.000 | 7054 | 4278 | 1.65 |
16 | 2025-03-27 10:00:00.000 | 4239 | 2603 | 1.63 |
17 | 2025-03-26 18:00:00.000 | 7111 | 4933 | 1.44 |
18 | 2025-03-26 19:00:00.000 | 5565 | 4071 | 1.37 |
19 | 2025-03-25 22:00:00.000 | 4632 | 3001 | 1.54 |
20 | 2025-03-28 05:00:00.000 | 2091 | 1543 | 1.36 |
SniperTotal Minted Transactions
Updated 7 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
trunc(BLOCK_TIMESTAMP,'hour') as hourly,
count(distinct tx_hash) as minted_Transactions,
count(distinct TO_ADDRESS) as minters,
round(minted_Transactions/minters,2) as avg_mint_txs_per_minter,
-- sum(QUANTITY) as minted_nfts,
-- round(minted_nfts/minters,2) as avg_mint_nft_per_minter,
-- round(minted_nfts/mint,2) as avg_mint_nft_per_mint_transaction
from ronin.nft.ez_nft_transfers where
contract_address in (
'0x2fb6feb663c481e9854a251002c772fead3974d6',--Ronke on a Sailing Ship,
'0xc2f09694fcc9c9ddcbe54a72b1a3b14658d2f755'--Jin on a Sailing Ship
)
and BLOCK_TIMESTAMP::date >= '2025-03-25'
and IS_MINT = 'TRUE'
group by 1
--0x2fb6feb663c481e9854a251002c772fead3974d6--Ronke on a Sailing Ship
--0xc2f09694fcc9c9ddcbe54a72b1a3b14658d2f755--Jin on a Sailing Ship
-- tx_hash = '0x026841b5d4b3a3d19ab4a1f476648a6c7abe5f5735e2f58295ac6fc6915f4df0'
Last run: 7 days ago
97
4KB
2s