SELECT

swapper,

swap_from_amount

FROM solana.defi.fact_swaps

WHERE swap_from_mint = 'So11111111111111111111111111111111111111112'

and swap_from_amount < 0.1

),

distinct_tokens as (

SELECT

swapper,

SUM(DISTINCT swap_to_amount) as tokens_counted

FROM

solana.defi.fact_swaps

WHERE

block_timestamp > '2024-06-15'

AND swap_to_mint != 'So11111111111111111111111111111111111111112'

AND swap_to_mint != 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

GROUP BY

swapper

HAVING

tokens_counted > 20 AND tokens_counted < 200

),

max_amounts AS (

SELECT

swapper,

swap_to_mint,

swap_from_mint,

tx_id,

MAX(swap_to_amount) AS max_swap_to_amount,

MAX(swap_from_amount) AS max_swap_from_amount,

FROM

solana.defi.fact_swaps

WHERE

succeeded = TRUE

AND block_timestamp > '2024-06-15'