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 | 8620616843 | 819029 | 8613290032 | 7326811 | 495.467106 | 5.747466974e-8 | 5e-8 | 0.0001824660966 | 0.0001586221458 | 15340402 | 133486255624386 | 581831579959442 | 22.94 |
Flipside Team1.1. Tx & Fees All-Time
Updated 3 hours ago
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
›
⌄
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"
, "Transactions" - "Successful Transactions" as "Failed Transactions"
, sum(total_fees_eth) as "Fees"
, sum(total_fees_eth)/sum(n_tx) as "Average Fee (ETH)"
, median(median_fee_eth) as "Median Fee (ETH)"
, sum(total_fees_usd)/sum(n_tx) as "Average Fee (USD)"
, median(median_fees_usd) as "Median Fee (USD)"
Last run: about 3 hours agoAuto-refreshes every 3 hours
1
150B
36s