PREVIEW / stock_daily / 2017-06-22
file: by_date/stock_daily/2017/2017-06-22.parquet size: 214 KB rows: 6,461 symbols: 2,999
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 |
|---|---|---|---|---|---|---|---|
| 2017-06-22 | AAPL | Stock | 36.4425 | 36.675 | 36.28 | 36.4075 | 76425200.0 |
| 2017-06-22 | MSFT | Stock | 70.54 | 70.59 | 69.71 | 70.26 | 22965700.0 |
| 2017-06-22 | NVDA | Stock | 3.995 | 4.0085 | 3.935 | 3.9593 | 469132000.0 |
| 2017-06-22 | AMZN | Stock | 50.1115 | 50.348 | 49.86 | 50.065 | 45068000.0 |
| 2017-06-22 | GOOGL | Stock | 48.8435 | 49.025 | 48.6657 | 48.831 | 20189520.0 |
| 2017-06-22 | META | Stock | 153.01 | 154.55 | 152.91 | 153.4 | 13005500.0 |
| 2017-06-22 | TSLA | Stock | 25.1993 | 25.6667 | 24.9047 | 25.5073 | 112947000.0 |
| 2017-06-22 | TLT | Stock | 127.71 | 127.87 | 127.31 | 127.84 | 6608055.0 |
| 2017-06-22 | ES | Stock | 62.51 | 62.7 | 62.17 | 62.2 | 842600.0 |
| 2017-06-22 | CL | Stock | 75.7 | 75.86 | 75.41 | 75.53 | 2373500.0 |
| 2017-06-22 | A | Stock | 59.94 | 60.8 | 59.61 | 60.61 | 3473200.0 |
| 2017-06-22 | AA | Stock | 29.81 | 30.25 | 29.66 | 29.8 | 2906700.0 |
| 2017-06-22 | AAAP-DELISTED | Stock | 39.0 | 39.93 | 37.3266 | 39.721 | 171673.0 |
| 2017-06-22 | AABA-DELISTED | Stock | 54.75 | 55.45 | 54.42 | 54.6 | 8995561.0 |
| 2017-06-22 | AAC-DELISTED | Stock | 6.55 | 7.27 | 6.55 | 7.24 | 102515.0 |
| 2017-06-22 | AACG | Stock | 4.86 | 4.86 | 4.73 | 4.84 | 5100.0 |
| 2017-06-22 | AAIC-DELISTED | Stock | 14.7 | 14.76 | 14.65 | 14.65 | 264877.0 |
| 2017-06-22 | AAL | Stock | 50.5 | 50.56 | 48.79 | 48.97 | 9792100.0 |
| 2017-06-22 | AAM.A-DELISTED | Stock | 25.91 | 25.98 | 25.91 | 25.95 | 25171.0 |
| 2017-06-22 | AAMC-DELISTED | Stock | 25.4559 | 27.1691 | 25.4559 | 26.75 | 39256.0 |
| 2017-06-22 | AAME | Stock | 3.6 | 3.75 | 3.6 | 3.7 | 2300.0 |
| 2017-06-22 | AAMI | Stock | 14.53 | 14.665 | 14.43 | 14.49 | 388400.0 |
| 2017-06-22 | AAOI | Stock | 63.06 | 63.945 | 61.92 | 63.58 | 1315700.0 |
| 2017-06-22 | AAON | Stock | 24.1667 | 24.2333 | 23.8667 | 24.0667 | 139350.0 |
| 2017-06-22 | AAP | Stock | 120.21 | 122.52 | 119.83 | 120.7 | 2118400.0 |
| 2017-06-22 | AAT | Stock | 39.59 | 40.19 | 39.28 | 39.81 | 221100.0 |
| 2017-06-22 | AAU-DELISTED | Stock | 1.38 | 1.4 | 1.34 | 1.34 | 101176.0 |
| 2017-06-22 | AAUAF-DELISTED | Stock | 1.38 | 1.4 | 1.34 | 1.37 | 103742.0 |
| 2017-06-22 | AAV-DELISTED | Stock | 6.1 | 6.25 | 6.1 | 6.25 | 94249.0 |
| 2017-06-22 | AAWW-DELISTED | Stock | 50.2 | 51.1 | 50.05 | 50.85 | 184920.0 |
| 2017-06-22 | AAXJ | Stock | 67.67 | 67.89 | 67.6 | 67.67 | 3471330.0 |
| 2017-06-22 | AAXN-DELISTED | Stock | 26.0 | 26.4 | 25.815 | 26.295 | 451929.0 |
| 2017-06-22 | AB | Stock | 23.25 | 23.8 | 23.25 | 23.45 | 321000.0 |
| 2017-06-22 | ABAC-DELISTED | Stock | 2.0799 | 2.12 | 2.0 | 2.1039 | 13596.0 |
| 2017-06-22 | ABAX-DELISTED | Stock | 51.53 | 52.15 | 51.35 | 51.74 | 34662.0 |
| 2017-06-22 | ABB-DELISTED | Stock | 25.14 | 25.36 | 25.11 | 25.325 | 2771982.0 |
| 2017-06-22 | ABBNY-DELISTED | Stock | 25.14 | 25.36 | 25.11 | 25.31 | 2822284.0 |
| 2017-06-22 | ABBV | Stock | 71.49 | 73.67 | 71.41 | 73.18 | 9998900.0 |
| 2017-06-22 | ABC-DELISTED | Stock | 95.7 | 97.67 | 95.5 | 96.39 | 1504288.0 |
| 2017-06-22 | ABCB | Stock | 46.3 | 46.35 | 45.51 | 46.1 | 88000.0 |
| 2017-06-22 | ABCD-DELISTED | Stock | 4.9 | 4.96 | 4.7665 | 4.94 | 11309.0 |
| 2017-06-22 | ABCO-DELISTED | Stock | 51.3 | 51.75 | 50.9 | 51.05 | 463455.0 |
| 2017-06-22 | ABDC-DELISTED | Stock | 13.4 | 13.5499 | 13.18 | 13.45 | 46418.0 |
| 2017-06-22 | ABE-DELISTED | Stock | 13.93 | 14.07 | 13.93 | 14.04 | 9524.0 |
| 2017-06-22 | ABEO | Stock | 132.5 | 151.25 | 131.25 | 140.0 | 50812.0 |
| 2017-06-22 | ABEOW-DELISTED | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 100.0 |
| 2017-06-22 | ABEV | Stock | 5.44 | 5.47 | 5.4 | 5.43 | 27446100.0 |
| 2017-06-22 | ABG | Stock | 52.8 | 52.8 | 51.45 | 52.4 | 359100.0 |
| 2017-06-22 | ABIL-DELISTED | Stock | 1.14 | 1.2 | 1.1 | 1.18 | 118991.0 |
| 2017-06-22 | ABM | Stock | 41.41 | 41.59 | 41.33 | 41.52 | 221100.0 |
> showing 50 of 6,461 rows — these rows as CSV