PREVIEW / stock_daily / 2006-12-05
file: by_date/stock_daily/2006/2006-12-05.parquet size: 156 KB rows: 4,652 symbols: 2,950
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-05 | AAPL | Stock | 3.2732 | 3.2975 | 3.2454 | 3.2596 | 662838400.0 |
| 2006-12-05 | MSFT | Stock | 29.36 | 29.4 | 29.03 | 29.13 | 45606000.0 |
| 2006-12-05 | NVDA | Stock | 0.6098 | 0.6135 | 0.6032 | 0.61 | 663354000.0 |
| 2006-12-05 | AMZN | Stock | 1.9565 | 1.965 | 1.936 | 1.949 | 114754000.0 |
| 2006-12-05 | CL | Stock | 33.14 | 33.24 | 32.755 | 32.79 | 3185200.0 |
| 2006-12-05 | A | Stock | 23.6052 | 24.1989 | 23.4263 | 23.7196 | 5722993.0 |
| 2006-12-05 | AABA-DELISTED | Stock | 26.8700008392334 | 27.6100006103516 | 26.8600006103516 | 27.4300003051758 | 27118200.0 |
| 2006-12-05 | AACC-DELISTED | Stock | 16.59 | 17.03 | 16.28 | 16.95 | 75760.0 |
| 2006-12-05 | AACQ-DELISTED | Stock | 5.48 | 5.49 | 5.45 | 5.49 | 13500.0 |
| 2006-12-05 | AACQW-DELISTED | Stock | 0.6 | 0.6 | 0.6 | 0.6 | 2500.0 |
| 2006-12-05 | AAI-DELISTED | Stock | 12.5 | 12.74 | 12.35 | 12.52 | 1147800.0 |
| 2006-12-05 | AAIC-DELISTED | Stock | 158.8 | 160.0 | 158.0 | 159.4 | 1646800.0 |
| 2006-12-05 | AAME | Stock | 2.85 | 2.85 | 2.81 | 2.81 | 1400.0 |
| 2006-12-05 | AAON | Stock | 3.6596 | 3.7136 | 3.6425 | 3.6609 | 249075.0 |
| 2006-12-05 | AAP | Stock | 35.35 | 35.58 | 35.2 | 35.5 | 2000100.0 |
| 2006-12-05 | AATI-DELISTED | Stock | 5.77 | 5.98 | 5.62 | 5.68 | 234456.0 |
| 2006-12-05 | AAU-DELISTED | Stock | 2.53 | 2.53 | 2.48 | 2.53 | 63300.0 |
| 2006-12-05 | AAUAF-DELISTED | Stock | 2.53 | 2.53 | 2.48 | 2.53 | 63300.0 |
| 2006-12-05 | AAV-DELISTED | Stock | 12.12 | 12.23 | 12.0 | 12.08 | 783500.0 |
| 2006-12-05 | AAWW-DELISTED | Stock | 43.48 | 43.51 | 42.97 | 43.38 | 198988.0 |
| 2006-12-05 | AAXN-DELISTED | Stock | 8.39999961853027 | 8.60000038146973 | 8.35999965667725 | 8.46000003814697 | 551300.0 |
| 2006-12-05 | AB | Stock | 78.15 | 81.0 | 78.14 | 80.4 | 554300.0 |
| 2006-12-05 | ABAX-DELISTED | Stock | 19.4 | 19.88 | 19.2 | 19.6 | 116705.0 |
| 2006-12-05 | ABB-DELISTED | Stock | 16.47 | 16.67 | 16.43 | 16.66 | 2279900.0 |
| 2006-12-05 | ABBC-DELISTED | Stock | 19.4 | 19.49 | 19.33 | 19.38 | 4718.0 |
| 2006-12-05 | ABC-DELISTED | Stock | 23.46 | 23.5 | 23.16 | 23.24 | 2363600.0 |
| 2006-12-05 | ABCB | Stock | 27.623 | 27.7689 | 27.0394 | 27.2632 | 14908.0 |
| 2006-12-05 | ABCO-DELISTED | Stock | 28.19 | 28.38 | 27.96 | 28.11 | 451984.0 |
| 2006-12-05 | ABCW-DELISTED | Stock | 29.22 | 29.48 | 29.0 | 29.1 | 22400.0 |
| 2006-12-05 | ABD-DELISTED | Stock | 25.33 | 25.8 | 25.27 | 25.57 | 173530.0 |
| 2006-12-05 | ABE-DELISTED | Stock | 18.15 | 18.24 | 17.9 | 18.24 | 59300.0 |
| 2006-12-05 | ABFS-DELISTED | Stock | 36.82 | 37.03 | 36.41 | 36.97 | 350579.0 |
| 2006-12-05 | ABG | Stock | 24.0 | 24.01 | 23.77 | 23.87 | 234500.0 |
| 2006-12-05 | ABK-DELISTED | Stock | 85.05 | 85.35 | 84.62 | 85.05 | 426200.0 |
| 2006-12-05 | ABM | Stock | 20.88 | 20.95 | 20.84 | 20.86 | 92500.0 |
| 2006-12-05 | ABMD-DELISTED | Stock | 12.75 | 13.13 | 12.57 | 13.03 | 122360.0 |
| 2006-12-05 | ABP-DELISTED | Stock | 4.0 | 4.05 | 3.94 | 3.97 | 134700.0 |
| 2006-12-05 | ABR | Stock | 29.1 | 29.59 | 29.04 | 29.06 | 120600.0 |
| 2006-12-05 | ABT | Stock | 23.1264 | 23.3663 | 23.1072 | 23.1695 | 9998749.0 |
| 2006-12-05 | ABTL-DELISTED | Stock | 15.95 | 16.2 | 15.701 | 16.2 | 31877.0 |
| 2006-12-05 | ABV-DELISTED | Stock | 46.75 | 47.4 | 46.75 | 47.3 | 335400.0 |
| 2006-12-05 | ABVA-DELISTED | Stock | 16.09 | 16.18 | 16.04 | 16.04 | 2902.0 |
| 2006-12-05 | ABX-DELISTED | Stock | 31.46 | 31.51 | 30.68 | 30.97 | 3426000.0 |
| 2006-12-05 | ACAD | Stock | 9.15 | 9.2 | 9.02 | 9.12 | 114800.0 |
| 2006-12-05 | ACAP-DELISTED | Stock | 40.75 | 40.83 | 39.65 | 39.74 | 43758.0 |
| 2006-12-05 | ACAS-DELISTED | Stock | 44.59 | 45.02 | 44.4 | 44.91 | 479072.0 |
| 2006-12-05 | ACAT-DELISTED | Stock | 16.97 | 18.18 | 16.97 | 18.04 | 111602.0 |
| 2006-12-05 | ACC-DELISTED | Stock | 29.76 | 30.01 | 29.58 | 29.73 | 133034.0 |
| 2006-12-05 | ACCL-DELISTED | Stock | 6.02 | 6.07 | 6.01 | 6.04 | 27427.0 |
| 2006-12-05 | ACCO | Stock | 25.33 | 25.8 | 25.27 | 25.57 | 191100.0 |
> showing 50 of 4,652 rows — these rows as CSV