SELECT block_timestamp::DATE AS DAY, project_name,
COUNT(DISTINCT tx_hash) AS number_of_tx,
COUNT(DISTINCT origin_from_address) AS number_of_users,
SUM(number_of_tx) over (partition BY project_name ORDER BY DAY ROWS BETWEEN unbounded preceding AND CURRENT ROW ) AS cumulative_number_of_tx,
SUM(number_of_users) over (partition BY project_name ORDER BY DAY ROWS BETWEEN unbounded preceding AND CURRENT ROW ) AS cumulative_number_of_users
FROM optimism.core.fact_event_logs
INNER JOIN optimism.core.dim_labels ON origin_to_address = address
WHERE tx_status = 'SUCCESS'
AND block_timestamp::DATE >= CURRENT_DATE - 90
GROUP BY 1,2
ORDER BY 1