SELECT
SUM(tx.transaction_fee) / POW(10, 24) AS "Total Bridge Transaction Fees NEAR"
FROM
near.defi.ez_bridge_activity bridge
JOIN
near.core.fact_transactions tx
ON
bridge.tx_hash = tx.tx_hash
WHERE
bridge.block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
AND tx.block_timestamp BETWEEN '2024-01-01' AND '2024-12-31';