PREVIEW / stock_daily / 2016-05-26
file: by_date/stock_daily/2016/2016-05-26.parquet size: 218 KB rows: 6,545 symbols: 3,283
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-05-26 | AAPL | Stock | 24.92 | 25.1825 | 24.66 | 25.1025 | 225324800.0 |
| 2016-05-26 | MSFT | Stock | 51.93 | 51.98 | 51.36 | 51.89 | 24335200.0 |
| 2016-05-26 | NVDA | Stock | 1.1312 | 1.1495 | 1.128 | 1.1413 | 309964000.0 |
| 2016-05-26 | AMZN | Stock | 35.4165 | 35.75 | 35.3645 | 35.7455 | 48934000.0 |
| 2016-05-26 | GOOGL | Stock | 36.8 | 37.055 | 36.65 | 36.8465 | 27202380.0 |
| 2016-05-26 | META | Stock | 118.24 | 119.76 | 117.92 | 119.47 | 18481300.0 |
| 2016-05-26 | TSLA | Stock | 14.7 | 15.0173 | 14.6033 | 15.008 | 61086000.0 |
| 2016-05-26 | TLT | Stock | 129.81 | 130.45 | 129.8 | 130.04 | 5419303.0 |
| 2016-05-26 | ES | Stock | 53.9 | 54.83 | 53.9 | 54.8 | 2818900.0 |
| 2016-05-26 | CL | Stock | 70.68 | 70.95 | 70.35 | 70.49 | 6419500.0 |
| 2016-05-26 | A | Stock | 45.58 | 45.6 | 45.2 | 45.51 | 2569600.0 |
| 2016-05-26 | AA.B-DELISTED | Stock | 33.71 | 34.2899 | 33.1201 | 33.39 | 73847.0 |
| 2016-05-26 | AAAP-DELISTED | Stock | 29.61 | 29.61 | 28.4935 | 28.78 | 38140.0 |
| 2016-05-26 | AABA-DELISTED | Stock | 36.13 | 36.85 | 36.07 | 36.77 | 15441769.0 |
| 2016-05-26 | AAC-DELISTED | Stock | 21.28 | 21.57 | 20.58 | 20.64 | 107301.0 |
| 2016-05-26 | AACG | Stock | 4.91 | 5.1 | 4.91 | 4.93 | 10600.0 |
| 2016-05-26 | AAIC-DELISTED | Stock | 13.08 | 13.11 | 12.83 | 12.83 | 180775.0 |
| 2016-05-26 | AAL | Stock | 32.13 | 32.34 | 31.37 | 31.51 | 7222800.0 |
| 2016-05-26 | AAMC-DELISTED | Stock | 4.7659 | 5.2147 | 4.7647 | 4.9912 | 67201.0 |
| 2016-05-26 | AAME | Stock | 3.36 | 3.57 | 3.36 | 3.44 | 5900.0 |
| 2016-05-26 | AAMI | Stock | 14.91 | 14.915 | 14.74 | 14.87 | 364000.0 |
| 2016-05-26 | AAOI | Stock | 10.11 | 10.355 | 10.05 | 10.2 | 425100.0 |
| 2016-05-26 | AAON | Stock | 18.7 | 18.92 | 18.5 | 18.5333 | 225300.0 |
| 2016-05-26 | AAP | Stock | 154.55 | 156.79 | 153.5 | 156.66 | 2191700.0 |
| 2016-05-26 | AAT | Stock | 39.69 | 39.9 | 39.27 | 39.86 | 102800.0 |
| 2016-05-26 | AAU-DELISTED | Stock | 1.09 | 1.139 | 1.03 | 1.07 | 225397.0 |
| 2016-05-26 | AAUAF-DELISTED | Stock | 1.09 | 1.139 | 1.03 | 1.07 | 227042.0 |
| 2016-05-26 | AAV-DELISTED | Stock | 5.97 | 6.03 | 5.7899 | 5.85 | 88031.0 |
| 2016-05-26 | AAWW-DELISTED | Stock | 45.11 | 45.5 | 44.03 | 44.08 | 205467.0 |
| 2016-05-26 | AAXJ | Stock | 52.75 | 52.82 | 52.5606 | 52.67 | 958413.0 |
| 2016-05-26 | AAXN-DELISTED | Stock | 21.94 | 22.07 | 21.77 | 22.0 | 491897.0 |
| 2016-05-26 | AB | Stock | 23.3 | 23.51 | 23.14 | 23.33 | 163100.0 |
| 2016-05-26 | ABAC-DELISTED | Stock | 0.6675 | 0.67 | 0.644 | 0.66 | 26394.0 |
| 2016-05-26 | ABAX-DELISTED | Stock | 45.83 | 46.06 | 44.7301 | 45.09 | 79953.0 |
| 2016-05-26 | ABB-DELISTED | Stock | 21.03 | 21.07 | 20.9 | 20.92 | 1149047.0 |
| 2016-05-26 | ABBNY-DELISTED | Stock | 21.03 | 21.07 | 20.9 | 20.92 | 1232853.0 |
| 2016-05-26 | ABBV | Stock | 61.0 | 62.17 | 60.9 | 61.9 | 6537100.0 |
| 2016-05-26 | ABC-DELISTED | Stock | 74.04 | 74.07 | 73.31 | 73.71 | 1310894.0 |
| 2016-05-26 | ABCB | Stock | 32.0 | 32.1 | 31.7 | 31.81 | 186200.0 |
| 2016-05-26 | ABCD-DELISTED | Stock | 4.66 | 4.68 | 4.59 | 4.63 | 10105.0 |
| 2016-05-26 | ABCO-DELISTED | Stock | 32.34 | 32.8 | 32.15 | 32.42 | 165828.0 |
| 2016-05-26 | ABDC-DELISTED | Stock | 12.1 | 12.13 | 11.835 | 12.13 | 20497.0 |
| 2016-05-26 | ABE-DELISTED | Stock | 11.7228 | 11.74 | 11.71 | 11.7398 | 3129.0 |
| 2016-05-26 | ABEO | Stock | 76.75 | 82.25 | 75.0 | 80.5 | 8236.0 |
| 2016-05-26 | ABEOW-DELISTED | Stock | 1.07 | 1.39 | 1.0 | 1.3 | 16525.0 |
| 2016-05-26 | ABEV | Stock | 5.32 | 5.36 | 5.31 | 5.32 | 6235500.0 |
| 2016-05-26 | ABG | Stock | 55.03 | 55.62 | 54.69 | 54.81 | 134600.0 |
| 2016-05-26 | ABIL-DELISTED | Stock | 2.78 | 3.0341 | 2.78 | 2.9 | 62445.0 |
| 2016-05-26 | ABM | Stock | 33.43 | 33.74 | 33.25 | 33.67 | 294000.0 |
| 2016-05-26 | ABMD-DELISTED | Stock | 99.43 | 99.61 | 98.51 | 98.79 | 244744.0 |
> showing 50 of 6,545 rows — these rows as CSV