select

tx_id,

block_timestamp,

signers[0] as trader,

inner_instruction,

inner_instruction['instructions'][0]['parsed']['info']['mint'] as token_address_1,

case

when token_address_1 like 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL' then 'SOL'

when token_address_1 like 'So11111111111111111111111111111111111111112' then 'ETH'

when token_address_1 like 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' then 'USDC'

when token_address_1 like 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn' then 'tETH'

when token_address_1 like 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm' then 'USDT'

end as token_symbol_1,

inner_instruction['instructions'][0]['parsed']['info']['tokenAmount']['uiAmount'] as token_amount_1,

inner_instruction['instructions'][1]['parsed']['info']['mint'] as token_address_2,

case

when token_address_2 like 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL' then 'SOL'

when token_address_2 like 'So11111111111111111111111111111111111111112' then 'ETH'

when token_address_2 like 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' then 'USDC'

when token_address_2 like 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn' then 'tETH'

when token_address_2 like 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm' then 'USDT'

end as token_symbol_2,

inner_instruction['instructions'][1]['parsed']['info']['tokenAmount']['uiAmount'] as token_amount_2

from eclipse.core.fact_events

where program_id like 'CPMMQoayoCZGUq4wQRxrPBNrrExU6PLg1eEAXC83KDzv'

and block_timestamp > '2024-03-10'

and ARRAY_SIZE(instruction['accounts']) = 13

and SUCCEEDED

), tab2 as (

select

date(hour) as date,

median(case when token_address like 'So11111111111111111111111111111111111111112' then price end) as SOL_price,

median(case when token_address like '7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs' then price end) as ETH_price