Updated 2025-03-06
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address as user,
    origin_to_address as contract_address
    from
    ink.core.fact_event_logs
    where
    tx_succeeded
    )

    select
    count(distinct tx_hash) as transactions,
    count(distinct contract_address) as contracts,
    count(distinct user) as users,
    transactions / contracts as average_transactions_per_contract,
    users / contracts as average_users_per_contract
    from
    main
    Last run: 3 months ago
    TRANSACTIONS
    CONTRACTS
    USERS
    AVERAGE_TRANSACTIONS_PER_CONTRACT
    AVERAGE_USERS_PER_CONTRACT
    1
    583232413339260319437.23847419.515631
    1
    45B
    4s