saadiqOddities Wallet Contents
Updated 2022-11-25
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
›
⌄
⌄
WITH nft AS
(SELECT DISTINCT project_name,
nft_address
FROM ethereum.core.ez_nft_sales)
SELECT nft.project_name,
w.symbol,
w.contract_address,
concat('https://etherscan.io/address/', w.contract_address) AS etherscan,
count(1) AS wallets_holding
FROM ethereum.core.ez_current_balances w,
nft
WHERE w.contract_address = nft.nft_address
AND user_address in
(SELECT DISTINCT user_address
FROM ethereum.core.ez_current_balances
WHERE contract_address = '0x1792a96e5668ad7c167ab804a100ce42395ce54d' -- oddity
)
/*
proof contracts:
Proof: 0x08d7c0242953446436f34b4c78fe9da38c73668d
Moonbirds: 0x23581767a106ae21c074b2276d25e5c3e136a68b
Oddities: 0x1792a96e5668ad7c167ab804a100ce42395ce54d
*/
GROUP BY nft.project_name,
w.symbol,
w.contract_address
ORDER BY wallets_holding DESC;
Run a query to Download Data