SELECT

DATE_TRUNC('{{granularity }}', block_timestamp) AS date,

COUNT(DISTINCT tx_hash) AS tx

FROM near.core.fact_actions_events

WHERE BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '{{trading_period}} days'

GROUP BY date

SELECT

date,

tx,

SUM(tx) OVER (ORDER BY date ASC) AS cumulative_tx

FROM data

ORDER BY date DESC;