WITH sol_in as (

SELECT

date_trunc('day', block_timestamp) as date,

SUM(swap_from_amount) AS volume_in

FROM solana.core.fact_swaps

WHERE swap_from_mint = 'So11111111111111111111111111111111111111112'

AND swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

AND succeeded = 'TRUE'

AND swap_program ilike 'orca%'

AND date_trunc('day', block_timestamp) >= '2022-2-1'

and date_trunc('day', block_timestamp) <= '2022-2-28'

GROUP BY date

ORDER BY date ASC

),

sol_out as (

SELECT

date_trunc('day', block_timestamp) as date,

SUM(swap_to_amount) AS volume_out

FROM solana.core.fact_swaps

WHERE swap_to_mint = 'So11111111111111111111111111111111111111112'

AND swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

AND succeeded = 'TRUE'

AND swap_program ilike 'orca%'

AND date_trunc('day', block_timestamp) >= '2022-2-1'

and date_trunc('day', block_timestamp) <= '2022-2-28'

GROUP BY date

ORDER BY date ASC)

SELECT a.date, a.volume_in, b.volume_out, (a.volume_in - b.volume_out) as flow

FROM sol_in as a

LEFT JOIN sol_out as b on b.date = a.date

ORDER BY date ASC