saadiqProof Ecosystem Wallet Holdings
Updated 2023-09-11
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
›
⌄
-- Inventory of proof holdings for wallets that hold a
-- Proof Pass, MB, Oddity or Mythics Egg
with
ens_filtered AS (
SELECT
ROW_NUMBER() OVER (
PARTITION BY
owner
ORDER BY
expiration_date DESC
) AS row_num,
owner,
ens_name,
twitter
FROM
crosschain.core.ez_ens
WHERE
owner IN (
SELECT DISTINCT
user_address
FROM
ethereum.core.ez_current_balances
WHERE
contract_address IN (
'0x23581767a106ae21c074b2276d25e5c3e136a68b',
'0x08d7c0242953446436f34b4c78fe9da38c73668d',
'0x1792a96e5668ad7c167ab804a100ce42395ce54d',
'0x13303b4ee819fac204be5ef77523cfcd558c082f',
'0xc0ffee8ff7e5497c2d6f7684859709225fcc5be8'
)
/* proof contracts: MB, Proof, Oddities, Mythics Eggs, Mythics */
)
)
SELECT
b.user_address,
CASE
Run a query to Download Data