Salehblast-all_count
    Updated 2024-11-11
    select
    count(DISTINCT tx_hash) as TXn
    ,count(DISTINCT from_address) as Wallets
    ,sum(value) as "ETH volume"
    ,count(DISTINCT block_timestamp::date) as "Activity Days"
    ,TXn/"Activity Days"/24/60/60 as "TPS"
    ,sum(TX_FEE) as "TX FEE(ETH)"
    ,count(DISTINCT block_hash) as Blocks
    from blast.core.fact_transactions
    where STATUS='SUCCESS'

    QueryRunArchived: QueryRun has been archived