SELECT
block_timestamp::date AS date,
SUM(swap_from_amount) AS Swapped_away
FROM solana.swaps
WHERE
block_timestamp::date >= '2022-01-01'
AND swap_from_mint = 'So11111111111111111111111111111111111111112'
AND swap_to_mint != 'So11111111111111111111111111111111111111112'
AND succeeded = 'TRUE'
Group BY date