tx_status,

count(distinct tx_hash) as txn_count,

count (distinct tx_receiver) as receivers_count,

count (distinct tx_signer) as senders_count,

sum(gas_used / pow(10, 12)) as total_gas_used,

sum(transaction_fee / pow(10,24)) as total_tx_fee,

avg(gas_used / pow(10, 12)) as average_gas_used_per_tx,

avg(transaction_fee / pow(10,24)) as average_tx_fee,

median(gas_used / pow(10, 12)) as median_gas_used_per_tx,

median(transaction_fee / pow(10,24)) as median_tx_fee

from near.core.fact_transactions

where block_timestamp::date between '2022-01-01' and '2022-12-31'

group by 1

order by 2 desc