wallets AS (

SELECT from_address AS wallet

, min(block_timestamp)::date AS first_tx_date

FROM optimism.core.fact_transactions

GROUP BY 1

),

first_2_txs_per_wallet AS (

SELECT from_address AS wallet

, tx_hash

, block_timestamp

, row_number() OVER (partition by from_address order by block_timestamp) AS wallet_tx_rank

, (CASE WHEN to_address IN ( '0xbe811a0d44e2553d25d11cb8dc0d3f0d0e6430e6' -- TridentRouter

, '0x8b396ddf906d552b2f98a8e7d743dd58cd0d920f' -- SushiXSwap

)

THEN 1 ELSE 0 END) AS is_sushiswap_tx

FROM optimism.core.fact_transactions

QUALIFY wallet_tx_rank <= 2

),

onboarded_wallets__sushiswap_onboarded_or_not AS (

SELECT w.wallet

, w.first_tx_date

, max(tx.is_sushiswap_tx) > 0 AS is_sushiswap_onboarded

FROM wallets AS w

LEFT JOIN first_2_txs_per_wallet AS tx

ON tx.wallet = w.wallet

GROUP BY 1,2

),