PREVIEW / stock_daily / 2015-10-16
file: by_date/stock_daily/2015/2015-10-16.parquet size: 220 KB rows: 6,604 symbols: 3,408
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-16 | AAPL | Stock | 27.945 | 28.0 | 27.6325 | 27.76 | 156930400.0 |
| 2015-10-16 | MSFT | Stock | 47.02 | 47.54 | 46.9 | 47.51 | 26450300.0 |
| 2015-10-16 | NVDA | Stock | 0.688 | 0.703 | 0.6862 | 0.6965 | 448396000.0 |
| 2015-10-16 | AMZN | Stock | 28.2635 | 28.547 | 28.0155 | 28.538 | 86316000.0 |
| 2015-10-16 | GOOGL | Stock | 34.77 | 34.811 | 34.455 | 34.766 | 36315180.0 |
| 2015-10-16 | META | Stock | 96.18 | 97.59 | 95.35 | 97.54 | 25412900.0 |
| 2015-10-16 | TSLA | Stock | 14.8693 | 15.3653 | 14.858 | 15.134 | 65017500.0 |
| 2015-10-16 | TLT | Stock | 124.25 | 124.47 | 123.8699 | 123.93 | 8048318.0 |
| 2015-10-16 | ES | Stock | 51.98 | 52.53 | 51.94 | 52.24 | 1292200.0 |
| 2015-10-16 | CL | Stock | 66.9 | 67.26 | 66.71 | 67.12 | 2410800.0 |
| 2015-10-16 | A | Stock | 35.69 | 36.02 | 35.37 | 35.78 | 1754300.0 |
| 2015-10-16 | AA.B-DELISTED | Stock | 34.58 | 34.58 | 33.7 | 34.21 | 61476.0 |
| 2015-10-16 | AABA-DELISTED | Stock | 33.64 | 33.86 | 33.16 | 33.36 | 11750683.0 |
| 2015-10-16 | AAC-DELISTED | Stock | 26.82 | 28.35 | 25.2103 | 27.18 | 683635.0 |
| 2015-10-16 | AACG | Stock | 3.17 | 3.45 | 3.17 | 3.39 | 18500.0 |
| 2015-10-16 | AAIC-DELISTED | Stock | 15.44 | 15.44 | 15.18 | 15.33 | 115189.0 |
| 2015-10-16 | AAL | Stock | 43.95 | 44.02 | 42.86 | 43.71 | 11572900.0 |
| 2015-10-16 | AAMC-DELISTED | Stock | 9.7471 | 9.7471 | 8.7382 | 8.7647 | 61853.0 |
| 2015-10-16 | AAME | Stock | 4.22 | 4.28 | 4.22 | 4.25 | 11400.0 |
| 2015-10-16 | AAMI | Stock | 15.08 | 15.36 | 14.97 | 15.07 | 102700.0 |
| 2015-10-16 | AAOI | Stock | 18.87 | 18.87 | 18.07 | 18.58 | 178200.0 |
| 2015-10-16 | AAON | Stock | 14.0933 | 14.3067 | 13.74 | 14.1467 | 193650.0 |
| 2015-10-16 | AAP | Stock | 191.84 | 191.94 | 189.81 | 190.8 | 627400.0 |
| 2015-10-16 | AAT | Stock | 43.03 | 43.41 | 42.79 | 43.17 | 136600.0 |
| 2015-10-16 | AAU-DELISTED | Stock | 0.58 | 0.5919 | 0.543 | 0.57 | 92605.0 |
| 2015-10-16 | AAUAF-DELISTED | Stock | 0.58 | 0.5919 | 0.543 | 0.57 | 93145.0 |
| 2015-10-16 | AAV-DELISTED | Stock | 6.29 | 6.29 | 6.12 | 6.16 | 50376.0 |
| 2015-10-16 | AAVL-DELISTED | Stock | 8.33 | 8.555 | 8.21 | 8.485 | 305861.0 |
| 2015-10-16 | AAWW-DELISTED | Stock | 40.61 | 41.7 | 39.52 | 40.28 | 211343.0 |
| 2015-10-16 | AAXJ | Stock | 57.89 | 58.17 | 57.72 | 58.11 | 475978.0 |
| 2015-10-16 | AAXN-DELISTED | Stock | 24.32 | 24.68 | 24.05 | 24.62 | 840261.0 |
| 2015-10-16 | AB | Stock | 26.88 | 27.5 | 26.5 | 27.09 | 208800.0 |
| 2015-10-16 | ABAC-DELISTED | Stock | 0.6281 | 0.6689 | 0.6281 | 0.66 | 8500.0 |
| 2015-10-16 | ABAX-DELISTED | Stock | 44.68 | 45.73 | 44.49 | 44.59 | 125672.0 |
| 2015-10-16 | ABB-DELISTED | Stock | 18.22 | 18.3 | 18.05 | 18.26 | 2134578.0 |
| 2015-10-16 | ABBNY-DELISTED | Stock | 18.22 | 18.3 | 18.05 | 18.26 | 2202147.0 |
| 2015-10-16 | ABBV | Stock | 56.29 | 56.97 | 55.79 | 56.53 | 7342800.0 |
| 2015-10-16 | ABC-DELISTED | Stock | 94.62 | 95.32 | 94.34 | 95.06 | 1459972.0 |
| 2015-10-16 | ABCB | Stock | 28.61 | 28.79 | 28.02 | 28.75 | 101100.0 |
| 2015-10-16 | ABCD-DELISTED | Stock | 4.84 | 4.9 | 4.72 | 4.87 | 22326.0 |
| 2015-10-16 | ABCO-DELISTED | Stock | 44.98 | 46.47 | 44.168 | 46.21 | 274859.0 |
| 2015-10-16 | ABCW-DELISTED | Stock | 42.4 | 42.5 | 41.96 | 42.24 | 19625.0 |
| 2015-10-16 | ABDC-DELISTED | Stock | 12.0 | 12.26 | 11.77 | 12.08 | 5143.0 |
| 2015-10-16 | ABE-DELISTED | Stock | 11.46 | 11.5699 | 11.46 | 11.5699 | 2996.0 |
| 2015-10-16 | ABEO | Stock | 106.25 | 106.75 | 103.25 | 103.75 | 3360.0 |
| 2015-10-16 | ABEOW-DELISTED | Stock | 1.58 | 1.58 | 1.58 | 1.58 | 110.0 |
| 2015-10-16 | ABEV | Stock | 5.0 | 5.05 | 4.86 | 4.99 | 16467600.0 |
| 2015-10-16 | ABG | Stock | 86.18 | 87.07 | 85.25 | 86.95 | 394500.0 |
| 2015-10-16 | ABGB-DELISTED | Stock | 4.97 | 5.16 | 4.97 | 5.16 | 27312.0 |
| 2015-10-16 | ABM | Stock | 28.46 | 28.52 | 28.09 | 28.52 | 449600.0 |
> showing 50 of 6,604 rows — these rows as CSV