PREVIEW / stock_daily / 2013-08-28
file: by_date/stock_daily/2013/2013-08-28.parquet size: 211 KB rows: 6,362 symbols: 3,523
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2013-08-28 | AAPL | Stock | 17.3571 | 17.7071 | 17.3571 | 17.5321 | 307608000.0 |
| 2013-08-28 | MSFT | Stock | 33.39 | 33.6 | 33.0 | 33.02 | 44257400.0 |
| 2013-08-28 | NVDA | Stock | 0.3708 | 0.3735 | 0.3685 | 0.37 | 318824000.0 |
| 2013-08-28 | AMZN | Stock | 14.018 | 14.15 | 13.9665 | 14.079 | 29142000.0 |
| 2013-08-28 | META | Stock | 39.96 | 40.85 | 39.88 | 40.55 | 57918200.0 |
| 2013-08-28 | TSLA | Stock | 11.2707 | 11.4333 | 10.8833 | 11.0967 | 221101500.0 |
| 2013-08-28 | TLT | Stock | 105.41 | 105.57 | 104.94 | 105.27 | 7498069.0 |
| 2013-08-28 | ES | Stock | 41.22 | 41.55 | 40.99 | 41.16 | 3034500.0 |
| 2013-08-28 | CL | Stock | 57.51 | 57.51 | 57.14 | 57.27 | 2641000.0 |
| 2013-08-28 | A | Stock | 33.5336 | 33.598 | 33.269 | 33.4335 | 2223379.0 |
| 2013-08-28 | AABA-DELISTED | Stock | 26.9 | 27.24 | 26.83 | 27.115 | 9407418.0 |
| 2013-08-28 | AACG | Stock | 5.07 | 5.11 | 5.01 | 5.02 | 2900.0 |
| 2013-08-28 | AAIC-DELISTED | Stock | 23.31 | 23.5 | 23.111 | 23.13 | 117144.0 |
| 2013-08-28 | AAME | Stock | 3.79 | 3.9 | 3.79 | 3.87 | 6600.0 |
| 2013-08-28 | AAMRQ-DELISTED | Stock | 3.095 | 3.1 | 2.87 | 3.05 | 5020124.0 |
| 2013-08-28 | AAON | Stock | 10.36 | 10.6 | 10.36 | 10.48 | 170775.0 |
| 2013-08-28 | AAP | Stock | 81.4 | 81.74 | 80.95 | 81.07 | 311100.0 |
| 2013-08-28 | AAT | Stock | 29.98 | 29.98 | 29.39 | 29.77 | 379700.0 |
| 2013-08-28 | AAU-DELISTED | Stock | 1.76 | 1.8 | 1.73 | 1.76 | 91679.0 |
| 2013-08-28 | AAUAF-DELISTED | Stock | 1.76 | 1.8 | 1.73 | 1.76 | 91824.0 |
| 2013-08-28 | AAV-DELISTED | Stock | 3.67 | 3.78 | 3.605 | 3.75 | 159559.0 |
| 2013-08-28 | AAWW-DELISTED | Stock | 47.6 | 48.0 | 47.45 | 47.47 | 100740.0 |
| 2013-08-28 | AAXJ | Stock | 53.34 | 53.97 | 53.19 | 53.6 | 731988.0 |
| 2013-08-28 | AAXN-DELISTED | Stock | 11.49 | 11.68 | 11.05 | 11.15 | 2583677.0 |
| 2013-08-28 | AB | Stock | 19.38 | 19.95 | 19.32 | 19.38 | 181600.0 |
| 2013-08-28 | ABAC-DELISTED | Stock | 0.82 | 0.9 | 0.76 | 0.83 | 85805.0 |
| 2013-08-28 | ABAX-DELISTED | Stock | 40.47 | 40.74 | 39.73 | 39.74 | 64510.0 |
| 2013-08-28 | ABB-DELISTED | Stock | 21.77 | 22.02 | 21.73 | 21.91 | 1206574.0 |
| 2013-08-28 | ABBNY-DELISTED | Stock | 21.77 | 22.02 | 21.73 | 21.9 | 1241818.0 |
| 2013-08-28 | ABBV | Stock | 42.53 | 42.81 | 42.35 | 42.56 | 3009700.0 |
| 2013-08-28 | ABC-DELISTED | Stock | 56.85 | 57.135 | 56.24 | 56.97 | 1270845.0 |
| 2013-08-28 | ABCB | Stock | 19.26 | 19.61 | 19.21 | 19.42 | 83900.0 |
| 2013-08-28 | ABCD-DELISTED | Stock | 1.75 | 1.85 | 1.71 | 1.79 | 74828.0 |
| 2013-08-28 | ABCO-DELISTED | Stock | 57.2 | 58.08 | 56.92 | 57.13 | 101178.0 |
| 2013-08-28 | ABE-DELISTED | Stock | 18.78 | 18.78 | 18.46 | 18.544 | 4700.0 |
| 2013-08-28 | ABEO | Stock | 400.0 | 425.0 | 400.0 | 425.0 | 10.0 |
| 2013-08-28 | ABFS-DELISTED | Stock | 26.26 | 27.19 | 26.26 | 26.49 | 434152.0 |
| 2013-08-28 | ABG | Stock | 48.62 | 49.33 | 48.43 | 48.94 | 106500.0 |
| 2013-08-28 | ABM | Stock | 25.03 | 25.17 | 24.55 | 24.62 | 108100.0 |
| 2013-08-28 | ABMD-DELISTED | Stock | 22.39 | 22.67 | 22.28 | 22.62 | 209016.0 |
| 2013-08-28 | ABR | Stock | 6.93 | 6.96 | 6.85 | 6.87 | 47100.0 |
| 2013-08-28 | ABR.A-DELISTED | Stock | 24.5799 | 24.5799 | 24.4 | 24.53 | 755.0 |
| 2013-08-28 | ABR.B-DELISTED | Stock | 23.3799 | 23.38 | 23.3799 | 23.38 | 700.0 |
| 2013-08-28 | ABT | Stock | 33.97 | 34.03 | 33.73 | 33.75 | 7262000.0 |
| 2013-08-28 | ABTL-DELISTED | Stock | 5.86 | 5.97 | 5.82 | 5.93 | 21882.0 |
| 2013-08-28 | ABUS | Stock | 5.17 | 5.19 | 5.1 | 5.11 | 16600.0 |
| 2013-08-28 | ABV-DELISTED | Stock | 34.38 | 34.59 | 33.8175 | 34.26 | 2407877.0 |
| 2013-08-28 | ABX-DELISTED | Stock | 19.87 | 20.44 | 19.26 | 19.33 | 18715563.0 |
| 2013-08-28 | ACAD | Stock | 19.96 | 20.32 | 19.83 | 20.11 | 1641400.0 |
| 2013-08-28 | ACAS-DELISTED | Stock | 12.6 | 12.72 | 12.59 | 12.615 | 2051021.0 |
> showing 50 of 6,362 rows — these rows as CSV