mo115ETH Blocks - June 20th
Updated 2022-06-29
9
1
2
3
4
5
6
›
⌄
select count(distinct BLOCK_NUMBER)as blocks,count(distinct tx_hash)as transactions, sum(TX_FEE)as fees,
(count(distinct tx_hash)/count(distinct BLOCK_NUMBER)) as transactions_per_block,(sum(gas_price)/count(distinct tx_hash)) as average_gas_price,
(sum(TX_FEE)/count(distinct BLOCK_NUMBER)) as fee_per_block,(sum(TX_FEE)/count(distinct tx_hash)) as fee_per_transaction
from ethereum.core.fact_transactions
where block_timestamp < '2022-06-21'
and block_timestamp > '2022-06-19'
Run a query to Download Data