NFTS_MINTED | WALLETS | TOTAL_NFTS_MINTED | |
|---|---|---|---|
1 | Minted More than 1 | 222 | 774 |
2 | Minted 1 | 10647 | 10647 |
Pine AnalyticsMoo Games 1 copy copy
Updated 2025-02-03
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
›
⌄
SELECT
case when events = 1 then 'Minted 1' else 'Minted More than 1' end as NFTs_minted,
count(*) as wallets,
sum(events) as total_NFTs_minted
FROM (
SELECT
tx_from,
COUNT(*) AS events --,
--SUM(15000000.0 / POWER(10, 9)) AS volume_eth
FROM eclipse.core.fact_transfers
WHERE tx_to LIKE '6fviXSXwds8BRLCdisipRRfiZJENQ9LjESXAGkoVeADy'
AND mint LIKE 'Eth1111111111111111111111111111111111111111'
AND amount = 15000000
and succeeded
GROUP BY 1
order by 2 desc
)
GROUP BY 1
Last run: 3 months ago
2
57B
5s