PREVIEW / stock_daily / 2017-11-03
file: by_date/stock_daily/2017/2017-11-03.parquet size: 215 KB rows: 6,458 symbols: 2,914
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-03 | AAPL | Stock | 43.5 | 43.565 | 42.78 | 43.125 | 237594400.0 |
| 2017-11-03 | MSFT | Stock | 84.08 | 84.54 | 83.4 | 84.14 | 17633500.0 |
| 2017-11-03 | NVDA | Stock | 5.18 | 5.2172 | 5.1335 | 5.2172 | 353640000.0 |
| 2017-11-03 | AMZN | Stock | 54.5575 | 55.634 | 54.426 | 55.58 | 75030000.0 |
| 2017-11-03 | GOOGL | Stock | 52.1375 | 52.533 | 51.8825 | 52.4995 | 27769220.0 |
| 2017-11-03 | META | Stock | 179.29 | 179.86 | 176.71 | 178.92 | 17822100.0 |
| 2017-11-03 | TSLA | Stock | 19.9667 | 20.4167 | 19.6753 | 20.406 | 133410000.0 |
| 2017-11-03 | TLT | Stock | 125.47 | 125.7 | 125.14 | 125.64 | 10984056.0 |
| 2017-11-03 | ES | Stock | 63.13 | 64.04 | 63.04 | 63.54 | 1381900.0 |
| 2017-11-03 | CL | Stock | 70.98 | 71.14 | 70.04 | 70.15 | 2506100.0 |
| 2017-11-03 | A | Stock | 68.09 | 68.67 | 68.01 | 68.37 | 1072300.0 |
| 2017-11-03 | AA | Stock | 47.25 | 47.43 | 46.71 | 47.12 | 1839000.0 |
| 2017-11-03 | AAAP-DELISTED | Stock | 80.75 | 81.15 | 80.73 | 81.0 | 636551.0 |
| 2017-11-03 | AABA-DELISTED | Stock | 71.01 | 71.3999 | 69.84 | 70.22 | 6055078.0 |
| 2017-11-03 | AAC-DELISTED | Stock | 10.36 | 10.48 | 9.77 | 10.09 | 348279.0 |
| 2017-11-03 | AACG | Stock | 4.4 | 4.53 | 4.4 | 4.44 | 6700.0 |
| 2017-11-03 | AAIC-DELISTED | Stock | 11.18 | 11.185 | 10.931 | 11.0 | 649109.0 |
| 2017-11-03 | AAL | Stock | 47.36 | 47.61 | 46.8 | 47.45 | 4037100.0 |
| 2017-11-03 | AAM.A-DELISTED | Stock | 26.15 | 26.23 | 26.15 | 26.23 | 16952.0 |
| 2017-11-03 | AAMC-DELISTED | Stock | 23.6471 | 23.6471 | 23.6471 | 23.6471 | 524.0 |
| 2017-11-03 | AAME | Stock | 3.65 | 3.65 | 3.51 | 3.6 | 1300.0 |
| 2017-11-03 | AAMI | Stock | 15.83 | 15.93 | 15.7 | 15.75 | 355800.0 |
| 2017-11-03 | AAOI | Stock | 39.3 | 39.873 | 37.56 | 37.82 | 2730700.0 |
| 2017-11-03 | AAON | Stock | 22.8667 | 23.1333 | 22.6333 | 22.9667 | 227700.0 |
| 2017-11-03 | AAP | Stock | 81.39 | 82.38 | 80.27 | 81.8 | 1108600.0 |
| 2017-11-03 | AAT | Stock | 38.8 | 38.89 | 38.08 | 38.36 | 382800.0 |
| 2017-11-03 | AAU-DELISTED | Stock | 0.9 | 0.94 | 0.9 | 0.9089 | 332669.0 |
| 2017-11-03 | AAUAF-DELISTED | Stock | 0.9 | 0.94 | 0.9 | 0.9089 | 345987.0 |
| 2017-11-03 | AAV-DELISTED | Stock | 5.7 | 5.75 | 5.6 | 5.65 | 117130.0 |
| 2017-11-03 | AAWW-DELISTED | Stock | 61.4 | 61.4 | 59.85 | 60.35 | 189534.0 |
| 2017-11-03 | AAXJ | Stock | 76.24 | 76.24 | 75.59 | 75.9 | 691479.0 |
| 2017-11-03 | AAXN-DELISTED | Stock | 23.45 | 23.45 | 23.175 | 23.4 | 378120.0 |
| 2017-11-03 | AB | Stock | 25.65 | 25.9 | 25.5 | 25.65 | 159400.0 |
| 2017-11-03 | ABAC-DELISTED | Stock | 3.3001 | 3.4 | 3.23 | 3.4 | 2800.0 |
| 2017-11-03 | ABAX-DELISTED | Stock | 47.54 | 48.1045 | 47.49 | 47.49 | 123863.0 |
| 2017-11-03 | ABB-DELISTED | Stock | 26.18 | 26.25 | 26.06 | 26.195 | 1366361.0 |
| 2017-11-03 | ABBNY-DELISTED | Stock | 26.18 | 26.25 | 26.06 | 26.2 | 1414438.0 |
| 2017-11-03 | ABBV | Stock | 91.3 | 92.56 | 90.91 | 92.31 | 3620800.0 |
| 2017-11-03 | ABC-DELISTED | Stock | 73.35 | 75.3 | 73.32 | 74.81 | 2427790.0 |
| 2017-11-03 | ABCB | Stock | 48.4 | 48.45 | 47.85 | 48.1 | 91400.0 |
| 2017-11-03 | ABCD-DELISTED | Stock | 6.33 | 6.3764 | 6.13 | 6.29 | 79908.0 |
| 2017-11-03 | ABCO-DELISTED | Stock | 53.95 | 53.95 | 53.575 | 53.65 | 652121.0 |
| 2017-11-03 | ABDC-DELISTED | Stock | 8.79 | 8.98 | 8.7 | 8.84 | 80821.0 |
| 2017-11-03 | ABE-DELISTED | Stock | 14.391 | 14.4092 | 14.37 | 14.384 | 4505.0 |
| 2017-11-03 | ABEO | Stock | 416.25 | 423.25 | 408.75 | 412.5 | 23116.0 |
| 2017-11-03 | ABEOW-DELISTED | Stock | 11.55 | 11.55 | 11.55 | 11.55 | 1000.0 |
| 2017-11-03 | ABEV | Stock | 6.3 | 6.32 | 6.12 | 6.17 | 43746500.0 |
| 2017-11-03 | ABG | Stock | 62.65 | 63.5 | 61.9 | 61.95 | 210000.0 |
| 2017-11-03 | ABIL-DELISTED | Stock | 0.63 | 0.632 | 0.6205 | 0.6316 | 48981.0 |
| 2017-11-03 | ABLX-DELISTED | Stock | 20.57 | 20.96 | 20.53 | 20.95 | 137522.0 |
> showing 50 of 6,458 rows — these rows as CSV