count(distinct tx_hash) as txn_count,

count (distinct tx_receiver) as receivers_count,

count (distinct tx_signer) as senders_count,

txn_count / 31536000 as tps,

txn_count / senders_count as users_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 '2021-01-01' and '2021-12-31'