afonsofee data total
    Updated 2023-06-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