PREVIEW / stock_daily / 2015-10-28
file: by_date/stock_daily/2015/2015-10-28.parquet size: 222 KB rows: 6,631 symbols: 3,423
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-10-28 | AAPL | Stock | 29.2325 | 29.825 | 29.015 | 29.8175 | 342205600.0 |
| 2015-10-28 | MSFT | Stock | 53.54 | 53.98 | 52.86 | 53.98 | 47000800.0 |
| 2015-10-28 | NVDA | Stock | 0.7155 | 0.7168 | 0.705 | 0.7168 | 217036000.0 |
| 2015-10-28 | AMZN | Stock | 30.615 | 30.8615 | 30.475 | 30.855 | 78524000.0 |
| 2015-10-28 | GOOGL | Stock | 36.65 | 36.8685 | 36.3635 | 36.846 | 39603080.0 |
| 2015-10-28 | META | Stock | 103.9 | 104.48 | 102.92 | 104.2 | 24081500.0 |
| 2015-10-28 | TSLA | Stock | 14.0873 | 14.23 | 13.8867 | 14.1973 | 40929000.0 |
| 2015-10-28 | TLT | Stock | 124.27 | 124.34 | 123.3 | 123.83 | 8468672.0 |
| 2015-10-28 | ES | Stock | 51.93 | 52.16 | 50.43 | 50.97 | 1283500.0 |
| 2015-10-28 | CL | Stock | 69.0 | 69.16 | 68.12 | 68.83 | 3364000.0 |
| 2015-10-28 | A | Stock | 37.06 | 37.61 | 36.77 | 37.52 | 1780100.0 |
| 2015-10-28 | AA.B-DELISTED | Stock | 31.72 | 32.7 | 31.6901 | 32.39 | 83357.0 |
| 2015-10-28 | AABA-DELISTED | Stock | 34.3 | 35.27 | 34.3 | 35.1899 | 13933391.0 |
| 2015-10-28 | AAC-DELISTED | Stock | 28.4 | 28.4 | 22.66 | 23.78 | 622016.0 |
| 2015-10-28 | AACG | Stock | 3.75 | 3.79 | 3.67 | 3.67 | 16300.0 |
| 2015-10-28 | AAIC-DELISTED | Stock | 13.57 | 14.06 | 13.51 | 13.85 | 508815.0 |
| 2015-10-28 | AAL | Stock | 46.2 | 46.36 | 45.23 | 45.86 | 7629700.0 |
| 2015-10-28 | AAMC-DELISTED | Stock | 7.3088 | 7.9676 | 7.2059 | 7.5 | 48651.0 |
| 2015-10-28 | AAME | Stock | 4.3 | 4.32 | 4.07 | 4.29 | 12300.0 |
| 2015-10-28 | AAMI | Stock | 15.13 | 15.91 | 15.0 | 15.76 | 345100.0 |
| 2015-10-28 | AAOI | Stock | 20.38 | 21.59 | 20.145 | 21.3 | 580500.0 |
| 2015-10-28 | AAON | Stock | 13.92 | 14.3067 | 13.76 | 14.18 | 265200.0 |
| 2015-10-28 | AAP | Stock | 194.01 | 194.67 | 192.3 | 194.28 | 384600.0 |
| 2015-10-28 | AAT | Stock | 43.12 | 43.55 | 42.12 | 42.85 | 277800.0 |
| 2015-10-28 | AAU-DELISTED | Stock | 0.5811 | 0.6091 | 0.58 | 0.59 | 439976.0 |
| 2015-10-28 | AAUAF-DELISTED | Stock | 0.5811 | 0.6091 | 0.58 | 0.59 | 528208.0 |
| 2015-10-28 | AAV-DELISTED | Stock | 5.41 | 5.59 | 5.36 | 5.44 | 256164.0 |
| 2015-10-28 | AAVL-DELISTED | Stock | 8.04 | 8.58 | 7.84 | 8.56 | 356276.0 |
| 2015-10-28 | AAWW-DELISTED | Stock | 40.28 | 40.31 | 38.98 | 40.27 | 230502.0 |
| 2015-10-28 | AAXJ | Stock | 57.66 | 57.85 | 56.7 | 57.07 | 893428.0 |
| 2015-10-28 | AAXN-DELISTED | Stock | 23.03 | 23.49 | 22.55 | 23.48 | 1258575.0 |
| 2015-10-28 | AB | Stock | 26.85 | 26.99 | 26.26 | 26.71 | 327800.0 |
| 2015-10-28 | ABAC-DELISTED | Stock | 0.61 | 0.62 | 0.6025 | 0.6025 | 6265.0 |
| 2015-10-28 | ABAX-DELISTED | Stock | 46.2 | 54.04 | 46.2 | 53.5 | 843368.0 |
| 2015-10-28 | ABB-DELISTED | Stock | 18.67 | 18.94 | 18.58 | 18.77 | 3016242.0 |
| 2015-10-28 | ABBNY-DELISTED | Stock | 18.67 | 18.94 | 18.58 | 18.76 | 3563732.0 |
| 2015-10-28 | ABBV | Stock | 52.82 | 53.84 | 52.08 | 53.26 | 7869000.0 |
| 2015-10-28 | ABC-DELISTED | Stock | 97.68 | 98.18 | 96.21 | 97.49 | 3068960.0 |
| 2015-10-28 | ABCB | Stock | 32.25 | 32.75 | 31.99 | 32.33 | 1616000.0 |
| 2015-10-28 | ABCD-DELISTED | Stock | 4.63 | 4.85 | 4.63 | 4.835 | 23734.0 |
| 2015-10-28 | ABCO-DELISTED | Stock | 42.73 | 44.23 | 42.46 | 44.22 | 417475.0 |
| 2015-10-28 | ABCW-DELISTED | Stock | 41.41 | 42.09 | 41.41 | 42.0 | 23007.0 |
| 2015-10-28 | ABDC-DELISTED | Stock | 12.1 | 12.45 | 11.75 | 11.89 | 27783.0 |
| 2015-10-28 | ABE-DELISTED | Stock | 11.33 | 11.42 | 11.32 | 11.32 | 8971.0 |
| 2015-10-28 | ABEO | Stock | 98.0 | 103.25 | 96.25 | 102.0 | 4244.0 |
| 2015-10-28 | ABEV | Stock | 5.0 | 5.05 | 4.87 | 4.89 | 17504900.0 |
| 2015-10-28 | ABG | Stock | 77.9 | 80.55 | 77.42 | 80.06 | 552400.0 |
| 2015-10-28 | ABGB-DELISTED | Stock | 4.74 | 4.79 | 4.65 | 4.69 | 31658.0 |
| 2015-10-28 | ABIL-DELISTED | Stock | 10.1 | 10.1 | 10.0999 | 10.0999 | 5197.0 |
| 2015-10-28 | ABM | Stock | 28.69 | 29.3 | 28.6 | 28.88 | 470500.0 |
> showing 50 of 6,631 rows — these rows as CSV