PREVIEW / stock_daily / 2015-10-08
file: by_date/stock_daily/2015/2015-10-08.parquet size: 220 KB rows: 6,607 symbols: 3,411
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-10-08 | AAPL | Stock | 27.5475 | 27.5475 | 27.0525 | 27.375 | 247918400.0 |
| 2015-10-08 | MSFT | Stock | 46.56 | 47.52 | 46.5 | 47.45 | 33772700.0 |
| 2015-10-08 | NVDA | Stock | 0.6478 | 0.656 | 0.6368 | 0.6543 | 460068000.0 |
| 2015-10-08 | AMZN | Stock | 26.8355 | 26.9695 | 25.9945 | 26.658 | 93528000.0 |
| 2015-10-08 | GOOGL | Stock | 33.4725 | 33.5945 | 32.7245 | 33.35 | 39307940.0 |
| 2015-10-08 | META | Stock | 91.89 | 93.22 | 90.47 | 92.47 | 27290500.0 |
| 2015-10-08 | TSLA | Stock | 15.3387 | 15.3813 | 14.754 | 15.1147 | 91998000.0 |
| 2015-10-08 | TLT | Stock | 123.29 | 123.37 | 121.66 | 121.96 | 12882333.0 |
| 2015-10-08 | ES | Stock | 50.32 | 51.11 | 50.17 | 51.07 | 1034000.0 |
| 2015-10-08 | CL | Stock | 65.18 | 65.94 | 65.02 | 65.9 | 2587600.0 |
| 2015-10-08 | A | Stock | 35.39 | 36.07 | 35.34 | 36.01 | 2597900.0 |
| 2015-10-08 | AA.B-DELISTED | Stock | 36.65 | 37.69 | 36.49 | 37.6 | 339652.0 |
| 2015-10-08 | AABA-DELISTED | Stock | 31.78 | 32.5 | 31.73 | 32.36 | 13501342.0 |
| 2015-10-08 | AAC-DELISTED | Stock | 26.56 | 26.93 | 26.29 | 26.77 | 98151.0 |
| 2015-10-08 | AACG | Stock | 2.85 | 3.24 | 2.83 | 3.16 | 32900.0 |
| 2015-10-08 | AAIC-DELISTED | Stock | 15.32 | 15.43 | 15.239 | 15.31 | 190001.0 |
| 2015-10-08 | AAL | Stock | 39.21 | 40.03 | 38.7 | 39.74 | 8308100.0 |
| 2015-10-08 | AAMC-DELISTED | Stock | 8.25 | 8.6471 | 7.9559 | 8.6471 | 35992.0 |
| 2015-10-08 | AAME | Stock | 3.97 | 4.38 | 3.97 | 4.27 | 13000.0 |
| 2015-10-08 | AAMI | Stock | 15.16 | 15.29 | 14.9 | 15.2 | 137400.0 |
| 2015-10-08 | AAOI | Stock | 19.67 | 20.35 | 19.28 | 20.31 | 197700.0 |
| 2015-10-08 | AAON | Stock | 13.7 | 14.2533 | 13.7 | 14.2267 | 196650.0 |
| 2015-10-08 | AAP | Stock | 190.4 | 191.15 | 186.46 | 187.35 | 986100.0 |
| 2015-10-08 | AAT | Stock | 41.86 | 42.4 | 41.69 | 42.16 | 201500.0 |
| 2015-10-08 | AAU-DELISTED | Stock | 0.5419 | 0.57 | 0.5419 | 0.5577 | 36198.0 |
| 2015-10-08 | AAUAF-DELISTED | Stock | 0.5419 | 0.57 | 0.5419 | 0.5577 | 36513.0 |
| 2015-10-08 | AAV-DELISTED | Stock | 6.18 | 6.32 | 6.18 | 6.255 | 202659.0 |
| 2015-10-08 | AAVL-DELISTED | Stock | 8.59 | 8.68 | 8.11 | 8.47 | 316432.0 |
| 2015-10-08 | AAWW-DELISTED | Stock | 40.06 | 40.95 | 39.78 | 40.81 | 216488.0 |
| 2015-10-08 | AAXJ | Stock | 56.01 | 57.02 | 56.01 | 56.93 | 845642.0 |
| 2015-10-08 | AAXN-DELISTED | Stock | 25.73 | 26.11 | 24.62 | 25.34 | 1998663.0 |
| 2015-10-08 | AB | Stock | 26.9 | 27.08 | 26.5 | 26.79 | 182600.0 |
| 2015-10-08 | ABAC-DELISTED | Stock | 0.5 | 0.54 | 0.49 | 0.54 | 42527.0 |
| 2015-10-08 | ABAX-DELISTED | Stock | 44.84 | 45.14 | 44.23 | 44.84 | 101575.0 |
| 2015-10-08 | ABB-DELISTED | Stock | 18.42 | 18.75 | 18.41 | 18.72 | 1655054.0 |
| 2015-10-08 | ABBNY-DELISTED | Stock | 18.42 | 18.75 | 18.41 | 18.71 | 1769664.0 |
| 2015-10-08 | ABBV | Stock | 55.13 | 56.16 | 54.8 | 56.04 | 6737300.0 |
| 2015-10-08 | ABC-DELISTED | Stock | 93.06 | 93.88 | 91.77 | 93.52 | 1939133.0 |
| 2015-10-08 | ABCB | Stock | 28.4 | 28.55 | 28.16 | 28.51 | 145500.0 |
| 2015-10-08 | ABCD-DELISTED | Stock | 4.85 | 4.85 | 4.68 | 4.81 | 75873.0 |
| 2015-10-08 | ABCO-DELISTED | Stock | 43.33 | 44.17 | 42.8 | 44.12 | 258801.0 |
| 2015-10-08 | ABCW-DELISTED | Stock | 42.03 | 42.54 | 41.28 | 42.14 | 26147.0 |
| 2015-10-08 | ABDC-DELISTED | Stock | 12.06 | 12.59 | 11.89 | 12.51 | 74547.0 |
| 2015-10-08 | ABE-DELISTED | Stock | 11.27 | 11.37 | 11.23 | 11.37 | 6073.0 |
| 2015-10-08 | ABEO | Stock | 102.75 | 108.0 | 100.0 | 105.5 | 6532.0 |
| 2015-10-08 | ABEOW-DELISTED | Stock | 1.55 | 1.55 | 1.5 | 1.52 | 2800.0 |
| 2015-10-08 | ABEV | Stock | 5.16 | 5.21 | 5.06 | 5.15 | 40747900.0 |
| 2015-10-08 | ABG | Stock | 83.98 | 85.01 | 83.59 | 84.56 | 199400.0 |
| 2015-10-08 | ABGB-DELISTED | Stock | 4.95 | 4.95 | 4.66 | 4.75 | 278918.0 |
| 2015-10-08 | ABM | Stock | 28.28 | 28.95 | 28.27 | 28.93 | 355100.0 |
> showing 50 of 6,607 rows — these rows as CSV