SELECT

block_timestamp,

swap_to_mint,

swapper

FROM

solana.defi.fact_swaps

WHERE

succeeded = TRUE

AND swap_to_mint = '3LiStshvoyU5qV8eb74RYTowGLPCyqba1R1qqBnnpump'

ORDER BY

block_timestamp DESC

LIMIT 10000

),

wallets AS (

SELECT

s.swapper,

s.swap_to_mint

FROM

solana.defi.fact_swaps s

WHERE s.swapper IN 'mint'

),

ref_tokens AS (

SELECT DISTINCT

w.swap_to_mint AS ref_token

FROM

wallets w

),

swapper_tokens AS (

SELECT

swap_to_mint,

swapper

FROM

solana.defi.fact_swaps

),

common_tokens_count AS (