machdragon

Sample Dataset: 65000 daily Morningstar funds price data

Sep 23rd, 2021
1,060
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE [MyDB]
  2. GO
  3. /****** Object:  Table [Stage].[Funds_Morningstar]    Script Date: 16/09/2021 08:45:19 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. CREATE TABLE [Stage].[Funds_Morningstar](
  9.     [SecId] [varchar](20) NULL,
  10.     [Name] [varchar](250) NULL,
  11.     [PriceCurrency] [varchar](20) NULL,
  12.     [TenforeId] [varchar](100) NULL,
  13.     [LegalName] [varchar](250) NULL,
  14.     [ClosePrice] [varchar](100) NULL,
  15.     [StarRatingM255] [int] NULL,
  16.     [QuantitativeRating] [int] NULL,
  17.     [CategoryName] [varchar](100) NULL,
  18.     [Yield_M12] [varchar](100) NULL,
  19.     [GBRReturnD1] [decimal](10, 2) NULL,
  20.     [GBRReturnW1] [decimal](10, 2) NULL,
  21.     [GBRReturnM1] [decimal](10, 2) NULL,
  22.     [GBRReturnM3] [decimal](10, 2) NULL,
  23.     [GBRReturnM6] [decimal](10, 2) NULL,
  24.     [GBRReturnM0] [decimal](10, 2) NULL,
  25.     [GBRReturnM12] [decimal](10, 2) NULL,
  26.     [GBRReturnM36] [decimal](10, 2) NULL,
  27.     [MaxFrontEndLoad] [decimal](10, 2) NULL,
  28.     [OngoingCostActual] [decimal](10, 2) NULL,
  29.     [PerformanceFeeActual] [decimal](10, 2) NULL,
  30.     [TransactionFeeActual] [decimal](10, 2) NULL,
  31.     [MaximumExitCostAcquired] [decimal](10, 2) NULL,
  32.     [FeeLevel] [varchar](20) NULL,
  33.     [ManagerTenure] [decimal](10, 2) NULL,
  34.     [MaxDeferredLoad] [decimal](10, 2) NULL,
  35.     [FundTNAV] [varchar](50) NULL,
  36.     [MorningstarRiskM255] [decimal](10, 2) NULL,
  37.     [AlphaM36] [decimal](10, 2) NULL,
  38.     [BetaM36] [decimal](10, 2) NULL,
  39.     [R2M36] [decimal](10, 2) NULL,
  40.     [StandardDeviationM36] [decimal](10, 2) NULL,
  41.     [SharpeM36] [decimal](10, 2) NULL,
  42.     [InvestorTypeRetail] [int] NULL,
  43.     [InvestorTypeProfessional] [int] NULL,
  44.     [InvestorTypeEligibleCounterparty] [int] NULL,
  45.     [ExpertiseBasic] [int] NULL,
  46.     [ExpertiseAdvanced] [int] NULL,
  47.     [ExpertiseInformed] [int] NULL,
  48.     [ReturnProfilePreservation] [int] NULL,
  49.     [ReturnProfileGrowth] [int] NULL,
  50.     [ReturnProfileIncome] [int] NULL,
  51.     [ReturnProfileHedging] [int] NULL,
  52.     [ReturnProfileOther] [int] NULL,
  53.     [TrackRecordExtension] [varchar](20) NULL,
  54.     [GBRReturnM60] [decimal](10, 2) NULL,
  55.     [GBRReturnM120] [decimal](10, 2) NULL
  56. ) ON [PRIMARY]
  57. GO
  58. INSERT [Stage].[Funds_Morningstar] ([SecId], [Name], [PriceCurrency], [TenforeId], [LegalName], [ClosePrice], [StarRatingM255], [QuantitativeRating], [CategoryName], [Yield_M12], [GBRReturnD1], [GBRReturnW1], [GBRReturnM1], [GBRReturnM3], [GBRReturnM6], [GBRReturnM0], [GBRReturnM12], [GBRReturnM36], [MaxFrontEndLoad], [OngoingCostActual], [PerformanceFeeActual], [TransactionFeeActual], [MaximumExitCostAcquired], [FeeLevel], [ManagerTenure], [MaxDeferredLoad], [FundTNAV], [MorningstarRiskM255], [AlphaM36], [BetaM36], [R2M36], [StandardDeviationM36], [SharpeM36], [InvestorTypeRetail], [InvestorTypeProfessional], [InvestorTypeEligibleCounterparty], [ExpertiseBasic], [ExpertiseAdvanced], [ExpertiseInformed], [ReturnProfilePreservation], [ReturnProfileGrowth], [ReturnProfileIncome], [ReturnProfileHedging], [ReturnProfileOther], [TrackRecordExtension], [GBRReturnM60], [GBRReturnM120]) VALUES (N'0P00000AWF', N'BGF European Value A2 USD', N'USD', N'52.8.LU0171281750USD', N'BlackRock Global Funds - European Value Fund A2 USD', N'95.07', 4, NULL, N'Europe Large-Cap Value Equity', N'0.00', CAST(-1.38 AS Decimal(10, 2)), CAST(-1.57 AS Decimal(10, 2)), CAST(-0.34 AS Decimal(10, 2)), CAST(-0.68 AS Decimal(10, 2)), CAST(10.16 AS Decimal(10, 2)), CAST(11.39 AS Decimal(10, 2)), CAST(31.66 AS Decimal(10, 2)), CAST(9.10 AS Decimal(10, 2)), CAST(5.26 AS Decimal(10, 2)), CAST(1.82 AS Decimal(10, 2)), NULL, CAST(0.29 AS Decimal(10, 2)), NULL, N'aboveAvg', CAST(10.83 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), N'822764886', CAST(3.00 AS Decimal(10, 2)), CAST(3.95 AS Decimal(10, 2)), CAST(0.96 AS Decimal(10, 2)), CAST(92.61 AS Decimal(10, 2)), CAST(18.86 AS Decimal(10, 2)), CAST(0.38 AS Decimal(10, 2)), 1, 1, 1, 1, 1, 1, 3, 1, 1, NULL, NULL, NULL, CAST(6.53 AS Decimal(10, 2)), CAST(8.30 AS Decimal(10, 2)))
  59. INSERT [Stage].[Funds_Morningstar] ([SecId], [Name], [PriceCurrency], [TenforeId], [LegalName], [ClosePrice], [StarRatingM255], [QuantitativeRating], [CategoryName], [Yield_M12], [GBRReturnD1], [GBRReturnW1], [GBRReturnM1], [GBRReturnM3], [GBRReturnM6], [GBRReturnM0], [GBRReturnM12], [GBRReturnM36], [MaxFrontEndLoad], [OngoingCostActual], [PerformanceFeeActual], [TransactionFeeActual], [MaximumExitCostAcquired], [FeeLevel], [ManagerTenure], [MaxDeferredLoad], [FundTNAV], [MorningstarRiskM255], [AlphaM36], [BetaM36], [R2M36], [StandardDeviationM36], [SharpeM36], [InvestorTypeRetail], [InvestorTypeProfessional], [InvestorTypeEligibleCounterparty], [ExpertiseBasic], [ExpertiseAdvanced], [ExpertiseInformed], [ReturnProfilePreservation], [ReturnProfileGrowth], [ReturnProfileIncome], [ReturnProfileHedging], [ReturnProfileOther], [TrackRecordExtension], [GBRReturnM60], [GBRReturnM120]) VALUES (N'0P00000B02', N'BGF Japan Small & MidCap Opps A2 USD', N'USD', N'52.8.LU0006061252USD', N'BlackRock Global Funds - Japan Small & MidCap Opportunities Fund A2 USD', N'87.07', 3, NULL, N'Japan Small/Mid-Cap Equity', N'0.00', CAST(0.97 AS Decimal(10, 2)), CAST(4.39 AS Decimal(10, 2)), CAST(6.95 AS Decimal(10, 2)), CAST(5.28 AS Decimal(10, 2)), CAST(10.96 AS Decimal(10, 2)), CAST(11.40 AS Decimal(10, 2)), CAST(28.95 AS Decimal(10, 2)), CAST(7.60 AS Decimal(10, 2)), CAST(5.26 AS Decimal(10, 2)), CAST(1.83 AS Decimal(10, 2)), NULL, CAST(1.26 AS Decimal(10, 2)), NULL, N'avg', CAST(7.33 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), N'164654313', CAST(3.00 AS Decimal(10, 2)), CAST(-0.47 AS Decimal(10, 2)), CAST(1.08 AS Decimal(10, 2)), CAST(94.20 AS Decimal(10, 2)), CAST(17.26 AS Decimal(10, 2)), CAST(0.20 AS Decimal(10, 2)), 1, 1, 1, 1, 1, 1, 3, 1, 1, NULL, NULL, NULL, CAST(10.03 AS Decimal(10, 2)), CAST(8.97 AS Decimal(10, 2)))
  60. INSERT [Stage].[Funds_Morningstar] ([SecId], [Name], [PriceCurrency], [TenforeId], [LegalName], [ClosePrice], [StarRatingM255], [QuantitativeRating], [CategoryName], [Yield_M12], [GBRReturnD1], [GBRReturnW1], [GBRReturnM1], [GBRReturnM3], [GBRReturnM6], [GBRReturnM0], [GBRReturnM12], [GBRReturnM36], [MaxFrontEndLoad], [OngoingCostActual], [PerformanceFeeActual], [TransactionFeeActual], [MaximumExitCostAcquired], [FeeLevel], [ManagerTenure], [MaxDeferredLoad], [FundTNAV], [MorningstarRiskM255], [AlphaM36], [BetaM36], [R2M36], [StandardDeviationM36], [SharpeM36], [InvestorTypeRetail], [InvestorTypeProfessional], [InvestorTypeEligibleCounterparty], [ExpertiseBasic], [ExpertiseAdvanced], [ExpertiseInformed], [ReturnProfilePreservation], [ReturnProfileGrowth], [ReturnProfileIncome], [ReturnProfileHedging], [ReturnProfileOther], [TrackRecordExtension], [GBRReturnM60], [GBRReturnM120]) VALUES (N'0P00000BOW', N'MS INVF Global Bond I EUR', N'EUR', N'52.8.LU0011983433EUR', N'Morgan Stanley Investment Funds - Global Bond Fund I EUR', N'44.77', 5, NULL, N'Global Bond', N'0.00', CAST(0.20 AS Decimal(10, 2)), CAST(-0.04 AS Decimal(10, 2)), CAST(-0.42 AS Decimal(10, 2)), CAST(2.75 AS Decimal(10, 2)), CAST(2.17 AS Decimal(10, 2)), CAST(1.18 AS Decimal(10, 2)), CAST(1.34 AS Decimal(10, 2)), CAST(4.72 AS Decimal(10, 2)), CAST(3.00 AS Decimal(10, 2)), CAST(0.64 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), CAST(0.54 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), N'belowAvg', CAST(26.42 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), N'1183842420', CAST(3.00 AS Decimal(10, 2)), CAST(0.27 AS Decimal(10, 2)), CAST(1.16 AS Decimal(10, 2)), CAST(91.79 AS Decimal(10, 2)), CAST(7.15 AS Decimal(10, 2)), CAST(0.44 AS Decimal(10, 2)), 1, 1, 1, 1, 1, 1, 3, 1, 1, NULL, NULL, NULL, CAST(2.12 AS Decimal(10, 2)), CAST(4.26 AS Decimal(10, 2)))
RAW Paste Data