with base as ( SELECT date_trunc('month', block_timestamp) as date, 'Near' as chain, count (DISTINCT TX_SIGNER) as active_users from near.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Ethereum' as chain, count (DISTINCT from_address) as active_users from ethereum.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Arbitrum' as chain, count (DISTINCT from_address) as active_users from arbitrum.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Avalanche' as chain, count (DISTINCT from_address) as active_users from avalanche.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Base' as chain, count (DISTINCT from_address) as active_users from base.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Optimism' as chain, count (DISTINCT from_address) as active_users from optimism.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Flow' as chain, count (DISTINCT PROPOSER) as active_users from flow.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Solana' as chain, count (DISTINCT SIGNERs [0]) as active_users from solana.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Sei' as chain, count (DISTINCT TX_FROM) as active_users from sei.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Aptos' as chain, count (DISTINCT SENDER) as active_users from aptos.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Gnosis' as chain, count (DISTINCT FROM_ADDRESS) as active_users from gnosis.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 UNION all SELECT date_trunc('month', block_timestamp) as date, 'Polygon' as chain, count (DISTINCT FROM_ADDRESS) as active_users from polygon.core.fact_transactions where date >= ' 2024-07-01' and date <= ' 2024-07-31' group by 1 ) select * from base order by active_users desc

Near Users Activity