elsinatotal amount
    Updated 2025-03-01
    select
    count(distinct tx_hash) as tx_count,
    count(distinct from_address) as user_count,
    sum(value) as volume,
    sum(tx_fee) as tx_fees,
    count(distinct case when TX_SUCCEEDED = 'TRUE' then tx_hash end ) as succeed_txns,
    (succeed_txns / tx_count ) * 100 as success_rate,

    avg(tx_fee) as avg_fee_per_tx
    from boba.core.fact_transactions

    QueryRunArchived: QueryRun has been archived