15 records deleted from our previous date position file
| assetKey | bodValUSD | bodWeights | fcost | fcostUSD | bcost | bcostUSD | preOptWeights | postOptWeights | optTradeWeights | longBoundHard | shortBoundHard | trade_qty | preOptQty | target_contracts | cvret | vcret | fxretd | preTradePnLHoldUSD | preTradeValUSD | preTradePnLFxUSD | preTradeWeights | tradeBoundLo | tradeBoundHi | execWeights | postExecWeights | tradeValUSD | tradeWeights | linearCostUSD | impactCostUSD | tcostUSD | postTradeValUSD | postTradeWeights | postTradePnLHoldUSD | eodValUSD | postTradePnLFxUSD | pnlHoldUSD | pnlFxUSD | totalPnLUSD | eodWeights | ric | position | modifiedRic | _merge | priceCloseUSD | numGQRShares |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| @AIAGR1 | 22629.6 | 1.4e-03 | 3.7e-03 | 2.3e-01 | 0.0 | -0.0 | 1.4e-03 | 0.0 | -1.4e-03 | 1.0 | 1.0e-06 | -3200 | 3200 | 0 | 2.0e-03 | -7.5e-03 | 4.9e-04 | 46.1 | 22681.2 | 5.6 | 1.4e-03 | -2.2 | 2.2 | -1.4e-03 | -1.0e-06 | -22611.9 | -1.4e-03 | 28.9 | 1.9e+00 | 30.8 | 6.9e+01 | 4.3e-06 | -5.2e-01 | 6.9e+01 | 1.7e-02 | 45.6 | 5.6 | 20.1 | 4.3e-06 | 1299.HK | NaN | NaN | left_only | 7.0 | 9.7e+00 |
| @KEYEN4 | 46277.0 | 2.9e-03 | 3.0e-03 | 3.8e-01 | 0.0 | -0.0 | 2.9e-03 | 0.0 | -2.9e-03 | 1.0 | 1.0e-06 | -100 | 100 | 0 | 2.3e-03 | 2.4e-04 | 7.0e-03 | 108.1 | 46547.1 | 161.9 | 2.9e-03 | -5.3 | 5.3 | -2.9e-03 | -6.7e-07 | -46547.1 | -2.9e-03 | 5.8 | 6.3e+00 | 12.1 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 108.1 | 161.9 | 257.6 | 0.0e+00 | 6861.T | NaN | NaN | left_only | 469.0 | 0.0e+00 |
| @EBARA3 | 24055.2 | 1.5e-03 | 3.0e-03 | 2.0e-01 | 0.0 | -0.0 | 1.5e-03 | 0.0 | -1.5e-03 | 1.0 | 1.0e-06 | -1800 | 1800 | 0 | 2.9e-02 | 1.2e-02 | 7.0e-03 | 689.9 | 24831.5 | 86.4 | 1.5e-03 | -1.4 | 1.4 | -1.5e-03 | 3.9e-05 | -24831.5 | -1.5e-03 | 3.1 | 1.1e+01 | 13.7 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 689.9 | 86.4 | 762.4 | 0.0e+00 | 6361.T | NaN | NaN | left_only | 14.1 | 0.0e+00 |
| @DAIFU1 | 28322.6 | 1.8e-03 | 3.0e-03 | 2.3e-01 | 0.0 | -0.0 | 1.8e-03 | 0.0 | -1.8e-03 | 1.0 | 1.0e-06 | -1500 | 1500 | 0 | -1.4e-02 | 1.2e-04 | 7.0e-03 | -408.9 | 28011.1 | 97.5 | 1.7e-03 | -0.4 | 0.4 | -1.7e-03 | -1.0e-06 | -27551.7 | -1.7e-03 | 3.4 | 1.0e+01 | 13.7 | 4.6e+02 | 2.9e-05 | 5.4e-02 | 4.6e+02 | 1.6e+00 | -408.9 | 99.1 | -323.8 | 2.9e-05 | 6383.T | NaN | NaN | left_only | 18.8 | 2.4e+01 |
| @PETRO164 | 32485.2 | 2.0e-03 | 7.7e-03 | 6.9e-01 | 0.0 | -0.0 | 2.0e-03 | 0.0 | -2.0e-03 | 1.0 | 1.0e-06 | -29500 | 29500 | 0 | 1.2e-02 | -4.7e-03 | 3.4e-03 | 402.3 | 32943.0 | 55.5 | 2.0e-03 | -2.3 | 2.3 | -2.0e-03 | 1.6e-05 | -32943.0 | -2.0e-03 | 44.8 | 4.2e+00 | 49.0 | 0.0e+00 | 0.0e+00 | -0.0e+00 | 0.0e+00 | 0.0e+00 | 402.3 | 55.5 | 408.2 | 0.0e+00 | 601857.SH | NaN | NaN | left_only | 1.1 | 0.0e+00 |
| @FASTR4 | 62545.7 | 3.9e-03 | 3.0e-03 | 5.1e-01 | 0.0 | -0.0 | 3.9e-03 | 0.0 | -3.9e-03 | 1.0 | 1.0e-06 | -200 | 200 | 0 | -1.3e-03 | -1.3e-02 | 7.0e-03 | -79.9 | 62683.9 | 218.1 | 3.9e-03 | -10.6 | 10.6 | -3.9e-03 | -1.0e-06 | -62459.5 | -3.9e-03 | 7.8 | 6.4e+00 | 14.2 | 2.2e+02 | 1.4e-05 | -2.8e+00 | 2.2e+02 | 7.7e-01 | -82.7 | 218.9 | 121.4 | 1.4e-05 | 9983.T | NaN | NaN | left_only | 311.7 | 7.1e-01 |
| @NITTO9 | 16163.2 | 1.0e-03 | 3.0e-03 | 1.3e-01 | 0.0 | -0.0 | 1.0e-03 | 0.0 | -1.0e-03 | 1.0 | 1.0e-06 | -200 | 200 | 0 | 9.8e-03 | 1.2e-02 | 7.0e-03 | 158.4 | 16378.7 | 57.0 | 1.0e-03 | -1.9 | 1.9 | -1.0e-03 | 7.3e-06 | -16378.7 | -1.0e-03 | 2.0 | 3.5e+00 | 5.6 | -1.8e-12 | -1.1e-19 | -2.1e-14 | -1.8e-12 | -6.4e-15 | 158.4 | 57.0 | 209.7 | -1.1e-19 | 6988.T | NaN | NaN | left_only | 83.5 | -2.2e-14 |
| @CHUGA4 | 19196.4 | 1.2e-03 | 3.0e-03 | 1.6e-01 | 0.0 | -0.0 | 1.2e-03 | 0.0 | -1.2e-03 | 1.0 | 1.0e-06 | -400 | 400 | 0 | -1.4e-02 | -2.0e-03 | 7.0e-03 | -277.7 | 18984.8 | 66.1 | 1.2e-03 | -2.9 | 2.9 | -1.2e-03 | -1.0e-06 | -18678.0 | -1.2e-03 | 2.3 | 2.8e+00 | 5.1 | 3.1e+02 | 1.9e-05 | -6.0e-01 | 3.1e+02 | 1.1e+00 | -278.3 | 67.1 | -216.5 | 1.9e-05 | 4519.T | NaN | NaN | left_only | 47.7 | 6.4e+00 |
| @FUJIE6 | 11139.4 | 7.0e-04 | 3.0e-03 | 9.2e-02 | 0.0 | -0.0 | 7.0e-04 | 0.0 | -7.0e-04 | 1.0 | 1.0e-06 | -200 | 200 | 0 | -6.6e-03 | 8.5e-03 | 7.0e-03 | -73.4 | 11104.6 | 38.6 | 6.9e-04 | -0.7 | 0.7 | -6.9e-04 | -1.0e-06 | -11019.2 | -6.8e-04 | 1.4 | 2.5e+00 | 3.8 | 8.5e+01 | 5.3e-06 | 7.3e-01 | 8.6e+01 | 3.0e-01 | -72.6 | 38.9 | -37.6 | 5.4e-06 | 6504.T | NaN | NaN | left_only | 56.4 | 1.5e+00 |
| @COCHL2 | 2328.9 | 1.5e-04 | 3.5e-03 | 2.2e-02 | 0.0 | -0.0 | 1.5e-04 | 0.0 | -1.5e-04 | 1.0 | 1.0e-06 | -12 | 12 | 0 | 2.6e-03 | -2.5e-03 | -2.8e-03 | 6.1 | 2331.7 | -3.3 | 1.4e-04 | -0.6 | 0.6 | -1.5e-04 | -7.0e-07 | -2331.7 | -1.4e-04 | 0.5 | 1.4e-01 | 0.7 | 0.0e+00 | 0.0e+00 | -0.0e+00 | 0.0e+00 | 0.0e+00 | 6.1 | -3.3 | 2.1 | 0.0e+00 | COH.AX | NaN | NaN | left_only | 194.9 | 0.0e+00 |
| @HONDA9 | 1049.1 | 6.6e-05 | 3.0e-03 | 8.6e-03 | 0.0 | -0.0 | 6.6e-05 | 0.0 | -6.6e-05 | 1.0 | 1.0e-06 | -100 | 100 | 0 | -7.2e-03 | -7.2e-03 | 7.0e-03 | -7.6 | 1045.1 | 3.6 | 6.5e-05 | -2.8 | 2.8 | -6.6e-05 | -6.4e-07 | -1045.1 | -6.5e-05 | 0.1 | 2.6e-02 | 0.2 | 0.0e+00 | 0.0e+00 | -0.0e+00 | 0.0e+00 | 0.0e+00 | -7.6 | 3.6 | -4.1 | 0.0e+00 | 7267.T | NaN | NaN | left_only | 10.5 | 0.0e+00 |
| @KAWAS14 | 4096.7 | 2.6e-04 | 3.0e-03 | 3.4e-02 | 0.0 | -0.0 | 2.6e-04 | 0.0 | -2.6e-04 | 1.0 | 1.0e-06 | -300 | 300 | 0 | 1.0e-02 | 2.0e-03 | 7.0e-03 | 42.5 | 4153.6 | 14.5 | 2.6e-04 | -1.9 | 1.9 | -2.6e-04 | 2.0e-06 | -4153.6 | -2.6e-04 | 0.5 | 2.6e-01 | 0.8 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 42.5 | 14.5 | 56.1 | 0.0e+00 | 9107.T | NaN | NaN | left_only | 14.0 | 0.0e+00 |
| @TDKCO10 | 12819.6 | 8.0e-04 | 3.0e-03 | 1.1e-01 | 0.0 | -0.0 | 8.0e-04 | 0.0 | -8.0e-04 | 1.0 | 1.0e-06 | -200 | 200 | 0 | -1.0e-02 | -6.9e-03 | 7.0e-03 | -131.5 | 12732.4 | 44.3 | 7.9e-04 | -3.0 | 3.0 | -7.9e-04 | -1.0e-06 | -12585.3 | -7.8e-04 | 1.6 | 1.7e+00 | 3.3 | 1.5e+02 | 9.1e-06 | -1.0e+00 | 1.5e+02 | 5.1e-01 | -132.6 | 44.8 | -91.1 | 9.1e-06 | 6762.T | NaN | NaN | left_only | 63.7 | 2.3e+00 |
| @ANTAS1 | 0.0 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0 | 0.0 | 0.0e+00 | 0.0 | 0.0e+00 | 1.0 | 1.0e-06 | 0 | 0 | 0 | 1.1e-02 | 3.9e-03 | 4.9e-04 | 0.0 | 0.0 | 0.0 | 0.0e+00 | -0.6 | 0.6 | 0.0e+00 | 0.0e+00 | 0.0 | 0.0e+00 | 0.0 | 0.0e+00 | 0.0 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0 | 0.0 | 0.0 | 0.0e+00 | 2020.HK | NaN | NaN | left_only | 9.0 | 0.0e+00 |
| @LARGA1 | 0.0 | 0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0 | 0.0 | 0.0e+00 | 0.0 | 0.0e+00 | 1.0 | 1.0e-06 | 0 | 0 | 0 | 1.8e-03 | -1.8e-03 | 3.9e-03 | 0.0 | 0.0 | 0.0 | 0.0e+00 | -0.7 | 0.7 | 0.0e+00 | 0.0e+00 | 0.0 | 0.0e+00 | 0.0 | 0.0e+00 | 0.0 | 0.0e+00 | 0.0e+00 | -0.0e+00 | 0.0e+00 | 0.0e+00 | 0.0 | 0.0 | 0.0 | 0.0e+00 | 3008.TW | NaN | NaN | left_only | 84.7 | 0.0e+00 |