date_trunc( 'month' , a.block_timestamp ) AS "date"

, 'near' as chain

, count( DISTINCT a.tx_signer ) AS "Active Users"

FROM

near.core.fact_transactions a

WHERE "date" >= '2023-01-01'

AND "date" < '2023-10-01'

AND a.tx_status = 'Success'

GROUP BY 1

ORDER BY 1 DESC

),

op as (

SELECT

date_trunc( 'month' , a.block_timestamp ) AS "date"

, 'optimism' as chain

, count( DISTINCT a.from_address ) AS "Active Users"

FROM

optimism.core.fact_transactions a

WHERE "date" >= '2023-01-01'

AND "date" < '2023-10-01'

AND a.status = 'SUCCESS'

GROUP BY 1

ORDER BY 1 DESC

),

arb as (

SELECT

date_trunc( 'month' , a.block_timestamp ) AS "date"

, 'arbitrum' as chain

, count( DISTINCT a.from_address ) AS "Active Users"

FROM

arbitrum.core.fact_transactions a

WHERE "date" >= '2023-01-01'

AND "date" < '2023-10-01'

AND a.status = 'SUCCESS'