jangob2023-12-27 12:03 PM
    SELECT
    evt_block_time,
    subaccount,
    SUBSTRING(CAST(subaccount AS VARCHAR), 1, 42) AS main_address,
    CASE WHEN amount > 0 THEN 'Long' ELSE 'Short' END AS trade_type,
    CASE WHEN amount > 0 THEN amount/1e18 ELSE -amount/1e18 END AS trade_amount,
    isTaker,
    priceX18/1e18 AS trade_price,
    feeAmount/1e18 AS fees,
    evt_block_number,
    contract_address,
    evt_index
    FROM vertex_arbitrum.OffchainBook_evt_FillOrder
    WHERE SUBSTRING(CAST(subaccount AS VARCHAR), 1, 42) = '0xb10f8d996c79d5e9aea89fa05ef829945c631de3'
    AND SUBSTRING(CAST(contract_address AS VARCHAR), 1, 42) = '0xf03f457a30e598d5020164a339727ef40f2b8fbc'
    /*
    BTC adress: 0xf03f457a30e598d5020164a339727ef40f2b8fbc
    ETH address: 0xfe653438a1a4a7f56e727509c341d60a7b54fa91 */

    Run a query to Download Data