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 s

WHERE

succeeded = TRUE

AND block_timestamp > '2024-08-01 00:00:00'

GROUP BY

swapper,

swap_to_mint,

swap_from_mint,

tx_id

),

buy_transactions AS (

SELECT

swapper as trader,

swap_to_mint as token_bought,

SUM(max_swap_to_amount) as total_tokens_bought,

SUM(max_swap_from_amount) as total_sol_spent

FROM

max_amounts

WHERE

swap_from_mint = 'So11111111111111111111111111111111111111112'

GROUP BY

swapper,

swap_to_mint

),

sell_transactions AS (

SELECT

swapper as trader,