WITH optimism_daily AS
(SELECT DATE_TRUNC('day',block_timestamp) AS "Days",
COUNT(tx_hash) AS "Total Transaction Volume",
'Optimism' AS chain_type
FROM optimism.core.fact_transactions
WHERE status = 'SUCCESS'
GROUP BY "Days", chain_type),
arbitrum_daily AS
(SELECT DATE_TRUNC('day',block_timestamp) AS "Days",
COUNT(tx_hash) AS "Total Transaction Volume",
'Arbitrum' AS chain_type
FROM arbitrum.core.fact_transactions
WHERE status = 'SUCCESS'
GROUP BY "Days", chain_type)
SELECT *
FROM optimism_daily
UNION
SELECT *
FROM arbitrum_daily