Sandeshholograph wallets split by chain
    Updated 2024-04-15
    with ethereum_data as
    (
    -- WHile the dune dashboard has a cutoff time for v1 contracts as 1st jan 2024, there were
    -- tras 1st jan 2024
    -- users continued to transact with even after that, so you can see a higher number in our method.
    with deployed_and_holograph_address as
    (
    with
    v1 as
    (
    (
    select
    cast(concat('0x',substr(topics[1],27,64))as varchar(42)) as cont_address
    from ethereum.core.fact_event_logs
    where block_timestamp >= '2023-01-01 00:00:00'
    AND contract_address = lower('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55')
    and topics[0]='0xa802207d4c618b40db3b25b7b90e6f483e16b2c1f8d3610b15b345a718c6b41b'
    )
    union all
    (
    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