select

block_timestamp,

TX_HASH

from crosschain.olas.fact_service_events

select

TRUNC(block_timestamp, 'd') AS date,

case

when trunc(block_timestamp, 'd') < '2023-04-01' then 'Q1-2023'

when trunc(block_timestamp, 'd') < '2023-07-01' then 'Q2-2023'

when trunc(block_timestamp, 'd') < '2023-09-01' then 'Q3-2023'

when trunc(block_timestamp, 'd') < '2024-01-01' then 'Q4-2023'

when trunc(block_timestamp, 'd') < '2024-04-01' then 'Q1-2024'

when trunc(block_timestamp, 'd') < '2024-07-01' then 'Q2-2024'

when trunc(block_timestamp, 'd') < '2024-10-01' then 'Q3-2024'

when trunc(block_timestamp, 'd') < '2025-01-01' then 'Q4-2024'

end as quarter,

count(DISTINCT TX_HASH) as "# Transactions",

sum("# Transactions") over (partition by quarter order by date asc) as "Cum # Transactions by Quarter"

from new

where date >= '2023-01-01'

group by 1,2

ORDER by 1 DESC