PREVIEW / stock_daily / 2015-08-28
file: by_date/stock_daily/2015/2015-08-28.parquet size: 222 KB rows: 6,665 symbols: 3,457
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-28 | AAPL | Stock | 28.0425 | 28.3275 | 27.885 | 28.3225 | 212657600.0 |
| 2015-08-28 | MSFT | Stock | 43.4 | 44.15 | 43.39 | 43.93 | 28246700.0 |
| 2015-08-28 | NVDA | Stock | 0.5658 | 0.5718 | 0.5618 | 0.5682 | 320944000.0 |
| 2015-08-28 | AMZN | Stock | 25.875 | 26.075 | 25.652 | 25.9005 | 54934000.0 |
| 2015-08-28 | GOOGL | Stock | 33.288 | 33.35 | 32.6875 | 32.9845 | 38836660.0 |
| 2015-08-28 | META | Stock | 89.88 | 91.48 | 89.79 | 91.01 | 33215900.0 |
| 2015-08-28 | TSLA | Stock | 16.124 | 16.7633 | 16.1047 | 16.5653 | 82705500.0 |
| 2015-08-28 | TLT | Stock | 123.15 | 123.47 | 122.23 | 122.36 | 9946158.0 |
| 2015-08-28 | ES | Stock | 48.5 | 48.77 | 47.54 | 48.29 | 1550300.0 |
| 2015-08-28 | CL | Stock | 63.01 | 63.38 | 62.52 | 63.35 | 3486900.0 |
| 2015-08-28 | A | Stock | 36.45 | 36.66 | 36.15 | 36.51 | 1783600.0 |
| 2015-08-28 | AA.B-DELISTED | Stock | 33.17 | 34.97 | 33.17 | 34.89 | 81643.0 |
| 2015-08-28 | AABA-DELISTED | Stock | 33.22 | 33.57 | 32.929 | 33.14 | 8849634.0 |
| 2015-08-28 | AAC-DELISTED | Stock | 21.47 | 22.52 | 20.31 | 22.48 | 297794.0 |
| 2015-08-28 | AACG | Stock | 2.47 | 2.59 | 2.45 | 2.49 | 7200.0 |
| 2015-08-28 | AAIC-DELISTED | Stock | 16.7 | 16.8 | 16.55 | 16.69 | 166948.0 |
| 2015-08-28 | AAL | Stock | 38.93 | 39.58 | 38.35 | 38.62 | 11825000.0 |
| 2015-08-28 | AAMC-DELISTED | Stock | 10.9088 | 11.0 | 10.2353 | 10.5 | 45315.0 |
| 2015-08-28 | AAME | Stock | 3.43 | 3.61 | 3.43 | 3.51 | 5500.0 |
| 2015-08-28 | AAMI | Stock | 16.43 | 16.45 | 16.05 | 16.36 | 189000.0 |
| 2015-08-28 | AAOI | Stock | 20.48 | 21.6 | 20.45 | 21.11 | 314600.0 |
| 2015-08-28 | AAON | Stock | 13.7067 | 13.8533 | 13.58 | 13.6733 | 194250.0 |
| 2015-08-28 | AAP | Stock | 175.5 | 176.83 | 174.66 | 176.48 | 641800.0 |
| 2015-08-28 | AAT | Stock | 39.45 | 39.66 | 38.99 | 39.42 | 240900.0 |
| 2015-08-28 | AAU-DELISTED | Stock | 0.52 | 0.5345 | 0.5 | 0.53 | 25892.0 |
| 2015-08-28 | AAUAF-DELISTED | Stock | 0.52 | 0.5299 | 0.5 | 0.5254 | 26648.0 |
| 2015-08-28 | AAV-DELISTED | Stock | 5.23 | 5.56 | 5.23 | 5.38 | 109890.0 |
| 2015-08-28 | AAVL-DELISTED | Stock | 10.6 | 10.86 | 10.6 | 10.75 | 404837.0 |
| 2015-08-28 | AAWW-DELISTED | Stock | 40.85 | 42.2 | 40.77 | 41.59 | 444167.0 |
| 2015-08-28 | AAXJ | Stock | 53.56 | 53.86 | 53.375 | 53.62 | 4956866.0 |
| 2015-08-28 | AAXN-DELISTED | Stock | 23.59 | 23.8892 | 23.3233 | 23.7 | 1391236.0 |
| 2015-08-28 | AB | Stock | 27.02 | 27.72 | 27.0 | 27.32 | 195000.0 |
| 2015-08-28 | ABAC-DELISTED | Stock | 0.78 | 0.78 | 0.7167 | 0.75 | 12727.0 |
| 2015-08-28 | ABAX-DELISTED | Stock | 46.92 | 47.98 | 46.9 | 47.885 | 147448.0 |
| 2015-08-28 | ABB-DELISTED | Stock | 19.16 | 19.359 | 19.14 | 19.33 | 2131406.0 |
| 2015-08-28 | ABBNY-DELISTED | Stock | 19.16 | 19.359 | 19.14 | 19.33 | 2185781.0 |
| 2015-08-28 | ABBV | Stock | 63.91 | 64.78 | 63.44 | 63.98 | 7316400.0 |
| 2015-08-28 | ABC-DELISTED | Stock | 101.34 | 101.49 | 100.31 | 100.88 | 1406001.0 |
| 2015-08-28 | ABCB | Stock | 26.49 | 26.9 | 26.29 | 26.8 | 130200.0 |
| 2015-08-28 | ABCD-DELISTED | Stock | 5.15 | 5.45 | 5.04 | 5.27 | 207673.0 |
| 2015-08-28 | ABCO-DELISTED | Stock | 49.61 | 49.91 | 49.01 | 49.61 | 247265.0 |
| 2015-08-28 | ABCW-DELISTED | Stock | 41.26 | 41.96 | 40.02 | 40.02 | 8329.0 |
| 2015-08-28 | ABDC-DELISTED | Stock | 12.23 | 12.86 | 12.175 | 12.79 | 31722.0 |
| 2015-08-28 | ABE-DELISTED | Stock | 10.85 | 11.32 | 10.85 | 11.135 | 16663.0 |
| 2015-08-28 | ABEO | Stock | 117.0 | 121.0 | 117.0 | 120.5 | 3232.0 |
| 2015-08-28 | ABEOW-DELISTED | Stock | 1.86 | 1.88 | 1.58 | 1.83 | 4286.0 |
| 2015-08-28 | ABEV | Stock | 5.3 | 5.35 | 5.26 | 5.34 | 12437700.0 |
| 2015-08-28 | ABG | Stock | 80.02 | 80.8 | 79.67 | 80.25 | 242500.0 |
| 2015-08-28 | ABGB-DELISTED | Stock | 5.91 | 5.91 | 5.64 | 5.6989 | 54570.0 |
| 2015-08-28 | ABIL-DELISTED | Stock | 9.95 | 9.95 | 9.95 | 9.95 | 1027.0 |
> showing 50 of 6,665 rows — these rows as CSV