Table "equity" (Equity)

    SELECT

[Date],

[Internal code],

[SecurityId],

[CompanyId],

[Symbol],

[ISIN],

[Name],

[BestBidPrice],

[BestAskPrice],

[Open],

[High],

[Low],

[Close],

[NumberOfTrades],

[Volume],

[Turnover],

[VolumeWeightedAveragePrice],

[Price],

[AdjustedPrice],

[Dividends],

[LDividends],

[CorpAdj],

[DividendAdj],

[Currency],

[NumberOfShares],

[NumberSharesOSEBX],

[Exchange],

[NOKPerForex],

[mktcap],

[OSEBXmktshare_prevmnth],

[OSEBXAlpha_prevmnth],

[OSEBXBeta_prevmnth],

[SMB],

[HML],

[LIQ],

[MOM],

[lnDeltaP],

[lnDeltaOSEBX],

[lnDeltaOBX],

[NOWA_DayLnrate],

[bills_3month_Lnrate],

[Sector],

[IN_OSEBX],

[Equity],

[Debt],

[Earnings],

[debt_ratio],

[PE],

[ID]

    FROM [OSE].[dbo].[equity]

    Table "AllISINS" (All ISINs)

    SELECT

[Name],

[Internal code],

[SecurityId],

[ISIN]

    FROM [OSE].[dbo].[AllISINS]

    Table "factors" (Equity factors)

    SELECT

[Date],

[HML_H_B],

[HML_H_S],

[HML_L_B],

[HML_L_S],

[HML_N_B],

[HML_N_S],

[LIQ_H_B],

[LIQ_H_S],

[LIQ_L_B],

[LIQ_L_S],

[LIQ_N_B],

[LIQ_N_S],

[MOM_H_B],

[MOM_H_S],

[MOM_L_B],

[MOM_L_S],

[MOM_N_B],

[MOM_N_S],

[size_N_B],

[size_N_S],

[TOT_N_M],

[SMB],

[HML],

[LIQ],

[MOM],

[ID]

    FROM [OSE].[dbo].[factors]

    Table "account" (Accounting)

    SELECT

[Name],

[ISIN],

[companyID],

[OrganizationID],

[Year],

[description],

[desc_simpl_en],

[desc_simpl_no],

[account_number],

[account_type],

[Value],

[CorporateAccountValue],

[CompanyAccountValue],

[source],

[Corporation],

[ID]

    FROM [OSE].[dbo].[account]

    Table "equityindex_linked" (equityindex_linked)

    SELECT

[Date],

[OSEBXLinked],

[OBXLinked],

[OSEFXLinked],

[ID]

    FROM [OSE].[dbo].[equityindex_linked]

    Table "equityindex" (Stocks indicies)

    SELECT

[Date],

[SecurityId],

[Internal code],

[ISIN code],

[Symbol],

[Name],

[Open],

[High],

[Low],

[Last],

[ID]

    FROM [OSE].[dbo].[equityindex]

    Table "bondindex" (Bonds Index)

    SELECT

[Date],

[SecurityId],

[Symbol],

[Name],

[IndexType],

[Open],

[High],

[Low],

[Close],

[OpenYield],

[CloseYield],

[OpenDuration],

[CloseDuration]

    FROM [OSE].[dbo].[bondindex]

    Table "WarrantsInfo" (Warrants info)

    SELECT

[FromDate],

[ToDate],

[SecurityId],

[Symbol],

[CompanyId],

[CurrencyCode],

[SubscriptionPrice],

[WarrantType],

[UnderlyingSecurity],

[TermsShares],

[WarrantsIssued],

[TermsWarrants],

[SecurityType],

[ISIN],

[SecurityName],

[Currency],

[Exchange],

[EquityClassId],

[Description]

    FROM [OSE].[dbo].[WarrantsInfo]

    Table "Warrants" (Warrants)

    SELECT

[Date],

[SecurityId],

[CompanyId],

[Symbol],

[ISIN],

[Name],

[BestBidPrice],

[BestAskPrice],

[Open],

[High],

[Low],

[Close],

[OfficialNumberOfTrades],

[OfficialVolume],

[UnofficialNumberOfTrades],

[UnofficialVolume],

[VolumeWeightedAveragePrice],

[Price],

[Currency],

[Description],

[CountryCode],

[NOKPerForex],

[PriceNOK]

    FROM [OSE].[dbo].[Warrants]

    Table "BondInfo" (Bonds Info)

    SELECT

[Type],

[SecurityId],

