PREVIEW / stock_daily / 2006-12-11
file: by_date/stock_daily/2006/2006-12-11.parquet size: 156 KB rows: 4,670 symbols: 2,964
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-12-11 | AAPL | Stock | 3.175 | 3.1893 | 3.1446 | 3.1696 | 499780400.0 |
| 2006-12-11 | MSFT | Stock | 29.19 | 29.75 | 29.11 | 29.54 | 107712000.0 |
| 2006-12-11 | NVDA | Stock | 0.5927 | 0.6098 | 0.5913 | 0.6027 | 515484000.0 |
| 2006-12-11 | AMZN | Stock | 1.911 | 1.9575 | 1.904 | 1.9345 | 96972000.0 |
| 2006-12-11 | CL | Stock | 32.83 | 32.955 | 32.735 | 32.945 | 2108800.0 |
| 2006-12-11 | A | Stock | 23.8555 | 24.1059 | 23.7911 | 24.0129 | 1937628.0 |
| 2006-12-11 | AABA-DELISTED | Stock | 26.3700008392334 | 26.7000007629395 | 26.1200008392334 | 26.4899997711182 | 12916900.0 |
| 2006-12-11 | AACC-DELISTED | Stock | 16.08 | 16.21 | 15.83 | 16.11 | 111726.0 |
| 2006-12-11 | AACQW-DELISTED | Stock | 0.57 | 0.57 | 0.56 | 0.56 | 27000.0 |
| 2006-12-11 | AAI-DELISTED | Stock | 12.61 | 12.88 | 12.58 | 12.74 | 1347900.0 |
| 2006-12-11 | AAIC-DELISTED | Stock | 152.0 | 152.63 | 150.4 | 151.2 | 1697800.0 |
| 2006-12-11 | AAME | Stock | 2.87 | 3.86 | 2.84 | 3.11 | 206700.0 |
| 2006-12-11 | AAON | Stock | 3.6491 | 3.6596 | 3.5213 | 3.5279 | 104794.0 |
| 2006-12-11 | AAP | Stock | 36.97 | 36.98 | 36.08 | 36.16 | 1041300.0 |
| 2006-12-11 | AATI-DELISTED | Stock | 5.3875 | 5.4 | 5.21 | 5.25 | 235712.0 |
| 2006-12-11 | AAU-DELISTED | Stock | 2.43 | 2.5 | 2.3794 | 2.4 | 103393.0 |
| 2006-12-11 | AAUAF-DELISTED | Stock | 2.36 | 2.42 | 2.31 | 2.33 | 106500.0 |
| 2006-12-11 | AAV-DELISTED | Stock | 11.82 | 11.85 | 11.5 | 11.58 | 925500.0 |
| 2006-12-11 | AAWW-DELISTED | Stock | 45.13 | 45.72 | 45.05 | 45.59 | 180343.0 |
| 2006-12-11 | AAXN-DELISTED | Stock | 8.30000019073486 | 8.35000038146973 | 7.88000011444092 | 8.31999969482422 | 1511400.0 |
| 2006-12-11 | AB | Stock | 79.07 | 79.27 | 78.54 | 78.7 | 214100.0 |
| 2006-12-11 | ABAX-DELISTED | Stock | 19.42 | 19.42 | 19.14 | 19.31 | 117927.0 |
| 2006-12-11 | ABB-DELISTED | Stock | 16.96 | 17.1 | 16.92 | 17.04 | 922700.0 |
| 2006-12-11 | ABBC-DELISTED | Stock | 19.42 | 19.42 | 19.2236 | 19.26 | 14790.0 |
| 2006-12-11 | ABC-DELISTED | Stock | 23.02 | 23.12 | 22.91 | 23.03 | 3055000.0 |
| 2006-12-11 | ABCB | Stock | 26.9519 | 27.3896 | 26.9422 | 27.1367 | 14702.0 |
| 2006-12-11 | ABCO-DELISTED | Stock | 26.52 | 26.73 | 26.4 | 26.63 | 281366.0 |
| 2006-12-11 | ABCW-DELISTED | Stock | 28.51 | 28.62 | 28.39 | 28.48 | 35330.0 |
| 2006-12-11 | ABD-DELISTED | Stock | 25.73 | 25.97 | 25.6 | 25.84 | 141900.0 |
| 2006-12-11 | ABE-DELISTED | Stock | 18.75 | 19.2 | 18.75 | 19.09 | 36700.0 |
| 2006-12-11 | ABFS-DELISTED | Stock | 37.43 | 37.54 | 37.33 | 37.39 | 405279.0 |
| 2006-12-11 | ABG | Stock | 23.94 | 23.95 | 23.71 | 23.89 | 182900.0 |
| 2006-12-11 | ABK-DELISTED | Stock | 85.18 | 85.63 | 85.03 | 85.28 | 213500.0 |
| 2006-12-11 | ABM | Stock | 20.9 | 20.94 | 20.76 | 20.84 | 80700.0 |
| 2006-12-11 | ABMD-DELISTED | Stock | 13.22 | 13.28 | 13.02 | 13.23 | 68662.0 |
| 2006-12-11 | ABP-DELISTED | Stock | 3.96 | 3.97 | 3.73 | 3.75 | 290800.0 |
| 2006-12-11 | ABR | Stock | 28.71 | 28.98 | 28.67 | 28.85 | 42600.0 |
| 2006-12-11 | ABT | Stock | 22.9824 | 23.0832 | 22.8241 | 22.944 | 7071697.0 |
| 2006-12-11 | ABTL-DELISTED | Stock | 16.4 | 16.8 | 16.3 | 16.8 | 35762.0 |
| 2006-12-11 | ABV-DELISTED | Stock | 47.8 | 48.17 | 47.68 | 48.15 | 400100.0 |
| 2006-12-11 | ABVA-DELISTED | Stock | 16.1 | 16.15 | 16.09 | 16.14 | 4626.0 |
| 2006-12-11 | ABVT-DELISTED | Stock | 55.75 | 57.75 | 55.75 | 57.75 | 24979.0 |
| 2006-12-11 | ABX-DELISTED | Stock | 30.28 | 30.79 | 30.17 | 30.46 | 2756500.0 |
| 2006-12-11 | ACAD | Stock | 8.98 | 9.0 | 8.87 | 8.97 | 113300.0 |
| 2006-12-11 | ACAP-DELISTED | Stock | 39.89 | 39.89 | 39.37 | 39.38 | 36244.0 |
| 2006-12-11 | ACAS-DELISTED | Stock | 44.73 | 44.8 | 44.53 | 44.58 | 430257.0 |
| 2006-12-11 | ACAT-DELISTED | Stock | 17.74 | 18.2099 | 17.62 | 18.09 | 73155.0 |
| 2006-12-11 | ACC-DELISTED | Stock | 29.35 | 29.83 | 29.11 | 29.59 | 131600.0 |
| 2006-12-11 | ACCL-DELISTED | Stock | 5.95 | 6.0 | 5.76 | 5.79 | 39826.0 |
| 2006-12-11 | ACCO | Stock | 25.73 | 25.97 | 25.6 | 25.84 | 148900.0 |
> showing 50 of 4,670 rows — these rows as CSV