NFT Name | Mints | Minters | Transaction Fee Spent | Successful Mint | Failed Mint | |
|---|---|---|---|---|---|---|
1 | Jin on a Sailing Ship | 325224 | 325224 | 976.391319511 | 325224 | 0 |
2 | Ronke on a Sailing Ship | 270357 | 270357 | 576.687839311 | 270357 | 0 |
i_danJ&R On Opensea s
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
Select
n.name AS "NFT Name"
, COUNT(n.tx_hash) AS "Mints"
, COUNT(DISTINCT n.to_address) AS "Minters"
-- , COUNT(CASE WHEN n.from_address = '0x0000000000000000000000000000000000000000' THEN n.tx_hash END) AS mint
-- , COUNT(CASE WHEN n.from_address != '0x0000000000000000000000000000000000000000' THEN tx_hash END) AS Other_Activity
, SUM(t.tx_fee) AS "Transaction Fee Spent"
, COUNT(CASE WHEN t.tx_succeeded THEN n.tx_hash END) AS "Successful Mint"
, COUNT(CASE WHEN NOT t.tx_succeeded THEN n.tx_hash END) AS "Failed Mint"
FROM ronin.nft.ez_nft_transfers n
LEFT JOIN ronin.core.fact_transactions t on t.tx_hash = n.tx_hash
WHERE n.contract_address IN ('0xc2f09694fcc9c9ddcbe54a72b1a3b14658d2f755', '0x2fb6feb663c481e9854a251002c772fead3974d6')
AND n.from_address = '0x0000000000000000000000000000000000000000'
GROUP BY 1
ORDER BY 2 DESC
Last run: 3 days ago
2
129B
3s