binhachonFractionalized Dragons - Sample transactions
Updated 2022-03-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with swap as (
select
tx_id,
array_size(inner_instruction:instructions) as len,
inner_instruction:instructions[len-1]:parsed:info:source::string as source2,
inner_instruction:instructions[len-1]:parsed:info:amount::float as amount2,
inner_instruction:instructions[len-2]:parsed:info:amount::float as amount1,
inner_instruction:instructions[len-2]:parsed:info:authority::string as authority,
case when source2 = 'EmEoA96UhGGEVi3HqpHmt78aKw2QFZqF8NCA4RrffKQY' then amount1/100 else -amount2/100 end as DRGNZ_amount,
case when source2 = 'EmEoA96UhGGEVi3HqpHmt78aKw2QFZqF8NCA4RrffKQY' then -amount2/1e9 else amount1/1e9 end as SOL_amount,
inner_instruction
from solana.events
where block_timestamp > '2022-02-27 00:00:00.000'
and tx_id in ('4T15XvTpizYRvxQpdKqixvDMvf1hDH9w1Mers92vYHLdDziuemhke9QWmm9qFeGUpJtUDYtf94khjYchYdQf3itj', '3jFHa4qpa9t9zCNnNceTLcwsQSyEDs8jnDfs8ShqrPoML6WJFuu6abfsHWViAxwh7nAnzAREehcpojHbLvZVXY7W', 'kf8RWZ8yR349YFHdKLgg2WtWuggpmHqpMEsLeeosgW5Kn2Qcu7sJUyHRX8TddbAZnGqZsS78pmACcFTPPLd9k5o')
and inner_instruction is not null
and len > 2
and coalesce(inner_instruction:instructions[len-1]:parsed:info:authority, '')::string = '5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1' -- LP address
and substr(coalesce(inner_instruction:instructions[len-3]:data, '')::string, 1, 7) = '121AS7P' -- I guess this is the swap functiona
)
select
*
from swap
Run a query to Download Data