PREVIEW / stock_daily / 2015-10-14
file: by_date/stock_daily/2015/2015-10-14.parquet size: 219 KB rows: 6,560 symbols: 3,383
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-14 | AAPL | Stock | 27.8225 | 27.88 | 27.39 | 27.5525 | 177849600.0 |
| 2015-10-14 | MSFT | Stock | 46.65 | 47.1 | 46.53 | 46.68 | 24697800.0 |
| 2015-10-14 | NVDA | Stock | 0.6608 | 0.6948 | 0.66 | 0.684 | 612148000.0 |
| 2015-10-14 | AMZN | Stock | 27.567 | 27.6125 | 26.984 | 27.2415 | 71642000.0 |
| 2015-10-14 | GOOGL | Stock | 34.1865 | 34.502 | 33.945 | 34.0205 | 31291640.0 |
| 2015-10-14 | META | Stock | 94.08 | 95.2 | 93.61 | 94.07 | 19253400.0 |
| 2015-10-14 | TSLA | Stock | 14.7113 | 14.73 | 14.362 | 14.4587 | 46566000.0 |
| 2015-10-14 | TLT | Stock | 123.7 | 124.545 | 123.3 | 124.5 | 9738108.0 |
| 2015-10-14 | ES | Stock | 51.13 | 51.6 | 51.03 | 51.25 | 1346300.0 |
| 2015-10-14 | CL | Stock | 65.97 | 66.11 | 65.5 | 65.75 | 2326100.0 |
| 2015-10-14 | A | Stock | 35.64 | 35.77 | 34.97 | 35.05 | 1647400.0 |
| 2015-10-14 | AA.B-DELISTED | Stock | 35.31 | 35.3903 | 35.0 | 35.13 | 22604.0 |
| 2015-10-14 | AABA-DELISTED | Stock | 32.28 | 32.49 | 31.77 | 32.09 | 10410745.0 |
| 2015-10-14 | AAC-DELISTED | Stock | 27.4 | 27.4 | 25.81 | 26.66 | 149648.0 |
| 2015-10-14 | AACG | Stock | 3.3 | 3.35 | 3.15 | 3.34 | 14700.0 |
| 2015-10-14 | AAIC-DELISTED | Stock | 15.21 | 15.21 | 14.94 | 15.0 | 234023.0 |
| 2015-10-14 | AAL | Stock | 44.0 | 44.5 | 43.23 | 43.8 | 11125800.0 |
| 2015-10-14 | AAMC-DELISTED | Stock | 9.2941 | 9.3265 | 8.2353 | 8.7088 | 72440.0 |
| 2015-10-14 | AAME | Stock | 4.25 | 4.28 | 4.23 | 4.25 | 2800.0 |
| 2015-10-14 | AAMI | Stock | 14.63 | 14.76 | 14.41 | 14.46 | 82000.0 |
| 2015-10-14 | AAOI | Stock | 18.32 | 18.42 | 17.16 | 17.24 | 363000.0 |
| 2015-10-14 | AAON | Stock | 13.7467 | 13.8267 | 13.5133 | 13.5467 | 129750.0 |
| 2015-10-14 | AAP | Stock | 190.45 | 191.0 | 185.16 | 187.07 | 849000.0 |
| 2015-10-14 | AAT | Stock | 42.36 | 42.78 | 41.94 | 41.97 | 326300.0 |
| 2015-10-14 | AAU-DELISTED | Stock | 0.55 | 0.59 | 0.525 | 0.5823 | 249121.0 |
| 2015-10-14 | AAUAF-DELISTED | Stock | 0.55 | 0.59 | 0.525 | 0.5823 | 251019.0 |
| 2015-10-14 | AAV-DELISTED | Stock | 6.1 | 6.2 | 6.09 | 6.16 | 69557.0 |
| 2015-10-14 | AAVL-DELISTED | Stock | 7.87 | 8.14 | 7.8 | 7.98 | 360750.0 |
| 2015-10-14 | AAWW-DELISTED | Stock | 39.77 | 41.07 | 39.66 | 40.49 | 211658.0 |
| 2015-10-14 | AAXJ | Stock | 56.605 | 56.79 | 56.44 | 56.51 | 1260007.0 |
| 2015-10-14 | AAXN-DELISTED | Stock | 23.65 | 23.99 | 23.315 | 23.39 | 848957.0 |
| 2015-10-14 | AB | Stock | 26.6 | 26.99 | 26.03 | 26.13 | 181900.0 |
| 2015-10-14 | ABAC-DELISTED | Stock | 0.53 | 0.53 | 0.5099 | 0.5201 | 12438.0 |
| 2015-10-14 | ABAX-DELISTED | Stock | 44.81 | 45.16 | 43.93 | 44.08 | 104367.0 |
| 2015-10-14 | ABB-DELISTED | Stock | 18.55 | 18.6199 | 18.4901 | 18.55 | 1421084.0 |
| 2015-10-14 | ABBNY-DELISTED | Stock | 18.55 | 18.6199 | 18.4901 | 18.55 | 1531561.0 |
| 2015-10-14 | ABBV | Stock | 54.09 | 54.62 | 53.57 | 53.94 | 8727400.0 |
| 2015-10-14 | ABC-DELISTED | Stock | 94.0 | 94.98 | 92.74 | 93.02 | 2014893.0 |
| 2015-10-14 | ABCB | Stock | 28.38 | 28.38 | 27.58 | 27.65 | 90700.0 |
| 2015-10-14 | ABCD-DELISTED | Stock | 4.76 | 4.83 | 4.68 | 4.76 | 20029.0 |
| 2015-10-14 | ABCO-DELISTED | Stock | 45.48 | 45.5 | 43.54 | 43.66 | 180410.0 |
| 2015-10-14 | ABCW-DELISTED | Stock | 41.84 | 42.14 | 41.68 | 41.7 | 29624.0 |
| 2015-10-14 | ABDC-DELISTED | Stock | 12.2 | 12.51 | 12.08 | 12.08 | 67842.0 |
| 2015-10-14 | ABE-DELISTED | Stock | 11.31 | 11.4 | 11.31 | 11.368 | 1418.0 |
| 2015-10-14 | ABEO | Stock | 99.75 | 104.0 | 97.5 | 99.5 | 5648.0 |
| 2015-10-14 | ABEOW-DELISTED | Stock | 1.58 | 1.58 | 1.58 | 1.58 | 540.0 |
| 2015-10-14 | ABEV | Stock | 4.84 | 4.89 | 4.71 | 4.79 | 48873600.0 |
| 2015-10-14 | ABG | Stock | 82.72 | 83.1 | 81.13 | 82.52 | 421000.0 |
| 2015-10-14 | ABGB-DELISTED | Stock | 4.9 | 5.0 | 4.88 | 4.98 | 32805.0 |
| 2015-10-14 | ABM | Stock | 28.48 | 28.7 | 28.22 | 28.23 | 406800.0 |
> showing 50 of 6,560 rows — these rows as CSV