DATE(BLOCK_TIMESTAMP) AS "DAY",

SUM(swap_from_amount) AS "SOL swap amount"

from solana.core.fact_swaps

where ( SWAP_PROGRAM = 'raydium v4')

and BLOCK_TIMESTAMP >= CURRENT_DATE() - interval '6 week'

AND swap_from_mint = 'So11111111111111111111111111111111111111112'

AND swap_to_mint != 'So11111111111111111111111111111111111111112' -- exclude swaps to SOL

GROUP BY 1