symbol,

sum(usd_amount) / sum(tx_count) as avg_usd_per_tx,

sum(usd_amount) / sum(user_count) as avg_usd_per_user

(

(

select

date_trunc(week, block_timestamp) as week,

symbol,

'Optimism' as network,

count(tx_hash) as tx_count,

count(distinct from_address) as user_count,

sum(AMOUNT_USD) as usd_amount

from

optimism.core.ez_token_transfers

where

(

to_address in (

select

address

from

Optimism.core.dim_labels

where

ADDRESS_NAME ilike '%layerzero%'

)

)

group by

1,

2

union

select

date_trunc(week, block_timestamp) as week,

'ETH' as symbol,

'Optimism' as network,

count(tx_hash) as tx_count,