WITH SCORE AS(

WITH BUY AS (

WITH DATES AS (

WITH BUY_TRANS AS(

SELECT

DATE_TRUNC('minute', BLOCK_TIMESTAMP) as BUY_DATE,

SWAP_TO_MINT as TOKEN,

SWAPPER

FROM

solana.defi.fact_swaps

WHERE

SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112' --ONLY SOL TO SPL

AND SWAPPER IN (

SELECT

swapper

FROM

solana.defi.fact_swaps

WHERE

SWAP_TO_MINT = '{{memecoins}}'

AND SWAP_FROM_AMOUNT > 0.1

ORDER BY

block_timestamp desc

LIMIT

2000

) --WALLET DOING SWAPPING

--AND SWAP_FROM_MINT = 'Hz9KLFv7MDmaMd3D77CFCvDpGT3A7qDkEKER84DW6jei' --SPECIFIC COIN

AND block_timestamp >= (current_date() - {{days}})

AND TOKEN != 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

AND TOKEN != 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

GROUP BY

TOKEN,

BUY_DATE,

SWAPPER

ORDER BY

BUY_DATE DESC