greyswanMarginNew
    Updated 2024-04-24
    with liquidations as (
    select
    a.block_timestamp,
    TX_ID,
    decoded_args as arg_liq,
    a.SIGNERS [0] as liquidator1,
    a.DECODED_ARGS:assetAmount as amount_liq
    from
    solana.core.ez_events_decoded a
    where
    a.PROGRAM_ID = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'
    and a.succeeded = 'true'
    and a.BLOCK_TIMESTAMP >= current_date - 30
    and a.event_type = 'lendingAccountLiquidate'
    ),
    withdraws as (
    select
    TX_ID,
    a.SIGNERS [0] as liquidator2,
    decoded_args as arg_withdraw,
    a.DECODED_ARGS:amount as amount_withdraw,
    DECODED_ACCOUNTS [5] :pubkey as vault_from
    from
    solana.core.ez_events_decoded a
    where
    a.PROGRAM_ID = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'
    and a.succeeded = 'true'
    and a.BLOCK_TIMESTAMP >= current_date - 30
    and a.event_type = 'lendingAccountWithdraw'
    ),
    merged as (
    select
    block_timestamp,
    amount_liq,
    amount_withdraw,
    a.tx_id,
    QueryRunArchived: QueryRun has been archived