FlorentGaptos swaps
    Updated 2024-05-08
    SELECT
    e.BLOCK_TIMESTAMP,
    e.EVENT_DATA[amount_in] as amount_in,
    e.EVENT_DATA[amount_out] as amount_out,
    e.EVENT_DATA[token_in] as token_in,
    e.EVENT_DATA[token_out] as token_out
    FROM aptos.core.fact_events e JOIN (
    SELECT TX_HASH
    FROM aptos.core.fact_transactions
    WHERE sender = '0xa42bb9fb49996d28605685ee93a5bd5de5b2399a466686d93727607fad610360' --trading wallet address
    ) t ON e.tx_hash = t.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>'
    EVENT_TYPE = '0x163df34fccbf003ce219d3f1d9e70d140b60622cb9dd47599c25fb2f797ba6e::liquidity_pool::SwapEvent <0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt, 0x1::aptos_coin::AptosCoin, 0x163df34fccbf003ce219d3f1d9e70d140b60622cb9dd47599c25fb2f797ba6e::curves::Stable>'
    OR
    QueryRunArchived: QueryRun has been archived