select date_trunc('month', BLOCK_TIMESTAMP::DATE) as MONTH, count(distinct FROM_ADDRESS) as MONTHLY_ACTIVE_ADDRESSES_ARBITRUM

from arbitrum.core.fact_transactions

group by 1

order by 1 asc

), query2 AS (

select date_trunc('month', BLOCK_TIMESTAMP::DATE) as MONTH, count(distinct PAYER) as MONTHLY_ACTIVE_ADDRESSES_FLOW

from flow.core.fact_transactions

group by 1

order by 1 asc

), query3 AS (

select date_trunc('month', BLOCK_TIMESTAMP::DATE) as MONTH, count(distinct signers[0]) as MONTHLY_ACTIVE_ADDRESSES_SOLANA

from solana.core.fact_transactions

where block_timestamp::date >= '2015-01-01'

group by 1

order by 1 asc

), query4 AS (

SELECT date_trunc('month', BLOCK_TIMESTAMP::DATE) as MONTH, count(distinct FROM_ADDRESS) as MONTHLY_ACTIVE_ADDRESSES_ETHEREUM

from ethereum.core.fact_transactions

GROUP BY 1

ORDER BY 1 asc

), query5 AS (

select date_trunc('month', BLOCK_TIMESTAMP::DATE) as MONTH, count(distinct FROM_ADDRESS) as MONTHLY_ACTIVE_ADDRESSES_GNOSIS

from gnosis.core.fact_transactions

group by 1

ORDER BY 1 asc

), query6 AS (

select date_trunc('month', BLOCK_TIMESTAMP::DATE) as MONTH, count(distinct FROM_ADDRESS) as MONTHLY_ACTIVE_ADDRESSES_AVALANCHE

from avalanche.core.fact_transactions

group by 1

ORDER BY 1 asc

), query7 AS (

select date_trunc('month', BLOCK_TIMESTAMP::DATE) as MONTH, count(distinct FROM_ADDRESS) as MONTHLY_ACTIVE_ADDRESSES_OPTIMISM

from optimism.core.fact_transactions

group by 1

ORDER BY 1 asc