binhachonFractionalized Dragons - Sample transactions
    Updated 2022-03-12
    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