jangob2023-12-27 12:03 PM
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
⌄
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