elsinatotal amount
Updated 2025-03-01Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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