Flipside TeamHolograph unique wallets
    Updated 2024-09-06
    -- forked from Holograph unique wallets @ https://flipsidecrypto.xyz/edit/queries/6211c259-9f11-453d-8239-26d3110d88cf

    with v1_contracts as
    (
    SELECT
    CAST(cont_address AS VARCHAR(42)) as cont_address
    FROM
    (
    SELECT
    '0x6429b42da2a06aa1c46710509fc96e846f46181e' AS cont_address -- Holograph
    UNION ALL
    SELECT
    '0xd85b5e176a30edd1915d6728faebd25669b60d8b' -- HolographBridge
    UNION ALL
    SELECT
    '0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55' -- HolographFactory
    UNION ALL
    SELECT
    '0xf2b701062cef0ebbbff6d388fd793e176e7ab185' -- HolographInterfaces
    UNION ALL
    SELECT
    '0xe8303f9b7d7a3de35f8c9b4405411c5ebfaf4c2c' -- HolographOperator
    UNION ALL
    SELECT
    '0x9c120f9281308d71c838f8fadb41a82bfc7fffef' -- HolographRegistry
    UNION ALL
    SELECT
    '0xd3ab25452b0e97ec923536dd49287da6dd089050' -- HolographTreasury
    ) AS t
    ),
    v2_contracts as
    (
    SELECT
    CAST(cont_address AS VARCHAR(42)) as cont_address
    FROM
    (
    Auto-refreshes every 1 hour
    QueryRunArchived: QueryRun has been archived