SELECT

COUNT(DISTINCT origin_from_address) AS active_transferer

FROM arbitrum.core.fact_token_transfers

WHERE block_timestamp >= '2024-01-01'

AND block_timestamp < '2024-07-01'

),

BASE AS (

SELECT

COUNT(DISTINCT origin_from_address) AS active_transferer

FROM base.core.fact_token_transfers

WHERE block_timestamp >= '2024-01-01'

AND block_timestamp < '2024-07-01'

),

OPTIMISM AS (

SELECT

COUNT(DISTINCT origin_from_address) AS active_transferer

FROM optimism.core.fact_token_transfers

WHERE block_timestamp >= '2024-01-01'

AND block_timestamp < '2024-07-01'

SELECT 'Arbitrum' AS chain, active_transferer

FROM ARBITRUM

UNION ALL

SELECT 'Base' AS chain, active_transferer

FROM BASE

UNION ALL

SELECT 'Optimism' AS chain, active_transferer

FROM OPTIMISM

ORDER BY chain;