sum(swap_from_amount) as volumeofswapped

from solana.swaps s

join solana.transactions t

on s.tx_id = t.tx_id

where swap_from_mint = 'So11111111111111111111111111111111111111112'

and swap_to_mint <> 'So11111111111111111111111111111111111111112'

and s.block_timestamp::date >= '2022-01-01'

and swap_program like '%orca%'

and t.succeeded = true

group by date