Updated 2025-04-16
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    from_address as user,
    tx_fee
    from
    sei.core_evm.fact_transactions
    where
    status = 'SUCCESS'
    and block_timestamp >= '2024-01-01'

    )

    select
    count(distinct tx_hash) as transactions,
    min(block_timestamp) as first_txn,
    count(distinct user) as users,
    sum(tx_fee) as fee_volume,
    avg(tx_fee) as average_fee_amount
    from
    main


    Last run: 17 days ago
    TRANSACTIONS
    FIRST_TXN
    USERS
    FEE_VOLUME
    AVERAGE_FEE_AMOUNT
    1
    1083547422024-05-27 13:20:03.00015754008288079.0868793830.00265866617
    1
    79B
    11s