afonsofee data total
Updated 2023-06-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
count (distinct (tx_hash)) as txn_count,
sum(tx_fee) as total_tx_fee,
txn_count / datediff(second, date('2022-01-01'), current_date) as tps,
avg(tx_fee) as avg_tx_fee,
median(tx_fee) as median_tx_fee,
sum(gas_price) as total_gas_price,
avg(gas_price) as avg_gas_price,
sum(gas_used) as total_gas_used,
avg(gas_used) as avg_gas_used
from optimism.core.fact_transactions
where block_timestamp::date >= '2022-01-01'
Run a query to Download Data