PREVIEW / stock_daily / 2006-06-05
file: by_date/stock_daily/2006/2006-06-05.parquet size: 148 KB rows: 4,434 symbols: 2,799
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-06-05 | AAPL | Stock | 2.1839 | 2.1839 | 2.1418 | 2.1429 | 605785600.0 |
| 2006-06-05 | MSFT | Stock | 22.72 | 22.73 | 22.49 | 22.5 | 63914100.0 |
| 2006-06-05 | NVDA | Stock | 0.395 | 0.4023 | 0.3793 | 0.3805 | 581052000.0 |
| 2006-06-05 | AMZN | Stock | 1.723 | 1.727 | 1.6635 | 1.6745 | 100988000.0 |
| 2006-06-05 | CL | Stock | 30.0 | 30.23 | 29.735 | 29.795 | 3392800.0 |
| 2006-06-05 | A | Stock | 25.2504 | 25.3004 | 24.5422 | 24.5637 | 4340371.0 |
| 2006-06-05 | AABA-DELISTED | Stock | 31.1900005340576 | 31.4300003051758 | 30.7900009155273 | 30.8199996948242 | 17188500.0 |
| 2006-06-05 | AACC-DELISTED | Stock | 17.64 | 17.76 | 17.15 | 17.19 | 140377.0 |
| 2006-06-05 | AACQU-DELISTED | Stock | 6.37 | 6.37 | 6.37 | 6.37 | 3500.0 |
| 2006-06-05 | AACQW-DELISTED | Stock | 0.56 | 0.56 | 0.5 | 0.5 | 28500.0 |
| 2006-06-05 | AAI-DELISTED | Stock | 12.06 | 12.2 | 11.87 | 12.0 | 1519900.0 |
| 2006-06-05 | AAIC-DELISTED | Stock | 214.6 | 221.2 | 211.8 | 213.2 | 996900.0 |
| 2006-06-05 | AAME | Stock | 3.05 | 3.07 | 3.04 | 3.04 | 1300.0 |
| 2006-06-05 | AAON | Stock | 3.1723 | 3.2316 | 2.9603 | 2.9616 | 191362.0 |
| 2006-06-05 | AAP | Stock | 37.87 | 38.05 | 37.37 | 37.42 | 683300.0 |
| 2006-06-05 | AATI-DELISTED | Stock | 11.43 | 11.57 | 10.95 | 11.1 | 107731.0 |
| 2006-06-05 | AAU-DELISTED | Stock | 2.6 | 2.6 | 2.5 | 2.53 | 62900.0 |
| 2006-06-05 | AAUAF-DELISTED | Stock | 2.6 | 2.6 | 2.5 | 2.53 | 62900.0 |
| 2006-06-05 | AAV-DELISTED | Stock | 18.99 | 19.08 | 18.8325 | 18.9 | 233600.0 |
| 2006-06-05 | AAWW-DELISTED | Stock | 51.0 | 51.03 | 50.88 | 50.89 | 54804.0 |
| 2006-06-05 | AAXN-DELISTED | Stock | 9.60000038146973 | 9.90999984741211 | 9.36999988555908 | 9.39999961853027 | 669400.0 |
| 2006-06-05 | AB | Stock | 65.15 | 65.5 | 64.1 | 64.1 | 96200.0 |
| 2006-06-05 | ABAX-DELISTED | Stock | 17.8 | 18.24 | 16.82 | 16.85 | 409084.0 |
| 2006-06-05 | ABB-DELISTED | Stock | 12.48 | 12.53 | 12.26 | 12.275 | 865700.0 |
| 2006-06-05 | ABBC-DELISTED | Stock | 14.74 | 14.79 | 14.39 | 14.6 | 48611.0 |
| 2006-06-05 | ABC-DELISTED | Stock | 21.78 | 21.9 | 21.42 | 21.48 | 5821800.0 |
| 2006-06-05 | ABCB | Stock | 21.7386 | 21.7386 | 20.9215 | 21.0869 | 30844.0 |
| 2006-06-05 | ABCO-DELISTED | Stock | 26.1 | 26.25 | 25.05 | 25.06 | 248850.0 |
| 2006-06-05 | ABCW-DELISTED | Stock | 30.33 | 30.54 | 28.9 | 28.95 | 80150.0 |
| 2006-06-05 | ABD-DELISTED | Stock | 22.85 | 22.9 | 22.3 | 22.52 | 360790.0 |
| 2006-06-05 | ABE-DELISTED | Stock | 12.8 | 12.8 | 12.5 | 12.5 | 17300.0 |
| 2006-06-05 | ABFS-DELISTED | Stock | 43.67 | 43.8 | 41.72 | 41.72 | 299980.0 |
| 2006-06-05 | ABG | Stock | 21.62 | 21.83 | 21.58 | 21.71 | 230900.0 |
| 2006-06-05 | ABK-DELISTED | Stock | 80.0 | 80.0 | 78.65 | 78.68 | 525300.0 |
| 2006-06-05 | ABM | Stock | 17.63 | 17.8 | 17.24 | 17.28 | 274000.0 |
| 2006-06-05 | ABMD-DELISTED | Stock | 13.64 | 13.64 | 12.65 | 12.72 | 86167.0 |
| 2006-06-05 | ABP-DELISTED | Stock | 4.9 | 4.99 | 4.82 | 4.85 | 404200.0 |
| 2006-06-05 | ABR | Stock | 24.6 | 24.95 | 24.51 | 24.55 | 89700.0 |
| 2006-06-05 | ABT | Stock | 20.6314 | 20.6506 | 20.3339 | 20.3723 | 7200709.0 |
| 2006-06-05 | ABTL-DELISTED | Stock | 15.2 | 15.2 | 14.1 | 14.2 | 82037.0 |
| 2006-06-05 | ABV-DELISTED | Stock | 43.25 | 43.55 | 41.84 | 41.95 | 388300.0 |
| 2006-06-05 | ABVA-DELISTED | Stock | 19.1581 | 19.33 | 19.108 | 19.33 | 1725.0 |
| 2006-06-05 | ABX-DELISTED | Stock | 30.8 | 31.03 | 29.98 | 30.09 | 4599400.0 |
| 2006-06-05 | ACAD | Stock | 10.33 | 10.5 | 9.92 | 9.97 | 199700.0 |
| 2006-06-05 | ACAP-DELISTED | Stock | 46.14 | 46.3 | 45.14 | 45.2 | 64999.0 |
| 2006-06-05 | ACAS-DELISTED | Stock | 34.47 | 34.5 | 33.95 | 33.95 | 681543.0 |
| 2006-06-05 | ACAT-DELISTED | Stock | 18.57 | 18.57 | 17.77 | 17.81 | 80927.0 |
| 2006-06-05 | ACC-DELISTED | Stock | 24.45 | 25.26 | 23.96 | 23.96 | 88200.0 |
| 2006-06-05 | ACCL-DELISTED | Stock | 7.45 | 7.45 | 7.22 | 7.3 | 84766.0 |
| 2006-06-05 | ACCO | Stock | 22.85 | 22.9 | 22.3 | 22.52 | 363500.0 |
> showing 50 of 4,434 rows — these rows as CSV