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

Query	Creator	Created
gino volume sushi gnosis swaps evm dex	hrst79	Mar 18, 2023
outflow stats (Ginosis) sushi gnosis swaps evm dex	hrst79	Mar 18, 2023
Chain Users In July gnosis flow aptos near arbitrum	hrst79	Aug 3, 2024
gino inflow sushi gnosis swaps evm dex	hrst79	Mar 18, 2023
gino outflow sushi gnosis swaps evm dex	hrst79	Mar 18, 2023
Inflow stats (Ginosis) sushi gnosis swaps evm dex	hrst79	Mar 18, 2023

hrst79