PREVIEW / stock_daily / 2015-10-12
file: by_date/stock_daily/2015/2015-10-12.parquet size: 219 KB rows: 6,563 symbols: 3,380
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-12 | AAPL | Stock | 28.1825 | 28.1875 | 27.86 | 27.9 | 121868800.0 |
| 2015-10-12 | MSFT | Stock | 46.98 | 47.07 | 46.5 | 47.0 | 19769100.0 |
| 2015-10-12 | NVDA | Stock | 0.6525 | 0.6625 | 0.6478 | 0.6588 | 227588000.0 |
| 2015-10-12 | AMZN | Stock | 26.998 | 27.541 | 26.99 | 27.5095 | 55522000.0 |
| 2015-10-12 | GOOGL | Stock | 33.4595 | 33.899 | 33.362 | 33.8215 | 26684500.0 |
| 2015-10-12 | META | Stock | 93.32 | 94.6 | 92.67 | 94.26 | 18449600.0 |
| 2015-10-12 | TSLA | Stock | 14.866 | 14.8667 | 14.3513 | 14.372 | 57544500.0 |
| 2015-10-12 | TLT | Stock | 123.03 | 123.425 | 122.911 | 123.21 | 4241027.0 |
| 2015-10-12 | ES | Stock | 50.73 | 51.43 | 50.71 | 51.18 | 949400.0 |
| 2015-10-12 | CL | Stock | 66.33 | 66.58 | 65.99 | 66.25 | 2419400.0 |
| 2015-10-12 | A | Stock | 36.08 | 36.18 | 35.86 | 35.99 | 1349900.0 |
| 2015-10-12 | AA.B-DELISTED | Stock | 36.02 | 36.07 | 35.23 | 35.35 | 56156.0 |
| 2015-10-12 | AABA-DELISTED | Stock | 32.72 | 33.02 | 32.55 | 32.87 | 12038632.0 |
| 2015-10-12 | AAC-DELISTED | Stock | 26.29 | 27.0 | 26.14 | 26.75 | 229018.0 |
| 2015-10-12 | AACG | Stock | 3.15 | 3.48 | 3.15 | 3.31 | 12900.0 |
| 2015-10-12 | AAIC-DELISTED | Stock | 15.36 | 15.466 | 15.24 | 15.4 | 151551.0 |
| 2015-10-12 | AAL | Stock | 42.59 | 43.88 | 42.55 | 43.84 | 11443300.0 |
| 2015-10-12 | AAMC-DELISTED | Stock | 9.7059 | 12.5441 | 9.4147 | 11.1765 | 225168.0 |
| 2015-10-12 | AAME | Stock | 4.18 | 4.24 | 4.11 | 4.15 | 3000.0 |
| 2015-10-12 | AAMI | Stock | 14.72 | 14.9 | 14.48 | 14.66 | 127400.0 |
| 2015-10-12 | AAOI | Stock | 19.57 | 19.57 | 17.6 | 18.94 | 697800.0 |
| 2015-10-12 | AAON | Stock | 13.9467 | 14.28 | 13.8133 | 14.0667 | 117450.0 |
| 2015-10-12 | AAP | Stock | 189.75 | 192.46 | 188.9 | 191.28 | 941700.0 |
| 2015-10-12 | AAT | Stock | 42.13 | 42.61 | 42.04 | 42.35 | 186900.0 |
| 2015-10-12 | AAU-DELISTED | Stock | 0.56 | 0.56 | 0.53 | 0.531 | 63277.0 |
| 2015-10-12 | AAUAF-DELISTED | Stock | 0.56 | 0.56 | 0.53 | 0.531 | 63811.0 |
| 2015-10-12 | AAV-DELISTED | Stock | 6.24 | 6.25 | 6.11 | 6.2 | 33401.0 |
| 2015-10-12 | AAVL-DELISTED | Stock | 8.49 | 8.655 | 8.08 | 8.19 | 167790.0 |
| 2015-10-12 | AAWW-DELISTED | Stock | 41.03 | 42.462 | 39.81 | 40.98 | 165757.0 |
| 2015-10-12 | AAXJ | Stock | 57.14 | 57.2472 | 56.88 | 56.95 | 660523.0 |
| 2015-10-12 | AAXN-DELISTED | Stock | 24.67 | 24.7 | 24.02 | 24.21 | 646756.0 |
| 2015-10-12 | AB | Stock | 26.46 | 26.76 | 26.0 | 26.68 | 230800.0 |
| 2015-10-12 | ABAC-DELISTED | Stock | 0.5123 | 0.5123 | 0.48 | 0.48 | 8597.0 |
| 2015-10-12 | ABAX-DELISTED | Stock | 46.07 | 46.49 | 45.61 | 45.61 | 100167.0 |
| 2015-10-12 | ABB-DELISTED | Stock | 18.76 | 18.815 | 18.695 | 18.74 | 951083.0 |
| 2015-10-12 | ABBNY-DELISTED | Stock | 18.76 | 18.815 | 18.695 | 18.74 | 981545.0 |
| 2015-10-12 | ABBV | Stock | 55.8 | 56.27 | 55.52 | 55.77 | 6515000.0 |
| 2015-10-12 | ABC-DELISTED | Stock | 93.02 | 93.75 | 92.8 | 93.7136 | 1681476.0 |
| 2015-10-12 | ABCB | Stock | 28.17 | 28.59 | 28.08 | 28.49 | 82800.0 |
| 2015-10-12 | ABCD-DELISTED | Stock | 4.84 | 4.84 | 4.76 | 4.84 | 13105.0 |
| 2015-10-12 | ABCO-DELISTED | Stock | 47.15 | 48.13 | 46.05 | 47.84 | 546328.0 |
| 2015-10-12 | ABCW-DELISTED | Stock | 41.0 | 42.06 | 40.6 | 41.88 | 43481.0 |
| 2015-10-12 | ABDC-DELISTED | Stock | 12.43 | 12.43 | 12.02 | 12.16 | 24399.0 |
| 2015-10-12 | ABE-DELISTED | Stock | 11.47 | 11.48 | 11.3992 | 11.48 | 1053.0 |
| 2015-10-12 | ABEO | Stock | 115.25 | 115.25 | 103.75 | 105.5 | 4580.0 |
| 2015-10-12 | ABEOW-DELISTED | Stock | 1.34 | 1.8 | 1.34 | 1.8 | 1100.0 |
| 2015-10-12 | ABEV | Stock | 5.2 | 5.24 | 5.08 | 5.1 | 17245400.0 |
| 2015-10-12 | ABG | Stock | 84.38 | 84.96 | 83.25 | 84.12 | 128200.0 |
| 2015-10-12 | ABGB-DELISTED | Stock | 4.87 | 4.87 | 4.75 | 4.75 | 17630.0 |
| 2015-10-12 | ABM | Stock | 28.74 | 29.0 | 28.66 | 28.81 | 274400.0 |
> showing 50 of 6,563 rows — these rows as CSV