select block_timestamp::date as day,
sum(swap_from_amount) as Swappedaway
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 day