with arbitrum as (select 'Arbitrum' as "Chain", count(distinct from_address) as "Total Users"

from arbitrum.core.fact_transactions

where block_timestamp::date>='2024-01-01' and tx_succeeded='TRUE'

group by 1),

avalanche as (select 'Avalanche' as "Chain", count(distinct from_address) as "Total Users"

from avalanche.core.fact_transactions

where block_timestamp::date>='2024-01-01' and tx_succeeded='TRUE'

group by 1),

base as (select 'Base' as "Chain", count(distinct from_address) as "Total Users"

from base.core.fact_transactions

where block_timestamp::date>='2024-01-01' and tx_succeeded='TRUE'

group by 1),

bsc as (select 'Bsc' as "Chain", count(distinct from_address) as "Total Users"

from bsc.core.fact_transactions

where block_timestamp::date>='2024-01-01' and tx_succeeded='TRUE'

group by 1),

ethereum as (select 'Ethereum' as "Chain", count(distinct from_address) as "Total Users"

from ethereum.core.fact_transactions

where block_timestamp::date>='2024-01-01' and tx_succeeded='TRUE'

group by 1),

polygon as (select 'Polygon' as "Chain", count(distinct from_address) as "Total Users"

from polygon.core.fact_transactions

where block_timestamp::date>='2024-01-01' and tx_succeeded='TRUE'

group by 1),

optimism as (select 'Optimism' as "Chain", count(distinct from_address) as "Total Users"

from optimism.core.fact_transactions

where block_timestamp::date>='2024-01-01' and tx_succeeded='TRUE'

group by 1),