DATE(block_timestamp) AS swap_date,

COUNT(

DISTINCT CASE

WHEN DATE(block_timestamp) = first_buy_date THEN swapper

END

) AS "New Buyers",

COUNT(DISTINCT swapper) - COUNT(

DISTINCT CASE

WHEN DATE(block_timestamp) = first_buy_date THEN swapper

END

) AS "Old Buyers"

(

SELECT

swapper,

block_timestamp,

MIN(DATE(block_timestamp)) OVER (PARTITION BY swapper) AS first_buy_date

FROM

SOLANA.defi.fact_swaps

WHERE

swap_to_mint = 'jupSoLaHXQiZZTSfEWMTRRgpnyFm8f6sZdosWBjx93v'

AND succeeded = TRUE

) AS buys

GROUP BY

swap_date

ORDER BY

swap_date DESC;