PREVIEW / stock_daily / 2006-11-02
file: by_date/stock_daily/2006/2006-11-02.parquet size: 153 KB rows: 4,591 symbols: 2,909
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-02 | AAPL | Stock | 2.8186 | 2.8329 | 2.8036 | 2.8207 | 465483200.0 |
| 2006-11-02 | MSFT | Stock | 28.71 | 28.86 | 28.58 | 28.77 | 58674400.0 |
| 2006-11-02 | NVDA | Stock | 0.5388 | 0.5505 | 0.5253 | 0.5327 | 862944000.0 |
| 2006-11-02 | AMZN | Stock | 1.8665 | 1.8885 | 1.8555 | 1.8725 | 108946000.0 |
| 2006-11-02 | CL | Stock | 31.95 | 32.04 | 31.66 | 31.78 | 3334200.0 |
| 2006-11-02 | A | Stock | 24.299 | 24.3062 | 23.7482 | 23.8984 | 2871632.0 |
| 2006-11-02 | AABA-DELISTED | Stock | 25.9400005340576 | 26.6000003814697 | 25.7700004577637 | 26.5300006866455 | 34824500.0 |
| 2006-11-02 | AACC-DELISTED | Stock | 16.53 | 16.92 | 16.27 | 16.53 | 187073.0 |
| 2006-11-02 | AACQ-DELISTED | Stock | 5.48 | 5.48 | 5.48 | 5.48 | 83000.0 |
| 2006-11-02 | AACQU-DELISTED | Stock | 6.65 | 6.7 | 6.65 | 6.7 | 14000.0 |
| 2006-11-02 | AACQW-DELISTED | Stock | 0.57 | 0.64 | 0.56 | 0.6 | 423590.0 |
| 2006-11-02 | AAI-DELISTED | Stock | 9.7 | 9.8 | 9.51 | 9.63 | 1395700.0 |
| 2006-11-02 | AAIC-DELISTED | Stock | 142.0 | 161.0 | 142.0 | 159.6 | 3227300.0 |
| 2006-11-02 | AAME | Stock | 2.53 | 2.54 | 2.42 | 2.51 | 9100.0 |
| 2006-11-02 | AAON | Stock | 2.9432 | 2.9959 | 2.8932 | 2.9919 | 221737.0 |
| 2006-11-02 | AAP | Stock | 35.19 | 36.99 | 35.19 | 36.3 | 4057700.0 |
| 2006-11-02 | AATI-DELISTED | Stock | 5.78 | 5.94 | 5.69 | 5.71 | 219695.0 |
| 2006-11-02 | AAU-DELISTED | Stock | 2.6 | 2.65 | 2.56 | 2.6368 | 41800.0 |
| 2006-11-02 | AAUAF-DELISTED | Stock | 2.6 | 2.65 | 2.56 | 2.6368 | 41800.0 |
| 2006-11-02 | AAV-DELISTED | Stock | 11.77 | 12.19 | 11.3 | 11.77 | 2789100.0 |
| 2006-11-02 | AAWW-DELISTED | Stock | 44.32 | 44.45 | 42.87 | 43.19 | 259155.0 |
| 2006-11-02 | AAXN-DELISTED | Stock | 8.89000034332275 | 8.97000026702881 | 8.69999980926514 | 8.77000045776367 | 1190900.0 |
| 2006-11-02 | AB | Stock | 75.75 | 76.36 | 74.64 | 75.92 | 340500.0 |
| 2006-11-02 | ABAX-DELISTED | Stock | 19.28 | 19.48 | 18.85 | 19.3 | 208688.0 |
| 2006-11-02 | ABB-DELISTED | Stock | 14.66 | 14.7 | 14.49 | 14.63 | 1428200.0 |
| 2006-11-02 | ABBC-DELISTED | Stock | 15.96 | 16.08 | 15.9 | 15.9 | 5273.0 |
| 2006-11-02 | ABC-DELISTED | Stock | 23.75 | 24.0 | 22.78 | 23.1 | 7344000.0 |
| 2006-11-02 | ABCB | Stock | 26.2906 | 26.7282 | 26.0668 | 26.1738 | 23647.0 |
| 2006-11-02 | ABCO-DELISTED | Stock | 26.32 | 26.64 | 26.32 | 26.54 | 142169.0 |
| 2006-11-02 | ABCW-DELISTED | Stock | 28.39 | 28.68 | 28.36 | 28.4 | 42710.0 |
| 2006-11-02 | ABD-DELISTED | Stock | 22.75 | 24.7 | 22.75 | 24.5 | 576500.0 |
| 2006-11-02 | ABE-DELISTED | Stock | 16.5 | 16.56 | 16.4 | 16.56 | 29500.0 |
| 2006-11-02 | ABFS-DELISTED | Stock | 40.18 | 40.32 | 39.4 | 40.0 | 595414.0 |
| 2006-11-02 | ABG | Stock | 23.3 | 24.22 | 23.14 | 24.12 | 549200.0 |
| 2006-11-02 | ABK-DELISTED | Stock | 83.32 | 84.3 | 83.32 | 83.84 | 462400.0 |
| 2006-11-02 | ABM | Stock | 19.6 | 19.81 | 19.58 | 19.59 | 92600.0 |
| 2006-11-02 | ABMD-DELISTED | Stock | 13.12 | 13.43 | 13.12 | 13.23 | 96735.0 |
| 2006-11-02 | ABP-DELISTED | Stock | 3.37 | 3.51 | 3.36 | 3.36 | 248800.0 |
| 2006-11-02 | ABR | Stock | 28.02 | 28.3 | 27.88 | 28.3 | 108600.0 |
| 2006-11-02 | ABT | Stock | 22.7665 | 22.8769 | 22.7185 | 22.7713 | 9768445.0 |
| 2006-11-02 | ABTL-DELISTED | Stock | 16.25 | 16.65 | 16.1 | 16.5 | 18347.0 |
| 2006-11-02 | ABV-DELISTED | Stock | 44.48 | 44.5 | 43.65 | 44.02 | 413000.0 |
| 2006-11-02 | ABVA-DELISTED | Stock | 16.32 | 16.358 | 16.25 | 16.25 | 1500.0 |
| 2006-11-02 | ABVT-DELISTED | Stock | 63.0 | 63.0 | 63.0 | 63.0 | 2.0 |
| 2006-11-02 | ABX-DELISTED | Stock | 31.15 | 31.55 | 30.61 | 30.86 | 5511300.0 |
| 2006-11-02 | ACAD | Stock | 9.08 | 9.47 | 9.07 | 9.3 | 176100.0 |
| 2006-11-02 | ACAP-DELISTED | Stock | 34.01 | 35.8 | 34.01 | 35.45 | 32637.0 |
| 2006-11-02 | ACAS-DELISTED | Stock | 42.77 | 42.98 | 38.72 | 41.55 | 3885512.0 |
| 2006-11-02 | ACAT-DELISTED | Stock | 17.23 | 17.66 | 17.17 | 17.51 | 96086.0 |
| 2006-11-02 | ACC-DELISTED | Stock | 26.24 | 26.49 | 25.87 | 26.36 | 111000.0 |
> showing 50 of 4,591 rows — these rows as CSV