flipside

    2. Total Transactions II
    hess2. Total Transactions II
    Updated 2025-04-13
    WITH basic AS ( SELECT
    block_timestamp::date AS date,
    tx_hash,
    from_address AS user,
    value,
    tx_fee,
    TX_SUCCEEDED
    FROM
    monad.testnet.fact_transactions
    )

    select trunc(date,'month') as month,
    month_name,
    count(DISTINCT tx_hash) as transactions,
    count(DISTINCT user) as address,
    transactions/address as "Avg Txn Per Address"
    from basic a join crosschain.core.dim_dates b on a.date = b.date_day
    where TX_SUCCEEDED = 'TRUE'
    group by 1,2
    order by 1 asc
    Last run: 10 days ago
    MONTH
    MONTH_NAME
    TRANSACTIONS
    ADDRESS
    Avg Txn Per Address
    1
    		2025-01-01 00:00:00.000January1685271130445536.370237
    2
    		2025-02-01 00:00:00.000February119584648408161229.298387
    3
    		2025-03-01 00:00:00.000March513435914869210325.906924
    4
    		2025-04-01 00:00:00.000April227276785822048592.764761
    4
    260B
    160s