usa_0851|CXP|Short Name|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|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
usa_0851|CXP|Long Name|Columbia Property Trust Inc Total Current Assets (Quarterly) (USD)|Columbia Property Trust Inc Cash and Short Term Investments (Quarterly) (USD)|Columbia Property Trust Inc Inventories (Quarterly) (USD)|Columbia Property Trust Inc Net PP&E (Quarterly) (USD)|Columbia Property Trust Inc Goodwill and Intangibles (Quarterly) (USD)|Columbia Property Trust Inc Total Liabilities (Quarterly) (USD)|Columbia Property Trust Inc Total Current Liabilities (Quarterly) (USD)|Columbia Property Trust Inc Total Long Term Liabilities (Quarterly) (USD)|Columbia Property Trust Inc Total Deposits (Quarterly) (USD)|Columbia Property Trust Inc Book Value (Quarterly) (USD)|Columbia Property Trust Inc Retained Earnings (Quarterly) (USD)|Columbia Property Trust Inc Treasury Stock (Quarterly) (USD)|Columbia Property Trust Inc EV to Revenues|Columbia Property Trust Inc EV to Earnings|Columbia Property Trust Inc EV to Free Cash Flow|Columbia Property Trust Inc EV to Assets (Quarterly)|Columbia Property Trust Inc PS Ratio|Columbia Property Trust Inc PE Ratio|Columbia Property Trust Inc Price to Book Value|Columbia Property Trust Inc PEG Ratio|Columbia Property Trust Inc Debt to Equity Ratio|Columbia Property Trust Inc Dividend Yield|Columbia Property Trust Inc Shareholder Yield (TTM)|Columbia Property Trust Inc Percent of Shares Outstanding Short|Columbia Property Trust Inc Total Receivables (Quarterly) (USD)|Columbia Property Trust Inc Total Payables (Quarterly) (USD)|Columbia Property Trust Inc Total Capital Stock (Quarterly) (USD)|Columbia Property Trust Inc Return on Invested Capital|Columbia Property Trust Inc Quality Ratio Score|Columbia Property Trust Inc Momentum Score|Columbia Property Trust Inc Beta (1Y)|Columbia Property Trust Inc Sustainable Growth Rate (TTM)|Columbia Property Trust Inc Institutional Investor Ownership Percentage|Columbia Property Trust Inc Average Diluted Shares Outstanding (Quarterly)|Columbia Property Trust Inc Total Employees (Annual)|Columbia Property Trust Inc EPS Diluted (Quarterly) (USD)|Columbia Property Trust Inc Dividend Per Share (Quarterly) (USD)|Columbia Property Trust Inc Revenue (Quarterly) (USD)|Columbia Property Trust Inc Gross Profit (Quarterly) (USD)|Columbia Property Trust Inc SG&A Expense (Quarterly) (USD)|Columbia Property Trust Inc Pre-Tax Income (Quarterly) (USD)|Columbia Property Trust Inc Net Income (Quarterly) (USD)|Columbia Property Trust Inc Net Interest Income (Quarterly) (USD)|Columbia Property Trust Inc Price (USD)|Columbia Property Trust Inc Total Return Price (USD)|Columbia Property Trust Inc Enterprise Value (USD)|Columbia Property Trust Inc 30-Day Average Daily Volume|Columbia Property Trust Inc 1 Year Price Returns (Daily)||
usa_0851|CXP|Unit|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|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||
usa_0851|CXP|201006||||||||||||||||||||||||||||||||||134.1926||-0.0513||140.089|85.035|6.355|-6.614|-6.887|-12.581|||||||
usa_0851|CXP|201009||||||||||||||||||||||||||||||||||134.1926||0.035||144.58|87.97|6.025|5.651|4.702|-9.731|||||||
usa_0851|CXP|201012|170.209|38.882|||269.726|1754.452|106.947|1647.505||3616.886|-1212.472||||||||||0.2452||||107.639|106.947|5.409|||||||134.1926||0.171||95.134|56.096|4.829|17.007|22.942|-6.707|||||||
usa_0851|CXP|201103||||||||||||||||||||||||||||||||||134.1926||0.018||143.959|88.595|6.614|4.326|2.411|-10.11|||||||
usa_0851|CXP|201106|181.617|38.593|||256.009|2414.846|117.165|2297.681||3504.095|-1349.643||||||||||0.4352||||117.657|117.165|5.434|||||||134.1926||-0.0334||152.894|94.515|6.435|-2.701|-4.482|-20.652|||||||
usa_0851|CXP|201109|185.902|31.809|||243.471|2354.271|135.093|2219.178||3450.781|-1412.311||||||||||0.4183||||123.169|135.093|5.446|0.5401|1|||-5.0199||134.1926||0.038||157.144|97.201|6.107|-1.503|5.102|-18.345|||||||
usa_0851|CXP|201112|206.28|39.468|||231.338|2316.448|75.678|2240.77||3459.802|-1426.55||||||||||0.4247||||130.549|75.678|5.462|1.1704|1|||-6.1028||134.1926||0.3995||38.89|20.892|1.861|31.43|53.61|-10.297|||||||
usa_0851|CXP|201203|206.087|49.156|||220.006|2266.391|72.709|2193.682||3429.63|-1463.373||||||||||0.4159||||126.518|72.709|5.467|1.7324|1|||-5.3212||134.1926||0.232||141.34|86.484|4.87|11.669|31.131|-16.265|||||||
usa_0851|CXP|201206|218.129|60.618|||208.146|2284.416|70.095|2214.321||3374.35|-1520.489||||||||||0.432||||127.915|70.095|5.473|2.0528|2|||-4.9611||134.1926||0.0813||140.971|86.63|6.614|8.756|10.914|-16.514|||||||
usa_0851|CXP|201209|215.074|48.436|||197.508|2309.925|93.194|2216.731||3310.243|-1594.505||||||||||0.4427||||134.564|93.194|5.489|1.8486|1|||-5.3508||134.1926||-0.0437||144.708|86.333|6.789|11.198|-5.859|-16.738|||||||
usa_0851|CXP|201212|217.129|53.657|||206.927|2467.443|104.778|2362.665||3263.506|-1634.531||||||||||0.5057||||134.099|104.778|1.369|0.9882|1|||-6.1761||134.1926||0.0883||67.252|37.467|6.34|-9.609|11.853|-12.513|||||||
usa_0851|CXP|201303|238.388|68.623|||526.124|2466.054|126.785|2339.269||3173.761|-1708.785||||||||||0.5144||||134.64|126.785|5.447|-0.1178|1|||-7.4136||134.1926||-0.1685||128.792|81.641|36.819|-18.756|-22.608|-17.023|||||||
usa_0851|CXP|201306|234.348|61.667|||504.218|2473.094|115.935|2357.159||3130.345|-1739.568||||||||||0.5297||||139.473|115.935|5.423|0.0827|2|||-6.74||134.1926||0.1535||131.897|89.478|8.957|16.812|20.601|-16.936|||||||
usa_0851|CXP|201309|242.67|59.908|||177.029|2514.263|102.84|2411.423||3048.362|-1785.762||||||||||0.5609||||149.083|102.84|1.342|0.3046|1|||-6.0045||134.1926||0.0358||132.502|87.787|7.88|14.43|4.8|-17.442||||||22.6|22.6
usa_0851|CXP|201312|253.284|99.855|||148.889|1804.659|99.678|1704.981||2787.823|-1810.284||10.8142|286.9005|22.47|0.9821|7.2307|227.3206|1.0922||0.5342|||1.8301|121.006|99.678|1.248|0.3338|2|||-5.7049||124.8301|92|0.1|0.3|133.387|88.409|8.21|13.834|12.927|-16.511|24.81|18.2556|4979.3174|1086778.7||24.84|24.84
usa_0851|CXP|201403|250.695|86.243|||140.457|1793.952|90.096|1703.856||2754.178|-1844.373||8.9882|115.21|27.2837|1.057|6.7056|221.6649|1.1994||0.5404|||2.0782|124.483|90.096|1.249|0.9122|2|||-4.5516||124.887||0.03|0.3|129.168|85.758|6.946|3.107|3.4|-16.1|26.78|19.9335|4732.9837|1136917.6667||26.71|26.71
usa_0851|CXP|201406|203.992|49.334|||133.778|1956.186|98.737|1857.449||2725.185|-1873.842||8.981|165.9372|26.4146|1.0332|6.5506|83.4672|1.2092|0.1746|0.6002|||0.7095|125.145|98.737|1.249|0.6498|2|||-4.6475||124.919||0.06|0.3|136.757|92.561|8.412|9.062|8.021|-17.058|26.65|20.0633|4732.5512|770402.6333||25.78|25.78
usa_0851|CXP|201409|220.451|46.433|||113.447|2169.567|100.911|2068.656||2714.02|-1886.346||8.9066|96.8162|27.3457|0.9781|5.5589|61.2051|1.0991|0.2378|0.6779|||0.9248|121.845|100.911|1.249|1.1115|2|||-3.5847||124.938||0.2|0.3|136.981|90.116|7.836|25.937|24.988|-17.47|23.87|18.18|4776.5248|615218.5667||23.9|23.9
usa_0851|CXP|201412|329.155|149.79|||105.528|2000.762|106.276|1894.486||2733.478|-1867.611||9.3123|50.6689|28.5913|0.9914|5.9641|65.6667|1.1793|0.2552|0.6129|4.6875|4.9514|0.684|123.434|106.276|1.249|2.1204|2|7|1.1902|-2.09||124.909|99|0.45|0.3|137.891|87.59|8.081|57.208|56.226|-17.808|25.61|19.7388|4994.0967|637674.6333|3.2258|25.44|25.44
usa_0851|CXP|201503|192.921|31.236|||105.759|2455.502|97.973|2357.529||2702.106|-1899.536||9.804|57.808|33.1929|1.0629|6.0366|36.0267|1.2507|0.2671|0.7897|4.4643|0.6449|0.8143|131.957|97.973|1.25|2.1166|2|6|0.8181|-2.0237||124.935||0.04|0.3|147.543|92.801|8.044|5.402|5.598|-19.651|27.02|21.0724|5482.1108|778997.7667|0.2237|26.82|26.82
usa_0851|CXP|201506|215.808|33.742|||84.407|2451.599|93.144|2358.455||2674.634|-1928.35||9.0325|53.9504|33.0195|1.0053|5.3765|32.3026|1.148|0.1365|0.7913|4.888|0.8206|2.9149|116.278|93.144|1.25|2.081|2|6|1.1194|-2.0115||125.017||0.07|0.3|148.124|94.391|7.08|8.8|8.709|-20.958|24.55|19.3626|5153.3939|1088828.6|-5.6132|24.95|24.95
usa_0851|CXP|201509|198.027|44.823|||87.71|2580.379|110.103|2470.276||2642.3|-1945.731||8.717|56.2674|31.8661|0.9769|5.0612|30.4079|1.0807|0.1285|0.8547|5.1926|1.3301|1.9106|123.568|110.103|1.245|1.9301|2|5|0.96|-2.2049||124.46||0.16|0.3|137.719|85.378|6.797|20.388|20.143|-20.204|23.11|18.4806|4973.3795|601919.2667|-3.8686|23.73|23.73
usa_0851|CXP|201512|189.225|32.645|||77.19|2063.924|136.113|1927.811||2614.194|-1972.916||9.071|103.3916|31.5433|0.9861|5.2159|33.1528|1.1235|0.3918|0.6602|5.0272|6.4765|3.2142|120.732|136.113|1.243|0.9585|2|7|0.9367|-2.5418||126.053|99|0.08|0.3|132.679|83.986|7.762|10.407|10.169|-17.229|23.87|19.3173|5182.0271|452436.3|-6.7214|23.18|23.18
usa_0851|CXP|201603|336.253|185.376|||70.56|2080.578|85.351|1995.227||2554.22|-2003.258||7.6167|94.7039|31.2851|0.9342|4.7941|61.9714|1.0243||0.7048|5.5325|6.107|1.5483|115.098|85.351|1.234|0.9844|2|5|1.032|-3.9326||123.412||0.05|0.3|126.579|80.582|10.49|6.774|6.697|-16.092|21.69|17.8086|4370.8133|661708.2|-19.308|21.5|21.5
usa_0851|CXP|201606|184.174|23.803|||65.775|1931.84|86.01|1845.83||2529.636|-2027.012||7.805|84.9155|30.1787|0.9573|4.8924|59.3889|1.0335||0.6533|5.6127|10.8598|0.8422|125.131|86.01|1.234|1.1143|2|4|0.9586|-3.7903||123.294||0.11|0.3|127.93|82.309|7.761|13.531|13.286|-15.572|21.38|17.8126|4254.5376|501264.1667|-14.7188|21.4|21.4
usa_0851|CXP|201609|324.599|190.856|||58.645|1788.26|81.617|1706.643||2531.665|-2027.155||8.4283|60.9696|31.812|0.9463|5.3614|56.6|1.1051||0.5982|5.3004|10.7908|0.5312|76.552|81.617|1.234|1.5362|2|7|1.3273|-3.1628||123.35||0.3|0.3|113.266|68.832|7.467|36.963|36.898|-15.299|22.64|19.1048|4424.0917|512501.8667|-1.7361|21.71|21.71
usa_0851|CXP|201612|357.863|216.085|||54.279|1797.025|167.755|1629.27||2502.768|-2036.482||7.7914|45.5326|27.0645|0.8925|5.1697|38.6296|1.0174||0.5651|5.7526|13.9959|1.1513|71.974|167.755|1.221|2.0221|2|3|1.4983|-2.5208||122.868|90|0.22|0.3|105.768|66.751|8.158|27.458|27.4|-13.358|20.86|17.8553|3899.2608|624395.9333|-11.3472|21.58|21.58
usa_0851|CXP|201703|672.193|554.655|||51.326|1636.584|125.743|1510.841||2553.869|-1986.25||8.2505|23.0484|25.4409|0.8377|5.7563|32.5294|1.0822|0.345|0.5249|4.9729|8.847|0.797|76.891|125.743|1.224|3.7341|2|5|2.0705|0.6711||122.329||0.61|0.2|82.156|55.706|8.768|74.334|74.722|-12.765|22.12|19.0968|3906.9603|668273.1|2.6364|22.49|22.49
usa_0851|CXP|201706|628.23|506.538|||48.586|1648.134|140.151|1507.983||2504.843|-2009.405||8.1919|25.3026|31.0663|0.8539|6.387|17.9758|1.0687|0.0735|0.5348|4.4863|9.956|1.3701|81.877|140.151|1.211|3.5242|2|5|2.3084|0.6974||121.909||0.01|0.2|74.857|52.757|9.201|1.14|1.133|-11.985|22.29|19.4229|3515.3019|495080.5333|4.0845|22.19|22.19
usa_0851|CXP|201709|541.474|382.73|||28.067|1489.378|129.802|1359.576||2553.902|-1931.927||9.1047|16.7945|38.9966|0.8506|6.9679|18.7456|1.0343|0.1013|0.4753|4.2115|10.8288|1.712|82.942|129.802|1.198|5.2591|1|3|1.5207|3.7648||120.529||0.84|0.2|60.362|41.607|7.747|101.537|101.534|-11.89|21.37|18.8036|3423.7886|572298.0333|-6.0911|21.55|21.55
usa_0851|CXP|201712|131.613|9.567|||42.959|1979.603|148.963|1830.64||2531.936|-1957.236||15.2406|25.0199|135.4653|0.9763|8.6468|13.6607|1.0752|0.0646|0.6576|3.4904|4.5532|1.6699|94.363|148.963|1.198|4.4861|2|5|1.6451|2.6282||120.262|94|-0.01|0.2|71.625|48.118|10.704|-1.183|-1.348|-14.347|22.92|20.3451|3577.0975|754403.3|8.562|22.84|22.84
usa_0851|CXP|201803|151.107|21.068|||40.54|1796.341|105.772|1690.569||2842.459|-1621.498||13.9714|38.2447|-164.4763|0.8477|8.6139|24.0706|0.9625|0.125|0.5371|3.8967|6.5811|1.4348|104.85|105.772|1.186|2.5611|1||0.2097|0.2562||119.35||0.01|0.2|73.71|50.44|8.525|1.505|1.498|-14.092|20.53|18.3995|4092.3343|854977.5667|-10.0046|20.4|20.4
usa_0851|CXP|201806|120.963|11.961|||38.002|1451.728|50.729|1400.999||2804.012|-1648.577||14.9163|39.7874|-236.3187|0.9185|9.6134|26.5765|0.9338||0.4428|3.5746|7.0325|1.7481|79.76|50.729|1.18|2.4289|2|6|0.2589|0.1031||118.462||-0.03|0.2|75.37|52.715|9.018|-3.433|-3.439|-12.5|22.38|20.2391|4159.9185|757911.4|1.0738|23.1|23.1
usa_0851|CXP|201809|132.75|15.596|||132.825|1462.535|52.725|1409.81||2789.2|-1665.745||14.1677|1282.1005|-484.1024|0.9469|9.9572|1182|0.9736||0.449|3.4203|5.5924|0.8021|85.838|52.725|1.18|0.0769|1|7|0.3651|-3.3989||118.207||0.05|0.2|73.34|52.134|9.049|6.432|6.429|-11.248|23.14|21.3306|3959.6447|910685.6667|9.2228|22.75|22.75
usa_0851|CXP|201812|130.753|17.118||0|132.632|1432.977|72.457|1360.52||2741.016|-1684.082||11.7129|375.6015|134.0566|0.8541|7.68|276.4286|0.8058||0.483|4.1344|6.3713|0.4592|90.417|72.457|1.167|0.2291|2|6|0.6588|-3.1208||116.997|95|0.04|0.2|75.523|52.987|9.495|5.024|5.003|-11.765|19.05|17.8133|3484.248|672152.2|-18.5814|19.19|19.19
usa_0851|CXP|201903|158.157|18.551||63.829|31.626|1504.865|37.962|1466.903||2718.864|-1703.945||13.1888|346.5673|148.4296|0.9441|8.966|322.7143|0.9598||0.5058|3.5414|7.4911|0.7162|87.588|37.962|1.169|0.2791|1|8|1.1021|-2.9667||116.88||0.03|0.2|75.433|50.941|9.233|3.52|3.513|-12.094|22.51|20.9876|3937.69|793922.8667|11.8087|23|23
usa_0851|CXP|201906|139.495|11.981||63.563|29.62|1302.064|43.403|1258.661||2742.731|-1679.58||12.5502|57.4594|81.0313|0.8906|8.3026|235|0.9092||0.4337|3.7825|7.9221|1.3917|90.094|43.403|1.169|1.5534|2|7|0.826|-1.1236||116.823||0.41|0.2|72.73|49.98|9.018|47.756|47.747|-10.897|21.15|19.8355|3828.6467|444387.7333|-8.942|21.17|21.17
usa_0851|CXP|201909|270.439|147.485||29.71|74.243|1228.267|53.281|1174.986||2697.534|-1723.248||12.2379|96.3956|47.7563|0.8834|8.2446|39.4151|0.8904||0.4237|3.8296|5.8407|1.2644|89.55||1.169|0.9006|1|6|0.8029|-2.1003|42.4411|116.821||-0.17|0.2|71.949|48.7|7.942|-20.284|-20.286|-10.289|20.89|19.7768|3619.7807|403629.7333|-9.9014|20.92|20.92
usa_0851|CXP|201912|137.498|12.303||29.47|88.996|1616.328|95.054|1521.274||2623.14|-1769.234||11.5521|421.978|55.0885|0.9142|8.4352|232.3333|0.9189|0.0461|0.5632|3.8737|3.497|1.3583|79.794|95.054|1.153|0.2295|2|5|0.736|-3.1162||115.55|93|-0.18|0.21|68.725|45.312|10.153|-21.907|-21.777|-9.717|20.91|20.0033|3880.9313|545617|10.636|20.64|20.64
usa_0851|CXP|202003|407.204|292.814||30.09|147.474|1776.604|90.291|1686.313||2562.671|-1787.119||9.9493|237.4859|60.5703|0.6461|5.2039|113.6364|0.5661|4.7406|0.6417|6.3566|6.1993|0.6498|85.257|90.291|1.144|0.2958|1|5|1.3934|-3.1163||114.486||0.05|0.21|76.254|46.612|11.782|3.985|6.29|-9.713|12.9|12.4796|2955.4568|1286262.4|-42.6921|12.03|12.03
usa_0851|CXP|202006|404.389|277.677||29.897|142.614|1777.187|93.122|1684.065||2544.322|-1806.071||10.1135|-95.6562|56.3771|0.6693|5.1083|118.5455|0.5911|5.3345|0.6465|6.3166|6.652|4.2041|87.469|93.122|1.145|-0.7521|2|3|1.543|-4.8021||113.903||0.04|0.21|79.371|48.92|11.119|4.89|5.085|-9.676|13.14|12.9147|2935.4976|1607799.1|-36.6442|12.53|12.53
usa_0851|CXP|202009|||||||||||||8.9028||51.4748||4.2414||0.4908|||7.6994||1.8978||||||2|1.3565|||||||||||||10.91|10.91|2680.2424|692377.7667|-48.4648|11.3|11.3