SELECT

swapper,

block_timestamp,

swap_from_symbol,

swap_from_amount_usd,

swap_to_symbol,

swap_to_amount_usd,

tx_id,

ROW_NUMBER() OVER (PARTITION BY swapper ORDER BY block_timestamp DESC) AS rn

FROM

solana.defi.ez_dex_swaps

WHERE

swapper LIKE '{{1Starts_With}}%'

AND swapper LIKE '%{{2Ends_With}}'

SELECT DISTINCT

r.swapper,

r.block_timestamp AS date_of_last_trade,

r.swap_from_symbol,

r.swap_from_amount_usd,

r.swap_to_symbol,

r.swap_to_amount_usd,

CONCAT('https://solscan.io/tx/', r.tx_id) AS Last_Tx_Link,

CONCAT('https://solscan.io/account/', r.swapper) AS Address_Link

FROM

recent_trades r

WHERE

r.rn = 1

order by date_of_last_trade DESC

LIMIT 1000;