Sample Dataset: 65000 daily Morningstar funds price data

USE [MyDB]
GO
/****** Object:  Table [Stage].[Funds_Morningstar]    Script Date: 16/09/2021 08:45:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Stage].[Funds_Morningstar](
    [SecId] [varchar](20) NULL,
    [Name] [varchar](250) NULL,
    [PriceCurrency] [varchar](20) NULL,
    [TenforeId] [varchar](100) NULL,
    [LegalName] [varchar](250) NULL,
    [ClosePrice] [varchar](100) NULL,
    [StarRatingM255] [int] NULL,
    [QuantitativeRating] [int] NULL,
    [CategoryName] [varchar](100) NULL,
    [Yield_M12] [varchar](100) NULL,
    [GBRReturnD1] [decimal](10, 2) NULL,
    [GBRReturnW1] [decimal](10, 2) NULL,
    [GBRReturnM1] [decimal](10, 2) NULL,
    [GBRReturnM3] [decimal](10, 2) NULL,
    [GBRReturnM6] [decimal](10, 2) NULL,
    [GBRReturnM0] [decimal](10, 2) NULL,
    [GBRReturnM12] [decimal](10, 2) NULL,
    [GBRReturnM36] [decimal](10, 2) NULL,
    [MaxFrontEndLoad] [decimal](10, 2) NULL,
    [OngoingCostActual] [decimal](10, 2) NULL,
    [PerformanceFeeActual] [decimal](10, 2) NULL,
    [TransactionFeeActual] [decimal](10, 2) NULL,
    [MaximumExitCostAcquired] [decimal](10, 2) NULL,
    [FeeLevel] [varchar](20) NULL,
    [ManagerTenure] [decimal](10, 2) NULL,
    [MaxDeferredLoad] [decimal](10, 2) NULL,
    [FundTNAV] [varchar](50) NULL,
    [MorningstarRiskM255] [decimal](10, 2) NULL,
    [AlphaM36] [decimal](10, 2) NULL,
    [BetaM36] [decimal](10, 2) NULL,
    [R2M36] [decimal](10, 2) NULL,
    [StandardDeviationM36] [decimal](10, 2) NULL,
    [SharpeM36] [decimal](10, 2) NULL,
    [InvestorTypeRetail] [int] NULL,
    [InvestorTypeProfessional] [int] NULL,
    [InvestorTypeEligibleCounterparty] [int] NULL,
    [ExpertiseBasic] [int] NULL,
    [ExpertiseAdvanced] [int] NULL,
    [ExpertiseInformed] [int] NULL,
    [ReturnProfilePreservation] [int] NULL,
    [ReturnProfileGrowth] [int] NULL,
    [ReturnProfileIncome] [int] NULL,
    [ReturnProfileHedging] [int] NULL,
    [ReturnProfileOther] [int] NULL,
    [TrackRecordExtension] [varchar](20) NULL,
    [GBRReturnM60] [decimal](10, 2) NULL,
    [GBRReturnM120] [decimal](10, 2) NULL
) ON [PRIMARY]
GO
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)))
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)))
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)))