COUNT(DISTINCT tx_hash) AS "Total Transactions 2024",

ROUND(SUM(transaction_fee)/POW(10,24), 2) AS "Transaction Fees 2024"

FROM near.core.fact_transactions

WHERE block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01';