PREVIEW / stock_daily / 2015-08-17
file: by_date/stock_daily/2015/2015-08-17.parquet size: 223 KB rows: 6,660 symbols: 3,459
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-17 | AAPL | Stock | 29.01 | 29.4125 | 28.875 | 29.29 | 163538800.0 |
| 2015-08-17 | MSFT | Stock | 46.81 | 47.45 | 46.57 | 47.32 | 21099700.0 |
| 2015-08-17 | NVDA | Stock | 0.5875 | 0.5875 | 0.5775 | 0.5848 | 273880000.0 |
| 2015-08-17 | AMZN | Stock | 26.5645 | 26.937 | 26.356 | 26.761 | 51634000.0 |
| 2015-08-17 | GOOGL | Stock | 34.402 | 34.737 | 34.153 | 34.7055 | 24679020.0 |
| 2015-08-17 | META | Stock | 94.42 | 94.46 | 93.39 | 93.93 | 18313500.0 |
| 2015-08-17 | TSLA | Stock | 17.0373 | 17.106 | 16.7007 | 16.9993 | 107650500.0 |
| 2015-08-17 | TLT | Stock | 124.71 | 125.1 | 124.39 | 124.52 | 7880324.0 |
| 2015-08-17 | ES | Stock | 51.23 | 51.74 | 51.12 | 51.61 | 1257000.0 |
| 2015-08-17 | CL | Stock | 67.46 | 67.8 | 67.08 | 67.66 | 1870500.0 |
| 2015-08-17 | A | Stock | 38.36 | 39.02 | 38.12 | 38.82 | 3302100.0 |
| 2015-08-17 | AA.B-DELISTED | Stock | 34.88 | 35.21 | 34.53 | 34.83 | 30475.0 |
| 2015-08-17 | AABA-DELISTED | Stock | 36.24 | 36.24 | 35.765 | 36.095 | 7387009.0 |
| 2015-08-17 | AAC-DELISTED | Stock | 22.4 | 23.64 | 22.0386 | 23.15 | 554301.0 |
| 2015-08-17 | AACG | Stock | 3.15 | 3.26 | 3.06 | 3.11 | 72900.0 |
| 2015-08-17 | AAIC-DELISTED | Stock | 18.04 | 18.35 | 18.015 | 18.23 | 285358.0 |
| 2015-08-17 | AAL | Stock | 42.96 | 44.02 | 42.82 | 43.95 | 8385400.0 |
| 2015-08-17 | AAMC-DELISTED | Stock | 26.8324 | 27.2265 | 23.1735 | 23.4559 | 238979.0 |
| 2015-08-17 | AAME | Stock | 3.64 | 3.65 | 3.54 | 3.63 | 1300.0 |
| 2015-08-17 | AAMI | Stock | 17.6 | 17.88 | 17.41 | 17.65 | 175000.0 |
| 2015-08-17 | AAOI | Stock | 21.96 | 22.7 | 21.5 | 21.87 | 1874800.0 |
| 2015-08-17 | AAON | Stock | 15.4267 | 15.46 | 15.1467 | 15.3333 | 233700.0 |
| 2015-08-17 | AAP | Stock | 187.24 | 188.06 | 183.12 | 184.69 | 1580600.0 |
| 2015-08-17 | AAT | Stock | 41.7 | 42.18 | 41.33 | 42.17 | 155600.0 |
| 2015-08-17 | AAU-DELISTED | Stock | 0.63 | 0.6799 | 0.5722 | 0.59 | 113278.0 |
| 2015-08-17 | AAUAF-DELISTED | Stock | 0.63 | 0.6799 | 0.5722 | 0.59 | 114158.0 |
| 2015-08-17 | AAV-DELISTED | Stock | 5.42 | 5.42 | 5.3 | 5.33 | 72676.0 |
| 2015-08-17 | AAVL-DELISTED | Stock | 10.5 | 11.4 | 10.11 | 10.99 | 1965091.0 |
| 2015-08-17 | AAWW-DELISTED | Stock | 44.76 | 45.44 | 44.43 | 45.19 | 191152.0 |
| 2015-08-17 | AAXJ | Stock | 56.18 | 56.4902 | 56.09 | 56.49 | 657766.0 |
| 2015-08-17 | AAXN-DELISTED | Stock | 23.6 | 24.41 | 23.57 | 24.29 | 887620.0 |
| 2015-08-17 | AB | Stock | 28.57 | 29.03 | 28.29 | 28.87 | 192700.0 |
| 2015-08-17 | ABAC-DELISTED | Stock | 0.91 | 0.916 | 0.87 | 0.88 | 26359.0 |
| 2015-08-17 | ABAX-DELISTED | Stock | 48.27 | 48.89 | 47.43 | 48.26 | 152197.0 |
| 2015-08-17 | ABB-DELISTED | Stock | 19.96 | 20.06 | 19.9 | 20.05 | 789143.0 |
| 2015-08-17 | ABBNY-DELISTED | Stock | 19.96 | 20.07 | 19.9 | 20.07 | 818790.0 |
| 2015-08-17 | ABBV | Stock | 68.71 | 69.82 | 68.3 | 69.37 | 17669900.0 |
| 2015-08-17 | ABC-DELISTED | Stock | 103.75 | 104.68 | 102.79 | 104.6 | 816339.0 |
| 2015-08-17 | ABCB | Stock | 28.25 | 28.99 | 27.92 | 28.5 | 137100.0 |
| 2015-08-17 | ABCD-DELISTED | Stock | 4.4 | 4.74 | 4.4 | 4.68 | 85212.0 |
| 2015-08-17 | ABCO-DELISTED | Stock | 51.36 | 52.64 | 50.76 | 52.28 | 336269.0 |
| 2015-08-17 | ABCW-DELISTED | Stock | 41.5 | 41.6 | 41.32 | 41.5 | 7932.0 |
| 2015-08-17 | ABDC-DELISTED | Stock | 12.86 | 13.06 | 12.82 | 13.04 | 65359.0 |
| 2015-08-17 | ABE-DELISTED | Stock | 12.0503 | 12.0503 | 11.84 | 11.85 | 4284.0 |
| 2015-08-17 | ABEO | Stock | 134.0 | 137.75 | 128.5 | 135.25 | 5504.0 |
| 2015-08-17 | ABEOW-DELISTED | Stock | 2.09 | 2.35 | 2.05 | 2.35 | 1591.0 |
| 2015-08-17 | ABEV | Stock | 5.34 | 5.38 | 5.28 | 5.3 | 16525800.0 |
| 2015-08-17 | ABG | Stock | 83.42 | 84.74 | 82.81 | 84.73 | 259100.0 |
| 2015-08-17 | ABGB-DELISTED | Stock | 5.15 | 5.15 | 4.81 | 4.93 | 125163.0 |
| 2015-08-17 | ABM | Stock | 33.52 | 33.89 | 33.29 | 33.8 | 117600.0 |
> showing 50 of 6,660 rows — these rows as CSV