SalehTotal
    Updated 2025-04-30
    select
    count(distinct block_timestamp::date) as "Active Days"
    ,count(distinct from_address) as "# of Wallets"
    ,count(distinct tx_hash) as "# of TXs"
    ,sum(TX_FEE_PRECISE) as "Total Fee-$BTC"
    ,sum(VALUE) as "Volume-$BTC"
    from mezo.testnet.fact_transactions
    where TX_SUCCEEDED
    Last run: about 1 month ago
    Active Days
    # of Wallets
    # of TXs
    Total Fee-$BTC
    Volume-$BTC
    1
    33299984697570.4540905102462.741610699
    1
    46B
    1s