date_trunc('day', block_timestamp) as date,

case when date >= '2023-01-01' then '2023' ELSE '2022' end as "year",

count(*) as "Number of TXs",

count(distinct from_address) as "Number of Users",

sum("Number of TXs") over (order by date asc) as "Cumulative Number of TXs",

sum("Number of Users") over (order by date asc) as "Cululative Number of Users",

"Number of TXs"/"Number of Users" as "Number of TXs per User",

sum(ETH_VALUE) as "Volume",

avg(ETH_VALUE) as "Average Volume",

sum("Volume") over (order by date asc) as "Cululative Volume",

avg(tx_fee) as "Average TX Fee"

FROM optimism.core.fact_transactions

WHERE STATUS = 'SUCCESS' AND block_timestamp >= CURRENT_DATE - INTERVAL '90 days'

GROUP BY 1,2

order by 1