SELECT TX_HASH, ORIGIN_FROM_ADDRESS

FROM arbitrum.core.ez_decoded_event_logs

WHERE ORIGIN_TO_ADDRESS = LOWER('0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae')

AND EVENT_NAME = 'LiFiGenericSwapCompleted'

AND TX_STATUS = 'SUCCESS'

),

Table2 AS (

SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Day, TX_HASH, ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, AMOUNT_USD

FROM arbitrum.core.ez_token_transfers

WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

AND ORIGIN_FROM_ADDRESS = TO_ADDRESS

SELECT Day,

CASE

WHEN time_row = 1 THEN 'First Time Swappers'

ELSE 'Returning Swappers'

END AS user_type,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS swappers

FROM (

SELECT t2.Day, t2.ORIGIN_FROM_ADDRESS,

ROW_NUMBER() OVER (PARTITION BY t2.ORIGIN_FROM_ADDRESS ORDER BY t2.Day) AS time_row

FROM Table2 t2

JOIN Table1 t1 ON t2.TX_HASH = t1.TX_HASH

) AS tab

GROUP BY Day, user_type

ORDER BY Day, user_type;