select

date(s.block_timestamp) as dt,

sum(swap_from_amount) as sol_vol

from solana.core.fact_swaps s inner join solana.core.dim_labels l on s.swap_to_mint=l.address

where swap_program='orca' and

swap_from_mint='So11111111111111111111111111111111111111112' and

succeeded='TRUE' and

swap_to_mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' and

block_timestamp>='2022-02-01' and block_timestamp<='2022-02-28'

group by 1

order by 1),

usdctosol as (

select

date(s.block_timestamp) as dt,

sum(swap_to_amount) as usdc_vol

from solana.core.fact_swaps s inner join solana.core.dim_labels l on s.swap_to_mint=l.address

where swap_program='orca' and

swap_from_mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' and

succeeded='TRUE' and

swap_to_mint='So11111111111111111111111111111111111111112' and

block_timestamp>='2022-02-01' and

block_timestamp<='2022-02-28'

group by 1

order by 1)

select soltousdc.dt,

sol_vol as sol_vol_in,