SELECT

swapper,

block_timestamp,

swap_from_symbol,

swap_from_amount_usd,

swap_to_symbol,

swap_to_amount_usd,

swap_from_amount,

swap_from_amount_usd / NULLIF(swap_from_amount, 0) AS swap_from_price,

tx_id,

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

FROM

solana.defi.ez_dex_swaps

WHERE

-- (SWAP_TO_MINT = '{{Token_Address}}'

SWAP_FROM_MINT = '{{Token_Address}}' -- sellers only

AND block_timestamp BETWEEN

CASE WHEN '{{Start_Date}}' = '' THEN '2020-01-01 00:00:00' ELSE '{{Start_Date}}' END

AND

CASE WHEN '{{End_Date}}' = '' THEN CURRENT_TIMESTAMP ELSE '{{End_Date}}' END

AND swap_from_amount_usd BETWEEN

CASE WHEN '{{Sell_Amount_Low}}' = '' THEN '0' ELSE '{{Sell_Amount_Low}}' END

AND

CASE WHEN '{{Sell_Amount_High}}' = '' THEN 1000000000 ELSE '{{Sell_Amount_High}}' END

AND swap_from_price BETWEEN

CASE WHEN '{{Price_Amount_Low}}' = '' THEN '0' ELSE '{{Price_Amount_Low}}' END

AND

CASE WHEN '{{Price_Amount_High}}' = '' THEN 1000000000 ELSE '{{Price_Amount_High}}' END

SELECT DISTINCT

r.swapper,

r.block_timestamp AS last_trade_timestamp,

r.swap_from_price AS swap_sell_price,

r.swap_from_symbol AS swap_sell_symbol,

r.swap_from_amount_usd AS swap_sell_amount_usd,