new_0222_0510|APG|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_0510|APG|1|APi Group Corp Total Current Assets (Quarterly) (USD)|APi Group Corp Cash and Short Term Investments (Quarterly) (USD)|APi Group Corp Inventories (Quarterly) (USD)|APi Group Corp Net PP&E (Quarterly) (USD)|APi Group Corp Goodwill and Intangibles (Quarterly) (USD)|APi Group Corp Total Liabilities (Quarterly) (USD)|APi Group Corp Total Current Liabilities (Quarterly) (USD)|APi Group Corp Total Long Term Liabilities (Quarterly) (USD)|APi Group Corp Total Deposits (Quarterly) (USD)|APi Group Corp Book Value (Quarterly) (USD)|APi Group Corp Retained Earnings (Quarterly) (USD)|APi Group Corp Treasury Stock (Quarterly) (USD)|APi Group Corp EV to Revenues|APi Group Corp EV to Earnings|APi Group Corp EV to Free Cash Flow|APi Group Corp EV to Assets (Quarterly)|APi Group Corp PS Ratio|APi Group Corp PE Ratio|APi Group Corp Price to Book Value|APi Group Corp PEG Ratio|APi Group Corp Debt to Equity Ratio|APi Group Corp Dividend Yield|APi Group Corp Shareholder Yield (TTM)|APi Group Corp Percent of Shares Outstanding Short|APi Group Corp Total Receivables (Quarterly) (USD)|APi Group Corp Total Payables (Quarterly) (USD)|APi Group Corp Total Capital Stock (Quarterly) (USD)|APi Group Corp Return on Invested Capital|APi Group Corp Quality Ratio Score|APi Group Corp Momentum Score|APi Group Corp Beta (1Y)|APi Group Corp Sustainable Growth Rate (TTM)|APi Group Corp Institutional Investor Ownership Percentage|APi Group Corp Average Diluted Shares Outstanding (Quarterly)|APi Group Corp Total Employees (Annual)|APi Group Corp EPS Diluted (Quarterly) (USD)|APi Group Corp SG&A Expense (Quarterly) (USD)|APi Group Corp Shares Outstanding|APi Group Corp Repurchase of Capital Stock (Quarterly) (USD)|APi Group Corp Ordinary Shares Number (Quarterly)|APi Group Corp Payout Ratio|APi Group Corp Quick Ratio (Quarterly)|APi Group Corp Normalized Diluted EPS (Quarterly) (USD)|APi Group Corp Stock Buybacks (Quarterly) (USD)|APi Group Corp Effective Tax Rate (TTM)|APi Group Corp Return on Equity|APi Group Corp Net Income (TTM) (USD)|APi Group Corp Revenue (TTM) (USD)|APi Group Corp Dividend Per Share (Quarterly) (USD)|APi Group Corp Revenue (Quarterly) (USD)|APi Group Corp Gross Profit (Quarterly) (USD)|APi Group Corp Pre-Tax Income (Quarterly) (USD)|APi Group Corp Net Income (Quarterly) (USD)|APi Group Corp Net Interest Income (Quarterly) (USD)|APi Group Corp Price (USD)|APi Group Corp Total Return Price (USD)|APi Group Corp Enterprise Value (USD)|APi Group Corp 30-Day Average Daily Volume|APi Group Corp 1 Year Price Returns (Daily)|APi Group Corp Short Interest|APi Group Corp PE Ratio (Forward)|APi Group Corp PE Ratio (Forward 1y)|APi Group Corp PS Ratio (Forward)|APi Group Corp PS Ratio (Forward 1y)|APi Group Corp Quarterly EPS Estimates (USD)|APi Group Corp Quarterly Revenue Estimates (USD)|APi Group Corp Quarterly EPS Surprise|APi Group Corp Quarterly Revenue Surprise|APi Group Corp Quarterly Actual EPS (USD)|APi Group Corp Quarterly Actual Revenue (USD)|APi Group Corp Revenue Estimates for Current Fiscal Year (USD)|APi Group Corp Revenue Estimates for Next Fiscal Year (USD)|APi Group Corp Price Target (USD)|APi Group Corp Consensus Recommendation|APi Group Corp Price Target Num Estimates|APi Group Corp EPS Estimates for Current Fiscal Year (USD)|APi Group Corp EPS Estimates for Next Fiscal Year (USD)|APi Group Corp Research and Development Expense (Quarterly) (USD)|APi Group Corp Reconciled Depreciation (Quarterly) (USD)|APi Group Corp Non-Operating Interest Expense (Quarterly) (USD)|APi Group Corp Land and Improvements (Quarterly) (USD)|APi Group Corp Buildings and Improvements (Quarterly) (USD)|APi Group Corp Other Properties (Quarterly) (USD)|APi Group Corp Machine, Furniture & Equipment (Quarterly) (USD)||
new_0222_0510|APG|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_0510|APG|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|quarterly|monthly|daily|quarterly|daily|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|monthly|monthly|monthly|monthly|daily|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_0510|APG|5|131|131|104.428571429|104.428571429|104.428571429|131|131|131||131|131||1.44444444444|91.4|1.44755244755|104.428571429|1.44444444444||7.75935828877|1.43827160494|104.428571429|1.63459570113||15.2619047619|131|104.428571429|131|91.4|91.4|32.1666666667|30.4615384615|91.4||102.875||102.875|102.875|49.6666666667||131|91.4|104.428571429|102.875||91.4|91.4|91.4|91.4||102.875|102.875|102.875|102.875|102.875|7.82843137255|7.82843137255|7.63684210526|7.33962264151|7.2899408284|15.2619047619|1.44712430427|1.44712430427|1.44712430427|1.44712430427|91.3333333333|91.3636363636|91.2857142857|91.3333333333|91.2857142857|91.3333333333|16.0192307692|21.9210526316|17.4255319149|9.83720930233|17.4255319149|11.7323943662|14.6140350877||91.3333333333|102.875|91.3333333333|91.3333333333|104.428571429|91.3333333333||
new_0222_0510|APG|6|10|10|7|7|7|10|10|10||10|10||414|5|286|7|414||187|162|7|977||42|10|7|10|5|5|36|39|5||8||8|8|30||10|5|7|8||5|5|5|5||8|8|8|8|8|204|204|190|212|169|42|539|539|539|539|12|11|7|6|7|6|52|38|47|86|47|71|57||6|8|6|6|7|6||
new_0222_0510|APG|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_0510|APG|201709||||||||||||||||||||||||||||||||||||||121.0325|||||||||||||||||9.62|9.62||3639.5|||||||||||||||||||||||||||9.84|10
new_0222_0510|APG|201712|||||||||||||||||||||||||||||||||||||||||||||||||||||||9.71|9.71||1283.3333||||||||||||||||||||||||||||
new_0222_0510|APG|201801.85037406484|1232.3126|1232.0343||||1.2187|0.0083|1.2103||1191.0939|3.5463||||||||0.9653||||||0.0008||1227.5476|||||||||||121.0325||121.0325|||||||||||||||9.5|9.5|-42.2256|66998.3333||||||||||||||||||||||||||||
new_0222_0510|APG|201803|||||||||||||||||||0.9755||||||||||||||||||||||||||||||||||||9.6|9.6|-30.1223|66751.1667|||||||||||||||||||||||||||9.45|9.8
new_0222_0510|APG|201800|||||||||||||||||||0.9653||||||||||||||||||||||||||||||||||||9.5|9.5|-42.2256|66748.3333||||||||||||||||||||||||||||
new_0222_0510|APG|201806|1242.1483|1242.0307||||1.3497|0.1394|1.2103||1200.7986|13.251||||||||0.9958||||||0.0087||40|||||||||||121.0325||121.0325|||||||||||||||9.8|9.8|-5.9158|66.6667|||||||||||||||||||||||||||9.1|
new_0222_0510|APG|201809|||||||||||||||||||0.9172|||||||||||5|-0.0656||||||||||||||||||||||||9.1|9.1|-100.635|4.1667|-12.5||||||||||||||||||||||||||9.1|9.1
new_0222_0510|APG|201812|||||||||||||||||||0.9071|||||||||||6|-0.0155||||||||||||||||||||||||9|9|-112.7382|83.3333|-7.2165|||||||||||||||||||||||||||
new_0222_0510|APG|201901.85037406484|1254.0009|1253.9354||||1.2103||1.2103||1212.7906|25.243||||||||0.9071||||||0.0232||1227.5476|||6|-0.0345|||||||121.0325||121.0325|||||||||||||||9|9|-112.7382||-5.2632|||||||||||||||||||||||||||
new_0222_0510|APG|201903|||||||||||||||||||0.8982|||||||||||5|-0.022|||169.9023||0.4379|145||||||0.4324|||||||1067|208|57|53|-7|9|9|-124.6429|39341.2667|-6.25|||||||||||||||||||||7|||||8.85|8.75
new_0222_0510|APG|201900|||||||||||||||||||0.8982|||||||||||5|-0.0277||||||||||||||||||||||||9|9|-124.6429|39307.9333|-5.2632|||||||||||||||||||||||||||
new_0222_0510|APG|201906|1293.11|133.61|60.325|331.123|432.885|1507.134|1116.422|390.712||597.004||||||0.8186|||0.8583||1.1119||||1072.34|190.404||||5|-0.0086|||169.9023||0.0991|208|||169.9023||1.0802|0.119|||||||1118|233|14|12|-7|8.6|8.6|-173.0559|2400|-12.2449|||||||||||||||||||||7|||331.123||9.21|10
new_0222_0510|APG|201909|||||||||||||||||||2.789|||||||||||8|-0.0634|||||||169.9023|||||||||||||||||9.8|9.8|2212.3638|33749.6667|7.6923||9.089|10.3131|0.5126|0.475|0.26||34.6154||0.35||3955|4100|14|2|1|1.03|1.11||||||||9.7|9.72
new_0222_0510|APG|201912|||||||||||||||||||3.287|||||||||||6|-0.2167||||||||||||||||||||||||11.55|11.55|2526.683|767057.4|28.3333||10.1228|11.4862|0.5709|0.5291|||||||4100||14|2|1|1.11||||||||||
new_0222_0510|APG|202001.85037406484|||||||||||||||||||3.2671|||||||||||8|0.2994||||||||||||||||||||||||11.15|11.15|2390.7612|900838.4|23.8889||9.4336|10.7041|0.532|0.493||||||||||||||||||||||
new_0222_0510|APG|202003|1394|377|60|467|1799|2205|821|1384||1565|-316||0.7276|-30.7626||0.7589|0.5298||1.1545||0.7546|||0.9326|891|155||-4.0342|6|5|2.1277|-7.6222||176||0.17|147|169.2942||169.2942||1.5445|0.1244||38|-7.6222|-93|3932||889|174|24|36|-14|10.4|10.4|2634.1702|692917.3667|15.5556|1578899|8.7013|9.8732|0.4889|0.4531|0.1186|727.695|169.9055|16.6698|0.32|849|3520|3723.8624|12|1.5|2|0.7092|1.0743||74|14|22|57|102|332|11.01|13.16
new_0222_0510|APG|202000|1450|436|59|500|1836|2361|919|1442||1525|-355|||||0.5489|||2.0064||0.9075||||913|152||||9|1.4376|||170||-1.14|188|169.2942||169.2942||1.4679|-0.1861|||||||858|162|-245|-194|-14|7.05|7.05|1634.696|428867.7667|-21.6667||6.0306|6.8428|0.3389|0.3141|0.0805|861.7875|61.4305|-4.8489|0.13|820|3520|3667.4|14|2|1|1.11|1.02||70|14|20|64|103|319||
new_0222_0510|APG|202006|1504|467|57|452|1772|2228|834|1394||1598|-288||0.8042|-26.2321||0.8159|0.6074||1.4907||0.7359|||3.2979|906|142||-4.9123|5|9|2.5331|-9.157||182||0.13|171|169.2942||169.5442||1.6463|0.0618||21.7105|-9.157|-119|3823||958|222|55|27|-13|13.78|13.78|3048.8411|2375177.2|60.2326|5583180|12.0009|13.6172|0.6744|0.625|0.3015|949.2115|29.3532|0.3991|0.39|953|3550.6435|3817.4536|15|1.25|4|0.8938|1.0868||52|13|26|74|98|317|14.56|14.23
new_0222_0510|APG|202009|1437|515|64|462|2047|2507|841|1666||1558|-298||0.8236|-25.8118|8.6227|0.9715|0.6567||1.4737||0.9082|||3.0421|781|150||-6.0412|6|9|2.2597|-11.1793||166||-1.44|219|169.7942||168||1.541|-1.5016||16.8478|-11.1793|-153|3587||882|198|-18|-22|-11|13.89|13.89|3186.0408|889692.2333|40.303|5157767|12.3972|14.0669|0.6977|0.6466|0.3118|875.0425|9.0548|0.7951|0.34|882|3517.733|3881.6476|18.8|1.4|5|0.9801|1.1515||67|11|26|76|107|333|15.85|17.85
new_0222_0510|APG|202012|||||||||||||1.1753||9.2047||0.8663||2.1353|||||3.0638||||||9|2.0605||||13000|||185.1341|||||||||||||||||17.97|17.97|4349.3531|904779.9|50.2508|5672119|17.5078|15.013|0.8787|0.6834|||||||3881.0837|4108.2228|21.8|1.4|5|1.2721|1.389|||||||||
new_0222_0510|APG|202101.85037406484|||||||||||||1.2824||10.0437||0.8948||2.4281|||||1.832||||||8|2.2303|||||||200|||||||||||||||||19.34|19.34|4592.928|1005947.6|61.3011|3663976|18.0846|15.5075|0.9806|0.7626|||||||3807.333|4059.3927|22|1.4|5|1.2278|1.3665|||||||||
new_0222_0510|APG|202103|1685|686|69|453|1991|2415|730|1685||1828|-277||1.3987|276.8272|11.5427|1.1744|1.0774||2.3893|-0.0868|0.8042|||2.236|848|180||0.6002|6|8|0.6608|1.0791||206||0.09|185|201.2822||201||2.1014|0.1004||66.0377|1.0791|18|3621||978|232|30|21|-14|21.29|21.29|4968.4|994414.6667|107.0192|4494406|20.7826|17.8211|1.1325|0.8808|0.3089|937.1786|0.3658|4.3558|0.31|978|3732.1667|3972.0363|24.4|1.4|5|1.1923|1.3364||52|14|27|81|105|354|20.33|20.89
new_0222_0510|APG|202100|1633|745|66|459|2008|2427|781|1646||1791|-311||1.3657|146.1721|11.2703|1.1436|1.0481||2.3209||0.7884|||1.9763|747|167||1.1298|5|7|1.7046|2.053||192||-0.04|183|201||201||1.9104|-0.0514||29.7872|2.053|33|3532||803|181|-14|-8|-15|20.68|20.68|4909.029|1020234.6|164.8227|3972298|20.2156|17.3349|1.1016|0.8567|0.1385|767.2819|-13.3574|4.6551|0.12|803|3710.0936|3933.1366|23.2|1.4|5|1.1864|1.3289||50|15|26|82|106|342||
new_0222_0510|APG|202106|2239|1128|71|439|1996|2486|792|1694||2297|-262||1.4934|490.04|23.7182|1.0245|1.1805||2.5305|-0.0952|0.64|||2.1926|947|205||0.3122|4|7|0.5867|0.5511||209||0.08|211|201.7343||224||2.6199|0.0712||64.2857|0.5511|10|3710||1047|252|30|19|-14|22.93|22.93|5274.6055|981355.2333|68.1422|4423257|22.4053|19.2126|1.2254|0.953|0.345|1036.4707|1.461|1.0159|0.35|1047|3732.1667|3972.0363|25|1.5|4|1.1471|1.3312||52|14|26|77|102|367|23.2|20.88
new_0222_0510|APG|202109|||||||||||||1.4072||29.3299||1.1345||2.0869|-0.2164||||1.9025||||||7|1.2911|||||||224.6252|||||||||||||||||21.4|21.4|5299.12|1502659.1|56.0835|4261577|21.2909|18.257|1.2929|1.0055|0.2647|965.8097|||||3759.0081|4066.361|24.8|1.5|5|1.0633|1.2026||||||||24.5|25.53
new_0222_0510|APG|202112|||||||||||||1.4424||30.0626||1.1616||2.123|-0.2216||||1.8361||||||8|1.7514||||||||||||||||||||||||21.89|21.89|5259.0456|767158.2|17.4356|4262882|16.0698|14.023|0.7919|0.7552|||||||6325.1987|6632.4301|29|1.8|6|1.3877|1.5902|||||||||
new_0222_0510|APG|202201.85037406484|||||||||||||1.3618||28.3842||1.0923||2.0507|-0.2084|||||||||||||||||||||||||||||||||||20.97|20.97|5052.3904|842572.4667|9.5039||15.1113|13.1867|0.7447|0.7102||||||||||1.8||||||||||||
new_0222_0510|APG|202203|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.3669|1616.3197||||||||||||||||||||
new_0222_0510|APG|202200|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.2024|1427.793||||||||||||||||||||
new_0222_0510|APG|202206|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.445|1709.2247||||||||||||||||||||
new_0222_0510|APG|202209|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.3708|1619.5642||||||||||||||||||||
new_0222_0510|APG|202212||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||