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

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

COUNT(DISTINCT swap.tx_hash) AS total_swaps

FROM

near.core.fact_transactions tx

INNER JOIN

near.defi.ez_dex_swaps swap

ON

tx.tx_hash = swap.tx_hash

WHERE

tx.block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'

AND swap.block_timestamp BETWEEN '2024-01-01' AND '2024-12-31';