PREVIEW / stock_daily / 2017-11-06
file: by_date/stock_daily/2017/2017-11-06.parquet size: 216 KB rows: 6,477 symbols: 2,926
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-06 | AAPL | Stock | 43.0925 | 43.7475 | 42.93 | 43.5625 | 140105200.0 |
| 2017-11-06 | MSFT | Stock | 84.2 | 84.7 | 84.08 | 84.47 | 19860900.0 |
| 2017-11-06 | NVDA | Stock | 5.18 | 5.2495 | 5.1675 | 5.2408 | 389944000.0 |
| 2017-11-06 | AMZN | Stock | 55.4575 | 56.2705 | 55.4385 | 56.033 | 67622000.0 |
| 2017-11-06 | GOOGL | Stock | 52.455 | 52.6295 | 52.1 | 52.134 | 18294960.0 |
| 2017-11-06 | META | Stock | 178.56 | 180.45 | 178.31 | 180.17 | 13312700.0 |
| 2017-11-06 | TSLA | Stock | 20.4667 | 20.5 | 19.934 | 20.1853 | 97290000.0 |
| 2017-11-06 | TLT | Stock | 125.93 | 126.22 | 125.7192 | 126.11 | 6246719.0 |
| 2017-11-06 | ES | Stock | 63.58 | 64.02 | 63.27 | 63.7 | 2325900.0 |
| 2017-11-06 | CL | Stock | 70.27 | 70.63 | 69.75 | 70.25 | 3197200.0 |
| 2017-11-06 | A | Stock | 68.27 | 68.45 | 67.87 | 68.22 | 995700.0 |
| 2017-11-06 | AA | Stock | 47.2 | 47.68 | 46.53 | 47.29 | 1726600.0 |
| 2017-11-06 | AAAP-DELISTED | Stock | 80.75 | 81.1 | 80.75 | 80.96 | 2026647.0 |
| 2017-11-06 | AABA-DELISTED | Stock | 70.27 | 71.96 | 70.27 | 71.72 | 6780988.0 |
| 2017-11-06 | AAC-DELISTED | Stock | 10.08 | 11.36 | 10.0 | 11.14 | 233754.0 |
| 2017-11-06 | AACG | Stock | 4.05 | 4.14 | 4.05 | 4.14 | 800.0 |
| 2017-11-06 | AAIC-DELISTED | Stock | 11.0 | 11.22 | 11.0 | 11.14 | 601227.0 |
| 2017-11-06 | AAL | Stock | 47.46 | 48.1 | 47.28 | 47.51 | 4249500.0 |
| 2017-11-06 | AAM.A-DELISTED | Stock | 26.23 | 26.42 | 26.22 | 26.41 | 101825.0 |
| 2017-11-06 | AAME | Stock | 3.6 | 3.65 | 3.6 | 3.6 | 8800.0 |
| 2017-11-06 | AAMI | Stock | 15.72 | 15.96 | 15.66 | 15.86 | 366000.0 |
| 2017-11-06 | AAOI | Stock | 37.58 | 38.72 | 36.7 | 37.8 | 2389000.0 |
| 2017-11-06 | AAON | Stock | 23.0 | 23.1667 | 22.8333 | 23.1333 | 160800.0 |
| 2017-11-06 | AAP | Stock | 81.53 | 81.81 | 80.31 | 80.71 | 1173500.0 |
| 2017-11-06 | AAT | Stock | 38.35 | 38.87 | 38.27 | 38.51 | 314400.0 |
| 2017-11-06 | AAU-DELISTED | Stock | 0.91 | 0.9701 | 0.88 | 0.96 | 489595.0 |
| 2017-11-06 | AAUAF-DELISTED | Stock | 0.91 | 0.9701 | 0.88 | 0.96 | 502317.0 |
| 2017-11-06 | AAV-DELISTED | Stock | 5.7 | 5.8383 | 5.65 | 5.75 | 176220.0 |
| 2017-11-06 | AAWW-DELISTED | Stock | 60.5 | 61.25 | 58.9505 | 60.85 | 252338.0 |
| 2017-11-06 | AAXJ | Stock | 75.9 | 76.53 | 75.89 | 76.53 | 1313730.0 |
| 2017-11-06 | AAXN-DELISTED | Stock | 23.4 | 23.49 | 23.16 | 23.21 | 621198.0 |
| 2017-11-06 | AB | Stock | 25.65 | 25.7 | 25.3 | 25.45 | 132500.0 |
| 2017-11-06 | ABAC-DELISTED | Stock | 3.29 | 3.44 | 3.29 | 3.4 | 13377.0 |
| 2017-11-06 | ABAX-DELISTED | Stock | 47.62 | 47.72 | 46.69 | 47.0 | 72081.0 |
| 2017-11-06 | ABB-DELISTED | Stock | 26.18 | 26.29 | 26.135 | 26.275 | 1297543.0 |
| 2017-11-06 | ABBNY-DELISTED | Stock | 26.18 | 26.29 | 26.135 | 26.28 | 1335989.0 |
| 2017-11-06 | ABBV | Stock | 92.22 | 93.58 | 91.42 | 92.96 | 5633600.0 |
| 2017-11-06 | ABC-DELISTED | Stock | 74.8 | 75.2 | 73.19 | 74.85 | 3134459.0 |
| 2017-11-06 | ABCB | Stock | 48.15 | 48.45 | 47.76 | 47.9 | 68800.0 |
| 2017-11-06 | ABCD-DELISTED | Stock | 6.31 | 6.35 | 6.16 | 6.23 | 14515.0 |
| 2017-11-06 | ABCO-DELISTED | Stock | 53.7 | 53.7 | 53.05 | 53.1 | 1233251.0 |
| 2017-11-06 | ABDC-DELISTED | Stock | 8.84 | 8.84 | 8.57 | 8.67 | 78097.0 |
| 2017-11-06 | ABE-DELISTED | Stock | 14.3998 | 14.4802 | 14.39 | 14.45 | 62103.0 |
| 2017-11-06 | ABEO | Stock | 415.0 | 423.75 | 405.0 | 407.5 | 30176.0 |
| 2017-11-06 | ABEOW-DELISTED | Stock | 11.8 | 11.8647 | 11.14 | 11.14 | 3645.0 |
| 2017-11-06 | ABEV | Stock | 6.22 | 6.29 | 6.18 | 6.24 | 25072700.0 |
| 2017-11-06 | ABG | Stock | 61.95 | 63.0 | 61.6 | 61.65 | 184500.0 |
| 2017-11-06 | ABIL-DELISTED | Stock | 0.6316 | 0.632 | 0.62 | 0.622 | 53073.0 |
| 2017-11-06 | ABLX-DELISTED | Stock | 20.68 | 21.89 | 20.65 | 21.08 | 234644.0 |
| 2017-11-06 | ABM | Stock | 41.04 | 41.18 | 40.52 | 40.63 | 130100.0 |
> showing 50 of 6,477 rows — these rows as CSV