select

date_trunc('day',BLOCK_TIMESTAMP_HOUR) as "Date"

, sum (TRANSACTION_COUNT ) as "Transactions"

, sum (TRANSACTION_COUNT_SUCCESS ) as "Successful Transactions"

, sum (TRANSACTION_COUNT_FAILED ) as "Failed Transactions"

, sum (TOTAL_FEES_NATIVE/1e9 ) as "Fees (SOL)"

, sum("Transactions") over (order by "Date") as "Cumulative Transactions Last 30d"

, sum("Fees (SOL)") over (order by "Date") as "Cumulative Fees (SOL) Last 30d"

from solana.stats.ez_core_metrics_hourly

where "Date" >= current_date - 31

and "Date" < current_date

group by 1

;