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.1666666667|91.1666666667|0|0|91.1666666667|91.1666666667|91.1666666667|91.1666666667|0|91.1666666667|91.1666666667|91.1666666667|1.44391408115|91.25|1.44391408115|91.25|1.44391408115|1.44473007712|1.44391408115|0|91.1666666667|1.46551724138|0|15.2631578947|91.1666666667|91.1666666667|91.1666666667|91.25|0|30.6666666667|30.7142857143|91.25|0|91.3333333333|366|91.3333333333|28.2666666667|0|91.1666666667|91.1666666667|91.1666666667|91.3333333333|91.375|91.1666666667|91.25|91.1666666667|91.1666666667|91|91.3333333333|0|91.3333333333|91.3333333333|91.3333333333|91.3333333333|1.44391408115|1.44391408115|1.44391408115|1.44358974359|1.4371257485||
new_0222_0031|RPRX|6|6|6|0|0|6|6|6|6|0|6|6|6|419|4|419|4|419|389|419|0|6|58|0|38|6|6|6|4|0|6|7|4|0|9|1|9|15|0|6|6|6|9|8|6|4|6|6|3|9|0|9|9|9|9|419|419|419|390|167||
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|0||||||457.608||30.349|178.77|151.713|-64.694|||||||
new_0222_0031|RPRX|201909||||||||||||||||||||||||||||||||||354.1756||1.1547||||||1.2125|0||||||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|||595.383|31.4782|2.4953|3.4871|0|0||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|||||||595.383||0.1197|||595.383|33.2979|4.0045|0.4331||0||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|19.2815|15.9142|20.0704|2.3768|10.4059|9.0328|7.0902||1.4221|||0.5506|35.454|157.137|0.1|17.2231||||33.3428||353.98||0.09|607.106||607.106|26.8316|7.4905|-0.4596|-1918.229|0|45.57|2342.692|1933.574||510.932||42.799|601.976|442.074|-31.465|48.55|47.4132|37282.1273|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|16.9186|15.2707|20.3734|2.1242|8.767|8.3971|5.7372||1.3055|||1.8699|36.761|159.983|0.1|15.7708||||34.3933|67.1398|370.002||0.79|607.11||607.11|23.1743|10.2579|0.3761|8.578|0|44.7679|2224.342|2007.696|0.15|538.399||50.732|624.254|290.632|-29.857|42.07|41.2453|33967.3077|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|18.2017|39.6193|18.9865|2.4113|10.1279|39.0614|6.3057||1.2071|||3.4043|39.166|155.741|0.102|6.759||||11.6874||398.517|51|0.2817|607.111||607.111|40.8027|8.7315|0.1248|0.907|0|19.7431|975.04|2122.353|0.15|572.143||50.119|366.628|171.094|-16.632|50.05|49.2503|38630.3896|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|15.8983|35.8599|16.6962|2.1923|8.595|32.5119|5.4242||1.1923|||4.6179|39.995|135.712|0.102|6.4511||||13.8661||607.148||0.18|607.112||607.112|33.1014|9.4122|0.2584||0|20.727|972.919|2194.501|0.17|573.027||43.156|158.979|69.119|-20.817|43.62|43.0776|34888.7434|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.077|17.5797|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|0|0|20.2054|971.621|2238.532|0.17|554.963||44.921|806.755|440.776|-23.389|40.99|40.6467|25349.7019|2386661.5|-15.5716|38.2|38.65
new_0222_0031|RPRX|202109|||||||||||||10.3991||10.917||8.003|15.4997|2.6915|||1.7098||1.9631||||||3|1.695||||||||||||||||||||||||36.14|35.9954|23278.7192|2706086.4333|-14.0956|39.53|39.77
new_0222_0031|RPRX|202112|||||||||||||11.1068||11.6599||8.8245|17.1895|2.9678|||1.7064||1.3616||||||4|0.9638||||||||||||||||||||||||39.85|39.85|24862.9111|2107268.9667|-20.3796|40.01|39.86