Salehblast-all_count
Updated 2024-11-11
99
1
2
3
4
5
6
7
8
9
10
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