Banknifty And Its Components

2019-2024(with daily updates) BankNifty: Decoding India's Banking Evolution 🔑

@kaggle.saswattulo_banknifty_and_its_components

Table List

1 table(190.45 KB)

Banknifty

@kaggle.saswattulo_banknifty_and_its_components.banknifty

190.45 KB
1482 rows
14 columns

date Date	bnf Bnf	axis_bank Axis Bank	bandhan_bank Bandhan Bank	au_bank Au Bank	sbi_bank Sbi Bank	bob_bank Bob Bank	idfc_bank Idfc Bank	federal_bank Federal Bank	kotak_bank Kotak Bank	hdfc_bank Hdfc Bank	icici_bank Icici Bank	pnb_bank Pnb Bank	indusind_bank Indusind Bank
Wed Jan 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	27296.682169751475	619.5279930433406	540.3521419398114	306.0039818243652	281.5261960680548	113.2578428546708	43.20000076293945	88.45584230607284	1243.4709164807575	1019.8981830384116	347.7482671481625	75.94950757138567	1525.0900812097707
Thu Jan 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	27181.2845390018	617.9368821727583	538.3978718190798	308.59132885555886	277.6670936960917	111.3320143763392	42.650001525878906	90.4489559859212	1235.5989860035925	1011.0451096293305	351.1151610319974	74.56513133728154	1511.065075582111
Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	26999.38508477019	608.5891705345581	522.030958924692	308.9893547286912	274.93748226461406	110.41494064440144	43.09999847412109	88.50330005506362	1233.60587275655	1006.7852363853076	348.0849865521699	74.46965800231492	1499.3455622288668
Mon Jan 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	27378.3331257057	622.5112004703954	527.6494632202666	310.9796293982004	283.3615966434706	112.34078208695222	46	90.40149860747418	1246.5099512452998	1012.7109238879556	353.5200292659996	78.71823426533865	1499.5376332241071
Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	27301.58249535359	632.4554765946266	470.9759892128787	304.5609996801792	278.42005646254466	112.70760786573422	46.34999847412109	90.02186420428251	1238.588261085636	1009.9980497772898	353.8086093468544	76.90424538476483	1501.602932091816
Wed Jan 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	27650.92853828813	648.7142812209598	469.0217775826071	310.48205633094767	288.0207599507001	113.80808523162078	46.150001525878906	90.68622682803736	1232.9582725647433	1008.09420623908	367.1317419184675	78.28861877700896	1517.789484401826
Thu Jan 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	27713.2283161553	665.1721862375601	441.6621317326516	314.8606425404869	287.17365576524463	112.34077895100364	46	92.25223166267642	1234.602351981682	1007.618152223098	366.45839026131534	76.66554872755964	1544.5429774726176
Fri Jan 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	27602.48069520467	661.2938821253165	458.0779101151935	325.8320247311049	287.4560227745961	113.53297568116184	46.70000076293945	91.44550070389782	1220.6520582799942	1006.095016172554	366.1217229400403	77.57255208776273	1508.1831210151313
Mon Jan 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	27388.88117579989	659.3049325423577	443.2255471930152	325.309558516306	283.31456928917714	110.91931915283205	47	89.59476131722072	1212.6804626855208	1004.2388463659556	364.29397930812576	76.71328542506407	1449.585009646026
Tue Jan 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	27317.23338853654	657.6143847761671	433.99164987385626	326.1057312951443	284.2557718084344	111.2403024833052	47.150001525878906	85.98820330663251	1212.6803373542896	1001.930496125907	359.33986816175985	79.10014198883985	1432.2936639366303


CREATE TABLE banknifty (
  "date" TIMESTAMP,
  "bnf" DOUBLE,
  "axis_bank" DOUBLE,
  "bandhan_bank" DOUBLE,
  "au_bank" DOUBLE,
  "sbi_bank" DOUBLE,
  "bob_bank" DOUBLE,
  "idfc_bank" DOUBLE,
  "federal_bank" DOUBLE,
  "kotak_bank" DOUBLE,
  "hdfc_bank" DOUBLE,
  "icici_bank" DOUBLE,
  "pnb_bank" DOUBLE,
  "indusind_bank" DOUBLE
);