DATE_TRUNC('hour', block_timestamp) AS tx_hour,

COUNT(tx_id) AS tx_count_per_hour,

SUM(COUNT(tx_id)) OVER (ORDER BY DATE_TRUNC('hour', block_timestamp)) AS running_total

FROM solana.core.fact_events

WHERE succeeded

AND program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'

AND instruction:accounts[0] = 'x44bDE1D2kxBxmPfCjQ3RUGQbF7ccBP9HhYxWvsuU1b' -- Tree Authority

AND instruction:accounts[4] = '8LWKE6EiFBRsBSeHsZHqgCFaq3qxh9o1VpD6htK6mJV5' -- Payer

AND block_timestamp > current_date() - 365

GROUP BY DATE_TRUNC('hour', block_timestamp)

ORDER BY tx_hour