Transactions | Minters | Transaction Fee Spent | Successful Mint | Failed Mint | |
|---|---|---|---|---|---|
1 | 595581 | 332503 | 1553.079158822 | 595581 | 0 |
i_danJ&R On Opensea
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
Select
COUNT(t.tx_hash) AS "Transactions"
, 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 = 'TRUE' THEN t.tx_hash END) AS "Successful Mint"
, COUNT(CASE WHEN t.tx_succeeded = 'FALSE' THEN t.tx_hash END) AS "Failed Mint"
FROM ronin.nft.ez_nft_transfers n
FULL 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'
Last run: 3 days ago
1
41B
5s