Stock Portfolio Allocation Dataset
This dataset provides detailed simulated stock portfolio allocations, including asset class breakdowns, risk profiles, and return metrics for investor accounts. It is ideal for financial research, portfolio optimization studies, and risk-return analysis, offering granular insights into investment strategies and outcomes.
Sample rows
preview · 8 of 200 rows · all 14 columns| account_idstring | investor_profilestring | historical_annual_return_pctfloat | allocation_datedate | asset_class_equity_pctfloat | asset_class_fixed_income_pctfloat | asset_class_cash_pctfloat | asset_class_alternatives_pctfloat | portfolio_total_valuefloat | expected_annual_return_pctfloat | risk_scorefloat | sharpe_ratiofloat | max_drawdown_pctfloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| inv_0001 | conservative | 2.5 | 2014-05-22 | 12 | 81 | 5 | 2 | 18650.58 | 2.3 | 2.1 | 1.65 | -2.6 | Retirement-oriented portfolio, prefers stability. |
| inv_0002 | aggressive | 17.1 | 2021-07-03 | 74 | 4 | 2 | 20 | 353480.44 | 15.4 | 31.7 | 1.12 | -52.2 | Young investor targeting high growth. |
| inv_0003 | balanced | 6.9 | 2019-11-15 | 47 | 35 | 13 | 5 | 113240.87 | 7.6 | 8.4 | 1.22 | -15.1 | Mid-career investor, moderate risk. |
| inv_0004 | custom | blank | 2018-03-05 | 14 | 9 | 16 | 61 | 23315.09 | 9.4 | 42.3 | 0.97 | -74.8 | Alternative assets focused, family office. |
| inv_0005 | aggressive | 19.8 | 2023-02-28 | 82 | 2 | 1 | 15 | 687241.52 | 21.9 | 37.2 | 1.84 | -87.3 | Diversified growth, emerging markets. |
| inv_0006 | balanced | 7.1 | 2015-08-09 | 60 | 23 | 10 | 7 | 112742.81 | 7.2 | 10.2 | 1.09 | -24.7 | Balanced allocation for long-term stability. |
| inv_0007 | conservative | 1.8 | 2016-02-03 | 6 | 92 | 2 | 0 | 15627.73 | 1.7 | 1.3 | 2.3 | -1.9 | Government bonds focus, minimal equity. |
| inv_0008 | custom | blank | 2017-04-17 | 0 | 0 | 0 | 100 | 5521.36 | -100 | 100 | blank | -100 | Edge case: full allocation, total loss. |
| inv_0009 | balanced | 6.8 | 2020-09-25 | 52 | 31 | 12 | 5 | 128341.04 | 6.1 | 9.5 | 1.15 | -18.4 | Moderate allocation, focus on diversification. |
| inv_0010 | aggressive | blank | 2022-04-11 | 93 | 0 | 2 | 5 | 427521.88 | 29.4 | 44.3 | 2.05 | -95.2 | Tech sector overweight, high risk tolerance. |
| inv_0011 | conservative | 3.9 | 2013-09-28 | 18 | 76 | 4 | 2 | 30251.11 | 3.7 | 3.6 | 1.88 | -2.2 | Stable income, low volatility. |
| inv_0012 | custom | blank | 2017-11-03 | 0 | 0 | 100 | 0 | 3942.84 | 0 | 0 | blank | 0 | Edge case: liquidity event. |
| inv_0013 | balanced | 6.3 | 2016-06-14 | 38 | 45 | 12 | 5 | 67280.98 | 6.9 | 7.2 | 1.07 | -20.7 | Long-term balanced approach. |
| inv_0014 | aggressive | blank | 2023-06-01 | 100 | 0 | 0 | 0 | 218742.95 | 35 | 45.2 | 2.3 | -99 | Edge case: full equity, highest risk. |
| inv_0015 | conservative | 2.7 | 2014-03-19 | 11 | 74 | 14 | 1 | 18231.77 | 2.8 | 2.9 | 1.45 | -3.9 | Low volatility, focus on capital preservation. |
| inv_0016 | custom | 10.2 | 2015-09-12 | 26 | 0 | 19 | 55 | 18941.32 | 11 | 61.6 | 1.02 | -82.5 | Family office, alternative asset overweight. |
| inv_0017 | balanced | 5.6 | 2018-10-21 | 41 | 45 | 8 | 6 | 94210.2 | 5.8 | 8.7 | 1.12 | -19.2 | Diversified balanced portfolio. |
| inv_0018 | aggressive | 14.4 | 2020-01-13 | 71 | 9 | 5 | 15 | 291243.17 | 13.6 | 24.2 | 1.01 | -40.7 | Aggressive allocation, some fixed income. |
| inv_0019 | conservative | 2.9 | 2015-12-11 | 17 | 72 | 9 | 2 | 25521.13 | 3.1 | 3.1 | 1.78 | -2.7 | Stable income, capital preservation. |
| inv_0020 | custom | blank | 2020-03-06 | 0 | 12 | 18 | 70 | 15822.25 | 5 | 77.9 | blank | -100 | Alternatives heavy, recent allocation. |
What the 200 rows show
from the 200-row sampleAggressive (investor profile) stands out: mean historical_
- 6.8median historical_
annual_ return_ pct - 33.0median asset_
class_ equity_ pct - 22.0median asset_
class_ fixed_ income_ pct - 7.8median asset_
class_ cash_ pct - 5.0median asset_
class_ alternatives_ pct - 94,105median portfolio_
total_ value
Median 6.8, from 1.4 to 32.2.
- string 3
- float 10
- date 1
Columns
14 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 3 columns | |||
account_id | string | Unique identifier for the simulated investor accountunique | inv_0001 |
investor_profile | string | Investor risk profile category (e.g., conservative, balanced, aggressive)conservative · balanced · aggressive · custom | conservative |
notes | string | Additional notes or comments about the allocation recordoptional | Bond heavy, low risk. |
| Numbers 10 columns | |||
asset_class_equity_pct | float | Percentage of portfolio allocated to equities0 to 100 | 12 |
asset_class_fixed_income_pct | float | Percentage of portfolio allocated to fixed income assets0 to 100 | 81 |
asset_class_cash_pct | float | Percentage of portfolio allocated to cash or cash equivalents0 to 100 | 5 |
asset_class_alternatives_pct | float | Percentage of portfolio allocated to alternative investments (e.g., real estate, commodities)0 to 100 · optional | 2 |
portfolio_total_value | float | Total monetary value of the portfolio at allocation date0 or more | 18650.58 |
expected_annual_return_pct | float | Expected annual return percentage for the portfolio-100 to 100 | 2.3 |
historical_annual_return_pct | float | Actual historical annual return percentage for the portfolio (if available)-100 to 100 · optional | 2.5 |
risk_score | float | Numerical risk score for the portfolio (e.g., standard deviation of returns)0 or more | 2.1 |
sharpe_ratio | float | Sharpe ratio of the portfolio, measuring risk-adjusted returnoptional | 1.65 |
max_drawdown_pct | float | Maximum observed drawdown percentage for the portfolio-100 to 0 · optional | -2.6 |
| Dates and times 1 column | |||
allocation_date | date | Date when the asset allocation was recorded | 2014-05-22 |
Use it for
A finance dashboard
Historical_
annual_ return_ pct by investor_ profile. Excel, Power BI or Tableau. Why do the 18 aggressive rows have a mean historical_
annual_ return_ pct of 21.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Accounts200inv_00012.5conserva…inv_000217.1aggressi…inv_00036.9balanced
A software demo
Believable accounts with investor_
profile, allocation_ date and asset_ class_ equity_ pct to fill a screen in front of a buyer.
This dataset200 rows14 columns
Yours1,000 rows14 columns
blueprint · stock-portfolio-allocation-dataset
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Investor profiles anonymized
- Asset classes and allocations detailed
- Portfolio returns calculated monthly
- Risk-adjusted performance features
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- stock-portfolio-allocation-dataset