PREVIEW / stock_daily / 2017-11-15
file: by_date/stock_daily/2017/2017-11-15.parquet size: 215 KB rows: 6,465 symbols: 2,897
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-11-15 | AAPL | Stock | 42.4925 | 42.58 | 42.095 | 42.27 | 116632400.0 |
| 2017-11-15 | MSFT | Stock | 83.47 | 83.69 | 82.69 | 82.98 | 19383100.0 |
| 2017-11-15 | NVDA | Stock | 5.2988 | 5.3 | 5.195 | 5.2495 | 501948000.0 |
| 2017-11-15 | AMZN | Stock | 56.3505 | 56.5875 | 56.0815 | 56.3345 | 78574000.0 |
| 2017-11-15 | GOOGL | Stock | 51.75 | 51.9815 | 51.538 | 51.8205 | 18105240.0 |
| 2017-11-15 | META | Stock | 176.66 | 178.57 | 176.4 | 177.95 | 10253700.0 |
| 2017-11-15 | TSLA | Stock | 20.4007 | 20.8327 | 20.1 | 20.7533 | 89680500.0 |
| 2017-11-15 | TLT | Stock | 126.06 | 126.665 | 125.64 | 126.56 | 9568163.0 |
| 2017-11-15 | ES | Stock | 65.91 | 66.15 | 64.96 | 65.0 | 1607800.0 |
| 2017-11-15 | CL | Stock | 73.46 | 73.47 | 72.42 | 72.48 | 3063900.0 |
| 2017-11-15 | A | Stock | 67.29 | 67.56 | 66.91 | 67.31 | 2042300.0 |
| 2017-11-15 | AA | Stock | 41.27 | 42.37 | 40.73 | 42.21 | 4734000.0 |
| 2017-11-15 | AAAP-DELISTED | Stock | 81.01 | 81.11 | 80.97 | 81.0 | 568151.0 |
| 2017-11-15 | AABA-DELISTED | Stock | 68.31 | 69.55 | 68.045 | 69.42 | 7284782.0 |
| 2017-11-15 | AAC-DELISTED | Stock | 10.09 | 10.15 | 9.55 | 9.8 | 236541.0 |
| 2017-11-15 | AACG | Stock | 4.38 | 4.39 | 4.38 | 4.39 | 1200.0 |
| 2017-11-15 | AAIC-DELISTED | Stock | 11.25 | 11.35 | 11.2001 | 11.27 | 278177.0 |
| 2017-11-15 | AAL | Stock | 45.71 | 47.31 | 45.45 | 47.19 | 5223100.0 |
| 2017-11-15 | AAM.A-DELISTED | Stock | 26.411 | 26.58 | 26.28 | 26.31 | 200114.0 |
| 2017-11-15 | AAMC-DELISTED | Stock | 22.2353 | 22.7941 | 22.0588 | 22.3235 | 16286.0 |
| 2017-11-15 | AAME | Stock | 3.8 | 3.8 | 3.65 | 3.65 | 1000.0 |
| 2017-11-15 | AAMI | Stock | 15.48 | 15.84 | 15.32 | 15.61 | 2106800.0 |
| 2017-11-15 | AAOI | Stock | 45.8 | 45.8 | 44.13 | 45.4 | 1819800.0 |
| 2017-11-15 | AAON | Stock | 22.7 | 22.8 | 22.4333 | 22.6 | 175950.0 |
| 2017-11-15 | AAP | Stock | 93.93 | 95.49 | 91.37 | 91.58 | 3074000.0 |
| 2017-11-15 | AAT | Stock | 39.58 | 39.58 | 39.2 | 39.41 | 256100.0 |
| 2017-11-15 | AAU-DELISTED | Stock | 0.92 | 0.9251 | 0.887 | 0.8983 | 305765.0 |
| 2017-11-15 | AAUAF-DELISTED | Stock | 0.92 | 0.9251 | 0.887 | 0.8983 | 320751.0 |
| 2017-11-15 | AAV-DELISTED | Stock | 5.3 | 5.375 | 5.2 | 5.25 | 57058.0 |
| 2017-11-15 | AAWW-DELISTED | Stock | 52.1 | 53.45 | 52.1 | 53.0 | 224733.0 |
| 2017-11-15 | AAXJ | Stock | 75.22 | 75.43 | 74.9599 | 75.24 | 886623.0 |
| 2017-11-15 | AAXN-DELISTED | Stock | 21.17 | 21.95 | 21.13 | 21.9 | 709048.0 |
| 2017-11-15 | AB | Stock | 24.75 | 25.25 | 24.6 | 25.2 | 310600.0 |
| 2017-11-15 | ABAC-DELISTED | Stock | 3.07 | 3.085 | 2.67 | 2.95 | 15795.0 |
| 2017-11-15 | ABAX-DELISTED | Stock | 45.99 | 47.64 | 45.91 | 47.21 | 73209.0 |
| 2017-11-15 | ABB-DELISTED | Stock | 25.14 | 25.1701 | 25.035 | 25.09 | 898047.0 |
| 2017-11-15 | ABBNY-DELISTED | Stock | 25.14 | 25.1701 | 25.035 | 25.09 | 1217131.0 |
| 2017-11-15 | ABBV | Stock | 94.63 | 94.7 | 92.72 | 93.76 | 4745700.0 |
| 2017-11-15 | ABC-DELISTED | Stock | 75.32 | 77.66 | 74.6 | 77.53 | 2371586.0 |
| 2017-11-15 | ABCB | Stock | 46.3 | 47.5 | 44.75 | 46.95 | 156200.0 |
| 2017-11-15 | ABCD-DELISTED | Stock | 5.93 | 5.93 | 5.26 | 5.56 | 170480.0 |
| 2017-11-15 | ABCO-DELISTED | Stock | 53.55 | 53.75 | 53.55 | 53.75 | 1199726.0 |
| 2017-11-15 | ABDC-DELISTED | Stock | 7.1 | 7.2 | 7.0 | 7.03 | 171371.0 |
| 2017-11-15 | ABE-DELISTED | Stock | 13.81 | 14.0 | 13.81 | 13.97 | 21850.0 |
| 2017-11-15 | ABEO | Stock | 380.0 | 435.0 | 367.25 | 418.75 | 56296.0 |
| 2017-11-15 | ABEOW-DELISTED | Stock | 11.3 | 12.08 | 11.3 | 11.75 | 3650.0 |
| 2017-11-15 | ABEV | Stock | 6.05 | 6.08 | 6.02 | 6.05 | 8667900.0 |
| 2017-11-15 | ABG | Stock | 61.65 | 62.4 | 61.15 | 62.25 | 119200.0 |
| 2017-11-15 | ABIL-DELISTED | Stock | 0.63 | 0.63 | 0.521 | 0.5348 | 512568.0 |
| 2017-11-15 | ABLX-DELISTED | Stock | 20.56 | 20.86 | 20.37 | 20.59 | 175603.0 |
> showing 50 of 6,465 rows — these rows as CSV