new_0222_0191|STEM|Short Name|0|0|total_current_assets|cash_on_hand|inventories_net|net_ppe|goodwill_and_intangible|liabilities|total_current_liabilities|total_long_term_liab|total_deposits|book_value_of_equity|retained_earnings|treasury_stock|ev_revenues|ev_earnings|ev_free_cash_flow|ev_assets|ps_ratio|pe_ratio|price_to_book_value|peg_ratio|debt_equity_ratio|dividend_yield|shareholder_yield_ttm|percent_of_shares_outstanding|receivables|payables|capital_stock|return_on_invested_capital|quality_ratio_fractile|momentum_fractile|market_beta_12_month|sustainable_growth_rate|institutional_investor_ownership_percentage|average_shares_outs_diluted|total_employee_number|eps|sga_expense|shares_outstanding|repurchase_of_capital_stock|ordinary_shares_number|payout_ratio|quick_ratio|normalized_eps|stock_buyback|effective_tax_rate|return_on_equity|net_income_ttm|revenues_ttm|dividend_per_share|revenues|gross_profit|pre_tax_income|net_income|interest_income|price|total_return_price|enterprise_value|average_volume_30|one_year_return|short_interest|forward_pe_ratio|forward_pe_ratio_1y|forward_ps_ratio|forward_ps_ratio_1y|quarterly_eps_estimates|quarterly_sales_estimates|quarterly_eps_surprise|quarterly_sales_surprise|quarterly_eps_actual|quarterly_sales_actual|sales_est_0y|sales_est_1y|price_target|consensus_recommendation|price_target_num_est|eps_est_0y|eps_est_1y|r_and_d_expense|reconciled_depreciation|interest_expense_non_operating|land_and_improvements|buildings_and_improvements|other_properties|machinery_furniture_equipment
new_0222_0191|STEM|Long Name|1|1|Stem Inc Total Current Assets (Quarterly) (USD)|Stem Inc Cash and Short Term Investments (Quarterly) (USD)|Stem Inc Inventories (Quarterly) (USD)|Stem Inc Net PP&E (Quarterly) (USD)|Stem Inc Goodwill and Intangibles (Quarterly) (USD)|Stem Inc Total Liabilities (Quarterly) (USD)|Stem Inc Total Current Liabilities (Quarterly) (USD)|Stem Inc Total Long Term Liabilities (Quarterly) (USD)|Stem Inc Total Deposits (Quarterly) (USD)|Stem Inc Book Value (Quarterly) (USD)|Stem Inc Retained Earnings (Quarterly) (USD)|Stem Inc Treasury Stock (Quarterly) (USD)|Stem Inc EV to Revenues|Stem Inc EV to Earnings|Stem Inc EV to Free Cash Flow|Stem Inc EV to Assets (Quarterly)|Stem Inc PS Ratio|Stem Inc PE Ratio|Stem Inc Price to Book Value|Stem Inc PEG Ratio|Stem Inc Debt to Equity Ratio|Stem Inc Dividend Yield|Stem Inc Shareholder Yield (TTM)|Stem Inc Percent of Shares Outstanding Short|Stem Inc Total Receivables (Quarterly) (USD)|Stem Inc Total Payables (Quarterly) (USD)|Stem Inc Total Capital Stock (Quarterly) (USD)|Stem Inc Return on Invested Capital|Stem Inc Quality Ratio Score|Stem Inc Momentum Score|Stem Inc Beta (1Y)|Stem Inc Sustainable Growth Rate (TTM)|Stem Inc Institutional Investor Ownership Percentage|Stem Inc Average Diluted Shares Outstanding (Quarterly)|Stem Inc Total Employees (Annual)|Stem Inc EPS Diluted (Quarterly) (USD)|Stem Inc SG&A Expense (Quarterly) (USD)|Stem Inc Shares Outstanding|Stem Inc Repurchase of Capital Stock (Quarterly) (USD)|Stem Inc Ordinary Shares Number (Quarterly)|Stem Inc Payout Ratio|Stem Inc Quick Ratio (Quarterly)|Stem Inc Normalized Diluted EPS (Quarterly) (USD)|Stem Inc Stock Buybacks (Quarterly) (USD)|Stem Inc Effective Tax Rate (TTM)|Stem Inc Return on Equity|Stem Inc Net Income (TTM) (USD)|Stem Inc Revenue (TTM) (USD)|Stem Inc Dividend Per Share (Quarterly) (USD)|Stem Inc Revenue (Quarterly) (USD)|Stem Inc Gross Profit (Quarterly) (USD)|Stem Inc Pre-Tax Income (Quarterly) (USD)|Stem Inc Net Income (Quarterly) (USD)|Stem Inc Net Interest Income (Quarterly) (USD)|Stem Inc Price (USD)|Stem Inc Total Return Price (USD)|Stem Inc Enterprise Value (USD)|Stem Inc 30-Day Average Daily Volume|Stem Inc 1 Year Price Returns (Daily)|Stem Inc Short Interest|Stem Inc PE Ratio (Forward)|Stem Inc PE Ratio (Forward 1y)|Stem Inc PS Ratio (Forward)|Stem Inc PS Ratio (Forward 1y)|Stem Inc Quarterly EPS Estimates (USD)|Stem Inc Quarterly Revenue Estimates (USD)|Stem Inc Quarterly EPS Surprise|Stem Inc Quarterly Revenue Surprise|Stem Inc Quarterly Actual EPS (USD)|Stem Inc Quarterly Actual Revenue (USD)|Stem Inc Revenue Estimates for Current Fiscal Year (USD)|Stem Inc Revenue Estimates for Next Fiscal Year (USD)|Stem Inc Price Target (USD)|Stem Inc Consensus Recommendation|Stem Inc Price Target Num Estimates|Stem Inc EPS Estimates for Current Fiscal Year (USD)|Stem Inc EPS Estimates for Next Fiscal Year (USD)|Stem Inc Research and Development Expense (Quarterly) (USD)|Stem Inc Reconciled Depreciation (Quarterly) (USD)|Stem Inc Non-Operating Interest Expense (Quarterly) (USD)|Stem Inc Land and Improvements (Quarterly) (USD)|Stem Inc Buildings and Improvements (Quarterly) (USD)|Stem Inc Other Properties (Quarterly) (USD)|Stem Inc Machine, Furniture & Equipment (Quarterly) (USD)
new_0222_0191|STEM|Unit|2|2|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|percent_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|percent_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_beta|percent_USD_metric|percent_USD_metric|mil_figure_USD_metric|figure_whole_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_USD_metric|mil_figure_money_USD_metric|mil_figure_USD_metric|percent_USD_metric|figure_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_price|figure_money_USD_price|mil_figure_money_USD_metric|figure_USD_metric|percent_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|percent_USD_per_share_metric|percent_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_price|figure_USD_metric|figure_whole_USD_price|figure_money_USD_per_share_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric
new_0222_0191|STEM||4|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|quarterly|quarterly|daily|quarterly|quarterly|daily|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|daily|monthly|quarterly|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|monthly|monthly|monthly|monthly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly
new_0222_0191|STEM||5|5|91.5|91.5|92|92|92|91.5|91.5|91.5|0|91.5|91.5|0|0|92|1.43902439024|92|0|0|1.43902439024|0|91.5|1.4476744186|0|15.4117647059|92|91.5|91.5|0|0|31|30.6666666667|0|30.6666666667|109.6|0|109.6|109.6|32.1666666667|0|91.5|92|91.5|109.6|0|0|0|91.5|0|0|114.25|114.25|109.6|109.6|114.25|1.4476744186|1.4476744186|1.43902439024|1.45079365079|1.44565217391|15.4117647059|0|1.44117647059|1.44117647059|1.44117647059|91.5|91.5|92|92|92|92|13.9|15.4444444444|15.875|8.25714285714|15.875|18.1428571429|15.875|114.25|121.666666667|114.25|0|0|92|0
new_0222_0191|STEM||6|6|2|2|1|1|1|2|2|2|0|2|2|0|0|1|205|1|0|0|205|0|2|344|0|17|1|2|2|0|0|2|3|0|9|5|0|5|5|6|0|2|1|2|5|0|0|0|2|0|0|4|4|5|5|4|344|344|205|315|92|17|0|34|34|34|6|6|1|1|1|1|20|18|16|35|16|14|16|4|3|4|0|0|1|0
new_0222_0191|STEM||7|7|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|daily|quarterly|daily|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|monthly|quarterly|yearly|quarterly|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|market_daily|market_daily|daily|market_daily|market_daily|daily|daily|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly
new_0222_0191|STEM|202003|202003|202003||||||||||||||||||||||||||||||||||47.9481||-0|0||||||-0|||||||||-0.0011|-0.0011|||||||||||||||||||||||||||||||
new_0222_0191|STEM|202006|202006|202006||||||||||||||||||||||||||||||||||47.9481||-0.3959|6.646||||||-0.3559|||||||4.379|-1.745|-18.981|-18.981|-5.192||||||||||||||||||||||||3.619||5.192||||
new_0222_0191|STEM|202009|202009|202009||||||||||||||||||||||||||||||||||47.9481||-0.3918|5.688||||||-0.3599|||||||9.172|-1.73|-18.643|-18.785|-4.265||||||||||||||||||||||||5.052|5.851|4.265||||
new_0222_0191|STEM|202010|202009|202009||||||||||||||||||||||0|||||||||||||||||||||||||||||||||9.65|9.65||||||||||||||||||||||||||||
new_0222_0191|STEM|202011|202009|202009||||||||||||||||||||||0|||||||||||||||||||||||||||||||||10.15|10.15||113400.7||||||||||||||||||||||||||
new_0222_0191|STEM|202012|202012|202012||||||||||||||||||||||0|||||||||||||||||||||||||||||||||20.46|20.46||2641079.4||||||||||||||||||||||||||
new_0222_0191|STEM|202101|202012|202012||||||||||||||||||||||0|||||||||||||||||||||||||||||||||27.1|27.1||3297213.7||||||||||||||||||||||||||
new_0222_0191|STEM|202102|202012|202012||||||||||||||||||||||0|||||||||||||||||||||||||||||||||34.18|34.18||4241183.1||||||||||||||||||||||||||
new_0222_0191|STEM|202103|202103|202103|1.0123|0.4261||||293.1897|2.6866|290.5031||91.4083|-268.9988||||||||||0|0||||0.0705|86.4123|||||||47.9481||-3.2608|0.5513|||125.7545||0.1586|-0.0125||||-194.1141|||||-156.347|-156.347||26.58|26.58||3969120.1||||||||||||||||||||||||||
new_0222_0191|STEM|202104|202103|202103|||||||||||||||-173.2059||||34.9302|||0|||||||||||7.1531|||||125.7545|||||||||||||||||25.39|25.39|3192.4807|2496573.2333|||||||||||||147|315||0||||||||||
new_0222_0191|STEM|202105|202103|202103|||||||||||||||-172.8648||||34.8614|||0||6.8251|||||||||7.2606|||||125.7545|||||||||||||||||25.34|25.34|3186.193|2056403.7||8582920|||||||||||146.0075|302.513|30|2|1|-0.89|-0.04|||||||
new_0222_0191|STEM|202106|202106|202106|538.337|474.138|27.167|118.216|14.173|489.561|85.842|403.719||208.778|-590.61|||-14.3939|-55.6934|6.0666|||22.5549||0.0082|0||11.1682|17.833|17.798|0.013||||||54.2399|100.612||-1|18.927|130.7681||130.7681|0|5.7311|-0.282||||-294.329|||19.337|-0.127|-100.216|-100.216|-3.929|36.01|36.01|4236.5403|3624510.2333||14604457|||||-0.17|20.2057|-9.8235|-4.2991|-0.1867|19.337|146.5283|318.5253|39|2|2|-1.37|-0.135|4.827||3.929|||158.064|
new_0222_0191|STEM|202107|202106|202106|||||||||||||||-40.3936||||16.9803|||0||9.5336|||||||||55.3176||||||||||||||||||||||27.11|27.11|3072.7042|3233435.9333||12466921|||||||||||146.9733|314.075|39|1.6667|3|-1.1833|-0.1067|||||||
new_0222_0191|STEM|202108|202106|202106|||||||||||||||-36.8283||||15.6813|||0||7.0692|||||||||55.2914|||||131.0089|||||||||||||||||24.99|24.99|2801.4934|2152382.0667||9261311|||||||||||147.057|314.5088|39|1.6667|3|-2.57|-0.115|||||||
new_0222_0191|STEM|202109|202109|202109|651.677|575.984|24.2|128.043|14.866|194.048|78.419|115.629||630.919|-474.998|||-17.984|-36.3963|3.4822|||5.4634||0.0027|0||3.7389|34.997|14.962|0.014|-51.2796||||-51.4666|55.352|140.2852||-0.15|15.999|144.286||144.286|0|7.7912|-1.1266|||-51.4666|-159.736|||39.833|3.137|115.612|115.612|-2.674|23.89|23.89|2872.6835|2249906.9333||5394697|||||-0.355|35.8877|57.0507|10.9936|-0.1525|39.833||||||||6.268|5.305|2.674|||170.508|
new_0222_0191|STEM|202110|202109|202109|||||||||||||||-36.0672||||5.4223|||0||3.949|||||||-0.268||55.4581||||||||||||||||||||||23.71|23.71|2846.7121|2262981.3667|144.433|5697858|||||||||||146.0886|315.1582|32.75|2.25|4|-2.56|-0.11|||||||
new_0222_0191|STEM|202111|202109|202109|||||||||||||||-31.5699||||4.8597|||0||4.8||||||9|0.7077||55.756|||||144.4892|||||||||||||||||21.22|21.22|2491.7518|3830829.7|109.064|6935446|||||||||||146.9378|316.5695|33.8|1.8|5|-0.5533|-0.1825|||||||
new_0222_0191|STEM|202112|202112|202112|||||||||||||||-27.451||||4.3444|||0||6.3614||||||9|-1.1081||60.851||||||||||||||||||||||18.97|18.97|2166.6511|3899892.3667|-7.2825|9191592||97.2821|7.8289|4.5603|-0.115|72.2717|||||146.9454|321.0695|33.2|1.8|5|-0.445|-0.14|||||||
new_0222_0191|STEM|202201|202112|202112|||||||||||||||-15.204||||2.8123|||0||9.2595||||||4|1.4272||57.4414||||||||||||||||||||||12.28|12.28|1200.0184|3580822.7333|-54.6863|13379016||62.9744|5.0681|2.952|||||||||29.4|1.6|5|||||||||
new_0222_0191|STEM|202202|202112|202112|||||||||||||||-12.2383||||2.4413|||0|||||||||||||||||||||||||||||||||10.66|10.66|965.9459|3448379.2333|-75.6343|||57.6216|3.7736|2.2481|||||||408.161|685.125|27|1.6|2|-0.215|0.185|||||||
new_0222_0191|STEM|202203|202203|202203|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||-0.09|54.31||||||||||||||||||
new_0222_0191|STEM|202206|202206|202206|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||-0.07|72.54||||||||||||||||||
new_0222_0191|STEM|202209|202209|202209|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||-0.03|105.41||||||||||||||||||
new_0222_0191|STEM|202212|202212|202212|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.05|189.08||||||||||||||||||