select 'Aptos' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct sender) as "AUs" from aptos.core.fact_transactions where SUCCESS=true and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Arbitrum' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct FROM_ADDRESS) as "AUs" from arbitrum.core.fact_transactions where STATUS='SUCCESS' and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Optimism' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct FROM_ADDRESS) as "AUs" from optimism.core.fact_transactions where STATUS='SUCCESS' and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Avalanche' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct FROM_ADDRESS) as "AUs" from avalanche.core.fact_transactions where STATUS='SUCCESS' and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Polygon' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct FROM_ADDRESS) as "AUs" from polygon.core.fact_transactions where STATUS='SUCCESS' and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Base' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct FROM_ADDRESS) as "AUs" from base.core.fact_transactions where STATUS='SUCCESS' and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Blast' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct FROM_ADDRESS) as "AUs" from blast.core.fact_transactions where STATUS='SUCCESS' and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Ethereum' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct FROM_ADDRESS) as "AUs" from ethereum.core.fact_transactions where STATUS='SUCCESS' and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'BSC' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct FROM_ADDRESS) as "AUs" from bsc.core.fact_transactions where STATUS='SUCCESS' and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Sei' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct TX_FROM) as "AUs" from sei.core.fact_transactions where TX_SUCCEEDED=TRUE and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Solana' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct SIGNERS[0]) as "AUs" from solana.core.fact_transactions where SUCCEEDED=TRUE and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Near' as "Chain", 'Near' as "Tag", count(*) as "Transactions", count(distinct ifnull(tx:actions[0]:Delegate:delegate_action:sender_id::string, TX_SIGNER)) as "AUs" from near.core.fact_transactions where TX_SUCCEEDED=true and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Axelar' as "Chain", 'Other' as "Tag", count(*) as "Transactions", count(distinct TX_FROM) as "AUs" from axelar.core.fact_transactions where TX_SUCCEEDED=true and BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1 union all select 'Thorchain' as "Chain", 'Other' as "Tag", count(distinct FACT_TRANSFERS_ID) as "Transactions", count(distinct FROM_ADDRESS) as "AUs" from thorchain.core.fact_transfers where BLOCK_TIMESTAMP::date>='2024-07-01' and BLOCK_TIMESTAMP<'2024-10-01' group by 1

Query	Creator	Created
near q reprot - txs and aus in chains thorchain axelar aptos near bsc	MoDeFi	Jul 13, 2024
near reprot - txs and aus in chains thorchain axelar aptos near bsc	MoDeFi	May 26, 2024

MoDeFi