pinktest_usa_3001|RYDAF|Short Name|pe_ratio|shareholder_yield_ttm|enterprise_value|cash_on_hand|average_volume_30|one_year_return|price|ps_ratio|market_beta_12_month|total_deposits|dividend_yield|average_shares_outs_diluted|price_next_month|price_second_month
pinktest_usa_3001|RYDAF|Long Name|Royal Dutch Shell PLC PE Ratio|Royal Dutch Shell PLC Shareholder Yield (TTM)|Royal Dutch Shell PLC Enterprise Value (USD)|Royal Dutch Shell PLC Cash and Short Term Investments (Quarterly) (USD)|Royal Dutch Shell PLC 30-Day Average Daily Volume|Royal Dutch Shell PLC 1 Year Price Returns (Daily)|Royal Dutch Shell PLC Price (USD)|Royal Dutch Shell PLC PS Ratio|Royal Dutch Shell PLC Beta (1Y)|Royal Dutch Shell PLC Total Deposits (Quarterly) (USD)|Royal Dutch Shell PLC Dividend Yield|Royal Dutch Shell PLC Average Diluted Shares Outstanding (Quarterly)||
pinktest_usa_3001|RYDAF|Unit|figure_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_USD_metric|percent_USD_metric|figure_money_USD_price|figure_USD_metric|figure_USD_beta|mil_figure_money_USD_metric|percent_USD_metric|mil_figure_USD_metric||
pinktest_usa_3001|RYDAF|200406||||3244||||||||||
pinktest_usa_3001|RYDAF|200409||||3948||||||||6561.8||
pinktest_usa_3001|RYDAF|200412||||9201.001||||||||6528.8||
pinktest_usa_3001|RYDAF|200503||||8888||||||||6776.396||
pinktest_usa_3001|RYDAF|200506||||11520||||||||6744.1022||
pinktest_usa_3001|RYDAF|200509||||15998||||||||6702.0766||
pinktest_usa_3001|RYDAF|200512||||11730||||||||6732.5||
pinktest_usa_3001|RYDAF|200603||||12767||||||||6535.3||
pinktest_usa_3001|RYDAF|200606||||11774||||||||6483.1||
pinktest_usa_3001|RYDAF|200609||||11240||||||||6395.5||
pinktest_usa_3001|RYDAF|200612||||9002||||||||6470.9||
pinktest_usa_3001|RYDAF|200703||||11184||||||||6306.5||
pinktest_usa_3001|RYDAF|200706||||15117||||||||6299.7||
pinktest_usa_3001|RYDAF|200709||||14092||||||||6285.8232||
pinktest_usa_3001|RYDAF|200712||||9656||||||||6253.6956||
pinktest_usa_3001|RYDAF|200803||||14417||||||||6211.4243||
pinktest_usa_3001|RYDAF|200806||||8990||||||||6189.0587||
pinktest_usa_3001|RYDAF|||||7821||||||||6159.2281|27.25|27.25
pinktest_usa_3001|RYDAF|200812|4.251||80258.5185|15188|||25.7613|0.3302||||6127.3586|28.1|28.1
pinktest_usa_3001|RYDAF|200903||||15961|85905.1333||22.95|0.3435||||6124.5|22.2528|22.2528
pinktest_usa_3001|RYDAF|200906||||10596|54567.3667||25.8|0.4329||||6129.3567|23.7975|23.7975
pinktest_usa_3001|RYDAF|200909|13.5613||98611.4829|14275|28457.9||28.75|0.5101||||6131.0394|28.15|28.15
pinktest_usa_3001|RYDAF|200912|23.4375||104544.243|9719|21109.4667|15.3846|30|0.634|0.7177|||6131.0778|31.15|31.15
pinktest_usa_3001|RYDAF|201003|14.0686|2.2316|104387.6925|8448|70711.2667|25.0545|28.7|0.6145|0.7238||5.8537|6132.8|29.675|29.675
pinktest_usa_3001|RYDAF|201006|10.8537|2.1709|101946.0763|12008|23630.0333|15.8859|28.45|0.4816|0.8187||5.9051|6143.7|24.75|24.75
pinktest_usa_3001|RYDAF|201009|12.2561|1.6744|111246.6142|11282|25258.1333|4.8696|30.15|0.5438|0.9408||5.5721|6138.3|31.25|31.25
pinktest_usa_3001|RYDAF|201012|13.3333|3.0327|124999.8289|13444|19705.8|10.6667|33.2|0.5737|1.2439||5.0602|6145.9004|33.8|33.8
pinktest_usa_3001|RYDAF|201103|9.6316|2.7154|126563.5765|16608|21721.7|27.972|36.6|0.5725|1.2664||4.5902|6174|36.7|36.7
pinktest_usa_3001|RYDAF|201106|9.0789|1.906|120902.3794|19465|74804.2|29.2135|34.5|0.5396|1.3895||4.8696|6227.2|35.85|35.85
pinktest_usa_3001|RYDAF|201109|6.9978|6.1208|114199.1606|19256|24875.4667|3.7479|31.28|0.4568|1.3046||5.3708|6247.1|31.49|31.49
pinktest_usa_3001|RYDAF|201112|7.2107|15.9331|118265.8002||26145.4667|10.1093|36.27|0.4938|1.2501||4.6319|6241|37.03|37.03
pinktest_usa_3001|RYDAF|201203|7.1026|8.9865|93947.533|15024|28608.9333|-2.8886|35.3|0.4672|1.022||4.7592|6239.1|35.2|35.2
pinktest_usa_3001|RYDAF|201206|6.5657||107258.983|17282|24931.5333|-3.9882|32.5|0.4223|1.0914||5.2|6273.2|34|34
pinktest_usa_3001|RYDAF|201209|8.3531|10.3137|109868.2656|18839|43087.7667|14.2626|35.25|0.4629|1.2278||4.8227|6273.9|34.4|34.4
pinktest_usa_3001|RYDAF|201212|8.1179|9.2682|237726.396||1859|-5.0483|34.42|0.4635|0.9528||4.9494|6289.2|34.35|34.35
pinktest_usa_3001|RYDAF|201303|7.6253|3.0019|207508.7318|17614|5688.2667|-9.1771|32.56|0.4369|1.1797||5.3115|6313.7|32.18|32.18
pinktest_usa_3001|RYDAF|201306||||12540|18030.4667|-3.6947|31.8|0.4382|0.8949||5.4737|6316.9|32.15|32.15
pinktest_usa_3001|RYDAF|201309|8.7135||229449.296|14278|8377.6|-6.8088|32.8499|0.4541|0.9304||5.8069|6272.5|32.62|32.62
pinktest_usa_3001|RYDAF|201312|10.5296|11.1204|250797.5657||59063.8333|3.6099|35.59|0.4872|1.0594||5.434|6275.1|35.3999|35.3999
pinktest_usa_3001|RYDAF|201403|18.0235|4.0235|267054.8291|11924|121560.5|12.8915|36.4075|0.5109|0.9667||5.3235|6288.9|36.55|36.55
pinktest_usa_3001|RYDAF|201406|20.3416|5.6733|296561.2908|15419|28135.4667|29.2138|41.152|0.5767|0.7507||4.7869|6323.4|41.1|41.1
pinktest_usa_3001|RYDAF|201409|14.8649|5.2716|275288.1366|19027|21797.7|17.6653|37.9501|0.5422|0.7296||4.7792|6334.1|36.8|36.8
pinktest_usa_3001|RYDAF|201412|14.1702|10.5657|211069.4459||159531.2|-6.2236|33.4801|0.4991|0.4388||5.5856|6301.1|31.7|31.7
pinktest_usa_3001|RYDAF|201503|13.2341|2.9175|197018.9936|19867|195770.7333|-13.0556|30.13|0.4662|1.117||6.045|6377|31.35|31.35
pinktest_usa_3001|RYDAF|201506|12.9009|7.1072|215142.6782|26981|382418.1|-27.1599|28.27|0.5026|1.0376||6.3275|6383.9|27.13|27.13
pinktest_usa_3001|RYDAF|201509|11.2429|7.4274|177866.9047|31846|307428.3|-38.6755|23.25|0.4431|1.1332||8.0213|6396.9|26.93|26.93
pinktest_usa_3001|RYDAF|201512|99.5652|14.3734|172152.5074||85661.9333|-33.8533|23.0765|0.4872|1.5683||8.27|6416.1|22.5|22.5
pinktest_usa_3001|RYDAF|201603|81.181|-2.41|188830.6422|11019|62950.2|-22.3017|23.5425|0.5681|1.3062||6.0479|7230.4|23.48|23.48
pinktest_usa_3001|RYDAF|201606||0.943|283220.893|15222|43795.3333|-10.775|26.25|0.6999|1.2344||5.3714|8053.3|27.55|27.55
pinktest_usa_3001|RYDAF|201609||1.197|268061.6403|19984|104662.7|0.4264|23.55|0.7075|0.9511||5.9873|8107.7|25.4891|25.4891
pinktest_usa_3001|RYDAF|201612|49.8704|11.9461|299824.3362||43448.6|16.0276|26.93|0.8842|0.5411||6.9811|8170.1|28.19|28.19
pinktest_usa_3001|RYDAF|201703|45.5172|-1.1791|217065.6101|19595|49378.3333|7.2213|26.4|0.8918|-0.797||7.1659|8222.9|26.1|26.1
pinktest_usa_3001|RYDAF|201706|28.2872|6.3385|293499.8187|23992|22387.4667|2.6641|26.59|0.8426|-0.1366||7.1147|8292.3|26.75|26.75
pinktest_usa_3001|RYDAF|201709|30.9184|6.6467|320754.0094|20699|57733.6667|23.6735|30.3|0.9182|0.6549||6.2435|8324.9|30.89|30.89
pinktest_usa_3001|RYDAF|201712|25.7786|7.8221|352894.372|20312|89384.8333|23.7903|33.77|0.9798|0.2645||5.602|8355.1|34.22|34.22
pinktest_usa_3001|RYDAF|201803|17.0811|-0.1401|333704.7147|21927|44170.9|20.3027|31.7575|0.8593|1.1874||5.9199|8377.2|31.44|31.44
pinktest_usa_3001|RYDAF|201806|18.4953|6.7254|359566.0112|19468|143791.2667|30.0998|34.2163|0.8967|0.981||5.4945|8376|34.195|34.195
pinktest_usa_3001|RYDAF|201809|14.7941|7.3138|352093.5918|19112|44674.6667|17.2104|35.21|0.8321|0.3923||5.3394|8353.1|34.9|34.9
pinktest_usa_3001|RYDAF|201812|11.2403|15.9454|300134.5354||47830.0333|-12.2276|29|0.6479|0.526||6.4828|8289.4|29.25|29.25
pinktest_usa_3001|RYDAF|201903|11.4624|6.8205|258840.5236|21470|13850.6|-0.2184|31.98|0.6832|0.5394||5.8787|8210.7|31.935|31.935
pinktest_usa_3001|RYDAF|201906|11.6844|8.6754|340477.3151|18470|30798.0333|-3.7007|32.95|0.7127|0.4961||5.7056|8153.7|32.68|32.68
pinktest_usa_3001|RYDAF|201909|11.6356|10.3288|313106.0411|15417|107849.0333|-18.3755|28.74|0.6436|0.6419||6.5414|8067.6|28.652|28.652
pinktest_usa_3001|RYDAF|201912|11.82|12.4154|283283.3555|18055|51269.4|1.8966|29.55|0.6869|0.6846||6.3621|7962.5|30|30
pinktest_usa_3001|RYDAF|202003|8.8718|4.5895|219910.5264|21811|131331.4667|-44.2675|17.5|0.4109|1.1275||10.7429|7819.8|17.405|17.405
pinktest_usa_3001|RYDAF|202006|13.4354|14.1978|210887.8173|27939|243723.9|-49.7256|16.49|0.4108|0.8004||9.5209|7789.8|16.255|16.255
pinktest_usa_3001|RYDAF|202009|||178713.5336||53457.0667|-56.6921|12.49|0.3755|0.77||10.0846||12.5|12.5