SELECT

DISTINCT tx_hash

FROM optimism.core.fact_event_logs

WHERE contract_address LIKE lower('0x126bE6a9ec71A1FeA19D2288Ba2Ce4cDC0faCB68')

), tab2 as (

SELECT

date_trunc('week', block_timestamp) as week,

symbol,

count(DISTINCT tx_hash) as events,

count(DISTINCT CASE WHEN to_address LIKE lower('0x856cb5c3cBBe9e2E21293A644aA1f9363CEE11E8') THEN origin_from_address ELSE to_address END) as users,

sum(raw_amount / power(10, decimals)) as volume

FROM optimism.core.fact_token_transfers

LEFT outer JOIN optimism.core.dim_contracts

ON address LIKE contract_address

WHERE from_address LIKE lower('0x856cb5c3cBBe9e2E21293A644aA1f9363CEE11E8')

AND NOT tx_hash IN (SELECT * FROM tab1)

GROUP BY 1,2

SELECT

date_trunc('week', block_timestamp) as week,

'ETH' as symbol,

count(DISTINCT tx_hash) as events,

count(DISTINCT CASE WHEN eth_to_address LIKE lower('0x856cb5c3cBBe9e2E21293A644aA1f9363CEE11E8') THEN origin_from_address ELSE eth_to_address END) as users,

sum(AMOUNT_USD) as volume

FROM optimism.core.ez_eth_transfers

WHERE eth_from_address LIKE lower('0x856cb5c3cBBe9e2E21293A644aA1f9363CEE11E8')

AND NOT tx_hash IN (SELECT * FROM tab1)

GROUP BY 1,2