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|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|sga_expense|pre_tax_income|net_income|interest_income|price|total_return_price|enterprise_value|average_volume_30|one_year_return
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 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 SG&A Expense (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)
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_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|mil_figure_money_USD_metric|figure_money_USD_price|figure_money_USD_price|mil_figure_money_USD_metric|figure_USD_metric|percent_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|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|daily
new_0222_0191|STEM||5|5|91.25|91.25|91.25|91.25|91.25|91.25|91.25|91.25|0|91.25|91.25|0|0|92|1.44196428571|92|0|0|1.44196428571|0|91.25|1.44903581267|0|15.2631578947|91.25|91.25|91.25|92|0|30|30|92|30.4|91.4285714286|0|91.4285714286|32.6666666667|0|91.25|91.6666666667|91.25|91.4285714286|0|0|92|91.25|0|0|91.5|91.5|91.4285714286|91.4285714286|91.4285714286|91.5|1.44903581267|1.44903581267|1.44196428571|1.45209580838|1.45045045045
new_0222_0191|STEM||6|6|4|4|4|4|4|4|4|4|0|4|4|0|0|2|224|2|0|0|224|0|4|363|0|19|4|4|4|2|0|3|4|2|10|7|0|7|9|0|4|3|4|7|0|0|2|4|0|0|6|6|7|7|7|6|363|363|224|334|111
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|daily|quarterly|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
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||||||-0.3559|||||||4.379|-1.745|6.646|-18.981|-18.981|-5.192|||||
new_0222_0191|STEM|202009|202009|202009||||||||||||||||||||||||||||||||||47.9481||-0.3918||||||-0.3599|||||||9.172|-1.73|5.688|-18.643|-18.785|-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|49.277|6.942|20.843|124.105|13.826|383.259|190.515|192.744||-177.409|-407.841||||||||||-0.5968|0|||13.695|14.148|0.004|||||||47.9481||-2.1041|||125.7545||0.1083|-0.4077||||-138.6541|||18.646|0.949|9.817|-101.024|-100.887|-6.98|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|||125.7545|0|0.1586|-0.0125||||-295|||||0.5513|-156.347|-156.347||26.58|26.58||3969120.1|
new_0222_0191|STEM|202104|202103|202103|||||||||||||||-69.0748||||34.9302|||0|||||||||||7.1531||||125.7545||||||||||||||||||25.39|25.39|3192.4807|2496573.2333|
new_0222_0191|STEM|202105|202103|202103|||||||||||||||-68.9388||||34.8614|||0||6.8251|||||||||7.2606||||125.7545||||||||||||||||||25.34|25.34|3186.193|2056403.7|
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|||-11.2604|-60.996|6.0666|||22.5549||0.0082|0||11.1682|17.833|17.798|0.013|-489.929||||-919.3105|54.337|100.612||-1|130.7681||130.7681|0|5.7311|-0.282|||-919.3105|-376.235|||19.337|-0.127|18.927|-100.216|-100.216|-3.929|36.01|36.01|4236.5403|3624510.2333|
new_0222_0191|STEM|202107|202106|202106|||||||||||||||-44.2396||||16.9803|||0||9.5336|||||||||55.508||||||||||||||||||||||27.11|27.11|3072.7042|3233435.9333|
new_0222_0191|STEM|202108|202106|202106|||||||||||||||-40.3348||||15.6813|||0||7.0692|||||||||55.4874||||131.0089||||||||||||||||||24.99|24.99|2801.4934|2152382.0667|
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|||-11.8785|-28.7168|3.4822|||5.4634||0.0027|0||3.7389|34.997|14.962|0.014|-112.095||||-128.3477|58.1527|140.2852||-0.15|144.286||144.286|0|7.7912|-1.1266|||-128.3477|-241.838|||39.833|3.137|15.999|115.612|115.612|-2.674|23.89|23.89|2872.6835|2249906.9333|
new_0222_0191|STEM|202110|202109|202109|||||||||||||||-28.4572||||5.4223|||0||3.949|||||||-0.268||58.3247||||||||||||||||||||||23.71|23.71|2846.7121|2262981.3667|144.433
new_0222_0191|STEM|202111|202109|202109|||||||||||||||-24.9088||||4.8597|||0||4.8||||||9|0.7077||58.7032||||144.4892||||||||||||||||||21.22|21.22|2491.7518|3830829.7|109.064
new_0222_0191|STEM|202112|202112|202112|1023.85|920.788|22.72|119.624|15.707|524.003|87.967|436.036||667.827|-509.052|||-12.2389|-19.2199|1.7971|||4.1095||0.4765|0||6.3534|61.914|28.579|0.014|-47.3234||9|-1.1081|-61.5554|77.4876|144.9346|213|-0.2354|144.6716||144.6716|0|11.1713|-0.2354|||-61.5554|-175.005|||52.78|-1.647|21.313|-34.054|-34.054|-4.56|18.97|18.97|2141.8613|3899892.3667|-7.2825
new_0222_0191|STEM|202201|202112|202112|||||||||||||||-10.5349||||2.6602|||0||9.2479||||||4|1.4272||77.9696||||||||||||||||||||||12.28|12.28|1174.0082|3580822.7333|-54.6863
new_0222_0191|STEM|202202|202112|202112|||||||||||||||-7.7012||||2.1874|||0||11.2012||||||2|1.4697||70.5645||||153.4438||||||||||||||||||9.52|9.52|858.226|4700399.9|-72.1475
new_0222_0191|STEM|202203|202203|202203|||||||||||||||-9.4224||||2.4746|||0|||||||||||||||||||||||||||||||||10.77|10.77|1050.0307|5165494.6|-63.8712