PREVIEW / stock_daily / 2016-06-02
file: by_date/stock_daily/2016/2016-06-02.parquet size: 219 KB rows: 6,579 symbols: 3,306
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-02 | AAPL | Stock | 24.4 | 24.46 | 24.1575 | 24.43 | 160766400.0 |
| 2016-06-02 | MSFT | Stock | 52.64 | 52.74 | 51.84 | 52.48 | 22840800.0 |
| 2016-06-02 | NVDA | Stock | 1.1765 | 1.1885 | 1.165 | 1.1785 | 329208000.0 |
| 2016-06-02 | AMZN | Stock | 36.0485 | 36.414 | 35.775 | 36.412 | 60532000.0 |
| 2016-06-02 | GOOGL | Stock | 37.305 | 37.365 | 36.85 | 37.2135 | 33916480.0 |
| 2016-06-02 | META | Stock | 118.69 | 119.44 | 118.22 | 118.93 | 13228300.0 |
| 2016-06-02 | TSLA | Stock | 14.6393 | 14.6607 | 14.474 | 14.5973 | 30492000.0 |
| 2016-06-02 | TLT | Stock | 130.9 | 131.69 | 130.87 | 131.36 | 5835531.0 |
| 2016-06-02 | ES | Stock | 55.5 | 55.55 | 54.86 | 55.35 | 1827800.0 |
| 2016-06-02 | CL | Stock | 71.02 | 71.42 | 70.87 | 71.42 | 2241500.0 |
| 2016-06-02 | A | Stock | 45.91 | 46.15 | 45.82 | 45.9 | 2209400.0 |
| 2016-06-02 | AA.B-DELISTED | Stock | 32.4 | 33.24 | 32.4 | 33.1 | 119615.0 |
| 2016-06-02 | AAAP-DELISTED | Stock | 30.54 | 31.8 | 29.53 | 30.4 | 79933.0 |
| 2016-06-02 | AABA-DELISTED | Stock | 36.69 | 37.22 | 36.5789 | 37.15 | 11501407.0 |
| 2016-06-02 | AAC-DELISTED | Stock | 22.15 | 22.5 | 21.73 | 22.22 | 158221.0 |
| 2016-06-02 | AACG | Stock | 5.07 | 5.09 | 4.89 | 4.95 | 8500.0 |
| 2016-06-02 | AAIC-DELISTED | Stock | 13.5 | 13.645 | 13.36 | 13.63 | 259869.0 |
| 2016-06-02 | AAL | Stock | 31.67 | 32.07 | 31.58 | 31.67 | 6813300.0 |
| 2016-06-02 | AAMC-DELISTED | Stock | 5.8118 | 6.4324 | 5.5529 | 6.2706 | 93483.0 |
| 2016-06-02 | AAME | Stock | 3.65 | 3.67 | 3.55 | 3.55 | 900.0 |
| 2016-06-02 | AAMI | Stock | 15.05 | 15.27 | 14.95 | 15.05 | 272400.0 |
| 2016-06-02 | AAOI | Stock | 10.6 | 11.171 | 10.56 | 11.04 | 411100.0 |
| 2016-06-02 | AAON | Stock | 18.5667 | 18.6067 | 18.24 | 18.6 | 151200.0 |
| 2016-06-02 | AAP | Stock | 151.39 | 153.16 | 150.58 | 152.15 | 1319900.0 |
| 2016-06-02 | AAT | Stock | 40.25 | 41.41 | 40.1 | 41.4 | 219000.0 |
| 2016-06-02 | AAU-DELISTED | Stock | 1.03 | 1.09 | 1.02 | 1.04 | 177050.0 |
| 2016-06-02 | AAUAF-DELISTED | Stock | 1.03 | 1.09 | 1.02 | 1.03 | 180177.0 |
| 2016-06-02 | AAV-DELISTED | Stock | 5.85 | 5.99 | 5.84 | 5.92 | 65978.0 |
| 2016-06-02 | AAWW-DELISTED | Stock | 43.0 | 43.83 | 42.7 | 43.54 | 226293.0 |
| 2016-06-02 | AAXJ | Stock | 53.24 | 53.64 | 53.22 | 53.62 | 507084.0 |
| 2016-06-02 | AAXN-DELISTED | Stock | 22.26 | 22.88 | 22.05 | 22.84 | 665144.0 |
| 2016-06-02 | AB | Stock | 23.55 | 23.75 | 23.35 | 23.57 | 127700.0 |
| 2016-06-02 | ABAC-DELISTED | Stock | 0.6532 | 0.6989 | 0.6532 | 0.6989 | 800.0 |
| 2016-06-02 | ABAX-DELISTED | Stock | 46.62 | 47.47 | 46.1801 | 47.47 | 84943.0 |
| 2016-06-02 | ABB-DELISTED | Stock | 20.76 | 20.86 | 20.71 | 20.84 | 1335680.0 |
| 2016-06-02 | ABBNY-DELISTED | Stock | 20.76 | 20.86 | 20.71 | 20.84 | 1491713.0 |
| 2016-06-02 | ABBV | Stock | 62.87 | 65.15 | 62.83 | 65.09 | 11628000.0 |
| 2016-06-02 | ABC-DELISTED | Stock | 75.81 | 77.23 | 75.66 | 77.08 | 2742459.0 |
| 2016-06-02 | ABCB | Stock | 31.67 | 31.9 | 31.43 | 31.88 | 160700.0 |
| 2016-06-02 | ABCD-DELISTED | Stock | 4.53 | 4.68 | 4.53 | 4.68 | 8837.0 |
| 2016-06-02 | ABCO-DELISTED | Stock | 33.91 | 34.47 | 33.49 | 34.35 | 380491.0 |
| 2016-06-02 | ABDC-DELISTED | Stock | 12.4 | 12.4599 | 12.25 | 12.3 | 37063.0 |
| 2016-06-02 | ABE-DELISTED | Stock | 11.79 | 11.87 | 11.76 | 11.87 | 5657.0 |
| 2016-06-02 | ABEO | Stock | 77.5 | 77.75 | 73.5 | 76.0 | 1932.0 |
| 2016-06-02 | ABEV | Stock | 5.3 | 5.36 | 5.28 | 5.36 | 11393200.0 |
| 2016-06-02 | ABG | Stock | 55.42 | 56.58 | 55.42 | 56.18 | 193100.0 |
| 2016-06-02 | ABIL-DELISTED | Stock | 3.18 | 3.29 | 3.0 | 3.06 | 34471.0 |
| 2016-06-02 | ABM | Stock | 34.07 | 34.58 | 34.03 | 34.42 | 210300.0 |
| 2016-06-02 | ABMD-DELISTED | Stock | 101.5 | 101.97 | 100.83 | 101.86 | 331882.0 |
| 2016-06-02 | ABR | Stock | 7.03 | 7.04 | 6.97 | 7.03 | 38600.0 |
> showing 50 of 6,579 rows — these rows as CSV