Flipside Teamholograph avalanche transactions
    Updated 1 hour ago
    -- forked from holograph Ethereum transactions @ https://flipsidecrypto.xyz/edit/queries/c15d081e-a875-4775-b978-1b233afaa489

    -- WHile the dune dashboard has a cutoff time for v1 contracts as 1st jan 2024, there were
    -- 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 avalanche.core.fact_event_logs
    where block_timestamp >= '2022-11-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
    SELECT
    Last run: about 1 hour agoAuto-refreshes every 1 hour
    DATE
    TRANSACTIONS
    TOTAL_TRANSACTIONS
    1
    2023-01-01 00:00:00.00000
    2
    2023-01-02 00:00:00.00000
    3
    2023-01-03 00:00:00.00000
    4
    2023-01-04 00:00:00.00000
    5
    2023-01-05 00:00:00.00000
    6
    2023-01-06 00:00:00.00099
    7
    2023-01-07 00:00:00.000918
    8
    2023-01-08 00:00:00.000018
    9
    2023-01-09 00:00:00.000624
    10
    2023-01-10 00:00:00.0003559
    11
    2023-01-11 00:00:00.000107166
    12
    2023-01-12 00:00:00.000280446
    13
    2023-01-13 00:00:00.000346792
    14
    2023-01-14 00:00:00.0002541046
    15
    2023-01-15 00:00:00.0004311477
    16
    2023-01-16 00:00:00.0004251902
    17
    2023-01-17 00:00:00.0006472549
    18
    2023-01-18 00:00:00.0005623111
    19
    2023-01-19 00:00:00.0006413752
    20
    2023-01-20 00:00:00.0004764228
    ...
    741
    28KB
    47s