FlorentGAmnis arb
    Updated 2024-06-11
    WITH hash as (
    SELECT tx_hash
    FROM aptos.core.fact_transactions
    WHERE BLOCK_TIMESTAMP > current_date() - INTERVAL '7 DAYS'
    AND SENDER = '0xff6cddaed038bb97db75ca0ffcf80297321ac670927b5df63e9a3c2c999c1a29'
    -- AND PAYLOAD["multisig_address"] = '0xa42bb9fb49996d28605685ee93a5bd5de5b2399a466686d93727607fad610360'
    )

    SELECT e.*
    -- sum(EVENT_DATA['amount_out'] - EVENT_DATA['amount_in']) as apt_profit
    FROM aptos.core.fact_events e
    JOIN hash h ON e.tx_hash = h.tx_hash
    WHERE EVENT_TYPE = '0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::stable_pool::SwapEvent<0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt, 0x1::aptos_coin::AptosCoin, 0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::base_pool::Null, 0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::base_pool::Null>'
    AND EVENT_DATA['idx_in'] = 1
    AND BLOCK_TIMESTAMP > current_date() - INTERVAL '7 DAYS'
    LIMIT 10




    SELECT *
    -- sum(EVENT_DATA['amount_out'] - EVENT_DATA['amount_in']) as apt_profit
    FROM aptos.core.fact_events
    WHERE EVENT_TYPE = '0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::stable_pool::SwapEvent<0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt, 0x1::aptos_coin::AptosCoin, 0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::base_pool::Null, 0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af::base_pool::Null>'
    AND EVENT_DATA['idx_in'] = 1
    AND BLOCK_TIMESTAMP > current_date() - INTERVAL '7 DAYS'
    LIMIT 10

    QueryRunArchived: QueryRun has been archived