EquitiesIndiaNse

Equities India NSE

sources: https://nseindia.com/

class plutoPy.model.EquitiesIndiaNse.CorporateActions(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockViz

Query the corporate actions for listed stocks

EX_DATE
PURPOSE
SERIES
SYMBOL
WHEN_UPDATED
class plutoPy.model.EquitiesIndiaNse.CorporateEvents(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockViz

Query the corporate events for listed stocks

AUTO_ID
DISC_DATE

when was the event disclosed?

EVENT_DATE

when was the event held?

PURPOSE
SYMBOL
class plutoPy.model.EquitiesIndiaNse.CorporateResults(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockViz

Query to CorporateResults for a specific period and stock

AUTO_ID
H1

section 1

H2

section 2

H3

section 3

H4

section 4

KEY
REF_ID

lookup CorporateResultsMeta to get this value

VALUE
class plutoPy.model.EquitiesIndiaNse.CorporateResultsMeta(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockViz

Query to obtain the REF_ID to lookup CorporateResults for a specific period

BROADCAST_DATE
IS_AUDITED
IS_CONSOLIDATED
IS_CUMULATIVE
PERIOD
PERIOD_BEGIN
PERIOD_END
REF_ID

use this to query CorporateResults

SYMBOL
class plutoPy.model.EquitiesIndiaNse.DailyReturns(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockViz

Query the percentage daily return (close-to-close) time-series for listed stocks

SYMBOL
TIME_STAMP
VALUE
class plutoPy.model.EquitiesIndiaNse.EodAdjustedTimeSeries(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockVizDyn

Query end-of-day price and volume time-series adjusted for splits, bonus and dividends for listed stocks

CLOSE
HIGH
LOW
OPEN
SYMBOL
TIME_STAMP
VOLUME
class plutoPy.model.EquitiesIndiaNse.EodTimeSeries(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockViz

Query unadjusted end-of-day price and volume time-series for listed stocks

CLOSE

usually a weighted average of price x volume of the last 15-minutes of trading

HIGH
LAST

last traded price

LOW
OPEN
SERIES
SYMBOL
TIME_STAMP
VOLUME
class plutoPy.model.EquitiesIndiaNse.MarketCapDecile(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockViz

Query market-cap decile of of listed equity tickers

DECILE
SYMBOL
TIME_STAMP
class plutoPy.model.EquitiesIndiaNse.MiscInfo(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockViz

Query miscellaneous information of listed equity tickers

D2T_PCT

delivery percentage. % of shares which were not squared off the same day out of total shares traded

FF_MKT_CAP_CR

free-float market-cap in crores

LOWER_PX_BAND

trading is halted if the stock trades below this level

SYMBOL
TIME_STAMP
UPPER_PX_BAND

trading is halted if the stock trades above this level

class plutoPy.model.EquitiesIndiaNse.Tickers(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, plutoPy.model.Db.StockViz

Query meta data of listed equity tickers

DATE_LISTING

date of birth of the ticker

FACE

a stock’s face value is the initial cost of the stock, as indicated on the certificate

ISIN

unique identifier

MARKET_LOT

usually, you can trade just 1 stock. but sometimes, only in multiples of “market lot”

NAME

name of the security. for eg: Infosys Limited

PAID_UP

paid-up capital is the amount of money a company has received from shareholders in exchange for shares of stock

SERIES

EQ/BE/BZ as assigned by the NSE

SYMBOL

ticker/stock symbol. for eg: INFY