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 = '{{wallet}}' --WALLET DOING SWAPPING

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

GROUP BY

TOKEN,

BUY_DATE,

SWAPPER

ORDER BY

BUY_DATE DESC

)

SELECT

TOKEN,

SWAPPER,

MIN(BUY_DATE) AS FIRST_BUY_DATE,

MAX(BUY_DATE) AS LAST_BUY_DATE,

COUNT(*) AS TOTAL_BUYS

FROM

BUY_TRANS

GROUP BY

TOKEN,

SWAPPER

),

BUY_AMOUNT AS (

SELECT

SUM(SWAP_FROM_AMOUNT) as TOKEN_BUY,

AVG(SWAP_FROM_AMOUNT) as AVG_TOKEN_BUY,