SELECT

block_timestamp::DATE AS date,

SUM(swap_to_amount) AS usdc_out

FROM

solana.core.fact_swaps

WHERE

block_timestamp >= '2022-10-01'

AND swap_from_mint = 'So11111111111111111111111111111111111111112'

AND swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

GROUP BY

1

),

sol_out AS (

SELECT

block_timestamp::DATE AS date,

SUM(swap_from_amount) AS usdc_in

FROM

solana.core.fact_swaps

WHERE

block_timestamp >= '2022-10-01'

AND swap_to_mint = 'So11111111111111111111111111111111111111112'

AND swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

GROUP BY

1

select

NVL(sol_in.date, sol_out.date) AS date,

CASE

WHEN NVL(sol_in.date, sol_out.date) <= '2022-11-07' THEN 'Before Market Downturn'

ELSE 'After Market Downturn'

END AS label,

usdc_in, usdc_out,

usdc_in-usdc_out AS difference

from

sol_in full outer join sol_out on sol_in.date = sol_out.date