Baselight
Sign In

Market-Data

A package of market data crawled using apis and bs4

@kaggle.bishop36_market_data

Sme
@kaggle.bishop36_market_data.sme

  • 70.23 KB
  • 211 rows
  • 28 columns
symbol

Symbol

assets

Assets

open

Open

high

High

low

Low

ltp

LtP

chn

Chn

per

Per

qty

Qty

trdval

TrdVal

nav

Nav

wkhi

Wkhi

wklo

Wklo

xdt

XDt

cact

CAct

ypc

YPC

mpc

MPC

prevclose

PrevClose

nearwkh

NearWKH

nearwkl

NearWKL

charttodaypath

ChartTodayPath

perchange365d

PerChange365d

date365dago

Date365dAgo

chart365dpath

Chart365dPath

date30dago

Date30dAgo

perchange30d

PerChange30d

chart30dpath

Chart30dPath

meta

Meta

ITNIFTY IT Index41.4842.5240.9142.420.942.2745571419181002.2641.587844.3131--Infinity2.56286266924565341.484.265402843601897-36.83870967741936https://nsearchives.nseindia.com/today/ITEQN.svg---15-Jul-20242.49https://nsearchives.nseindia.com/30d/IT-EQ.svg{'symbol': 'IT', 'companyName': 'Kotak Nifty IT ETF', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': True, 'isDelisted': False, 'isin':…
FINIETFICICI Prudential Nifty Financial Services Ex-Bank ETF24.825.224.6225.20.491.981078202667466.824.684526.216.5--Infinity-1.600937133932058424.713.816793893129771-52.72727272727272https://nsearchives.nseindia.com/today/FINIETFEQN.svg---15-Jul-2024-3.36https://nsearchives.nseindia.com/30d/FINIETF-EQ.svg{'symbol': 'FINIETF', 'companyName': 'ICICI Prudential Mutual Fund - ICICI Pru Nifty Fin Ser Ex-Bank ETF', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries…
AXISTECETFNIFTY IT Index415.5423.12415.31423.127.721.86118324994760.48414.965438.2314.06--31.2895618716644041.986116467412266415.43.44135098128708-34.72584856396867https://nsearchives.nseindia.com/today/AXISTECETFEQN.svg30.7414-Aug-2023https://nsearchives.nseindia.com/365d/AXISTECETF-EQ.svg15-Jul-20241.85https://nsearchives.nseindia.com/30d/AXISTECETF-EQ.svg{'symbol': 'AXISTECETF', 'companyName': 'AXIS MUTUAL FUND - AXIS NIFTY IT ETF', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': True, 'i…
ITBEESNifty IT TRI41.9842.641.7942.50.751.84568697192981761.2841.830644.2531.79--29.770992366412212.138908916125932741.753.9548022598870056-33.68983957219251https://nsearchives.nseindia.com/today/ITBEESEQN.svg30.4514-Aug-2023https://nsearchives.nseindia.com/365d/ITBEES-EQ.svg15-Jul-20242.04https://nsearchives.nseindia.com/30d/ITBEES-EQ.svg{'symbol': 'ITBEES', 'companyName': 'Nippon India Mutual Fund - Nippon India ETF Nifty IT', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSe…
GSEC10IETFICICI Prudential Nifty 10 yr Benchmark G-Sec ETF234.01239.94233.54239.944.241.89622555.2235.6224249.7216.2--Infinity2.9829606420876384235.73.908690428514213-10.980573543015732https://nsearchives.nseindia.com/today/GSEC10IETFEQN.svg---15-Jul-20242.98https://nsearchives.nseindia.com/30d/GSEC10IETF-EQ.svg{'symbol': 'GSEC10IETF', 'companyName': 'ICICI Pru Mutual Fund-ICICI Prudential Nifty 10 yr Benchmark G-Sec ETF', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspende…
MON100Nasdaq100152.8155.48152.79154.952.611.71908642140766818.64155.7863175112.8517-JUN-21 FACE VALUE SPLIT (SUB-DIVISION) - FROM RS 10/- PER SHARE TO RE 1/- PER SHARE27.983811018419093-8.275617119516971152.3411.457142857142864-37.30615861763402https://nsearchives.nseindia.com/today/MON100EQN.svg27.9114-Aug-2023https://nsearchives.nseindia.com/365d/MON100-EQ.svg15-Jul-2024-8.34https://nsearchives.nseindia.com/30d/MON100-EQ.svg{'symbol': 'MON100', 'companyName': 'Motilal Oswal Mutual Fund - Motilal Oswal NASDAQ 100 ETF', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isE…
ITETFADDDSP Nifty IT ETF39.8740.539.8740.50.631.5814643589234.3239.80342.929--Infinity2.479757085020234639.875.594405594405592-39.6551724137931https://nsearchives.nseindia.com/today/ITETFADDEQN.svg---15-Jul-20242.25https://nsearchives.nseindia.com/30d/ITETFADD-EQ.svg{'symbol': 'ITETFADD', 'companyName': 'DSP Mutual Fund - DSP Nifty IT ETF', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': True, 'isDel…
ITIETFNifty IT Index41.8342.5741.8342.480.641.5384202235600690.1641.774246.9728.201-SEP-22FACE VALUE SPLIT (SUB-DIVISION) - FROM RS 10/- PER UNIT TO RE 1/- PER UNITInfinity2.189078662496984741.849.559293165850548-50.63829787234042https://nsearchives.nseindia.com/today/ITIETFEQN.svg---15-Jul-20242.29https://nsearchives.nseindia.com/30d/ITIETF-EQ.svg{'symbol': 'ITIETF', 'companyName': 'ICICI PRUDENTIAL MUTUAL FUND - ICICI Prudential Nifty IT ETF', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], …
ITETFMirae Asset Nifty IT ETF40.6140.6139.8740.410.611.531259895079876.4839.792245.530.4--Infinity2.122820318423038539.811.186813186813197-32.92763157894736https://nsearchives.nseindia.com/today/ITETFEQN.svg---15-Jul-20242.17https://nsearchives.nseindia.com/30d/ITETF-EQ.svg{'symbol': 'ITETF', 'companyName': 'Mirae Asset Mutual Fund - Mirae Asset Nifty IT ETF', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': True, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec':…
SBISILVERSBI SILVER ETF80.4481.680.4481.61.161.44200921633881.4480.715793.2879.07--Infinity-11.20783460282917280.4412.521440823327625-3.199696471480968https://nsearchives.nseindia.com/today/SBISILVEREQN.svg------{'symbol': 'SBISILVER', 'companyName': 'SBI Mutual Fund - SBI SILVER ETF', 'industry': 'Mutual Fund Scheme', 'activeSeries': ['EQ'], 'debtSeries': [], 'isFNOSec': False, 'isCASec': False, 'isSLBSec': False, 'isDebtSec': False, 'isSuspended': False, 'tempSuspendedSeries': [], 'isETFSec': True, 'isDel…

CREATE TABLE sme (
  "symbol" VARCHAR,
  "assets" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "ltp" DOUBLE,
  "chn" DOUBLE,
  "per" DOUBLE,
  "qty" BIGINT,
  "trdval" DOUBLE,
  "nav" DOUBLE,
  "wkhi" DOUBLE,
  "wklo" DOUBLE,
  "xdt" VARCHAR,
  "cact" VARCHAR,
  "ypc" DOUBLE,
  "mpc" DOUBLE,
  "prevclose" DOUBLE,
  "nearwkh" DOUBLE,
  "nearwkl" DOUBLE,
  "charttodaypath" VARCHAR,
  "perchange365d" VARCHAR,
  "date365dago" VARCHAR,
  "chart365dpath" VARCHAR,
  "date30dago" VARCHAR,
  "perchange30d" VARCHAR,
  "chart30dpath" VARCHAR,
  "meta" VARCHAR
);

Share link

Anyone who has the link will be able to view this.