PREVIEW / stock_daily / 2015-08-10
file: by_date/stock_daily/2015/2015-08-10.parquet size: 223 KB rows: 6,653 symbols: 3,465
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-10 | AAPL | Stock | 29.1325 | 29.9975 | 29.1325 | 29.93 | 219806400.0 |
| 2015-08-10 | MSFT | Stock | 46.95 | 47.49 | 46.84 | 47.33 | 23079900.0 |
| 2015-08-10 | NVDA | Stock | 0.5705 | 0.5988 | 0.567 | 0.5945 | 662304000.0 |
| 2015-08-10 | AMZN | Stock | 26.426 | 26.614 | 26.15 | 26.2 | 52318000.0 |
| 2015-08-10 | GOOGL | Stock | 33.3545 | 33.581 | 33.0115 | 33.157 | 34458300.0 |
| 2015-08-10 | META | Stock | 95.68 | 95.9 | 93.63 | 94.15 | 21624200.0 |
| 2015-08-10 | TSLA | Stock | 15.8767 | 16.198 | 15.7367 | 16.076 | 62788500.0 |
| 2015-08-10 | TLT | Stock | 123.41 | 123.57 | 122.52 | 122.8 | 7461656.0 |
| 2015-08-10 | ES | Stock | 49.97 | 50.18 | 49.8 | 50.02 | 1834800.0 |
| 2015-08-10 | CL | Stock | 68.84 | 69.08 | 68.67 | 68.74 | 3016200.0 |
| 2015-08-10 | A | Stock | 40.24 | 40.64 | 40.16 | 40.47 | 1554500.0 |
| 2015-08-10 | AA.B-DELISTED | Stock | 34.97 | 36.45 | 34.97 | 36.25 | 53465.0 |
| 2015-08-10 | AABA-DELISTED | Stock | 36.87 | 37.69 | 36.87 | 37.155 | 10205051.0 |
| 2015-08-10 | AAC-DELISTED | Stock | 18.0 | 19.51 | 18.0 | 18.79 | 874140.0 |
| 2015-08-10 | AACG | Stock | 3.44 | 3.44 | 3.2 | 3.29 | 25400.0 |
| 2015-08-10 | AAIC-DELISTED | Stock | 18.13 | 18.27 | 18.12 | 18.23 | 228010.0 |
| 2015-08-10 | AAL | Stock | 41.75 | 42.43 | 41.45 | 41.68 | 6860600.0 |
| 2015-08-10 | AAMC-DELISTED | Stock | 38.3794 | 39.7059 | 28.2 | 33.5235 | 82746.0 |
| 2015-08-10 | AAME | Stock | 3.66 | 3.68 | 3.66 | 3.68 | 700.0 |
| 2015-08-10 | AAMI | Stock | 17.73 | 18.22 | 17.69 | 18.12 | 236100.0 |
| 2015-08-10 | AAOI | Stock | 21.87 | 22.23 | 21.41 | 21.99 | 520300.0 |
| 2015-08-10 | AAON | Stock | 15.2333 | 15.4533 | 15.1 | 15.28 | 257400.0 |
| 2015-08-10 | AAP | Stock | 174.87 | 175.32 | 172.92 | 173.66 | 937500.0 |
| 2015-08-10 | AAT | Stock | 40.78 | 41.06 | 40.26 | 40.53 | 282000.0 |
| 2015-08-10 | AAU-DELISTED | Stock | 0.7508 | 0.7608 | 0.7058 | 0.7492 | 19649.0 |
| 2015-08-10 | AAUAF-DELISTED | Stock | 0.75 | 0.76 | 0.705 | 0.7484 | 20037.0 |
| 2015-08-10 | AAV-DELISTED | Stock | 5.41 | 5.61 | 5.28 | 5.6 | 82299.0 |
| 2015-08-10 | AAVL-DELISTED | Stock | 13.97 | 14.87 | 13.926 | 14.5075 | 213296.0 |
| 2015-08-10 | AAWW-DELISTED | Stock | 45.72 | 46.7799 | 45.36 | 46.63 | 368533.0 |
| 2015-08-10 | AAXJ | Stock | 58.59 | 59.2 | 58.59 | 59.15 | 2101112.0 |
| 2015-08-10 | AAXN-DELISTED | Stock | 24.03 | 25.23 | 23.79 | 24.65 | 2111287.0 |
| 2015-08-10 | AB | Stock | 28.34 | 29.09 | 28.13 | 28.78 | 425900.0 |
| 2015-08-10 | ABAC-DELISTED | Stock | 0.9795 | 1.01 | 0.9795 | 0.99 | 3587.0 |
| 2015-08-10 | ABAX-DELISTED | Stock | 48.03 | 49.35 | 48.03 | 48.69 | 156252.0 |
| 2015-08-10 | ABB-DELISTED | Stock | 20.49 | 20.82 | 20.485 | 20.81 | 2063405.0 |
| 2015-08-10 | ABBNY-DELISTED | Stock | 20.49 | 20.82 | 20.485 | 20.81 | 2130090.0 |
| 2015-08-10 | ABBV | Stock | 68.92 | 69.43 | 68.5 | 69.21 | 8189400.0 |
| 2015-08-10 | ABC-DELISTED | Stock | 105.04 | 106.26 | 104.45 | 104.62 | 1142966.0 |
| 2015-08-10 | ABCB | Stock | 28.03 | 28.55 | 28.02 | 28.51 | 174300.0 |
| 2015-08-10 | ABCD-DELISTED | Stock | 4.38 | 4.56 | 4.2 | 4.21 | 48993.0 |
| 2015-08-10 | ABCO-DELISTED | Stock | 47.4 | 49.96 | 47.4 | 49.0 | 724931.0 |
| 2015-08-10 | ABCW-DELISTED | Stock | 39.92 | 40.1336 | 39.18 | 39.79 | 13175.0 |
| 2015-08-10 | ABDC-DELISTED | Stock | 12.0 | 12.35 | 11.94 | 12.28 | 43290.0 |
| 2015-08-10 | ABE-DELISTED | Stock | 12.35 | 12.38 | 12.35 | 12.38 | 265.0 |
| 2015-08-10 | ABEO | Stock | 140.25 | 147.5 | 140.0 | 145.25 | 8712.0 |
| 2015-08-10 | ABEOW-DELISTED | Stock | 2.12 | 2.75 | 2.12 | 2.75 | 1370.0 |
| 2015-08-10 | ABEV | Stock | 5.55 | 5.67 | 5.54 | 5.66 | 14265800.0 |
| 2015-08-10 | ABG | Stock | 84.44 | 85.41 | 84.31 | 84.75 | 292100.0 |
| 2015-08-10 | ABGB-DELISTED | Stock | 5.98 | 6.04 | 5.9 | 6.0 | 59101.0 |
| 2015-08-10 | ABM | Stock | 33.2 | 33.56 | 33.2 | 33.53 | 203400.0 |
> showing 50 of 6,653 rows — these rows as CSV