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