Updated 2025-05-10
    with

    users as (
    select
    distinct from_address as user
    from
    ink.core.fact_transactions
    where
    tx_succeeded
    ),

    main as (
    select
    tx_hash,
    block_timestamp,
    from_address as user,
    'Ethereum' as chain
    from
    ethereum.core.fact_transactions
    where
    status = 'SUCCESS'
    and user in (select user from users)

    union all

    select
    tx_hash,
    block_timestamp,
    from_address as user,
    'Avalanche' as chain
    from
    avalanche.core.fact_transactions
    where
    status = 'SUCCESS'
    and user in (select user from users)

    Last run: 19 days ago
    TRANSACTIONS
    USERS
    DAILY_AVERAGE_TRANSACTIONS
    DAILY_AVERAGE_USERS
    1
    371057759213850121738.10990870.160761
    1
    44B
    1084s