mlnsio/text2sql
0
1test_data = {2 1: {3 "quotes": {"expenseRatio": 0.023399999999999997, "lastTurnoverRatio": 0.1568},4 "holdings": {5 "equityHoldingPage": {6 "pageSize": 100,7 "totalPage": 1,8 "pageNumber": 1,9 "holdingList": [10 {11 "isin": "INE280A01028",12 "weighting": 9.3,13 },14 {15 "isin": "INE002A01018",16 "weighting": 7.1,17 },18 {"isin": "INE090A01021", "weighting": 2.4},19 {"isin": "INE040A01034", "weighting": 1.1},20 ],21 },22 },23 "list_info": {"isin": "MF123"},24 "risk_measures": {25 "cur": "INR",26 "fundName": "Testing fund 2",27 "indexName": "Morningstar India GR INR",28 "categoryName": "Large-Cap",29 "fundRiskVolatility": {30 "endDate": "2023-11-30T06:00:00.000",31 "for1Year": {32 "beta": 1.002,33 "alpha": 4.464,34 "rSquared": 98.8,35 "sharpeRatio": 0.877,36 "standardDeviation": 11.355,37 },38 "for3Year": {39 "beta": None,40 "alpha": None,41 "rSquared": None,42 "sharpeRatio": None,43 "standardDeviation": None,44 },45 "for5Year": {46 "beta": None,47 "alpha": None,48 "rSquared": None,49 "sharpeRatio": None,50 "standardDeviation": None,51 },52 "for10Year": {53 "beta": None,54 "alpha": None,55 "rSquared": None,56 "sharpeRatio": None,57 "standardDeviation": None,58 },59 "for15Year": {60 "beta": None,61 "alpha": None,62 "rSquared": None,63 "sharpeRatio": None,64 "standardDeviation": None,65 },66 "bestFitIndexName": None,67 "forLongestTenure": None,68 "bestFitBetaFor3Year": None,69 "primaryIndexNameNew": "S&P BSE 100 India TR INR",70 "bestFitAlphaFor3Year": None,71 "bestFitRSquaredFor3Year": None,72 },73 },74 },75 2: {76 "quotes": {"expenseRatio": 0.023399999999999997, "lastTurnoverRatio": 0.5158},77 "holdings": {78 "equityHoldingPage": {79 "pageSize": 100,80 "totalPage": 1,81 "pageNumber": 1,82 "holdingList": [83 {"isin": "INE040A01034", "weighting": 7.6},84 {"isin": "INE154A01025", "weighting": 1.1},85 {"isin": "INE018A01030", "weighting": 3.2},86 {"isin": "INE154A01025", "weighting": 3.1},87 ],88 },89 },90 "list_info": {"isin": "MF123"},91 "risk_measures": {92 "cur": "INR",93 "fundName": "Testing fund 2",94 "indexName": "Morningstar India GR INR",95 "categoryName": "Large-Cap",96 "fundRiskVolatility": {97 "endDate": "2023-11-30T06:00:00.000",98 "for1Year": {99 "beta": 0.994,100 "alpha": 0.337,101 "rSquared": 98.8,102 "sharpeRatio": 0.341,103 "standardDeviation": 11.355,104 },105 "for3Year": {106 "beta": None,107 "alpha": None,108 "rSquared": None,109 "sharpeRatio": None,110 "standardDeviation": None,111 },112 "for5Year": {113 "beta": None,114 "alpha": None,115 "rSquared": None,116 "sharpeRatio": None,117 "standardDeviation": None,118 },119 "for10Year": {120 "beta": None,121 "alpha": None,122 "rSquared": None,123 "sharpeRatio": None,124 "standardDeviation": None,125 },126 "for15Year": {127 "beta": None,128 "alpha": None,129 "rSquared": None,130 "sharpeRatio": None,131 "standardDeviation": None,132 },133 "bestFitIndexName": None,134 "forLongestTenure": None,135 "bestFitBetaFor3Year": None,136 "primaryIndexNameNew": "S&P BSE 100 India TR INR",137 "bestFitAlphaFor3Year": None,138 "bestFitRSquaredFor3Year": None,139 },140 },141 },142 3: {143 "quotes": {"expenseRatio": 0.0106, "lastTurnoverRatio": 0.3109},144 "holdings": {145 "equityHoldingPage": {146 "pageSize": 100,147 "totalPage": 1,148 "pageNumber": 1,149 "holdingList": [150 {"isin": "INE280A01028", "weighting": 11.2},151 {"isin": "INE090A01021", "weighting": 7.1},152 {"isin": "INE040A01034", "weighting": 2.4},153 ],154 },155 },156 "list_info": {"isin": "MF123"},157 "risk_measures": {158 "cur": "INR",159 "fundName": "Testing fund 2",160 "indexName": "Morningstar India GR INR",161 "categoryName": "Large-Cap",162 "fundRiskVolatility": {163 "endDate": "2023-11-30T06:00:00.000",164 "for1Year": {165 "beta": 0.954,166 "alpha": -0.645,167 "rSquared": 98.8,168 "sharpeRatio": 0.251,169 "standardDeviation": 11.355,170 },171 "for3Year": {172 "beta": None,173 "alpha": None,174 "rSquared": None,175 "sharpeRatio": None,176 "standardDeviation": None,177 },178 "for5Year": {179 "beta": None,180 "alpha": None,181 "rSquared": None,182 "sharpeRatio": None,183 "standardDeviation": None,184 },185 "for10Year": {186 "beta": None,187 "alpha": None,188 "rSquared": None,189 "sharpeRatio": None,190 "standardDeviation": None,191 },192 "for15Year": {193 "beta": None,194 "alpha": None,195 "rSquared": None,196 "sharpeRatio": None,197 "standardDeviation": None,198 },199 "bestFitIndexName": None,200 "forLongestTenure": None,201 "bestFitBetaFor3Year": None,202 "primaryIndexNameNew": "S&P BSE 100 India TR INR",203 "bestFitAlphaFor3Year": None,204 "bestFitRSquaredFor3Year": None,205 },206 },207 },208 4: {209 "quotes": {"expenseRatio": 0.0158, "lastTurnoverRatio": 0.5451},210 "holdings": {211 "equityHoldingPage": {212 "pageSize": 100,213 "totalPage": 1,214 "pageNumber": 1,215 "holdingList": [216 {"isin": "INE280A01028", "weighting": 10.2},217 {"isin": "INE002A01018", "weighting": 9.2},218 ],219 },220 },221 "list_info": {"isin": "MF123"},222 "risk_measures": {223 "cur": "INR",224 "fundName": "Testing fund 2",225 "indexName": "Morningstar India GR INR",226 "categoryName": "Large-Cap",227 "fundRiskVolatility": {228 "endDate": "2023-11-30T06:00:00.000",229 "for1Year": {230 "beta": 1.137,231 "alpha": 5.675,232 "rSquared": 98.8,233 "sharpeRatio": 0.735,234 "standardDeviation": 11.355,235 },236 "for3Year": {237 "beta": None,238 "alpha": None,239 "rSquared": None,240 "sharpeRatio": None,241 "standardDeviation": None,242 },243 "for5Year": {244 "beta": None,245 "alpha": None,246 "rSquared": None,247 "sharpeRatio": None,248 "standardDeviation": None,249 },250 "for10Year": {251 "beta": None,252 "alpha": None,253 "rSquared": None,254 "sharpeRatio": None,255 "standardDeviation": None,256 },257 "for15Year": {258 "beta": None,259 "alpha": None,260 "rSquared": None,261 "sharpeRatio": None,262 "standardDeviation": None,263 },264 "bestFitIndexName": None,265 "forLongestTenure": None,266 "bestFitBetaFor3Year": None,267 "primaryIndexNameNew": "S&P BSE 100 India TR INR",268 "bestFitAlphaFor3Year": None,269 "bestFitRSquaredFor3Year": None,270 },271 },272 },273 5: {274 "quotes": {"expenseRatio": 0.0216, "lastTurnoverRatio": 0.2025},275 "holdings": {276 "equityHoldingPage": {277 "pageSize": 100,278 "totalPage": 1,279 "pageNumber": 1,280 "holdingList": [281 {"isin": "INE002A01018", "weighting": 13.2},282 {"isin": "INE090A01021", "weighting": 7.4},283 {"isin": "INE040A01034", "weighting": 3.4},284 ],285 },286 },287 "list_info": {"isin": "MF123"},288 "risk_measures": {289 "cur": "INR",290 "fundName": "Testing fund 2",291 "indexName": "Morningstar India GR INR",292 "categoryName": "Large-Cap",293 "fundRiskVolatility": {294 "endDate": "2023-11-30T06:00:00.000",295 "for1Year": {296 "beta": 1.041,297 "alpha": 0.521,298 "rSquared": 98.8,299 "sharpeRatio": 0.354,300 "standardDeviation": 11.355,301 },302 "for3Year": {303 "beta": None,304 "alpha": None,305 "rSquared": None,306 "sharpeRatio": None,307 "standardDeviation": None,308 },309 "for5Year": {310 "beta": None,311 "alpha": None,312 "rSquared": None,313 "sharpeRatio": None,314 "standardDeviation": None,315 },316 "for10Year": {317 "beta": None,318 "alpha": None,319 "rSquared": None,320 "sharpeRatio": None,321 "standardDeviation": None,322 },323 "for15Year": {324 "beta": None,325 "alpha": None,326 "rSquared": None,327 "sharpeRatio": None,328 "standardDeviation": None,329 },330 "bestFitIndexName": None,331 "forLongestTenure": None,332 "bestFitBetaFor3Year": None,333 "primaryIndexNameNew": "S&P BSE 100 India TR INR",334 "bestFitAlphaFor3Year": None,335 "bestFitRSquaredFor3Year": None,336 },337 },338 },339}340