Market-Data

A package of market data crawled using apis and bs4

@kaggle.bishop36_market_data

Table List

4 tables(208.28 KB)

Etf

Nifty50 Stocks

Sgb

Sme

Nifty50 Stocks

@kaggle.bishop36_market_data.nifty50_stocks

35 KB
49 rows
27 columns

symbol Symbol	identifier Identifier	open Open	dayhigh DayHigh	daylow DayLow	lastprice LastPrice	previousclose PreviousClose	change Change	pchange PChange	ffmc Ffmc	yearhigh YearHigh	yearlow YearLow	totaltradedvolume TotalTradedVolume	totaltradedvalue TotalTradedValue	lastupdatetime LastUpdateTime	nearwkh NearWKH	nearwkl NearWKL	perchange365d PerChange365d	date365dago Date365dAgo	chart365dpath Chart365dPath	date30dago Date30dAgo	perchange30d PerChange30d	chart30dpath Chart30dPath	charttodaypath ChartTodayPath	series Series	meta Meta
HCLTECH	HCLTECHEQN	1600.1	1629.75	1598.25	1623.9	1592.65	31.25	1.96	1718621092263.82	1697.35	1139.3	3932148	6348413624.52	Wed Aug 14 2024 15:59:24 GMT+0000 (Coordinated Universal Time)	4.327333785017811	-42.53488984464146	38.87	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/HCLTECH-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3.6	https://nsearchives.nseindia.com/30d/HCLTECH-EQ.svg	https://nsearchives.nseindia.com/today/HCLTECHEQN.svg	EQ	{'symbol': 'HCLTECH', 'companyName': 'HCL Technologies Limited', 'industry': 'Computers - Software & Consulting', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': False, 'i…
TECHM	TECHMEQN	1512	1529.45	1505	1525.45	1503.4	22.05	1.47	969880556566.74	1569	1098.15	2833790	4309316115.1	Wed Aug 14 2024 15:55:46 GMT+0000 (Coordinated Universal Time)	2.77565328234544	-38.91089559714064	24.98	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/TECHM-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1.69	https://nsearchives.nseindia.com/30d/TECHM-EQ.svg	https://nsearchives.nseindia.com/today/TECHMEQN.svg	EQ	{'symbol': 'TECHM', 'companyName': 'Tech Mahindra Limited', 'industry': 'Computers - Software & Consulting', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': False, 'isDeli…
INFY	INFYEQN	1802	1825	1797.45	1820	1797.45	22.55	1.25	6574458814996.8	1903	1351.65	7450718	13513441743.78	Wed Aug 14 2024 15:59:58 GMT+0000 (Coordinated Universal Time)	4.361534419337888	-34.650242296452475	30.83	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/INFY-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	6.81	https://nsearchives.nseindia.com/30d/INFY-EQ.svg	https://nsearchives.nseindia.com/today/INFYEQN.svg	EQ	{'symbol': 'INFY', 'companyName': 'Infosys Limited', 'industry': 'Computers - Software & Consulting', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': False, 'isDelisted': …
M&M	M&MEQN	2728.8	2771.95	2715.3	2749.45	2718.05	31.4	1.16	2666835868626.5	3013.5	1450	2609359	7179129416.700001	Wed Aug 14 2024 15:59:45 GMT+0000 (Coordinated Universal Time)	8.762236601957863	-89.61724137931033	77.47	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/M&M-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	0.52	https://nsearchives.nseindia.com/30d/M&M-EQ.svg	https://nsearchives.nseindia.com/today/M&MEQN.svg	EQ	{'symbol': 'M&M', 'companyName': 'Mahindra & Mahindra Limited', 'industry': 'Passenger Cars & Utility Vehicles', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': False, 'is…
WIPRO	WIPROEQN	493	496.85	490.45	495.7	490.5	5.2	1.06	700084769774.51	579.9	375.05	5560878	2742291376.92	Wed Aug 14 2024 15:59:31 GMT+0000 (Coordinated Universal Time)	14.519744783583374	-32.169044127449666	19.27	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/WIPRO-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-11.53	https://nsearchives.nseindia.com/30d/WIPRO-EQ.svg	https://nsearchives.nseindia.com/today/WIPROEQN.svg	EQ	{'symbol': 'WIPRO', 'companyName': 'Wipro Limited', 'industry': 'Computers - Software & Consulting', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': False, 'isDelisted': F…
BPCL	BPCLEQN	321.7	327.45	320.65	325.1	321.7	3.4	1.06	634701660366.96	359.05	165.73	8457477	2747580552.99	Wed Aug 14 2024 15:59:56 GMT+0000 (Coordinated Universal Time)	9.455507589472216	-96.16243287274486	-8.83	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/BPCL-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	5.62	https://nsearchives.nseindia.com/30d/BPCL-EQ.svg	https://nsearchives.nseindia.com/today/BPCLEQN.svg	EQ	{'symbol': 'BPCL', 'companyName': 'Bharat Petroleum Corporation Limited', 'industry': 'Refineries & Marketing', 'activeSeries': ['T0', 'EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': False…
BHARTIARTL	BHARTIARTLEQN	1453.1	1480.1	1453.1	1473.25	1459.7	13.55	0.93	3941980519132.3	1536.25	847.05	5891784	8657033902.56	Wed Aug 14 2024 15:58:01 GMT+0000 (Coordinated Universal Time)	4.100895036615134	-73.92715896346144	69.74	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/BHARTIARTL-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2.37	https://nsearchives.nseindia.com/30d/BHARTIARTL-EQ.svg	https://nsearchives.nseindia.com/today/BHARTIARTLEQN.svg	EQ	{'symbol': 'BHARTIARTL', 'companyName': 'Bharti Airtel Limited', 'industry': 'Telecom - Cellular & Fixed line services', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': ['IL'], 'isETFSec'…
TATAMOTORS	TATAMOTORSEQN	1057	1067.05	1047	1062.85	1053.45	9.4	0.89	1872815057736.94	1179	593.3	8211830	8698134572.6	Wed Aug 14 2024 15:59:57 GMT+0000 (Coordinated Universal Time)	9.851569126378294	-79.14208663408056	74.92	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/TATAMOTORS-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	3.7	https://nsearchives.nseindia.com/30d/TATAMOTORS-EQ.svg	https://nsearchives.nseindia.com/today/TATAMOTORSEQN.svg	EQ	{'symbol': 'TATAMOTORS', 'companyName': 'Tata Motors Limited', 'industry': 'Passenger Cars & Utility Vehicles', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': False, 'isD…
LTIM	LTIMEQN	5395	5439.95	5367	5432.05	5384.9	47.15	0.88	498736414074.41	6442	4513.55	241696	1307336080.96	Wed Aug 14 2024 15:56:18 GMT+0000 (Coordinated Universal Time)	15.677584601055573	-20.349835495341804	4.51	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/LTIM-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-0.92	https://nsearchives.nseindia.com/30d/LTIM-EQ.svg	https://nsearchives.nseindia.com/today/LTIMEQN.svg	EQ	{'symbol': 'LTIM', 'companyName': 'LTIMindtree Limited', 'industry': 'Computers - Software & Consulting', 'activeSeries': ['T0', 'EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': False, 'isD…
SBIN	SBINEQN	800.95	809.15	800.4	803.2	797.55	5.65	0.71	3082346944005.18	912	543.2	11788665	9477025680.15	Wed Aug 14 2024 15:59:58 GMT+0000 (Coordinated Universal Time)	11.929824561403503	-47.86450662739322	43.19	Mon Aug 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	https://nsearchives.nseindia.com/365d/SBIN-EQ.svg	Mon Jul 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	-8.89	https://nsearchives.nseindia.com/30d/SBIN-EQ.svg	https://nsearchives.nseindia.com/today/SBINEQN.svg	EQ	{'symbol': 'SBIN', 'companyName': 'State Bank of India', 'industry': 'Public Sector Bank', 'activeSeries': ['T0', 'EQ'], 'debtSeries': [], 'isFNOSec': True, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': ['N2', 'N6', 'N5', 'IL', 'N1', 'N3', 'N4']…


CREATE TABLE nifty50_stocks (
  "priority" BIGINT,
  "symbol" VARCHAR,
  "identifier" VARCHAR,
  "open" DOUBLE,
  "dayhigh" DOUBLE,
  "daylow" DOUBLE,
  "lastprice" DOUBLE,
  "previousclose" DOUBLE,
  "change" DOUBLE,
  "pchange" DOUBLE,
  "ffmc" DOUBLE,
  "yearhigh" DOUBLE,
  "yearlow" DOUBLE,
  "totaltradedvolume" BIGINT,
  "totaltradedvalue" DOUBLE,
  "lastupdatetime" TIMESTAMP,
  "nearwkh" DOUBLE,
  "nearwkl" DOUBLE,
  "perchange365d" DOUBLE,
  "date365dago" TIMESTAMP,
  "chart365dpath" VARCHAR,
  "date30dago" TIMESTAMP,
  "perchange30d" DOUBLE,
  "chart30dpath" VARCHAR,
  "charttodaypath" VARCHAR,
  "series" VARCHAR,
  "meta" VARCHAR
);