PREVIEW / stock_daily / 2015-01-26
file: by_date/stock_daily/2015/2015-01-26.parquet size: 222 KB rows: 6,655 symbols: 3,533
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-26 | AAPL | Stock | 28.435 | 28.59 | 28.2 | 28.275 | 222460000.0 |
| 2015-01-26 | MSFT | Stock | 47.0 | 47.13 | 46.24 | 47.01 | 42525500.0 |
| 2015-01-26 | NVDA | Stock | 0.5155 | 0.518 | 0.5122 | 0.5155 | 133240000.0 |
| 2015-01-26 | AMZN | Stock | 15.591 | 15.65 | 15.376 | 15.483 | 63394000.0 |
| 2015-01-26 | GOOGL | Stock | 27.075 | 27.075 | 26.6035 | 26.836 | 30931260.0 |
| 2015-01-26 | META | Stock | 77.98 | 78.47 | 77.29 | 77.5 | 19260800.0 |
| 2015-01-26 | TSLA | Stock | 13.4553 | 13.908 | 13.4033 | 13.77 | 48517500.0 |
| 2015-01-26 | TLT | Stock | 134.84 | 135.19 | 134.05 | 134.36 | 5966478.0 |
| 2015-01-26 | ES | Stock | 55.68 | 55.82 | 55.17 | 55.8 | 889400.0 |
| 2015-01-26 | CL | Stock | 66.96 | 67.09 | 66.23 | 66.29 | 5433500.0 |
| 2015-01-26 | A | Stock | 38.79 | 39.17 | 38.47 | 39.15 | 1510900.0 |
| 2015-01-26 | AA.B-DELISTED | Stock | 51.25 | 51.55 | 50.5 | 51.48 | 68534.0 |
| 2015-01-26 | AABA-DELISTED | Stock | 49.57 | 49.79 | 49.07 | 49.43 | 17086344.0 |
| 2015-01-26 | AAC-DELISTED | Stock | 27.74 | 28.3 | 27.59 | 28.3 | 87982.0 |
| 2015-01-26 | AACG | Stock | 4.55 | 4.83 | 4.55 | 4.81 | 5900.0 |
| 2015-01-26 | AAIC-DELISTED | Stock | 26.86 | 27.09 | 26.57 | 27.02 | 144475.0 |
| 2015-01-26 | AAL | Stock | 55.89 | 56.2 | 54.73 | 55.45 | 13353900.0 |
| 2015-01-26 | AAMC-DELISTED | Stock | 73.5294 | 73.5294 | 67.6324 | 70.4941 | 56926.0 |
| 2015-01-26 | AAME | Stock | 3.96 | 3.99 | 3.87 | 3.87 | 1400.0 |
| 2015-01-26 | AAMI | Stock | 15.63 | 15.74 | 15.11 | 15.46 | 240400.0 |
| 2015-01-26 | AAOI | Stock | 9.21 | 9.52 | 9.09 | 9.25 | 174200.0 |
| 2015-01-26 | AAON | Stock | 15.0133 | 15.2333 | 14.9 | 15.1933 | 116400.0 |
| 2015-01-26 | AAP | Stock | 155.75 | 159.25 | 155.75 | 159.23 | 614500.0 |
| 2015-01-26 | AAT | Stock | 43.97 | 44.75 | 43.81 | 44.75 | 232300.0 |
| 2015-01-26 | AAU-DELISTED | Stock | 1.19 | 1.2102 | 1.14 | 1.2 | 229623.0 |
| 2015-01-26 | AAUAF-DELISTED | Stock | 1.17 | 1.2 | 1.12 | 1.2 | 246066.0 |
| 2015-01-26 | AAV-DELISTED | Stock | 4.16 | 4.31 | 4.12 | 4.17 | 119934.0 |
| 2015-01-26 | AAVL-DELISTED | Stock | 39.32 | 44.15 | 39.0 | 43.96 | 531127.0 |
| 2015-01-26 | AAWW-DELISTED | Stock | 46.52 | 47.4 | 46.13 | 47.22 | 99471.0 |
| 2015-01-26 | AAXJ | Stock | 63.88 | 64.08 | 63.65 | 64.0 | 1185482.0 |
| 2015-01-26 | AAXN-DELISTED | Stock | 27.68 | 28.2299 | 27.6 | 27.89 | 1279410.0 |
| 2015-01-26 | AB | Stock | 26.35 | 26.39 | 25.87 | 26.11 | 254700.0 |
| 2015-01-26 | ABAC-DELISTED | Stock | 1.43 | 1.49 | 1.43 | 1.48 | 2600.0 |
| 2015-01-26 | ABAX-DELISTED | Stock | 59.83 | 60.31 | 59.02 | 59.67 | 119758.0 |
| 2015-01-26 | ABB-DELISTED | Stock | 19.77 | 19.92 | 19.73 | 19.84 | 1850632.0 |
| 2015-01-26 | ABBNY-DELISTED | Stock | 19.77 | 19.92 | 19.73 | 19.84 | 1989021.0 |
| 2015-01-26 | ABBV | Stock | 62.26 | 63.04 | 61.68 | 62.83 | 8181100.0 |
| 2015-01-26 | ABC-DELISTED | Stock | 94.85 | 95.87 | 94.3 | 95.83 | 1857937.0 |
| 2015-01-26 | ABCB | Stock | 24.0 | 24.32 | 23.59 | 24.3 | 46100.0 |
| 2015-01-26 | ABCD-DELISTED | Stock | 2.5 | 2.61 | 2.46 | 2.54 | 220340.0 |
| 2015-01-26 | ABCO-DELISTED | Stock | 46.46 | 48.1 | 45.51 | 48.02 | 454581.0 |
| 2015-01-26 | ABCW-DELISTED | Stock | 34.63 | 34.64 | 34.23 | 34.64 | 1296.0 |
| 2015-01-26 | ABDC-DELISTED | Stock | 12.6752 | 13.05 | 12.6752 | 12.985 | 22091.0 |
| 2015-01-26 | ABE-DELISTED | Stock | 13.28 | 13.28 | 13.22 | 13.24 | 12630.0 |
| 2015-01-26 | ABEO | Stock | 79.25 | 82.5 | 79.25 | 80.0 | 1104.0 |
| 2015-01-26 | ABEV | Stock | 6.56 | 6.6 | 6.53 | 6.6 | 6818200.0 |
| 2015-01-26 | ABG | Stock | 75.2 | 77.68 | 75.0 | 77.18 | 438000.0 |
| 2015-01-26 | ABGB-DELISTED | Stock | 15.9 | 16.0499 | 15.72 | 15.96 | 62882.0 |
| 2015-01-26 | ABM | Stock | 29.41 | 29.51 | 29.07 | 29.43 | 207900.0 |
| 2015-01-26 | ABMD-DELISTED | Stock | 39.6 | 40.21 | 38.87 | 39.54 | 364794.0 |
> showing 50 of 6,655 rows — these rows as CSV