SELECT

COUNT(DISTINCT tx_signer) AS active_addresses,

COUNT(DISTINCT tx_hash) AS total_transactions,

SUM(transaction_fee) AS total_fees

FROM near.core.fact_transactions

WHERE block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

SELECT

active_addresses AS "Active Addresses 2024",

total_transactions AS "Total Transactions 2024",

total_fees / total_transactions / POW(10, 24) AS "Average Fee per Transaction 2024"

FROM transaction_data;