A as( select 'Arbitrum' as chain, origin_from_address as user, block_timestamp from arbitrum.core.ez_native_transfers

union all select 'Arbitrum' as chain, origin_from_address as user, block_timestamp from arbitrum.core.ez_token_transfers

union all select 'Optimism' as chain, origin_from_address as user, block_timestamp from optimism.core.ez_native_transfers

union all select 'Optimism' as chain, origin_from_address as user, block_timestamp from optimism.core.ez_token_transfers

union all select 'Blast' as chain, origin_from_address as user, block_timestamp from blast.core.ez_native_transfers

union all select 'Blast' as chain, origin_from_address as user, block_timestamp from blast.core.ez_token_transfers

union all select 'Base' as chain, origin_from_address as user, block_timestamp from base.core.ez_native_transfers

union all select 'Base' as chain, origin_from_address as user, block_timestamp from base.core.ez_token_transfers

select date_trunc('month',block_timestamp) as time, chain, count(distinct user) as user

from A

where year(block_timestamp) >= 2024

group by 1,2

order by 1 desc, user desc