NSE Future And Options Dataset 3M
Future and Options Data from NSE Website for past 3 Months
@kaggle.sunnysai12345_nse_future_and_options_dataset_3m
N 3mfanddo
@kaggle.sunnysai12345_nse_future_and_options_dataset_3m.n_3mfanddo
- 33.46 MB
- 2533210 rows
- 16 columns
unnamed_0Unnamed: 0 | instrumentINSTRUMENT | symbolSYMBOL | expiry_dtEXPIRY DT | strike_prSTRIKE PR | option_typOPTION TYP | openOPEN | highHIGH | lowLOW | closeCLOSE | settle_prSETTLE PR | contractsCONTRACTS | val_inlakhVAL INLAKH | open_intOPEN INT | chg_in_oiCHG IN OI | timestampTIMESTAMP |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 160393 | FUTIDX | BANKNIFTY | Thu Aug 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 28805.65 | 28924 | 28140.55 | 28499.3 | 28499.3 | 214569 | 1225914.96 | 1675780 | 234640 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 160394 | FUTIDX | BANKNIFTY | Thu Sep 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 28926.4 | 29030.55 | 28251.7 | 28611.45 | 28611.45 | 2484 | 14245.95 | 51400 | -80 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 160395 | FUTIDX | BANKNIFTY | Thu Oct 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 29000 | 29105 | 28355.55 | 28699.05 | 28699.05 | 598 | 3434.43 | 9460 | 4860 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 160396 | FUTIDX | NIFTY | Thu Aug 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 11098.4 | 11098.4 | 10901.1 | 11015.35 | 11015.35 | 199881 | 1650955.24 | 19001400 | 1339200 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 160397 | FUTIDX | NIFTY | Thu Sep 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 11136.35 | 11145.2 | 10955 | 11066.6 | 11066.6 | 5283 | 43841.57 | 893625 | 66750 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 160398 | FUTIDX | NIFTY | Thu Oct 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 11175 | 11185.95 | 10991.45 | 11101.6 | 11101.6 | 1530 | 12746.44 | 115725 | 47775 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 160399 | FUTIDX | NIFTYIT | Thu Aug 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 15670 | 15670 | 15350 | 15423 | 15423 | 159 | 1230.09 | 13850 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | ||
| 160400 | FUTIDX | NIFTYIT | Thu Sep 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 15539 | 15545 | 15539 | 15542 | 15542 | 2 | 15.54 | 100 | 100 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| 160401 | FUTIDX | NIFTYIT | Thu Oct 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 15754 | 15585 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||||||
| 160402 | FUTSTK | ACC | Thu Aug 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | XX | 1547.1 | 1555.4 | 1506.4 | 1522.65 | 1522.65 | 3536 | 21691.65 | 2292000 | 63200 | Thu Aug 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time) |
CREATE TABLE n_3mfanddo (
"unnamed_0" BIGINT,
"instrument" VARCHAR,
"symbol" VARCHAR,
"expiry_dt" TIMESTAMP,
"strike_pr" DOUBLE,
"option_typ" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"settle_pr" DOUBLE,
"contracts" DOUBLE,
"val_inlakh" DOUBLE,
"open_int" DOUBLE,
"chg_in_oi" DOUBLE,
"timestamp" TIMESTAMP
);