PREVIEW / stock_daily / 2015-10-19
file: by_date/stock_daily/2015/2015-10-19.parquet size: 221 KB rows: 6,608 symbols: 3,414
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-19 | AAPL | Stock | 27.7 | 27.9375 | 27.5275 | 27.9325 | 119036800.0 |
| 2015-10-19 | MSFT | Stock | 47.42 | 47.88 | 47.02 | 47.62 | 29387600.0 |
| 2015-10-19 | NVDA | Stock | 0.6988 | 0.702 | 0.6872 | 0.6952 | 294712000.0 |
| 2015-10-19 | AMZN | Stock | 28.538 | 28.95 | 28.369 | 28.6575 | 87508000.0 |
| 2015-10-19 | GOOGL | Stock | 34.7 | 35.012 | 34.6105 | 34.9975 | 30171700.0 |
| 2015-10-19 | META | Stock | 97.18 | 98.57 | 96.92 | 98.47 | 23729900.0 |
| 2015-10-19 | TSLA | Stock | 15.1 | 15.41 | 14.996 | 15.2067 | 37618500.0 |
| 2015-10-19 | TLT | Stock | 123.79 | 123.97 | 122.91 | 123.59 | 6238361.0 |
| 2015-10-19 | ES | Stock | 52.06 | 52.22 | 51.55 | 51.98 | 1342400.0 |
| 2015-10-19 | CL | Stock | 67.02 | 67.43 | 66.89 | 67.25 | 2384400.0 |
| 2015-10-19 | A | Stock | 35.69 | 36.23 | 35.59 | 36.23 | 3685800.0 |
| 2015-10-19 | AA.B-DELISTED | Stock | 34.12 | 34.12 | 33.7 | 33.84 | 26200.0 |
| 2015-10-19 | AABA-DELISTED | Stock | 33.26 | 33.63 | 33.18 | 33.5 | 9808113.0 |
| 2015-10-19 | AAC-DELISTED | Stock | 27.02 | 28.72 | 26.84 | 28.45 | 347496.0 |
| 2015-10-19 | AACG | Stock | 3.26 | 3.53 | 3.26 | 3.52 | 16400.0 |
| 2015-10-19 | AAIC-DELISTED | Stock | 15.31 | 15.45 | 15.25 | 15.29 | 142990.0 |
| 2015-10-19 | AAL | Stock | 43.83 | 44.49 | 43.62 | 44.45 | 8934600.0 |
| 2015-10-19 | AAMC-DELISTED | Stock | 9.25 | 9.2794 | 8.5324 | 8.6353 | 44061.0 |
| 2015-10-19 | AAME | Stock | 4.28 | 4.28 | 4.27 | 4.28 | 5400.0 |
| 2015-10-19 | AAMI | Stock | 14.98 | 15.04 | 14.81 | 14.88 | 111100.0 |
| 2015-10-19 | AAOI | Stock | 18.43 | 18.57 | 17.51 | 17.9 | 263200.0 |
| 2015-10-19 | AAON | Stock | 14.0333 | 14.1867 | 13.9533 | 14.16 | 104100.0 |
| 2015-10-19 | AAP | Stock | 190.78 | 192.03 | 189.79 | 191.4 | 726400.0 |
| 2015-10-19 | AAT | Stock | 43.07 | 43.72 | 43.07 | 43.53 | 153200.0 |
| 2015-10-19 | AAU-DELISTED | Stock | 0.576 | 0.5883 | 0.55 | 0.58 | 77981.0 |
| 2015-10-19 | AAUAF-DELISTED | Stock | 0.576 | 0.5883 | 0.55 | 0.58 | 78320.0 |
| 2015-10-19 | AAV-DELISTED | Stock | 6.1 | 6.1 | 5.87 | 5.91 | 83914.0 |
| 2015-10-19 | AAVL-DELISTED | Stock | 8.46 | 8.63 | 8.31 | 8.55 | 437292.0 |
| 2015-10-19 | AAWW-DELISTED | Stock | 40.08 | 40.43 | 39.59 | 40.35 | 247256.0 |
| 2015-10-19 | AAXJ | Stock | 57.64 | 57.75 | 57.46 | 57.64 | 781078.0 |
| 2015-10-19 | AAXN-DELISTED | Stock | 24.55 | 24.9 | 24.47 | 24.77 | 637931.0 |
| 2015-10-19 | AB | Stock | 26.75 | 26.75 | 26.4 | 26.54 | 397200.0 |
| 2015-10-19 | ABAC-DELISTED | Stock | 0.63 | 0.66 | 0.6265 | 0.66 | 11625.0 |
| 2015-10-19 | ABAX-DELISTED | Stock | 44.48 | 46.09 | 44.48 | 45.98 | 93517.0 |
| 2015-10-19 | ABB-DELISTED | Stock | 17.92 | 17.98 | 17.83 | 17.88 | 2471285.0 |
| 2015-10-19 | ABBNY-DELISTED | Stock | 17.92 | 17.98 | 17.83 | 17.87 | 3600357.0 |
| 2015-10-19 | ABBV | Stock | 56.29 | 56.7 | 55.69 | 56.16 | 6463000.0 |
| 2015-10-19 | ABC-DELISTED | Stock | 94.97 | 95.54 | 94.17 | 94.76 | 1422265.0 |
| 2015-10-19 | ABCB | Stock | 28.64 | 28.87 | 28.07 | 28.58 | 82300.0 |
| 2015-10-19 | ABCD-DELISTED | Stock | 4.85 | 5.07 | 4.85 | 5.02 | 49308.0 |
| 2015-10-19 | ABCO-DELISTED | Stock | 46.02 | 47.24 | 44.362 | 46.49 | 238563.0 |
| 2015-10-19 | ABCW-DELISTED | Stock | 42.16 | 42.205 | 41.89 | 42.16 | 12302.0 |
| 2015-10-19 | ABDC-DELISTED | Stock | 12.0 | 12.32 | 11.82 | 12.13 | 13750.0 |
| 2015-10-19 | ABE-DELISTED | Stock | 11.3701 | 11.4814 | 10.77 | 11.26 | 25030.0 |
| 2015-10-19 | ABEO | Stock | 104.0 | 106.75 | 96.5 | 101.5 | 6324.0 |
| 2015-10-19 | ABEOW-DELISTED | Stock | 1.6 | 1.6 | 1.46 | 1.47 | 4380.0 |
| 2015-10-19 | ABEV | Stock | 4.89 | 4.99 | 4.85 | 4.96 | 10492300.0 |
| 2015-10-19 | ABG | Stock | 86.75 | 87.63 | 85.95 | 86.39 | 273300.0 |
| 2015-10-19 | ABGB-DELISTED | Stock | 5.08 | 5.3 | 5.05 | 5.2 | 192629.0 |
| 2015-10-19 | ABIL-DELISTED | Stock | 10.02 | 10.03 | 10.02 | 10.03 | 2700.0 |
> showing 50 of 6,608 rows — these rows as CSV