PREVIEW / stock_daily / 2015-08-06
file: by_date/stock_daily/2015/2015-08-06.parquet size: 224 KB rows: 6,668 symbols: 3,487
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-06 | AAPL | Stock | 28.9925 | 29.125 | 28.53 | 28.7825 | 211612000.0 |
| 2015-08-06 | MSFT | Stock | 47.71 | 47.77 | 46.33 | 46.62 | 27368000.0 |
| 2015-08-06 | NVDA | Stock | 0.5133 | 0.517 | 0.5028 | 0.5112 | 655676000.0 |
| 2015-08-06 | AMZN | Stock | 26.965 | 27.137 | 26.376 | 26.473 | 76410000.0 |
| 2015-08-06 | GOOGL | Stock | 33.6995 | 33.7375 | 33.0365 | 33.5075 | 40659680.0 |
| 2015-08-06 | META | Stock | 97.18 | 98.74 | 94.42 | 95.12 | 42271300.0 |
| 2015-08-06 | TSLA | Stock | 16.636 | 17.0 | 15.7413 | 16.4087 | 219357000.0 |
| 2015-08-06 | TLT | Stock | 122.0 | 122.87 | 122.0 | 122.73 | 6118061.0 |
| 2015-08-06 | ES | Stock | 49.28 | 49.62 | 48.98 | 49.53 | 1556200.0 |
| 2015-08-06 | CL | Stock | 69.2 | 69.3 | 68.64 | 68.65 | 2989000.0 |
| 2015-08-06 | A | Stock | 40.95 | 40.96 | 39.91 | 40.12 | 1932000.0 |
| 2015-08-06 | AA.B-DELISTED | Stock | 36.11 | 36.63 | 35.63 | 36.0 | 60866.0 |
| 2015-08-06 | AABA-DELISTED | Stock | 37.34 | 37.52 | 36.3 | 36.45 | 11270438.0 |
| 2015-08-06 | AAC-DELISTED | Stock | 20.73 | 21.28 | 19.47 | 20.03 | 652337.0 |
| 2015-08-06 | AACG | Stock | 3.56 | 3.56 | 3.4 | 3.42 | 16200.0 |
| 2015-08-06 | AAIC-DELISTED | Stock | 18.71 | 18.72 | 18.35 | 18.45 | 197352.0 |
| 2015-08-06 | AAL | Stock | 43.25 | 43.45 | 41.76 | 42.18 | 7395500.0 |
| 2015-08-06 | AAMC-DELISTED | Stock | 38.6882 | 38.6882 | 37.5 | 38.2706 | 13019.0 |
| 2015-08-06 | AAME | Stock | 3.71 | 3.72 | 3.59 | 3.72 | 1400.0 |
| 2015-08-06 | AAMI | Stock | 17.36 | 17.88 | 17.12 | 17.81 | 180600.0 |
| 2015-08-06 | AAOI | Stock | 19.95 | 21.56 | 19.7 | 20.95 | 1646300.0 |
| 2015-08-06 | AAON | Stock | 14.3133 | 15.3267 | 14.3133 | 15.2067 | 485550.0 |
| 2015-08-06 | AAP | Stock | 175.59 | 175.78 | 171.36 | 172.74 | 596800.0 |
| 2015-08-06 | AAT | Stock | 40.39 | 40.62 | 39.5 | 40.24 | 255700.0 |
| 2015-08-06 | AAU-DELISTED | Stock | 0.7 | 0.73 | 0.6809 | 0.7161 | 60859.0 |
| 2015-08-06 | AAUAF-DELISTED | Stock | 0.7 | 0.73 | 0.6809 | 0.7161 | 61798.0 |
| 2015-08-06 | AAV-DELISTED | Stock | 5.61 | 5.76 | 5.48 | 5.76 | 96817.0 |
| 2015-08-06 | AAVL-DELISTED | Stock | 14.99 | 15.15 | 14.21 | 14.34 | 180251.0 |
| 2015-08-06 | AAWW-DELISTED | Stock | 47.87 | 47.94 | 46.55 | 46.58 | 387221.0 |
| 2015-08-06 | AAXJ | Stock | 58.37 | 58.53 | 58.075 | 58.19 | 1222281.0 |
| 2015-08-06 | AAXN-DELISTED | Stock | 25.45 | 25.595 | 23.95 | 24.44 | 2184626.0 |
| 2015-08-06 | AB | Stock | 27.89 | 28.07 | 27.25 | 27.55 | 261300.0 |
| 2015-08-06 | ABAC-DELISTED | Stock | 1.0601 | 1.0999 | 1.04 | 1.0999 | 8880.0 |
| 2015-08-06 | ABAX-DELISTED | Stock | 49.96 | 49.96 | 48.71 | 48.75 | 118089.0 |
| 2015-08-06 | ABB-DELISTED | Stock | 20.41 | 20.455 | 20.33 | 20.4 | 1242453.0 |
| 2015-08-06 | ABBNY-DELISTED | Stock | 20.41 | 20.455 | 20.33 | 20.39 | 1327600.0 |
| 2015-08-06 | ABBV | Stock | 70.37 | 70.78 | 68.8 | 69.24 | 6172200.0 |
| 2015-08-06 | ABC-DELISTED | Stock | 107.37 | 107.85 | 104.56 | 104.8 | 1466249.0 |
| 2015-08-06 | ABCB | Stock | 28.24 | 28.45 | 27.94 | 28.14 | 211100.0 |
| 2015-08-06 | ABCD-DELISTED | Stock | 4.8 | 4.81 | 4.52 | 4.68 | 43460.0 |
| 2015-08-06 | ABCO-DELISTED | Stock | 46.64 | 52.0 | 45.81 | 47.91 | 1710557.0 |
| 2015-08-06 | ABCW-DELISTED | Stock | 39.58 | 40.01 | 39.2119 | 39.56 | 15768.0 |
| 2015-08-06 | ABDC-DELISTED | Stock | 12.15 | 12.44 | 11.5 | 11.91 | 98458.0 |
| 2015-08-06 | ABE-DELISTED | Stock | 12.34 | 12.3999 | 12.22 | 12.31 | 2778.0 |
| 2015-08-06 | ABEO | Stock | 159.25 | 159.25 | 142.5 | 146.0 | 16320.0 |
| 2015-08-06 | ABEOW-DELISTED | Stock | 2.32 | 2.32 | 2.2999 | 2.2999 | 2289.0 |
| 2015-08-06 | ABEV | Stock | 5.65 | 5.66 | 5.54 | 5.57 | 11095200.0 |
| 2015-08-06 | ABG | Stock | 86.22 | 86.23 | 83.87 | 85.21 | 396300.0 |
| 2015-08-06 | ABGB-DELISTED | Stock | 6.52 | 6.61 | 6.23 | 6.45 | 513193.0 |
| 2015-08-06 | ABM | Stock | 33.28 | 33.84 | 33.08 | 33.21 | 232500.0 |
> showing 50 of 6,668 rows — these rows as CSV