SELECT

trunc(hour, 'day') AS day,

AVG(price) AS price

FROM

near.price.ez_prices_hourly

WHERE

symbol = 'NEAR'

GROUP BY

day

SELECT

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

COUNT(DISTINCT tx_hash) AS transaction,

COUNT(tx_signer) AS user,

SUM(transaction_fee / 1e24) AS fee,

SUM((transaction_fee / 1e24) * np.price) AS fee_usd,

SUM(SUM((transaction_fee / 1e24) * np.price)) OVER (ORDER BY date) AS cum_fee

FROM

near.core.fact_transactions nf

JOIN

nearprice np

ON

DATE_TRUNC('day', nf.block_timestamp) = np.day

WHERE

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

AND TX_SUCCEEDED = 1

GROUP BY

date

ORDER BY

date DESC;