new_0222_0191|STEM|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|price_next_month|price_second_month
new_0222_0191|STEM|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|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|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|91.5|91.5|92|92|92|91.5|91.5|91.5|0|91.5|91.5|0|0|92|1.44117647059|92|0|0|1.43902439024|0|91.5|1.44897959184|0|15.4117647059|92|91.5|91.5|0|0|31|30.6666666667|0|30.6666666667|109.6|0|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|109.6|114.25|1.4476744186|1.4476744186|1.44117647059|1.45222929936|1.45054945055||
new_0222_0191|STEM|6|2|2|1|1|1|2|2|2|0|2|2|0|0|1|204|1|0|0|205|0|2|343|0|17|1|2|2|0|0|2|3|0|9|5|0|5|6|0|2|1|2|5|0|0|0|2|0|0|4|4|5|5|5|4|344|344|204|314|91||
new_0222_0191|STEM|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||||||||||||||||||||||||||||||||||47.9481||-0.0005||||||-0|||||||||0|-0.0011|-0.0011||||||||
new_0222_0191|STEM|202006||||||||||||||||||||||||||||||||||47.9481||-7.9173||||||-0.3559|||||||4.379|-1.745|6.646|-18.981|-18.981|-5.192|||||||
new_0222_0191|STEM|202009||||||||||||||||||||||0||||||||||||47.9481||-7.8356||||||-0.3599|||||||9.172|-1.73|5.688|-18.643|-18.785|-4.265|194|194||5411.9667||210|
new_0222_0191|STEM|202012||6.942||||383.259|||||||||||||||-0.5968|0||||||||||||||-42.0817||||||||||-138.6541|||18.646|0.949|9.817||-100.887||446.2|446.2||127567.1333||586.2|720.6
new_0222_0191|STEM|202103|1.0123|0.4261||||293.1897|2.6866|290.5031||91.4083|-268.9988||||-173.2059||37.6228||37.2137||0|0||6.8251||0.0705|86.4123||||||7.1531|47.9481||-13.1292|6.2877||125.7545||0.1586|-0.0125||||-221.206|47.617||15.42|-0.117|5.359|-156.347|-82.553||531.6|531.6|3401.2196|204537.8333||532.2|539
new_0222_0191|STEM|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|52.1029||50.641||0.0082|0||11.1682|17.833|17.798|0.013||||||54.2399|100.612||-20|6.5384||130.7681|0|5.7311|-0.282||||-302.441|62.575||19.337|-0.127|18.927|-100.216|-100.216|-3.929|720.2|720.2|4628.5787|181889.4333||545.2|497.4
new_0222_0191|STEM|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|31.4409||15.3235||0.0027|0||3.7389|34.997|14.962|0.014|-51.2796||9|-0.268|-51.4666|55.3412|140.2852||-3|7.2143||144.286|0|7.7912|-1.1266|||-51.4666|-168.044|93.236||39.833|3.137|15.999|115.612|115.612|-2.674|471.8|471.8|2726.7964|114291.0333|144.433|533|436.2
new_0222_0191|STEM|202112||920.788||||524.003|||||||||-27.451||21.1444||4.3559||0.4765|0||6.3614||||||9|-1.1081||60.9835|||-4.6|7.2336|||||||||-101.211|127.37||52.78|-1.647|21.313||-34.054||374.4|374.4|2173.8908|210677.7333|-7.2825|234.4|196.2
new_0222_0191|STEM|202203||351.81||||787.679|||||||||||11.6279||2.6607||0.7113|||||||||||||||-3|7.6859|||||||||-41.141|153.038||41.088|3.644|29.654||-22.483||223.2|223.2|1174.3225|255817.3667||151.2|147.8
new_0222_0191|STEM|202206||334.893||||823.275|||||||||||6.641||1.8555||0.7437|||||||||||||||-4.2|7.7113|||||||||27.056|200.648||66.947|7.788|28.648||-32.019||140.2|140.2|1265.395|204497.2333||174.6|314.4
new_0222_0191|STEM|202209||293.501||||839.999|||||||||||9.473||3.2957||0.7784|||||||||||||||-4.4|7.7244|||||||||-122.835|260.316||99.501|9.127|31.2||-34.279||264.4|264.4|2101.9049|225964.5333||273.2|261.4
new_0222_0191|STEM|202212||249.977||||869.726|||||||||||5.0055||2.3114||0.8149|||||||||||||||-4.6|7.727|||||||||-124.054|362.98||155.444|12.533|36.408||-35.273||166.8|166.8|1489.1314|140731.3||196|162.8
new_0222_0191|STEM|202303||205.561||||876.925|||||||||||2.6368||1.7534||0.8709|||||||||||||||-5.8|7.7754|||||||||-146.349|389.297||67.405|0.994|30.203||-44.778||111.8|111.8|1167.301|204900.5667||82.2|110.4
new_0222_0191|STEM|202306||138.174||||984.146|||||||||||2.0518||1.556||1.007|||||||||||||||-5.2|7.7898|||||||||-95.208|415.296||92.946|11.871|32.584||19.122||106.4|106.4|1049.0638|305423.1667||139.4|105.2
new_0222_0191|STEM|202309||125.365||||945.449|||||||||||1.5145||1.2191||1.155|||||||||||||||-9.8|7.7942|||||||||-138.001|449.535||133.74|-20.291|33.56||-77.072||81.2|81.2|1017.3631|173825.3333||63.4|55.8
new_0222_0191|STEM|202312||113.594||||930.296|||||||||||1.3921||1.3873||1.2286|||||||||||||||-4.8|7.7966|||||||||-140.413|461.515||167.424|11.091|30.124||-37.685||80.6|80.6|1026.4489|236206.1||59.2|54.6
new_0222_0191|STEM|202403||112.804||||912.844|||||||||||0.7385||0.8107||1.4108|||||||||||||||-9.2|8.0763|||||||||-167.942|419.579||25.469|-24.191|29.686||-72.307||43.8|43.8|756.0491|313704.4667||34.6|25.4
new_0222_0191|STEM|202406||89.649||||894.28|||||||||||0.4288||0.4829||-2.5823|||||||||||||||-71.8|8.1294|||||||||-769.334|360.632||33.999|9.375|26.79||-582.27||23|23|597.7808|199778.8333||25.4|11.662
new_0222_0191|STEM|202409||75.364||||881.39|||||||||||0.1358||||-1.5267|||||||||||||||-18.2|8.1357|||||||||-840.562|256.183||29.291|6.196|35.428||-148.3||6.584|6.584|486.0211|369707.4||10.822|7.844
new_0222_0191|STEM|202412||56.299||||835.192|||||||||||0.2571||||-1.3202|||||||||||||||-6|8.1399|||||||||-854.014|144.584||55.825|-2.438|33.926||-51.137||11.892|11.892|517.6418|364256.2||12.134|8.588
new_0222_0191|STEM|202503||58.584||||822.005|||||||||||0.4355||||-1.2612|||||||||||||||-3|8.3176|||||||||-806.707|151.627||32.512|10.538|20.358||-25||7.8|7.8|534.1825|266925.6||10.818|9.304
new_0222_0191|STEM|202506|||||||||||||||||0.3797||||||||||||||||||||8.3179||||||||||||||||||6.17|6.17|527.2676|207090.7333||8.61|