binhachonFractionalized Dragons - Largest deposit and withdrawal
    Updated 2022-03-12
    with provide_liquidity_transaction as (
    select
    block_timestamp,
    tx_id,
    inner_instruction:instructions[0]:parsed:info:amount::float/100 as DRGNZ_amount,
    inner_instruction:instructions[1]:parsed:info:amount::float/1e9 as SOL_amount
    from solana.events
    where block_timestamp > '2022-02-25 00:00:00.000'
    and succeeded = 'TRUE'
    and inner_instruction:instructions[2]:parsed:info:mint::string = 'H8BWkkGKpSpZVhuvuCAHBwWGWVrkAq9Dw3EH3okjy8dg'
    and inner_instruction:instructions[2]:parsed:type::string = 'mintTo'
    ),
    remove_liquidity_transaction as (
    select
    block_timestamp,
    tx_id,
    inner_instruction:instructions[2]:parsed:info:amount::float/100 as DRGNZ_amount,
    inner_instruction:instructions[3]:parsed:info:amount::float/1e9 as SOL_amount
    from solana.events
    where block_timestamp > '2022-02-25 00:00:00.000'
    and succeeded = 'TRUE'
    and inner_instruction:instructions[4]:parsed:info:mint::string = 'H8BWkkGKpSpZVhuvuCAHBwWGWVrkAq9Dw3EH3okjy8dg'
    and inner_instruction:instructions[4]:parsed:type::string = 'burn'
    )
    select
    'Largest deposit' as name,
    provide_liquidity_transaction.*
    from provide_liquidity_transaction
    qualify row_number() over (order by SOL_amount desc) = 1
    union all
    select
    'Largest withdraw' as name,
    remove_liquidity_transaction.*
    from remove_liquidity_transaction
    qualify row_number() over (order by SOL_amount desc) = 1

    Run a query to Download Data