(select

date_trunc(day,block_timestamp) as day,

'Optimism' as network,

count(tx_hash) as tx_count,

count(distinct from_address) as user_count,

tx_count/user_count as tx_per_user

from Optimism.core.fact_transactions

group by 1

union all

select

date_trunc(day,block_timestamp) as day,

'Arbitrum' as network,

count(tx_hash) as tx_count,

count(distinct from_address) as user_count,

tx_count/user_count as tx_per_user

from Arbitrum.core.fact_transactions

group by 1

union all

select

date_trunc(day,block_timestamp) as day,

'Polygon' as network,

count(tx_hash) as tx_count,

count(distinct from_address) as user_count,

tx_count/user_count as tx_per_user

from Polygon.core.fact_transactions

group by 1