saadiqProof Ecosystem Wallet Holdings
    Updated 2023-09-11
    -- 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