SELECT

block_timestamp,

transaction_fee / POW(10, 24) AS tx_fee

FROM

near.core.fact_transactions

WHERE

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

),

daily_summary AS (

SELECT

DATE_TRUNC('day', t1.block_timestamp) AS date,

SUM(t1.tx_fee) AS total_revenue,

SUM(t1.tx_fee) AS total_fees

FROM

t1

GROUP BY

date

SELECT

date,

total_revenue,

total_fees

FROM

daily_summary;