PREVIEW / stock_daily / 2015-09-08
file: by_date/stock_daily/2015/2015-09-08.parquet size: 222 KB rows: 6,676 symbols: 3,463
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-09-08 | AAPL | Stock | 27.9375 | 28.14 | 27.58 | 28.0775 | 219374400.0 |
| 2015-09-08 | MSFT | Stock | 43.3 | 44.0 | 43.2 | 43.89 | 32469800.0 |
| 2015-09-08 | NVDA | Stock | 0.557 | 0.5692 | 0.5548 | 0.567 | 238448000.0 |
| 2015-09-08 | AMZN | Stock | 25.4345 | 25.9175 | 25.4255 | 25.877 | 76214000.0 |
| 2015-09-08 | GOOGL | Stock | 32.05 | 32.252 | 31.645 | 32.194 | 39092960.0 |
| 2015-09-08 | META | Stock | 89.69 | 90.24 | 88.83 | 89.53 | 27012500.0 |
| 2015-09-08 | TSLA | Stock | 16.3367 | 16.6107 | 16.27 | 16.5447 | 47073000.0 |
| 2015-09-08 | TLT | Stock | 121.38 | 121.56 | 120.76 | 120.87 | 7049499.0 |
| 2015-09-08 | ES | Stock | 46.14 | 46.57 | 46.07 | 46.48 | 1710000.0 |
| 2015-09-08 | CL | Stock | 62.48 | 63.66 | 62.15 | 63.43 | 6568500.0 |
| 2015-09-08 | A | Stock | 35.82 | 36.25 | 35.51 | 36.21 | 1787400.0 |
| 2015-09-08 | AA.B-DELISTED | Stock | 35.5 | 36.08 | 35.5 | 36.0 | 23959.0 |
| 2015-09-08 | AABA-DELISTED | Stock | 32.25 | 32.83 | 30.86 | 30.89 | 25638833.0 |
| 2015-09-08 | AAC-DELISTED | Stock | 24.67 | 24.67 | 23.63 | 23.79 | 176240.0 |
| 2015-09-08 | AACG | Stock | 2.38 | 2.39 | 2.3 | 2.31 | 29900.0 |
| 2015-09-08 | AAIC-DELISTED | Stock | 15.92 | 15.98 | 15.81 | 15.84 | 327857.0 |
| 2015-09-08 | AAL | Stock | 41.28 | 41.58 | 40.69 | 40.8 | 10814800.0 |
| 2015-09-08 | AAMC-DELISTED | Stock | 9.5882 | 9.7059 | 8.8235 | 8.8971 | 45849.0 |
| 2015-09-08 | AAME | Stock | 3.54 | 3.58 | 3.43 | 3.54 | 8300.0 |
| 2015-09-08 | AAMI | Stock | 16.51 | 16.76 | 16.51 | 16.73 | 179800.0 |
| 2015-09-08 | AAOI | Stock | 20.69 | 22.2 | 20.51 | 21.66 | 436600.0 |
| 2015-09-08 | AAON | Stock | 13.3333 | 13.3467 | 13.1133 | 13.24 | 233250.0 |
| 2015-09-08 | AAP | Stock | 174.73 | 176.33 | 171.9 | 175.32 | 618200.0 |
| 2015-09-08 | AAT | Stock | 37.91 | 38.52 | 37.74 | 38.38 | 184700.0 |
| 2015-09-08 | AAU-DELISTED | Stock | 0.51 | 0.55 | 0.51 | 0.5318 | 126681.0 |
| 2015-09-08 | AAUAF-DELISTED | Stock | 0.51 | 0.55 | 0.51 | 0.5318 | 126983.0 |
| 2015-09-08 | AAV-DELISTED | Stock | 5.36 | 5.59 | 5.32 | 5.45 | 119505.0 |
| 2015-09-08 | AAVL-DELISTED | Stock | 10.33 | 10.63 | 10.3075 | 10.6 | 562060.0 |
| 2015-09-08 | AAWW-DELISTED | Stock | 38.63 | 39.06 | 37.74 | 38.86 | 188903.0 |
| 2015-09-08 | AAXJ | Stock | 52.51 | 53.01 | 52.5 | 52.97 | 1044278.0 |
| 2015-09-08 | AAXN-DELISTED | Stock | 24.03 | 24.49 | 23.91 | 24.28 | 1096641.0 |
| 2015-09-08 | AB | Stock | 25.64 | 26.57 | 25.51 | 26.45 | 260400.0 |
| 2015-09-08 | ABAC-DELISTED | Stock | 0.7805 | 0.7805 | 0.7805 | 0.7805 | 1000.0 |
| 2015-09-08 | ABAX-DELISTED | Stock | 47.68 | 48.8399 | 47.138 | 48.7 | 96225.0 |
| 2015-09-08 | ABB-DELISTED | Stock | 19.04 | 19.09 | 18.88 | 19.03 | 2363920.0 |
| 2015-09-08 | ABBNY-DELISTED | Stock | 19.04 | 19.09 | 18.88 | 19.03 | 2417354.0 |
| 2015-09-08 | ABBV | Stock | 60.22 | 60.94 | 59.91 | 60.57 | 9263200.0 |
| 2015-09-08 | ABC-DELISTED | Stock | 100.8 | 101.18 | 99.79 | 101.04 | 1593934.0 |
| 2015-09-08 | ABCB | Stock | 27.73 | 27.9 | 27.33 | 27.67 | 128900.0 |
| 2015-09-08 | ABCD-DELISTED | Stock | 5.1 | 5.2 | 5.03 | 5.13 | 80342.0 |
| 2015-09-08 | ABCO-DELISTED | Stock | 48.99 | 49.14 | 48.42 | 49.0 | 271268.0 |
| 2015-09-08 | ABCW-DELISTED | Stock | 40.94 | 43.37 | 40.94 | 41.94 | 42159.0 |
| 2015-09-08 | ABDC-DELISTED | Stock | 12.95 | 13.0 | 12.74 | 12.91 | 55105.0 |
| 2015-09-08 | ABE-DELISTED | Stock | 11.1 | 11.11 | 11.0274 | 11.06 | 2581.0 |
| 2015-09-08 | ABEO | Stock | 122.25 | 122.25 | 116.5 | 118.25 | 2936.0 |
| 2015-09-08 | ABEOW-DELISTED | Stock | 1.7101 | 1.78 | 1.7101 | 1.78 | 400.0 |
| 2015-09-08 | ABEV | Stock | 5.25 | 5.28 | 5.09 | 5.13 | 10816900.0 |
| 2015-09-08 | ABG | Stock | 81.11 | 82.34 | 79.65 | 81.92 | 342600.0 |
| 2015-09-08 | ABGB-DELISTED | Stock | 5.84 | 5.92 | 5.51 | 5.79 | 173870.0 |
| 2015-09-08 | ABIL-DELISTED | Stock | 10.06 | 10.24 | 10.0101 | 10.1 | 19150.0 |
> showing 50 of 6,676 rows — these rows as CSV