date_trunc('week', block_timestamp) as date,

CASE

WHEN tx_hash IN (SELECT DISTINCT tx_hash from optimism.core.ez_nft_sales) THEN 'NFT'

WHEN event_name IN ('Swap', 'TokenExchange', 'Swapped') THEN 'Swap'

WHEN event_name ilike '%Delegate%' THEN 'Delegate'

WHEN event_name ilike '%Add%' AND event_name ilike '%Liquidity%' THEN 'Add Liquidity'

WHEN (event_name ilike '%Decrease%' OR event_name ilike '%Remove%') AND event_name ilike '%Liquidity%' THEN 'Remove Liquidity'

WHEN event_name ilike '%Stake%' THEN 'Stake'

ELSE 'Other'

END as "Action",

COUNT(DISTINCT tx_hash) as "TX Count"

FROM optimism.core.fact_event_logs

WHERE "Action" is not null and block_timestamp::date>='2022-01-01' and block_timestamp::date<CURRENT_DATE

AND tx_hash IN (SELECT DISTINCT tx_hash FROM optimism.core.fact_event_logs WHERE TX_STATUS = 'SUCCESS' AND contract_address ILIKE '0x4200000000000000000000000000000000000042')

GROUP BY 1,2