block_timestamp::date as day,

count (distinct tx_id) as tx_num,

tx_num / 1440 as tpm,

tx_num / 86400 as tps,

sum(tx_num) over (order by day asc) as comulative_tx_num

from solana.core.fact_transactions

where block_timestamp >= current_date - interval '1 year'

and succeeded = 1

group by 1