PREVIEW / stock_daily / 2006-12-01
file: by_date/stock_daily/2006/2006-12-01.parquet size: 155 KB rows: 4,624 symbols: 2,923
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-01 | AAPL | Stock | 3.2786 | 3.2975 | 3.2179 | 3.2614 | 795079600.0 |
| 2006-12-01 | MSFT | Stock | 29.23 | 29.3 | 28.9 | 29.12 | 72257000.0 |
| 2006-12-01 | NVDA | Stock | 0.6097 | 0.6105 | 0.587 | 0.5923 | 785010000.0 |
| 2006-12-01 | AMZN | Stock | 2.013 | 2.027 | 1.9545 | 1.9705 | 166122000.0 |
| 2006-12-01 | CL | Stock | 32.6 | 32.7 | 32.325 | 32.68 | 3178600.0 |
| 2006-12-01 | A | Stock | 22.8684 | 22.9399 | 22.6609 | 22.8684 | 3398957.0 |
| 2006-12-01 | AABA-DELISTED | Stock | 27.0 | 27.25 | 26.0 | 26.4899997711182 | 20055800.0 |
| 2006-12-01 | AACC-DELISTED | Stock | 16.55 | 16.62 | 16.33 | 16.58 | 64466.0 |
| 2006-12-01 | AACQ-DELISTED | Stock | 5.46 | 5.46 | 5.46 | 5.46 | 5000.0 |
| 2006-12-01 | AACQU-DELISTED | Stock | 6.52 | 6.52 | 6.52 | 6.52 | 1000.0 |
| 2006-12-01 | AACQW-DELISTED | Stock | 0.56 | 0.57 | 0.56 | 0.57 | 167500.0 |
| 2006-12-01 | AAI-DELISTED | Stock | 12.74 | 12.75 | 12.32 | 12.54 | 1485900.0 |
| 2006-12-01 | AAIC-DELISTED | Stock | 155.6 | 158.8 | 153.0 | 155.8 | 1814800.0 |
| 2006-12-01 | AAME | Stock | 2.85 | 2.85 | 2.85 | 2.85 | 1100.0 |
| 2006-12-01 | AAON | Stock | 3.6872 | 3.6872 | 3.4897 | 3.6714 | 233128.0 |
| 2006-12-01 | AAP | Stock | 35.43 | 35.77 | 35.05 | 35.29 | 1693600.0 |
| 2006-12-01 | AATI-DELISTED | Stock | 5.53 | 5.66 | 5.5 | 5.58 | 264282.0 |
| 2006-12-01 | AAU-DELISTED | Stock | 2.56 | 2.56 | 2.46 | 2.46 | 69800.0 |
| 2006-12-01 | AAUAF-DELISTED | Stock | 2.56 | 2.56 | 2.46 | 2.46 | 69800.0 |
| 2006-12-01 | AAV-DELISTED | Stock | 12.55 | 12.68 | 12.27 | 12.42 | 543200.0 |
| 2006-12-01 | AAWW-DELISTED | Stock | 42.55 | 42.56 | 41.77 | 42.4 | 366288.0 |
| 2006-12-01 | AAXN-DELISTED | Stock | 8.59000015258789 | 8.59000015258789 | 8.15999984741211 | 8.27999973297119 | 1360900.0 |
| 2006-12-01 | AB | Stock | 76.49 | 77.0 | 75.6 | 76.98 | 618400.0 |
| 2006-12-01 | ABAX-DELISTED | Stock | 19.3 | 19.32 | 18.5 | 18.92 | 283870.0 |
| 2006-12-01 | ABB-DELISTED | Stock | 16.51 | 16.52 | 16.16 | 16.31 | 1399900.0 |
| 2006-12-01 | ABBC-DELISTED | Stock | 19.48 | 19.48 | 18.93 | 19.4 | 36140.0 |
| 2006-12-01 | ABC-DELISTED | Stock | 23.12 | 23.12 | 22.72 | 22.89 | 2270400.0 |
| 2006-12-01 | ABCB | Stock | 27.0103 | 27.409 | 27.0103 | 27.409 | 29096.0 |
| 2006-12-01 | ABCO-DELISTED | Stock | 27.75 | 27.75 | 27.12 | 27.42 | 335081.0 |
| 2006-12-01 | ABCW-DELISTED | Stock | 28.55 | 28.78 | 28.4 | 28.67 | 53790.0 |
| 2006-12-01 | ABD-DELISTED | Stock | 25.39 | 25.39 | 24.5 | 24.99 | 183380.0 |
| 2006-12-01 | ABE-DELISTED | Stock | 17.0 | 17.5 | 17.0 | 17.48 | 41600.0 |
| 2006-12-01 | ABFS-DELISTED | Stock | 37.64 | 38.11 | 37.1 | 37.2 | 396486.0 |
| 2006-12-01 | ABG | Stock | 23.63 | 23.72 | 23.38 | 23.59 | 272900.0 |
| 2006-12-01 | ABK-DELISTED | Stock | 85.41 | 85.76 | 84.15 | 84.68 | 480900.0 |
| 2006-12-01 | ABM | Stock | 20.72 | 20.85 | 20.31 | 20.85 | 184100.0 |
| 2006-12-01 | ABMD-DELISTED | Stock | 12.64 | 12.89 | 12.28 | 12.43 | 168262.0 |
| 2006-12-01 | ABP-DELISTED | Stock | 4.24 | 4.26 | 3.98 | 4.09 | 152400.0 |
| 2006-12-01 | ABR | Stock | 28.16 | 28.3 | 28.06 | 28.23 | 207200.0 |
| 2006-12-01 | ABT | Stock | 22.5026 | 22.5266 | 22.1908 | 22.3443 | 10331388.0 |
| 2006-12-01 | ABTL-DELISTED | Stock | 15.096 | 15.954 | 15.064 | 15.5 | 267345.0 |
| 2006-12-01 | ABV-DELISTED | Stock | 46.25 | 46.37 | 45.54 | 45.91 | 270900.0 |
| 2006-12-01 | ABVA-DELISTED | Stock | 16.29 | 16.29 | 16.04 | 16.04 | 19720.0 |
| 2006-12-01 | ABVT-DELISTED | Stock | 59.0 | 59.0 | 59.0 | 59.0 | 136.0 |
| 2006-12-01 | ABX-DELISTED | Stock | 31.38 | 31.54 | 31.0 | 31.15 | 3028800.0 |
| 2006-12-01 | ACAD | Stock | 9.45 | 9.45 | 9.07 | 9.29 | 91200.0 |
| 2006-12-01 | ACAP-DELISTED | Stock | 39.89 | 40.45 | 39.24 | 39.53 | 48263.0 |
| 2006-12-01 | ACAS-DELISTED | Stock | 45.35 | 45.36 | 44.78 | 45.09 | 679408.0 |
| 2006-12-01 | ACAT-DELISTED | Stock | 16.565 | 16.685 | 16.515 | 16.665 | 31304.0 |
| 2006-12-01 | ACC-DELISTED | Stock | 29.5 | 29.65 | 28.78 | 29.23 | 161400.0 |
> showing 50 of 4,624 rows — these rows as CSV