'ethereum' as blockchain,

count(DISTINCT from_address) as active_addresses

from ethereum.core.fact_transactions

where block_timestamp::date >= '2024-05-01' and block_timestamp < '2024-06-01'

group by 1

UNION all

select

'base' as blockchain,

count(DISTINCT from_address) as active_addresses

from base.core.fact_transactions

where block_timestamp::date >= '2024-05-01' and block_timestamp < '2024-06-01'

group by 1

UNION all

select

'aptos' as blockchain,

count(DISTINCT sender) as active_addresses

from aptos.core.fact_transactions

where block_timestamp::date >= '2024-05-01' and block_timestamp < '2024-06-01'

and TX_TYPE ilike '%user%'

group by 1

UNION all

select

'arbitrum' as blockchain,

count(DISTINCT from_address) as active_addresses

from arbitrum.core.fact_transactions

where block_timestamp::date >= '2024-05-01' and block_timestamp < '2024-06-01'

group by 1

UNION all

select

'blast' as blockchain,

count(DISTINCT from_address) as active_addresses

from blast.core.fact_transactions

where block_timestamp::date >= '2024-05-01' and block_timestamp < '2024-06-01'

group by 1

UNION all