new_0222_0194|BLI|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|price_next_month|price_second_month
new_0222_0194|BLI|1|Berkeley Lights Inc Total Current Assets (Quarterly) (USD)|Berkeley Lights Inc Cash and Short Term Investments (Quarterly) (USD)|Berkeley Lights Inc Inventories (Quarterly) (USD)|Berkeley Lights Inc Net PP&E (Quarterly) (USD)|Berkeley Lights Inc Goodwill and Intangibles (Quarterly) (USD)|Berkeley Lights Inc Total Liabilities (Quarterly) (USD)|Berkeley Lights Inc Total Current Liabilities (Quarterly) (USD)|Berkeley Lights Inc Total Long Term Liabilities (Quarterly) (USD)|Berkeley Lights Inc Total Deposits (Quarterly) (USD)|Berkeley Lights Inc Book Value (Quarterly) (USD)|Berkeley Lights Inc Retained Earnings (Quarterly) (USD)|Berkeley Lights Inc Treasury Stock (Quarterly) (USD)|Berkeley Lights Inc EV to Revenues|Berkeley Lights Inc EV to Earnings|Berkeley Lights Inc EV to Free Cash Flow|Berkeley Lights Inc EV to Assets (Quarterly)|Berkeley Lights Inc PS Ratio|Berkeley Lights Inc PE Ratio|Berkeley Lights Inc Price to Book Value|Berkeley Lights Inc PEG Ratio|Berkeley Lights Inc Debt to Equity Ratio|Berkeley Lights Inc Dividend Yield|Berkeley Lights Inc Shareholder Yield (TTM)|Berkeley Lights Inc Percent of Shares Outstanding Short|Berkeley Lights Inc Total Receivables (Quarterly) (USD)|Berkeley Lights Inc Total Payables (Quarterly) (USD)|Berkeley Lights Inc Total Capital Stock (Quarterly) (USD)|Berkeley Lights Inc Return on Invested Capital|Berkeley Lights Inc Quality Ratio Score|Berkeley Lights Inc Momentum Score|Berkeley Lights Inc Beta (1Y)|Berkeley Lights Inc Sustainable Growth Rate (TTM)|Berkeley Lights Inc Institutional Investor Ownership Percentage|Berkeley Lights Inc Average Diluted Shares Outstanding (Quarterly)|Berkeley Lights Inc Total Employees (Annual)|Berkeley Lights Inc EPS Diluted (Quarterly) (USD)|Berkeley Lights Inc SG&A Expense (Quarterly) (USD)|Berkeley Lights Inc Shares Outstanding|Berkeley Lights Inc Repurchase of Capital Stock (Quarterly) (USD)|Berkeley Lights Inc Ordinary Shares Number (Quarterly)|Berkeley Lights Inc Payout Ratio|Berkeley Lights Inc Quick Ratio (Quarterly)|Berkeley Lights Inc Normalized Diluted EPS (Quarterly) (USD)|Berkeley Lights Inc Stock Buybacks (Quarterly) (USD)|Berkeley Lights Inc Effective Tax Rate (TTM)|Berkeley Lights Inc Return on Equity|Berkeley Lights Inc Net Income (TTM) (USD)|Berkeley Lights Inc Revenue (TTM) (USD)|Berkeley Lights Inc Dividend Per Share (Quarterly) (USD)|Berkeley Lights Inc Revenue (Quarterly) (USD)|Berkeley Lights Inc Gross Profit (Quarterly) (USD)|Berkeley Lights Inc Pre-Tax Income (Quarterly) (USD)|Berkeley Lights Inc Net Income (Quarterly) (USD)|Berkeley Lights Inc Net Interest Income (Quarterly) (USD)|Berkeley Lights Inc Price (USD)|Berkeley Lights Inc Total Return Price (USD)|Berkeley Lights Inc Enterprise Value (USD)|Berkeley Lights Inc 30-Day Average Daily Volume|Berkeley Lights Inc 1 Year Price Returns (Daily)|Berkeley Lights Inc Short Interest|Berkeley Lights Inc PE Ratio (Forward)|Berkeley Lights Inc PE Ratio (Forward 1y)|Berkeley Lights Inc PS Ratio (Forward)|Berkeley Lights Inc PS Ratio (Forward 1y)|Berkeley Lights Inc Quarterly EPS Estimates (USD)|Berkeley Lights Inc Quarterly Revenue Estimates (USD)|Berkeley Lights Inc Quarterly EPS Surprise|Berkeley Lights Inc Quarterly Revenue Surprise|Berkeley Lights Inc Quarterly Actual EPS (USD)|Berkeley Lights Inc Quarterly Actual Revenue (USD)|Berkeley Lights Inc Revenue Estimates for Current Fiscal Year (USD)|Berkeley Lights Inc Revenue Estimates for Next Fiscal Year (USD)|Berkeley Lights Inc Price Target (USD)|Berkeley Lights Inc Consensus Recommendation|Berkeley Lights Inc Price Target Num Estimates|Berkeley Lights Inc EPS Estimates for Current Fiscal Year (USD)|Berkeley Lights Inc EPS Estimates for Next Fiscal Year (USD)|Berkeley Lights Inc Research and Development Expense (Quarterly) (USD)|Berkeley Lights Inc Reconciled Depreciation (Quarterly) (USD)|Berkeley Lights Inc Non-Operating Interest Expense (Quarterly) (USD)|Berkeley Lights Inc Land and Improvements (Quarterly) (USD)|Berkeley Lights Inc Buildings and Improvements (Quarterly) (USD)|Berkeley Lights Inc Other Properties (Quarterly) (USD)|Berkeley Lights Inc Machine, Furniture & Equipment (Quarterly) (USD)||
new_0222_0194|BLI|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_0194|BLI|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|quarterly|daily|daily|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|quarterly|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|monthly|monthly|monthly|monthly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly||
new_0222_0194|BLI|5|91.2857142857|91.2857142857|91.2857142857|91.2857142857||91.2857142857|91.2857142857|91.2857142857||91.2857142857|91.2857142857||1.44527363184|91.25|1.44527363184|91.25|1.44527363184||1.44571428571|1.44755244755|91.2857142857|1.44527363184|91.25|15.25|91.2857142857|91.2857142857|91.2857142857|91.4|91.4|30.6|30.6666666667|91.25|30.5|91.4|275|91.4|91.4|33.7857142857||91.2857142857|91.2857142857|91.2857142857|91.4|91.375|91.2857142857|91.25|91.2857142857|91.2857142857||91.4|91.4|91.4|91.4|91.4|1.44527363184|1.44527363184|1.44527363184|1.44772117962|1.42666666667|15.25|||1.44755244755|1.44755244755|91.4|91.4|91.4|91.4|91.4|91.4|14.9459459459|17.8387096774|36.8666666667|12.2888888889|36.8666666667|16.2647058824|19.75|91.4|91.4|91.4|||91.2857142857|91.2857142857||
new_0222_0194|BLI|6|7|7|7|7||7|7|7||7|7||402|4|402|4|402||350|286|7|402|4|36|7|7|7|5|5|5|6|4|14|10|1|10|10|14||7|7|7|10|8|7|4|7|7||10|10|10|10|10|402|402|402|373|150|36|||286|286|10|10|5|5|5|5|37|31|15|45|15|34|28|10|10|10|||7|7||
new_0222_0194|BLI|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_0194|BLI|201903||||||||||||||||||||||||||||||||||53.5102||-0.0786|4.479||||||-0.0786|||||||12.641|9.845|-4.186|-4.205|-0.122||||||||||||||||||||||||8.743|1.531|0.354||||||
new_0222_0194|BLI|201906||||||||||||||||||||||||||||||||||53.5102||-0.1156|5.532||||||-0.1156|||||||11.763|9.572|-6.17|-6.185|-0.08||||||||||||||||||||||||9.642|1.599|0.35||||||
new_0222_0194|BLI|201909||||||||||||||||||||||||||||||||||53.5102||-0.0831|5.759||||||-0.0831|||||||15.667|11.67|-4.427|-4.448|-0.139||||||||||||||||||||||||10.189|1.691|0.36||||||
new_0222_0194|BLI|201912|105.347|81.033|7.181|24.257||47.226|24.919|22.307||-140.986|-150.3||||||||||0.2366||||14.568|3.239|224.769|||||||53.5102||-0.0647|5.829|||60.9439||3.8365|-0.0647||-0.3784||-18.302|56.693||16.622|12.389|-3.45|-3.464|-0.175||||||||||||||||||||||||9.84|1.694|0.361|||27.295|3.504||
new_0222_0194|BLI|202003|98.25|70.306|10.678|23.182||46.098|18.639|27.459||76.68|-158.725||||||||||0.2588||||14.462|4.366|0.003|||||||53.5102|210|-0.1574|7.231|||64.3588||4.5479|-0.1574||-0.2939||-22.522|57.83||13.778|9.979|-8.409|-8.425|-0.206||||||||||||||||||||||||10.976|1.787|0.357|||27.26|3.771||
new_0222_0194|BLI|202006|90.375|59.17|11.908|27.757||53.373|22.572|30.801||-158.724|-171.155||70.7632||-128.0797||58.6281||||0.3007|||0.1589|14.283|4.27|224.769|-30.1712|7|||||60.9439||-0.204|7.269|63.7366||60.9439||3.2542|-0.204||-0.2055||-28.767|56.636||10.569|6.962|-12.422|-12.43|-0.309|59.97|59.97|4007.7429|204288.1333||101309|||||-0.2034|10.3417|4.1392|2.1982|-0.195|10.569|58.7823|85.025|70|1.75|2|-0.7792|-0.5983|11.843|0.832|0.356|||32.817|3.713|65.4|
new_0222_0194|BLI|202009|271.456|237.233|12.839|27.3||49.427|23.791|25.636||250.583|-179.756||79.3735|-142.6817|-140.2826|15.6564|71.4738||19.612||0.0793||-3.959|1.0047|15.243|4.178|0.003|-23.6622|5|||-477.9153|53.8853|53.597||-0.16|10.57|64.3588||64.3588||10.6122|-0.16|-190.585|-0.4761|-477.9153|-32.92|59.177||18.208|12.808|-8.483|-8.601|-0.31|76.36|76.36|4697.083|162432.7667||646595|||||-0.27|15.25|40.7407|19.3967|-0.16|18.208|58.7823|85.016|92.3333|1.75|3|-0.7792|-0.5958|10.421|1.283|0.361|||33.058|3.77|72.57|82.86
new_0222_0194|BLI|202012|265.569|233.408|11.047|31.262||54.877|28.968|25.909||244.781|-191.884||86.3443|-133.5177|-141.8512|18.5284|80.8328||23.5546|-1.1637|0.0813||-3.3745|2.8368|14.249|3.491|0.003|-25.3198|6|||-76.3474|63.5443|64.4862|85|-0.19|12.639|64.4862||64.4862||8.5493|-0.19||-0.4202|-76.3474|-41.584|64.303||21.748|14.806|-12.096|-12.128|-0.273|89.41|89.41|5552.1981|463434.4667||1829330|||63.4915|46.5784|-0.1931|19.04|1.6054|14.2227|-0.19|21.748|61.7756|125.2081|95.5|1.5|4|-1.085|-0.5655|14|2.891|0.362|||37.836|3.892|72|61.97
new_0222_0194|BLI|202103|265.778|230.165|10.941|33.375||60.585|39.608|20.977||242.366|-207.319||45.1788|-64.2929|-77.8048|10.3127|44.36||13.7581|-0.7138|0.0822||-5.7161|3.7877|17.839|6.934|0.004|-24.7968|5|||-37.0558|87.6137|65.2594||-0.24|14.573|66.3847||66.3847||6.2615|-0.24||-0.3614|-37.0558|-48.594|69.153||18.628|12.451|-15.418|-15.435|-0.288|50.23|50.23|3124.2505|1413254.8667||2514426|||36.7192|26.9379|-0.2203|16.76|-8.9226|11.1456|-0.24|18.628|86.4|135.1552|74.25|1.5|4|-0.8567|-0.7791|13.027|1.84|0.354|||40.518|4.052|49.11|43.5
new_0222_0194|BLI|202106|255.524|215.077|12.572|36.563||63.875|27.486|36.389||231.839|-225.473||36.0873|-51.7106|-61.9733|9.4984|36.0012||12.9582|-0.7566|0.0849||-6.3428|5.5117|21.535|8.727|0.004|-23.9322|5|2|0.7397|-33.4947||66.7908||-0.27|17.042|67.0435||67.0435||8.6085|-0.27||-0.3566|-33.4947|-54.318|77.834||19.25|12.728|-18.128|-18.154|-0.313|44.81|44.81|2808.8152|930716.5667|-22.2184|3695260|||33.0822|24.2697|-0.2337|19.635|-15.5179|-1.9608|-0.27|19.25|93.2834|132.4247|79.5|1.7143|4|-0.8576|-0.7801|13.535|0.814|0.356|||42.448|4.52|45.58|35.56
new_0222_0194|BLI|202109|245.912|197.001|13.21|51.784||80.969|34.314|46.655||220.185|-245.876||13.6056|-17.2745|-21.2492|3.7927|15.3631||5.9924|-0.277|0.0897||0.0017|10.3285|26.402|12.822|0.004|-25.6506|4|2|2.7233|-27.7873|98.6302|67.2133||-0.3|19.198|67.4562||67.4562||6.5105|-0.3||-0.1955|-27.7873|-66.12|83.95||24.324|15.413|-20.349|-20.403|-0.199|19.56|19.56|1142.1883|2344296.4667|-74.3845|6967187|||14.5296|10.6592|-0.226|23.475|-32.7551|3.6166|-0.3|24.324|91.0152|130.5167|66.8|1.7143|5|-0.8695|-0.7383|16.195|1.303|0.232|||57.525|4.754|23.25|20.87
new_0222_0194|BLI|202112|||||||||||||12.5007||-19.5236||14.2792||5.5712|-0.2575||||8.5773||||||1|3.5879||89.7782||||||||||||||||||||||18.18|18.18|1049.435|918471.0667|-79.6667|5787510|||10.0936|7.6783|-0.263|22.05|||||84.2069|152.9264|49.6|1.625|5|-0.9914|-0.6238||||||||9.71|6.86
new_0222_0194|BLI|202203|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||-0.285|23.975||||||||||||||||||||
new_0222_0194|BLI|202206|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||-0.2767|26.2267||||||||||||||||||||
new_0222_0194|BLI|202209|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||-0.2633|29.44||||||||||||||||||||
new_0222_0194|BLI|202212|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||-0.27|31.8||||||||||||||||||||