PREVIEW / stock_daily / 2016-02-11
file: by_date/stock_daily/2016/2016-02-11.parquet size: 216 KB rows: 6,594 symbols: 3,345
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-02-11 | AAPL | Stock | 23.4475 | 23.68 | 23.1475 | 23.425 | 200298800.0 |
| 2016-02-11 | MSFT | Stock | 48.68 | 50.11 | 48.51 | 49.69 | 48878600.0 |
| 2016-02-11 | NVDA | Stock | 0.6195 | 0.639 | 0.6195 | 0.6325 | 340144000.0 |
| 2016-02-11 | AMZN | Stock | 24.5585 | 25.465 | 24.2 | 25.191 | 147948000.0 |
| 2016-02-11 | GOOGL | Stock | 34.817 | 35.6158 | 34.5595 | 35.318 | 65004120.0 |
| 2016-02-11 | META | Stock | 99.6 | 105.11 | 98.88 | 101.91 | 43670600.0 |
| 2016-02-11 | TSLA | Stock | 10.1333 | 10.884 | 9.8 | 10.0313 | 213786000.0 |
| 2016-02-11 | TLT | Stock | 134.44 | 135.25 | 133.01 | 133.72 | 21620249.0 |
| 2016-02-11 | ES | Stock | 54.79 | 55.13 | 53.79 | 53.9 | 2151300.0 |
| 2016-02-11 | CL | Stock | 64.71 | 65.3 | 64.0 | 64.44 | 4744300.0 |
| 2016-02-11 | A | Stock | 35.12 | 35.61 | 34.94 | 35.33 | 3224000.0 |
| 2016-02-11 | AA.B-DELISTED | Stock | 25.5 | 26.56 | 25.21 | 25.84 | 39835.0 |
| 2016-02-11 | AAAP-DELISTED | Stock | 25.18 | 25.4 | 24.5 | 24.545 | 10980.0 |
| 2016-02-11 | AABA-DELISTED | Stock | 26.45 | 26.97 | 26.15 | 26.76 | 10516868.0 |
| 2016-02-11 | AAC-DELISTED | Stock | 19.51 | 19.95 | 19.385 | 19.84 | 111787.0 |
| 2016-02-11 | AACG | Stock | 5.28 | 5.3 | 4.78 | 4.85 | 8600.0 |
| 2016-02-11 | AAIC-DELISTED | Stock | 10.89 | 10.95 | 10.5702 | 10.66 | 298457.0 |
| 2016-02-11 | AAL | Stock | 36.47 | 37.22 | 36.17 | 36.49 | 8096000.0 |
| 2016-02-11 | AAMC-DELISTED | Stock | 4.3529 | 4.6147 | 4.35 | 4.4265 | 94891.0 |
| 2016-02-11 | AAME | Stock | 4.49 | 4.5 | 4.49 | 4.5 | 2600.0 |
| 2016-02-11 | AAMI | Stock | 10.56 | 10.93 | 10.49 | 10.8 | 146700.0 |
| 2016-02-11 | AAOI | Stock | 14.16 | 14.62 | 13.83 | 14.55 | 262700.0 |
| 2016-02-11 | AAON | Stock | 13.3267 | 13.7267 | 13.3267 | 13.64 | 102000.0 |
| 2016-02-11 | AAP | Stock | 137.04 | 142.77 | 131.59 | 138.41 | 2575700.0 |
| 2016-02-11 | AAT | Stock | 34.34 | 35.08 | 34.07 | 34.7 | 110000.0 |
| 2016-02-11 | AAU-DELISTED | Stock | 0.6325 | 0.7 | 0.6325 | 0.66 | 212903.0 |
| 2016-02-11 | AAUAF-DELISTED | Stock | 0.6325 | 0.7 | 0.6325 | 0.66 | 214298.0 |
| 2016-02-11 | AAV-DELISTED | Stock | 5.31 | 5.39 | 5.15 | 5.36 | 74415.0 |
| 2016-02-11 | AAVL-DELISTED | Stock | 4.48 | 4.89 | 4.17 | 4.75 | 954281.0 |
| 2016-02-11 | AAWW-DELISTED | Stock | 35.03 | 35.72 | 34.25 | 35.45 | 248569.0 |
| 2016-02-11 | AAXJ | Stock | 46.96 | 47.36 | 46.74 | 47.06 | 957424.0 |
| 2016-02-11 | AAXN-DELISTED | Stock | 15.09 | 15.72 | 15.03 | 15.41 | 1048868.0 |
| 2016-02-11 | AB | Stock | 16.16 | 17.2 | 16.16 | 16.92 | 262000.0 |
| 2016-02-11 | ABAC-DELISTED | Stock | 0.72 | 0.731 | 0.6022 | 0.645 | 9274.0 |
| 2016-02-11 | ABAX-DELISTED | Stock | 38.69 | 39.93 | 37.78 | 38.63 | 283169.0 |
| 2016-02-11 | ABB-DELISTED | Stock | 16.69 | 16.81 | 16.52 | 16.67 | 2635237.0 |
| 2016-02-11 | ABBNY-DELISTED | Stock | 16.69 | 16.81 | 16.52 | 16.67 | 2686219.0 |
| 2016-02-11 | ABBV | Stock | 52.3 | 53.12 | 51.82 | 52.18 | 8551100.0 |
| 2016-02-11 | ABC-DELISTED | Stock | 84.25 | 85.09 | 84.19 | 84.56 | 2412484.0 |
| 2016-02-11 | ABCB | Stock | 25.51 | 25.82 | 24.96 | 25.09 | 193300.0 |
| 2016-02-11 | ABCD-DELISTED | Stock | 3.61 | 3.78 | 3.43 | 3.655 | 65390.0 |
| 2016-02-11 | ABCO-DELISTED | Stock | 39.25 | 39.78 | 38.84 | 39.2 | 134075.0 |
| 2016-02-11 | ABCW-DELISTED | Stock | 40.64 | 41.08 | 40.29 | 40.56 | 97521.0 |
| 2016-02-11 | ABDC-DELISTED | Stock | 8.9 | 9.04 | 8.9 | 9.02 | 27575.0 |
| 2016-02-11 | ABE-DELISTED | Stock | 9.9401 | 10.06 | 9.9401 | 10.06 | 2981.0 |
| 2016-02-11 | ABEO | Stock | 57.25 | 58.75 | 56.25 | 57.75 | 1552.0 |
| 2016-02-11 | ABEV | Stock | 4.45 | 4.46 | 4.38 | 4.44 | 8266300.0 |
| 2016-02-11 | ABG | Stock | 47.96 | 50.07 | 47.83 | 49.1 | 738800.0 |
| 2016-02-11 | ABGB-DELISTED | Stock | 0.7561 | 0.7561 | 0.6801 | 0.6801 | 30245.0 |
| 2016-02-11 | ABIL-DELISTED | Stock | 6.3 | 6.3 | 5.75 | 5.98 | 14621.0 |
> showing 50 of 6,594 rows — these rows as CSV