PREVIEW / stock_daily / 2015-11-02
file: by_date/stock_daily/2015/2015-11-02.parquet size: 222 KB rows: 6,640 symbols: 3,422
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-11-02 | AAPL | Stock | 30.2 | 30.34 | 29.9025 | 30.295 | 128813200.0 |
| 2015-11-02 | MSFT | Stock | 52.85 | 53.36 | 52.62 | 53.24 | 30285000.0 |
| 2015-11-02 | NVDA | Stock | 0.7115 | 0.7183 | 0.7072 | 0.7175 | 190088000.0 |
| 2015-11-02 | AMZN | Stock | 31.3565 | 31.4315 | 31.0205 | 31.4175 | 56330000.0 |
| 2015-11-02 | GOOGL | Stock | 36.894 | 37.409 | 36.5725 | 37.387 | 39914160.0 |
| 2015-11-02 | META | Stock | 101.72 | 103.47 | 101.18 | 103.31 | 24003900.0 |
| 2015-11-02 | TSLA | Stock | 13.928 | 14.3867 | 13.8147 | 14.2527 | 58918500.0 |
| 2015-11-02 | TLT | Stock | 121.78 | 122.1799 | 121.68 | 121.95 | 8751010.0 |
| 2015-11-02 | ES | Stock | 50.97 | 51.26 | 50.49 | 50.96 | 1281900.0 |
| 2015-11-02 | CL | Stock | 66.77 | 67.57 | 66.36 | 67.49 | 5351700.0 |
| 2015-11-02 | A | Stock | 37.87 | 38.62 | 37.8 | 38.59 | 1810800.0 |
| 2015-11-02 | AA.B-DELISTED | Stock | 31.99 | 32.6299 | 31.98 | 32.39 | 28467.0 |
| 2015-11-02 | AABA-DELISTED | Stock | 35.46 | 35.48 | 35.07 | 35.28 | 14171806.0 |
| 2015-11-02 | AAC-DELISTED | Stock | 23.18 | 23.2 | 22.1023 | 22.26 | 279900.0 |
| 2015-11-02 | AACG | Stock | 4.03 | 4.24 | 4.03 | 4.23 | 37300.0 |
| 2015-11-02 | AAIC-DELISTED | Stock | 13.87 | 14.09 | 13.8 | 14.0 | 218943.0 |
| 2015-11-02 | AAL | Stock | 46.2 | 46.82 | 46.2 | 46.47 | 6189300.0 |
| 2015-11-02 | AAMC-DELISTED | Stock | 7.1029 | 7.8647 | 7.1029 | 7.8382 | 57837.0 |
| 2015-11-02 | AAME | Stock | 4.44 | 4.87 | 4.41 | 4.82 | 16700.0 |
| 2015-11-02 | AAMI | Stock | 15.2 | 15.97 | 15.2 | 15.91 | 113200.0 |
| 2015-11-02 | AAOI | Stock | 20.62 | 21.18 | 20.09 | 20.33 | 550500.0 |
| 2015-11-02 | AAON | Stock | 13.6133 | 14.82 | 13.08 | 14.46 | 465900.0 |
| 2015-11-02 | AAP | Stock | 199.14 | 201.17 | 197.98 | 200.38 | 728500.0 |
| 2015-11-02 | AAT | Stock | 42.17 | 42.84 | 42.17 | 42.69 | 282100.0 |
| 2015-11-02 | AAU-DELISTED | Stock | 0.56 | 0.5835 | 0.56 | 0.58 | 141641.0 |
| 2015-11-02 | AAUAF-DELISTED | Stock | 0.56 | 0.5835 | 0.56 | 0.58 | 155715.0 |
| 2015-11-02 | AAV-DELISTED | Stock | 5.5 | 5.62 | 5.5 | 5.55 | 34091.0 |
| 2015-11-02 | AAVL-DELISTED | Stock | 8.47 | 9.36 | 8.47 | 9.04 | 616258.0 |
| 2015-11-02 | AAWW-DELISTED | Stock | 41.34 | 43.34 | 41.34 | 43.01 | 292388.0 |
| 2015-11-02 | AAXJ | Stock | 56.7 | 57.27 | 56.665 | 57.24 | 508973.0 |
| 2015-11-02 | AAXN-DELISTED | Stock | 23.4 | 24.19 | 23.195 | 23.9 | 1989911.0 |
| 2015-11-02 | AB | Stock | 25.64 | 26.25 | 25.58 | 25.62 | 279300.0 |
| 2015-11-02 | ABAC-DELISTED | Stock | 0.6309 | 0.6309 | 0.62 | 0.62 | 10731.0 |
| 2015-11-02 | ABAX-DELISTED | Stock | 50.17 | 51.68 | 49.28 | 51.49 | 115053.0 |
| 2015-11-02 | ABB-DELISTED | Stock | 19.11 | 19.15 | 19.01 | 19.09 | 1555240.0 |
| 2015-11-02 | ABBNY-DELISTED | Stock | 19.11 | 19.15 | 19.01 | 19.1 | 1595630.0 |
| 2015-11-02 | ABBV | Stock | 61.6 | 64.2 | 61.44 | 63.38 | 17008700.0 |
| 2015-11-02 | ABC-DELISTED | Stock | 97.51 | 98.05 | 96.56 | 97.83 | 2128635.0 |
| 2015-11-02 | ABCB | Stock | 31.46 | 31.8 | 30.9 | 31.25 | 493700.0 |
| 2015-11-02 | ABCD-DELISTED | Stock | 4.84 | 5.05 | 4.77 | 5.04 | 25717.0 |
| 2015-11-02 | ABCO-DELISTED | Stock | 43.9 | 44.235 | 42.83 | 43.77 | 198936.0 |
| 2015-11-02 | ABCW-DELISTED | Stock | 40.76 | 42.2 | 40.76 | 42.16 | 34379.0 |
| 2015-11-02 | ABDC-DELISTED | Stock | 11.87 | 12.6 | 11.81 | 12.0 | 31151.0 |
| 2015-11-02 | ABE-DELISTED | Stock | 11.54 | 11.64 | 11.4999 | 11.5409 | 8750.0 |
| 2015-11-02 | ABEO | Stock | 101.5 | 105.25 | 99.75 | 104.25 | 4148.0 |
| 2015-11-02 | ABEOW-DELISTED | Stock | 1.545 | 1.545 | 1.43 | 1.43 | 1450.0 |
| 2015-11-02 | ABEV | Stock | 4.92 | 5.0 | 4.88 | 4.95 | 20982300.0 |
| 2015-11-02 | ABG | Stock | 79.18 | 80.16 | 78.69 | 79.98 | 245000.0 |
| 2015-11-02 | ABGB-DELISTED | Stock | 5.5 | 5.57 | 5.4 | 5.51 | 67816.0 |
| 2015-11-02 | ABM | Stock | 28.36 | 28.84 | 28.28 | 28.64 | 345600.0 |
> showing 50 of 6,640 rows — these rows as CSV