SELECT

date_trunc('day', block_timestamp) AS day,

count(DISTINCT tx_hash) as daily_transactions,

ROW_NUMBER() OVER (ORDER BY date_trunc('day', block_timestamp)) - 1 AS index

FROM

near.core.fact_transactions

WHERE

block_timestamp >= (SELECT MIN(block_timestamp) FROM near.core.fact_transactions) AND

block_timestamp < (SELECT MIN(block_timestamp) + interval '365 days' FROM near.core.fact_transactions)

GROUP BY

day

day,

daily_transactions,

index

indexed_transactions

ORDER BY

day;