[SecurityType],

[Symbol],

[ISIN],

[SecurityName],

[EqName],

[EqSecurityID],

[eqISIN],

[CompanyId],

[Issuer],

[FromDate],

[ToDate],

[IssueDate],

[MaturityDate],

[ActualMaturityDate],

[CouponDate],

[OpeningDate],

[ClosingDate],

[ExpirationDate],

[AnnouncementDate],

[InterestRegulationDate],

[CurrencyCode],

[CountryCode],

[SectorId],

[Exchange],

[ListingType],

[BondIssueType],

[BondType],

[AmortizationType],

[DownPaymentMethod],

[BondDescription],

[InterestAsOf],

[FirstCouponPayment],

[FirstDownPayment],

[CouponRate],

[CouponInformation],

[CouponSpread],

[FirstCouponRate],

[SecondCouponRate],

[RiskCategory],

[BondSector],

[CSD],

[MaxAmount],

[DenominationAmount],

[CashFlowDate],

[CashFlowTypeId],

[Price],

[NominalAmountVPS],

[NominalAmountTotal],

[OptionType],

[TimeType],

[ExCount]

    FROM [OSE].[dbo].[BondInfo]

    Table "FutureForwards" (Futures and forwards)

    SELECT

[ID],

[Date],

[SecurityId],

[IssuerName],

[Symbol],

[ISIN],

[ContractSymbol],

[Description],

[ExDate],

[IssuerSecurityId],

[IssuerSymbol],

[BestBidPrice],

[BestAskPrice],

[Open],

[High],

[Low],

[LastTradedPrice],

[NumberOfTrades],

[Volume],

[VolumeWeightedAveragePrice]

    FROM [OSE].[dbo].[FutureForwards]

    Table "bonds" (Bonds)

    SELECT

[Date],

[FromDate],

[MaturityDate],

[SecurityId],

[CompanyId],

[Name],

[Issuer],

[Equity_SecurityID],

[Equity_Symbol],

[ISINSubCode],

[BondType],

[Symbol],

[ISIN],

[CouponRate],

[OpenPrice],

[High],

[Low],

[LastTradedPrice],

[OfficialVolume],

[UnofficialVolume],

[BestBidPrice],

[BestAskPrice]

    FROM [OSE].[dbo].[bonds]

    Table "options" (Options)

    SELECT

[Date],

[SecurityID],

[Symbol],

[ISIN],

[Name],

[ExpirationDate],

[UnderlyingSID],

[UnderlyingISIN],

[UnderlyingName],

[UnderlyingSymbol],

[BestBidPrice],

[BestAskPrice],

[Last],

[Open],

[High],

[Low],

[Volum],

[OpenInterest],

[Strike],

[IsCall]

    FROM [OSE].[dbo].[options]

    Table "SecuritiesInfo" (Stocks info)

    SELECT

[EventDate],

[ToDate],

[FromDate],

[CompanyId],

[ISIN],

[Name],

[Symbol],

[SecurityId],

[SecurityName],

[SecurityType],

[EquityClassId],

[EventId],

[DividendId],

[AdjustmentFactor],

[DividendInForeignCurrency],

[DividendInNOK],

[NumberOfDividendsPerYear],

[TypeOfDividend],

[SequenceNumber],

[Price],

[SubscriptionPrice],

[Description],

[CountryCode],

[Currency],

[CurrencyCode],

[Exchange],

[Type],

[NewShares],

[OldShares],

[NumberOfShares],

[CompanyOwnedShares],

[TotalCompanyOwnedShares],

[TotalNumberOfShares],

[NominalValue]

    FROM [OSE].[dbo].[SecuritiesInfo]

    Table "newsweb" (News bulletins)

    SELECT

[publishTime],

[NewsWebName],

[EquityName],

[EquitySecurityID],

[CompanyId],

[EquitySymbol],

[EquityISIN],

[issuerStatus],

[title],

[category],

[market],

[text]

    FROM [OSE].[dbo].[newsweb]

    Table "mutualfund" (Mutual funds)

    SELECT

[Date],

[Name],

[Symbol],

[SecurityId],

[ISIN],

[NAV],

[FundId],

[Adjusted Price],

[Dividends],

[CorpAdj],

[DividendAdj],

[lnDeltaNAV],

[lnDeltaOSEBX],

[lnDeltaOBX],

[lnDeltaOSEFX],

[SMB],

[HML],

[LIQ],

[MOM],

[ID]

    FROM [OSE].[dbo].[mutualfund]