SELECT

ft.from_address AS user,

MIN(ft.block_timestamp) AS first_gaming_tx

FROM $query('6bbdf5a1-9212-4cc9-9983-bce1f246fbeb') ct

JOIN ronin.core.fact_transactions ft

ON ct.contract_address = ft.to_address

GROUP BY ft.from_address

),

dex_users AS (

SELECT

origin_from_address AS user,

MIN(block_timestamp) AS first_defi_tx

FROM ronin.core.ez_decoded_event_logs

WHERE origin_to_address IN (

'0x5f0acdd3ec767514ff1bf7e79949640bf94576bd',

'0x7d0556d55ca1a92708681e2e231733ebd922597d',

'0x77f96cf7b98b963fb8a9b84787806d396d953b2b',

'0x545edb750eb8769c868429be9586f5857a768758',

'0xc05afc8c9353c1dd5f872eccfacd60fd5a2a9ac7',

'0x7c645c35ab772be52a474b1e08414d55e8ea56d5',

'0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2'

)

GROUP BY origin_from_address

),

wallet_move AS (

SELECT g.user, g.first_gaming_tx, d.first_defi_tx

FROM gaming_users g

JOIN dex_users d

ON g.user = d.user

WHERE g.first_gaming_tx < d.first_defi_tx

),

katanaSwap AS (