freemartianCoca-Cola NFTs Total
Updated 2023-09-17
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
›
⌄
-- forked from Coca-Cola NFTs @ https://flipsidecrypto.xyz/edit/queries/48683299-6a2a-4032-8572-aad0d840e750
-- forked from On-Chain Summer NFTs Total @ https://flipsidecrypto.xyz/edit/queries/23178b3f-e51c-495c-b098-601f13d10722
-- forked from Bridge to Base NFT #1 quest Totals @ https://flipsidecrypto.xyz/edit/queries/b1903ab4-23a4-4c2d-b07a-d93fa3b0443b
with mints as (
select * from base.core.ez_nft_transfers
where nft_address in (
-- '0x0c664a85521d5721bca047d29238d9e2a9e9e861',
-- '0x33ed5107f821bb1465da30b7dce4fb7105b0ad16',
-- '0x8b2937ead425ccc91fc0ad884638dc2129c51cb2',
'0x65b2e459f779ff4af4e4a16bc8065a0063cf8221',
'0x9a466c55f0cfc8ea3cee03de0eb94bf35a934522',
'0x19766e9da39ecb68b85b9b4af3b0ce4f9a4f2ecf',
'0x766d25d7005e6b690c0ab4fa1e81a2eb9b416c50',
'0x32cf27f2753e90948195b64ec55c486ee640cf61',
'0x916555cd5f02e159b84d5247f8660531a4525d2d',
'0xe4c3aa3978b61431c070109629a687bc42d66d8f',
'0x1ddb721bf79d3ad33fbac72e5decf2a436cb42a3')
and event_type = 'mint')
select
count(distinct nft_to_address) as Unique_minters,
count(tx_hash) as Total_mints
from mints
Run a query to Download Data