PREVIEW / stock_daily / 2015-11-04
file: by_date/stock_daily/2015/2015-11-04.parquet size: 221 KB rows: 6,595 symbols: 3,400
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-04 | AAPL | Stock | 30.7825 | 30.955 | 30.405 | 30.5 | 179544400.0 |
| 2015-11-04 | MSFT | Stock | 54.18 | 54.88 | 54.06 | 54.4 | 37087800.0 |
| 2015-11-04 | NVDA | Stock | 0.7105 | 0.7158 | 0.6975 | 0.7008 | 442264000.0 |
| 2015-11-04 | AMZN | Stock | 31.388 | 32.2965 | 31.3675 | 32.0475 | 96810000.0 |
| 2015-11-04 | GOOGL | Stock | 37.495 | 37.995 | 37.46 | 37.7655 | 41839980.0 |
| 2015-11-04 | META | Stock | 103.19 | 104.14 | 102.48 | 103.94 | 43469300.0 |
| 2015-11-04 | TSLA | Stock | 15.1333 | 15.516 | 15.0133 | 15.442 | 190896000.0 |
| 2015-11-04 | TLT | Stock | 121.1 | 121.54 | 120.7 | 121.09 | 5980819.0 |
| 2015-11-04 | ES | Stock | 51.34 | 51.98 | 51.21 | 51.59 | 1113700.0 |
| 2015-11-04 | CL | Stock | 67.93 | 68.05 | 67.0 | 67.48 | 3732800.0 |
| 2015-11-04 | A | Stock | 38.33 | 38.48 | 38.0 | 38.34 | 1569600.0 |
| 2015-11-04 | AA.B-DELISTED | Stock | 33.3 | 33.63 | 32.98 | 33.2799 | 47218.0 |
| 2015-11-04 | AABA-DELISTED | Stock | 34.89 | 35.24 | 34.75 | 35.07 | 16256788.0 |
| 2015-11-04 | AAC-DELISTED | Stock | 21.77 | 24.64 | 21.77 | 24.06 | 248014.0 |
| 2015-11-04 | AACG | Stock | 4.45 | 4.5 | 4.24 | 4.43 | 24000.0 |
| 2015-11-04 | AAIC-DELISTED | Stock | 14.14 | 14.24 | 13.77 | 13.94 | 289629.0 |
| 2015-11-04 | AAL | Stock | 46.42 | 46.45 | 45.15 | 45.63 | 8081400.0 |
| 2015-11-04 | AAMC-DELISTED | Stock | 10.0471 | 10.7441 | 7.9412 | 8.0882 | 231044.0 |
| 2015-11-04 | AAME | Stock | 4.65 | 4.86 | 4.65 | 4.82 | 23100.0 |
| 2015-11-04 | AAMI | Stock | 16.21 | 16.27 | 15.72 | 16.26 | 143200.0 |
| 2015-11-04 | AAOI | Stock | 20.1 | 20.215 | 17.75 | 18.31 | 1261200.0 |
| 2015-11-04 | AAON | Stock | 15.16 | 16.3867 | 15.16 | 16.32 | 454650.0 |
| 2015-11-04 | AAP | Stock | 198.77 | 199.79 | 196.8 | 199.34 | 692600.0 |
| 2015-11-04 | AAT | Stock | 42.13 | 42.17 | 40.79 | 40.95 | 439300.0 |
| 2015-11-04 | AAU-DELISTED | Stock | 0.58 | 0.5801 | 0.55 | 0.58 | 180571.0 |
| 2015-11-04 | AAUAF-DELISTED | Stock | 0.58 | 0.5801 | 0.55 | 0.58 | 181435.0 |
| 2015-11-04 | AAV-DELISTED | Stock | 5.92 | 6.13 | 5.88 | 5.89 | 193639.0 |
| 2015-11-04 | AAVL-DELISTED | Stock | 9.31 | 9.52 | 9.16 | 9.42 | 320414.0 |
| 2015-11-04 | AAWW-DELISTED | Stock | 42.46 | 42.97 | 41.06 | 42.57 | 579559.0 |
| 2015-11-04 | AAXJ | Stock | 58.27 | 58.37 | 57.65 | 57.85 | 1190742.0 |
| 2015-11-04 | AAXN-DELISTED | Stock | 21.42 | 21.97 | 20.27 | 20.58 | 4207691.0 |
| 2015-11-04 | AB | Stock | 25.54 | 25.6 | 25.1 | 25.35 | 364900.0 |
| 2015-11-04 | ABAC-DELISTED | Stock | 0.64 | 0.67 | 0.64 | 0.67 | 4300.0 |
| 2015-11-04 | ABAX-DELISTED | Stock | 51.53 | 52.53 | 51.46 | 52.1 | 135960.0 |
| 2015-11-04 | ABB-DELISTED | Stock | 19.27 | 19.275 | 19.07 | 19.14 | 1883911.0 |
| 2015-11-04 | ABBNY-DELISTED | Stock | 19.27 | 19.275 | 19.07 | 19.14 | 1950328.0 |
| 2015-11-04 | ABBV | Stock | 62.43 | 64.15 | 62.3 | 63.8 | 10342600.0 |
| 2015-11-04 | ABC-DELISTED | Stock | 97.67 | 97.95 | 96.69 | 97.48 | 1017335.0 |
| 2015-11-04 | ABCB | Stock | 31.38 | 31.59 | 31.21 | 31.55 | 202300.0 |
| 2015-11-04 | ABCD-DELISTED | Stock | 5.15 | 5.31 | 5.1 | 5.28 | 43846.0 |
| 2015-11-04 | ABCO-DELISTED | Stock | 43.54 | 44.42 | 43.16 | 44.08 | 217669.0 |
| 2015-11-04 | ABCW-DELISTED | Stock | 42.0 | 42.04 | 41.59 | 41.97 | 17153.0 |
| 2015-11-04 | ABDC-DELISTED | Stock | 11.96 | 11.96 | 11.51 | 11.7 | 48756.0 |
| 2015-11-04 | ABE-DELISTED | Stock | 11.6888 | 11.69 | 11.54 | 11.54 | 62706.0 |
| 2015-11-04 | ABEO | Stock | 111.5 | 113.5 | 108.0 | 112.0 | 7720.0 |
| 2015-11-04 | ABEOW-DELISTED | Stock | 1.66 | 1.66 | 1.66 | 1.66 | 100.0 |
| 2015-11-04 | ABEV | Stock | 5.17 | 5.2 | 5.01 | 5.06 | 14932000.0 |
| 2015-11-04 | ABG | Stock | 81.54 | 81.54 | 80.28 | 81.27 | 210100.0 |
| 2015-11-04 | ABGB-DELISTED | Stock | 5.54 | 5.549 | 5.32 | 5.33 | 49409.0 |
| 2015-11-04 | ABIL-DELISTED | Stock | 10.0899 | 10.1 | 10.01 | 10.01 | 1230.0 |
> showing 50 of 6,595 rows — these rows as CSV