select block_timestamp::date as date1, sum(swap_from_amount) as SOL_swapped_to_other_tokens

From solana.swaps

Where block_timestamp::date >= '2022-01-01'

And swap_from_mint = 'So11111111111111111111111111111111111111112'

Group by date1), to_sol AS(

select block_timestamp::date as date2, sum(swap_to_amount) as other_tokens_swapped_to_sol

From solana.swaps

Where block_timestamp::date >= '2022-01-01'

And swap_to_mint = 'So11111111111111111111111111111111111111112'

Group by date2

SELECT date1, SOL_swapped_to_other_tokens, other_tokens_swapped_to_sol

FROM from_sol, to_sol

WHERE date1 = date2