with orca as ( select 'Orca' as defi, 'inflow' as status, sum(swap_from_amount) as total_amount from solana.fact_swaps where block_timestamp::date >= '2022-03-01' and block_timestamp::date< '2022-04-17' and succeeded = 'TRUE' and swap_from_mint = 'So11111111111111111111111111111111111111112' and lower(swap_program) LIKE lower('%orca%') UNION select 'Orca' as defi, 'outflow' as status, sum(swap_to_amount) as total_amount from solana.fact_swaps where block_timestamp::date >= '2022-03-01' and block_timestamp::date< '2022-04-17' and succeeded = 'TRUE' and swap_to_mint = 'So11111111111111111111111111111111111111112' and lower(swap_program) LIKE lower('%orca%') ), friktion as ( select 'Friktion' as defi, 'inflow' as status, sum(inner_instruction:instructions[0]:parsed:info:amount/1e9) as total_amount from solana.fact_events Where block_timestamp::date >='2022-03-01' and block_timestamp::date< '2022-04-17' and inner_instruction:instructions[0]:parsed:info:mint='4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2' and program_id = 'VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp' UNION select 'Friktion' as defi, 'outflow' as status, sum(inner_instruction:instructions[2]:parsed:info:amount/1e9) as total_amount from solana.fact_events Where block_timestamp::date >='2022-03-01' and block_timestamp::date< '2022-04-17' and inner_instruction:instructions[2]:parsed:info:authority='Hxtb6APfNtf9m8jJjh7uYp8fCTGr9aeHxBSfiPqCrV6G' and program_id = 'VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp' ), mango as ( select 'Mango' as defi, 'inflow' as status, sum(inner_instruction:instructions[0]:parsed:info:amount/1e9) as total_amount from solana.fact_events Where block_timestamp::date >='2022-03-01' and block_timestamp::date< '2022-04-17' and inner_instruction:instructions[0]:parsed:info:destination = 'AVn3JRGhifPCxjxZsU3tQuo4U4dTHizHzBDGW983tx47' and program_id = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' UNION select 'Mango' as defi, 'outflow' as status, sum(inner_instruction:instructions[0]:parsed:info:amount/1e9) as total_amount from solana.fact_events Where block_timestamp::date >='2022-03-01' and block_timestamp::date< '2022-04-17' and inner_instruction:instructions[0]:parsed:info:source = 'AVn3JRGhifPCxjxZsU3tQuo4U4dTHizHzBDGW983tx47' and program_id = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' ), saber as ( select 'Saber' as defi, 'inflow' as status, sum (inner_instruction:instructions[0]:parsed:info:amount/1e9) as total_amount from solana.fact_events where block_timestamp::date >= '2022-03-01' and block_timestamp::date< '2022-04-17' and inner_instruction:instructions[0]:parsed:info:destination='2hNHZg7XBhuhHVZ3JDEi4buq2fPQwuWBdQ9xkH7t1GQX' and program_id='SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ' UNION select 'Saber' as defi, 'outflow' as status, sum(inner_instruction:instructions[2]:parsed:info:amount/1e9) as total_amount from solana.fact_events where block_timestamp::date >= '2022-03-01' and block_timestamp::date< '2022-04-17' and inner_instruction:instructions[0]:parsed:info:source='2hNHZg7XBhuhHVZ3JDEi4buq2fPQwuWBdQ9xkH7t1GQX' and program_id='SSwpkEEcbUqx4vtoEByFjSkhKdCT862DNVb52nZg1UZ' ), raydium as ( select 'Raydium' as defi, 'inflow' as status, sum(swap_from_amount) as total_amount from solana.fact_swaps where block_timestamp::date >= '2022-03-01' and block_timestamp::date< '2022-04-17' and succeeded = 'TRUE' and swap_from_mint = 'So11111111111111111111111111111111111111112' and lower(swap_program) LIKE lower('%raydium%') UNION select 'Raydium' as defi, 'outflow' as status, sum(swap_to_amount) as total_amount from solana.fact_swaps where block_timestamp::date >= '2022-03-01' and block_timestamp::date< '2022-04-17' and succeeded='TRUE' and swap_to_mint='So11111111111111111111111111111111111111112' and lower(swap_program) LIKE lower('%raydium%') ) select * from orca UNION select * from friktion UNION select * from mango UNION select * from saber UNION select * from raydium

Cross Usage in Solana Defi