| Left file | fo14JUN2022bhav.csv |
|---|---|
| Right file | fo14JUN2022bhav.csv.modified |
| Key columns | INSTRUMENT, SYMBOL, EXPIRY_DT, STRIKE_PR, OPTION_TYP |
| Common non-key columns | OPEN, HIGH, LOW, CLOSE, SETTLE_PR, CONTRACTS, VAL_INLAKH, TIMESTAMP, |
| Columns only in left file (ignored) | OPEN_INT, CHG_IN_OI |
| Matched | Diffs | Only in left | Only in right |
|---|---|---|---|
| 64061 rows (93.32% cells) | 6 rows (0.00% cells) | 5 rows + 2 columns (6.67% cells) | 1 rows (0.00% cells) |
| INSTRUMENT | SYMBOL | EXPIRY_DT | STRIKE_PR | OPTION_TYP | OPEN | HIGH | LOW | CLOSE | SETTLE_PR | CONTRACTS | VAL_INLAKH | TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FUTIDX | MIDCPNIFTY | 30-Aug-2022 | 0 | XX | 0 | 0 | 0 | 6924.75 | 6479.75 | 0 | 0 | 14-JUN-2022 | |
| FUTIDX | MIDCPNIFTY | 08-Aug-2022 | 0 | XX | 0 | 0 | 0 | 6722.95 | 6459.75 | 0 | 0 | 14-JUN-2022 | |
| FUTSTK | HDFCAMC | 28-Jul-2022 | 0 | XX | 1818.1 | 1835 | 1808.15 | 1828.4 | 1828.4 | 720 | 3933.17 | 14-JUN-2022 | |
| OPTSTK | ZYDUSLIFE | 25-Aug-2022 | 390 | PE | 0 | 0 | 0 | 33.7 | 44.3 | 0 | 0 | 14-JUN-2022 | |
| OPTSTK | ZYDUSLIFE | 25-Aug-2022 | 385 | PE | 0 | 0 | 0 | 30.8 | 40.6 | 0 | 0 | 14-JUN-2022 |
| INSTRUMENT | SYMBOL | EXPIRY_DT | STRIKE_PR | OPTION_TYP | OPEN | HIGH | LOW | CLOSE | SETTLE_PR | CONTRACTS | VAL_INLAKH | TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FUTIDX | BANKNIFTY | 30-Jun-2022 | 0 | XX | 33390 | 33701.05 | 33185.15 | 33377.05 | 33377.05 | 163523 | 1365831.21 | 14-JUN-2022 |
| INSTRUMENT | SYMBOL | EXPIRY_DT | STRIKE_PR | OPTION_TYP | OPEN | HIGH | LOW | CLOSE | SETTLE_PR | CONTRACTS | VAL_INLAKH | TIMESTAMP | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FUTSTK | HDFC | 25-Aug-2022 | 0 | XX | 2130 | 2153.65 | 2116.85 | 2125.55 | 2125.55 | 2126.55 | 47 | 300.63 | 14-JUN-2022 | |||||||||
| OPTIDX | BANKNIFTY | 16-Jun-2022 | 34100 | CE | 87.6 | 8.6 | 147.5 | 147 | 47.6 | 63.65 | 63.65 | 579152 | 4949261.46 | 494261.46 | 14-JUN-2022 | |||||||
| OPTIDX | BANKNIFTY | 16-Jun-2022 | 34300 | CE | 78.65 | 99.85 | 9.85 | 31.35 | 40.95 | 40.95 | 715197 | 6142670.81 | 14-JUN-2022 | |||||||||
| OPTSTK | ZEEL | 25-Aug-2022 | 295 | CE | 0 | 0 | 0 | 13.95 | 8.5 | 8 | 0 | 0 | 14-JUN-2022 | |||||||||
| OPTSTK | ZYDUSLIFE | 25-Aug-2022 | 430 | PE | 0 | 0 | 0 | 61.55 | 6.55 | 77.3 | 77 | 0 | 0 | 14-JUN-2022 | ||||||||
| OPTSTK | ZYDUSLIFE | 25-Aug-2022 | 435 | PE | 0 | 0 | 0 | 65.45 | 81.8 | 81 | 0 | 0 | 14-JUN-2022 | |||||||||