'Aptos' as chain,

count(distinct tx_hash) as tx_count,

count(distinct sender) as unique_user_count,

-- tx_count / 86400 as tps

FROM aptos.core.fact_transactions

WHERE block_timestamp::date = current_date - interval '1 day'

union all

SELECT

'Arbitrum' as chain,

count(distinct tx_hash) as tx_count,

count(distinct from_address) as unique_user_count,

-- tx_count / 86400 as tps

FROM arbitrum.core.fact_transactions

WHERE block_timestamp::date = current_date - interval '1 day'

union all

SELECT

'Aurora' as chain,

count(distinct tx_hash) as tx_count,

count(distinct from_address) as unique_user_count,

-- tx_count / 86400 as tps

FROM aurora.core.fact_transactions

WHERE block_timestamp::date = current_date - interval '1 day'

union all

SELECT

'Avalanche' as chain,

count(distinct tx_hash) as tx_count,

count(distinct from_address) as unique_user_count,

-- tx_count / 86400 as tps

FROM avalanche.core.fact_transactions