PREVIEW / stock_daily / 2006-11-03
file: by_date/stock_daily/2006/2006-11-03.parquet size: 153 KB rows: 4,566 symbols: 2,891
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-03 | AAPL | Stock | 2.8343 | 2.8404 | 2.7782 | 2.7961 | 431888800.0 |
| 2006-11-03 | MSFT | Stock | 28.85 | 28.93 | 28.61 | 28.73 | 41124500.0 |
| 2006-11-03 | NVDA | Stock | 0.5387 | 0.544 | 0.53 | 0.5433 | 548070000.0 |
| 2006-11-03 | AMZN | Stock | 1.8805 | 1.8855 | 1.8435 | 1.873 | 102482000.0 |
| 2006-11-03 | CL | Stock | 31.835 | 31.985 | 31.66 | 31.835 | 2985400.0 |
| 2006-11-03 | A | Stock | 23.9843 | 24.113 | 23.5336 | 23.5551 | 3918454.0 |
| 2006-11-03 | AABA-DELISTED | Stock | 26.6299991607666 | 26.7000007629395 | 26.0400009155273 | 26.1800003051758 | 15313800.0 |
| 2006-11-03 | AACC-DELISTED | Stock | 16.53 | 16.57 | 16.27 | 16.31 | 153122.0 |
| 2006-11-03 | AACQ-DELISTED | Stock | 5.47 | 5.47 | 5.47 | 5.47 | 1200.0 |
| 2006-11-03 | AACQW-DELISTED | Stock | 0.585 | 0.585 | 0.58 | 0.58 | 40400.0 |
| 2006-11-03 | AAI-DELISTED | Stock | 9.63 | 9.94 | 9.62 | 9.801 | 1728900.0 |
| 2006-11-03 | AAIC-DELISTED | Stock | 159.6 | 160.8 | 151.8 | 155.0 | 2480200.0 |
| 2006-11-03 | AAME | Stock | 2.51 | 2.53 | 2.46 | 2.46 | 9700.0 |
| 2006-11-03 | AAON | Stock | 2.9946 | 3.1381 | 2.9946 | 3.0749 | 185287.0 |
| 2006-11-03 | AAP | Stock | 36.36 | 36.75 | 35.5 | 36.0 | 1484800.0 |
| 2006-11-03 | AATI-DELISTED | Stock | 5.84 | 5.84 | 5.57 | 5.64 | 285013.0 |
| 2006-11-03 | AAU-DELISTED | Stock | 2.65 | 2.75 | 2.6401 | 2.68 | 58900.0 |
| 2006-11-03 | AAUAF-DELISTED | Stock | 2.65 | 2.75 | 2.6401 | 2.68 | 58900.0 |
| 2006-11-03 | AAV-DELISTED | Stock | 11.67 | 12.55 | 11.6 | 12.19 | 1614500.0 |
| 2006-11-03 | AAWW-DELISTED | Stock | 43.28 | 43.64 | 43.03 | 43.41 | 159312.0 |
| 2006-11-03 | AAXN-DELISTED | Stock | 8.81999969482422 | 8.97000026702881 | 8.77999973297119 | 8.85999965667725 | 1150000.0 |
| 2006-11-03 | AB | Stock | 75.92 | 76.56 | 75.52 | 75.95 | 292700.0 |
| 2006-11-03 | ABAX-DELISTED | Stock | 19.33 | 20.13 | 19.32 | 19.89 | 216700.0 |
| 2006-11-03 | ABB-DELISTED | Stock | 14.71 | 14.79 | 14.7 | 14.73 | 1443000.0 |
| 2006-11-03 | ABBC-DELISTED | Stock | 16.03 | 16.03 | 15.75 | 15.86 | 10278.0 |
| 2006-11-03 | ABC-DELISTED | Stock | 23.14 | 23.2 | 22.59 | 22.69 | 4265600.0 |
| 2006-11-03 | ABCB | Stock | 26.1446 | 26.8449 | 26.1252 | 26.1252 | 15628.0 |
| 2006-11-03 | ABCO-DELISTED | Stock | 26.57 | 26.96 | 26.5 | 26.96 | 203985.0 |
| 2006-11-03 | ABCW-DELISTED | Stock | 28.6 | 28.95 | 28.58 | 28.92 | 39390.0 |
| 2006-11-03 | ABD-DELISTED | Stock | 24.6 | 24.9 | 24.38 | 24.46 | 332600.0 |
| 2006-11-03 | ABE-DELISTED | Stock | 16.49 | 16.7 | 16.41 | 16.61 | 26700.0 |
| 2006-11-03 | ABFS-DELISTED | Stock | 40.17 | 40.22 | 38.47 | 38.58 | 1097040.0 |
| 2006-11-03 | ABG | Stock | 24.02 | 24.02 | 23.28 | 23.32 | 261600.0 |
| 2006-11-03 | ABK-DELISTED | Stock | 84.1 | 84.58 | 83.35 | 84.33 | 632100.0 |
| 2006-11-03 | ABM | Stock | 19.64 | 19.96 | 19.58 | 19.96 | 128100.0 |
| 2006-11-03 | ABMD-DELISTED | Stock | 13.26 | 13.57 | 13.25 | 13.34 | 66812.0 |
| 2006-11-03 | ABP-DELISTED | Stock | 3.4 | 3.55 | 3.39 | 3.47 | 400600.0 |
| 2006-11-03 | ABR | Stock | 28.45 | 28.45 | 27.88 | 28.14 | 122800.0 |
| 2006-11-03 | ABT | Stock | 22.7473 | 22.9344 | 22.6993 | 22.8577 | 8309087.0 |
| 2006-11-03 | ABTL-DELISTED | Stock | 16.55 | 16.7 | 16.048 | 16.55 | 17921.0 |
| 2006-11-03 | ABV-DELISTED | Stock | 44.85 | 44.92 | 44.0 | 44.1 | 351200.0 |
| 2006-11-03 | ABVA-DELISTED | Stock | 16.44 | 16.45 | 16.09 | 16.09 | 2801.0 |
| 2006-11-03 | ABX-DELISTED | Stock | 30.75 | 31.1 | 30.6 | 30.87 | 5291600.0 |
| 2006-11-03 | ACAD | Stock | 9.35 | 9.88 | 9.26 | 9.83 | 174000.0 |
| 2006-11-03 | ACAP-DELISTED | Stock | 35.66 | 37.97 | 35.66 | 36.63 | 78148.0 |
| 2006-11-03 | ACAS-DELISTED | Stock | 41.59 | 41.86 | 41.04 | 41.53 | 1217413.0 |
| 2006-11-03 | ACAT-DELISTED | Stock | 17.61 | 17.7 | 16.87 | 17.14 | 153029.0 |
| 2006-11-03 | ACC-DELISTED | Stock | 26.38 | 26.9 | 26.05 | 26.44 | 285700.0 |
| 2006-11-03 | ACCL-DELISTED | Stock | 6.26 | 6.45 | 6.26 | 6.43 | 38472.0 |
| 2006-11-03 | ACCO | Stock | 24.6 | 24.9 | 24.38 | 24.46 | 338300.0 |
> showing 50 of 4,566 rows — these rows as CSV