SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,

COUNT(DISTINCT TX_HASH) AS ethereum_txs_per_day,

COUNT(DISTINCT FROM_ADDRESS) AS ethereum_activeaddrs_per_day

FROM ethereum.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= {{start_date}}

GROUP BY 1

),

opt AS

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,

COUNT(DISTINCT TX_HASH) AS optimism_txs_per_day,

COUNT(DISTINCT FROM_ADDRESS) AS optimism_activeaddrs_per_day

FROM optimism.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= {{start_date}}

GROUP BY 1

),

arb AS

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,

COUNT(DISTINCT TX_HASH) AS arbitrum_txs_per_day,

COUNT(DISTINCT FROM_ADDRESS) AS arbitrum_activeaddrs_per_day

FROM arbitrum.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= {{start_date}}

GROUP BY 1

),

pol AS

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,

COUNT(DISTINCT TX_HASH) AS polygon_txs_per_day,

COUNT(DISTINCT FROM_ADDRESS) AS polygon_activeaddrs_per_day