SELECT DISTINCT tx_hash

FROM optimism.core.fact_event_logs

WHERE contract_address LIKE '0x4200000000000000000000000000000000000010'

), tab2 as (

SELECT

date_trunc('week', block_timestamp) as week,

symbol,

count(DISTINCT tx_hash) as transfer,

count(DISTINCT TO_ADDRESS) as users

FROM optimism.core.fact_token_transfers

LEFT OUTER JOIN optimism.core.dim_contracts

ON address = contract_address

WHERE tx_hash in (SELECT * FROM tab1)

AND from_address LIKE '0x0000000000000000000000000000000000000000'

AND symbol IN ('USDC', 'USDT', 'ETH', 'WETH')

GROUP BY 1,2

), tab3 as (

SELECT

date_trunc('week', hour) as week2,

avg(price) as avg_price

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol LIKE 'WETH'

GROUP BY 1

SELECT

FROM tab2

LEFT outer JOIN tab3

ON week = week2