SELECT

date_trunc('day', block_timestamp) as daily,

sum(inner_instruction:instructions[0]:parsed:info:amount)/1e9 as daily_sol_supply

FROM

solana.core.fact_events

WHERE

daily >= '2022-10-01'

AND instruction:programId = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo'

AND instruction:accounts[2] = '8PbodeaosQP19SjYFx855UMqWxH2HynZLdBXmsrbac36'

AND instruction:accounts[3] = '8UviNr47S8eL6J3WfDxMRa3hvLta1VDJwNWqsDgtN3Cv'

AND instruction:accounts[4] = '5h6ssFpeDeRbzsEHDbTQNH7nVGgsKrZydxdSTnLm6QdV'

GROUP BY

daily

),

sol_borrow AS (

SELECT

date_trunc('day', block_timestamp) as daily,

sum(inner_instruction:instructions[1]:parsed:info:amount)/1e9 as daily_sol_borrow

FROM

solana.core.fact_events

WHERE

daily >= '2022-10-01'

AND instruction:programId = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo' -- Program

AND instruction:accounts[0] = '8UviNr47S8eL6J3WfDxMRa3hvLta1VDJwNWqsDgtN3Cv' -- Source Borrow Reserve Liquidity Supply

AND instruction:accounts[2] = '8PbodeaosQP19SjYFx855UMqWxH2HynZLdBXmsrbac36' -- Borrow Reserve Account

GROUP BY

1

SELECT

NVL(a.daily, b.daily) AS daily,

CASE

WHEN NVL(a.daily, b.daily) <= '2022-11-07' THEN 'Before Market Downturn'

ELSE 'After Market Downturn'

END AS label,

daily_sol_supply,