rural-jade copy copy copy

Pine Analyticsrural-jade copy copy copy

Updated 2025-04-12

with tab1 as (

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 'CLMMjQ8usCDmeP2hZFc6Mhih7JFbjg6mHeRxeEtTWHNf'

and block_timestamp > '2024-03-10'

and ARRAY_SIZE(instruction['accounts']) in (16, 17)

and SUCCEEDED

union all

select

tx_id,

block_timestamp,

Last run: 14 days ago

248B

flipside