new_0222_0031|RPRX|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_0031|RPRX|1|Royalty Pharma PLC Total Current Assets (Quarterly) (USD)|Royalty Pharma PLC Cash and Short Term Investments (Quarterly) (USD)|Royalty Pharma PLC Inventories (Quarterly) (USD)|Royalty Pharma PLC Net PP&E (Quarterly) (USD)|Royalty Pharma PLC Goodwill and Intangibles (Quarterly) (USD)|Royalty Pharma PLC Total Liabilities (Quarterly) (USD)|Royalty Pharma PLC Total Current Liabilities (Quarterly) (USD)|Royalty Pharma PLC Total Long Term Liabilities (Quarterly) (USD)|Royalty Pharma PLC Total Deposits (Quarterly) (USD)|Royalty Pharma PLC Book Value (Quarterly) (USD)|Royalty Pharma PLC Retained Earnings (Quarterly) (USD)|Royalty Pharma PLC Treasury Stock (Quarterly) (USD)|Royalty Pharma PLC EV to Revenues|Royalty Pharma PLC EV to Earnings|Royalty Pharma PLC EV to Free Cash Flow|Royalty Pharma PLC EV to Assets (Quarterly)|Royalty Pharma PLC PS Ratio|Royalty Pharma PLC PE Ratio|Royalty Pharma PLC Price to Book Value|Royalty Pharma PLC PEG Ratio|Royalty Pharma PLC Debt to Equity Ratio|Royalty Pharma PLC Dividend Yield|Royalty Pharma PLC Shareholder Yield (TTM)|Royalty Pharma PLC Percent of Shares Outstanding Short|Royalty Pharma PLC Total Receivables (Quarterly) (USD)|Royalty Pharma PLC Total Payables (Quarterly) (USD)|Royalty Pharma PLC Total Capital Stock (Quarterly) (USD)|Royalty Pharma PLC Return on Invested Capital|Royalty Pharma PLC Quality Ratio Score|Royalty Pharma PLC Momentum Score|Royalty Pharma PLC Beta (1Y)|Royalty Pharma PLC Sustainable Growth Rate (TTM)|Royalty Pharma PLC Institutional Investor Ownership Percentage|Royalty Pharma PLC Average Diluted Shares Outstanding (Quarterly)|Royalty Pharma PLC Total Employees (Annual)|Royalty Pharma PLC EPS Diluted (Quarterly) (USD)|Royalty Pharma PLC Shares Outstanding|Royalty Pharma PLC Repurchase of Capital Stock (Quarterly) (USD)|Royalty Pharma PLC Ordinary Shares Number (Quarterly)|Royalty Pharma PLC Payout Ratio|Royalty Pharma PLC Quick Ratio (Quarterly)|Royalty Pharma PLC Normalized Diluted EPS (Quarterly) (USD)|Royalty Pharma PLC Stock Buybacks (Quarterly) (USD)|Royalty Pharma PLC Effective Tax Rate (TTM)|Royalty Pharma PLC Return on Equity|Royalty Pharma PLC Net Income (TTM) (USD)|Royalty Pharma PLC Revenue (TTM) (USD)|Royalty Pharma PLC Dividend Per Share (Quarterly) (USD)|Royalty Pharma PLC Revenue (Quarterly) (USD)|Royalty Pharma PLC Gross Profit (Quarterly) (USD)|Royalty Pharma PLC SG&A Expense (Quarterly) (USD)|Royalty Pharma PLC Pre-Tax Income (Quarterly) (USD)|Royalty Pharma PLC Net Income (Quarterly) (USD)|Royalty Pharma PLC Net Interest Income (Quarterly) (USD)|Royalty Pharma PLC Price (USD)|Royalty Pharma PLC Total Return Price (USD)|Royalty Pharma PLC Enterprise Value (USD)|Royalty Pharma PLC 30-Day Average Daily Volume|Royalty Pharma PLC 1 Year Price Returns (Daily)||
new_0222_0031|RPRX|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_0031|RPRX|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|quarterly|quarterly|daily|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|quarterly|quarterly|yearly|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_0031|RPRX|5|91.375|91.375|||91.375|91.375|91.375|91.375||91.375|91.375|91.375|1.44469525959|91.5|1.44469525959|91.5|1.44469525959|1.44469525959|1.44469525959||91.375|1.46341463415||15.2|91.375|91.375|91.375|91.5||30.2857142857|30.375|91.5||91.4545454545|365.5|91.4545454545|32.2631578947||91.375|91.375|91.375|91.4545454545|91.5|91.375|91.5|91.375|91.375|91.4|91.4545454545||91.4545454545|91.4545454545|91.4545454545|91.4545454545|1.44469525959|1.44469525959|1.44469525959|1.44444444444|1.43979057592||
new_0222_0031|RPRX|6|8|8|||8|8|8|8||8|8|8|443|6|443|6|443|443|443||8|82||40|8|8|8|6||7|8|6||11|2|11|19||8|8|8|11|10|8|6|8|8|5|11||11|11|11|11|443|443|443|414|191||
new_0222_0031|RPRX|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_0031|RPRX|201903||||||||||||||||||||||||||||||||||354.1756||1.0375||||||0.9587|||||||434.883||24.426|396.094|367.444|-57.239|||||||
new_0222_0031|RPRX|201906||||||||||||||||||||||||||||||||||354.1756||0.4284||||||0.6435|||||||457.608||30.349|178.77|151.713|-64.694|||||||
new_0222_0031|RPRX|201909||||||||||||||||||||||||||||||||||354.1756||1.1547||||||1.2125|||||||464.277||25.603|440.027|408.982|-64.215|||||||
new_0222_0031|RPRX|201912|832.072|793.214|||51.724|6308.457|333.417|5975.04||6105.555|2825.212|4.266|||||||||1.0217||||38.766|42.218|3282.516|||||||354.1756|35|4.0104|||350.5548|31.4782|2.4953|3.4871||||2348.535|1814.254||457.486||23.061|1446.528|1420.396|-60.096|||||||
new_0222_0031|RPRX|202003|1737.837|1696.204|||45.991|6208.919|433.961|5774.958||5159.918|2561.971|4.266|||||||||1.1545||||41.581|141.833|2553.001|||||||350.5548||0.2032|||350.5548|33.2979|4.0045|0.7356||||2052.331|1880.25||500.879||38.065|109.096|71.24|-50.726|||||||
new_0222_0031|RPRX|202006|3390.789|3342.546|||40.258|6290.595|450.973|5839.622||4157.132|1571.399|2.119|13.225|10.9154|13.7661|1.6303|8.869|8.8946|4.2732||1.4221|||0.5506|35.454|157.137|0.1|17.2231||||33.3428||353.98||0.09|365.899||365.899|26.8316|7.4905|-0.4596|-1918.229||45.57|2342.692|1933.574||510.932||42.799|601.976|442.074|-31.465|48.55|47.1907|25571.5275|1593161.9667||43.05|41.38
new_0222_0031|RPRX|202009|2783.851|2732.692|||34.462|6192.03|269.983|5922.047||4451.813|1807.146|2.155|11.9501|10.7862|7.6501|1.5004|7.4844|8.2593|3.4965||1.3055|||1.8699|36.761|159.983|0.1|15.7708||||34.3933||370.002||0.79|370.002||370.002|23.1743|10.2579|0.3761|8.578||44.7679|2224.342|2007.696|0.15|538.399||50.732|624.254|290.632|-29.857|42.07|41.0518|23992.1741|1028687.1||36.7|42.6
new_0222_0031|RPRX|202012|2696.898|2649.136|||28.666|6124.471|307.887|5816.584||4818.779|1920.635|2.317|13.0377|28.379|13.5998|1.7272|8.6847|32.8458|4.0313||1.2071|||3.4043|39.166|137.141|0.102|6.759||||11.6874||398.552|51|0.4406|388.135||388.135|40.8027|8.7315|0.2837|0.907||19.7431|975.04|2122.353|0.15|572.143||50.119|366.628|171.094|-16.632|50.05|49.0193|27670.6408|2674242.4||47.01|46.57
new_0222_0031|RPRX|202103|2416.024|2369.372|||22.995|6077.055|255.983|5821.072||4882.215|1923.771|2.359|11.6395|26.2539|12.2237|1.6051|8.5952|29.069|3.51||1.1923|||4.6179|39.995|135.712|0.102|6.4511||||13.8661||607.148||0.18|392.857||392.857|33.1014|9.4122|0.2584|||20.727|972.919|2194.501|0.17|573.027||43.156|158.979|69.119|-20.817|43.62|42.8755|25542.9403|4046193.5||44|40.12
new_0222_0031|RPRX|202106|2707.454|2650.519|||17.262|6109.548|283.989|5825.559||5733.679|2291.966|2.662|11.3243|26.0901|11.8882|1.535|9.0771|16.4581|3.0527||1.016|||2.1924|44.837|126.771|0.105|6.1872||2|0.9878|14.9846||607.163||1.08|427.006||427.006|25.8385|9.4911|0.9687|||20.2054|971.621|2238.532|0.17|554.963||44.921|806.755|440.776|-23.389|40.99|40.456|25349.7019|2386661.5|-15.5716|38.2|38.65
new_0222_0031|RPRX|202109|2775.761|2693.315|||11.466|7345.724|255.055|7090.669||5793.07|2320.878|2.685|10.7237|31.3104|11.7107|1.3824|8.7747|18.6234|2.6795||1.224|1.7098||1.9631|73.501|128.322|0.106|4.8514||3|1.695|10.0027||607.174||0.24|429.511||429.511|34.3824|10.8479|0.3242|||15.244|782.918|2285.906|0.17|585.773||48.588|221.796|101.929|-32.066|36.14|35.8265|24513.4455|2706086.4333|-14.0956|39.53|39.77
new_0222_0031|RPRX|202112|2878.211|2803.271|||5.67|7267.32|171.25|7096.07||5776.594|2255.179|2.715|11.3947|42.0955|12.9305|1.4894|9.8177|26.5667|2.9988||1.2284|1.7064|0.224|1.3453|68.309|113.554|0.106|3.7594||4|0.9638|6.1943||434.7051|66||434.7051||434.7051|46.0176|16.7684|0.0473|||11.4746|619.728|2289.463|0.17|575.7||46.161|53.671|7.904|-36.335|39.85|39.663|26087.7482|2107272.4667|-20.3796|40.01|39.26
new_0222_0031|RPRX|202203|||||||||||||11.2941||12.8163||9.6871|26.2133|2.9589|||1.7803|||||||||||||||||||||||||||||||||39.32|39.32|25857.3742|1352317.4|-15.4409||