SELECT

tx_hash,

sender AS swapper,

LOWER(event_data:from_token) AS token_in,

LOWER(event_data:to_token) AS token_out,

event_data:amount_in / 1e6 AS amount_in,

event_data:amount_out / 1e6 AS amount_out

FROM aptos.core.fact_events

JOIN aptos.core.fact_transactions USING (tx_hash, block_timestamp)

WHERE block_timestamp >= '2025-01-01'

AND event_type =

'0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::SwapEvent'

AND success = TRUE

AND (

event_data:from_token ILIKE '%0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b%'

OR event_data:to_token ILIKE '%0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b%'

)

),

token_symbols AS (

SELECT

fs.tx_hash,

fs.swapper,

fs.amount_in,

fs.amount_out,

fs.token_in,

fs.token_out,

COALESCE(

CASE fs.token_in

WHEN '0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b' THEN 'USDt'

WHEN '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' THEN 'USDC'

WHEN '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::usdc' THEN 'lzUSDC'

WHEN '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::usdt' THEN 'lzUSDT'

ELSE NULL

END,

tm_in.symbol, 'Unknown'