Transactions | All-Time Signers | Successful Transactions | Failed Transactions | Fees | Average Fee (ETH) | Median Fee (ETH) | Average Fee (USD) | Median Fee (USD) | Blocks Produced | CU's Consumed | CU's Limit | CU's Limit % | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 17111874873 | 1029277 | 17101294557 | 10580316 | 939.570236 | 5.490749804e-8 | 5e-8 | 0.00015078436 | 0.0001358497083 | 24606393 | 260582873277642 | 1098409208617597 | 23.72 |
0xHaM-din Total
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- select
-- count(DISTINCT TX_ID) as "Transactions",
-- count(distinct SIGNERS[0]) as "AUs",
-- sum(fee/1e9) as "Fees",
-- from eclipse.core.fact_transactions
-- froked from https://flipsidecrypto.xyz/flipsideteam/q/K0tC4Z2TBOwg/1.1.-tx-fees-all-time
with eth_daily_price AS (
select
date_trunc('day', hour) as day_,
avg(price) as eth_day_price
from ethereum.price.ez_prices_hourly
where is_native = TRUE
group by day_
),
daily_priced AS (
select d.day_,
n_tx,
n_succeeded,
n_blocks,
total_fees_eth,
median_fee_eth,
(total_fees_eth * p.eth_day_price) as total_fees_usd,
(median_fee_eth * p.eth_day_price) as median_fees_usd,
total_compute_units,
total_compute_limit
from
datascience_public_misc.eclipse_analytics.daily_tx_stats d left join eth_daily_price p using (day_)
)
select
sum(n_tx) as "Transactions"
, (select count(signer_) from datascience_public_misc.eclipse_analytics.signer_first_timestamp) as "All-Time Signers"
, sum(n_succeeded) as "Successful Transactions"
Last run: 10 days ago
1
153B
1s