0xHaM-dNike NFT Holders Distribution
Updated 2023-02-02Copy Reference Fork
999
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
35
36
›
⌄
WITH
mints AS (
SELECT
block_timestamp,
tx_hash,
nft_to_address AS minter,
tokenid
FROM
ethereum.core.ez_nft_mints
WHERE nft_address IN (
'0x86825dfca7a6224cfbd2da48e85df2fc3aa7c4b1',
'0xf661d58cfe893993b11d53d11148c4650590c692',
'0x9a06ef3a841316a9e2c1c93b9c21a7342abe484f',
'0x212590b0dac9502e0591b79db4cedeb6356dcc36',
'0x1bb6edf7b129967d512086fbdf489ed659580916',
'0x348fc118bcc65a92dc033a951af153d14d945312',
'0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b',
'0x6d4bbc0387dd4759eee30f6a482ac6dc2df3facf',
'0x9930929903f9c6c83d9e7c70d058d03c376a8337',
'0xb7be4001bff2c5f4a61dd2435e4c9a19d8d12343',
'0xd3f69f10532457d35188895feaa4c20b730ede88',
'0xc541fc1aa62384ab7994268883f80ef92aac6399',
'0x0972290a80333d19c6703073c3e57134a4ca0127',
'0xae3d8d68b4f6c3ee784b2b0669885a315ba77c08'
)
),
sales AS (
SELECT
block_timestamp,
tx_hash,
buyer_address AS buyer,
tokenid
FROM
ethereum.core.ez_nft_sales
WHERE nft_address IN (
'0x86825dfca7a6224cfbd2da48e85df2fc3aa7c4b1',
Run a query to Download Data