PREVIEW / stock_daily / 2006-11-30
file: by_date/stock_daily/2006/2006-11-30.parquet size: 155 KB rows: 4,619 symbols: 2,931
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-30 | AAPL | Stock | 3.2932 | 3.31 | 3.2521 | 3.2736 | 870486400.0 |
| 2006-11-30 | MSFT | Stock | 29.42 | 29.57 | 29.33 | 29.36 | 53297400.0 |
| 2006-11-30 | NVDA | Stock | 0.6083 | 0.6215 | 0.601 | 0.6165 | 583632000.0 |
| 2006-11-30 | AMZN | Stock | 2.021 | 2.032 | 1.9925 | 2.017 | 126926000.0 |
| 2006-11-30 | CL | Stock | 32.675 | 32.735 | 32.415 | 32.525 | 3165200.0 |
| 2006-11-30 | A | Stock | 22.9256 | 22.9971 | 22.7468 | 22.7754 | 6192860.0 |
| 2006-11-30 | AABA-DELISTED | Stock | 27.0 | 27.1499996185303 | 26.7299995422363 | 27.0100002288818 | 14916300.0 |
| 2006-11-30 | AACC-DELISTED | Stock | 16.55 | 16.69 | 16.4 | 16.65 | 88135.0 |
| 2006-11-30 | AACQ-DELISTED | Stock | 5.5 | 5.5 | 5.5 | 5.5 | 2500.0 |
| 2006-11-30 | AACQU-DELISTED | Stock | 6.55 | 6.55 | 6.55 | 6.55 | 1000.0 |
| 2006-11-30 | AACQW-DELISTED | Stock | 0.59 | 0.59 | 0.59 | 0.59 | 4000.0 |
| 2006-11-30 | AAI-DELISTED | Stock | 12.55 | 12.61 | 12.34 | 12.41 | 2486600.0 |
| 2006-11-30 | AAIC-DELISTED | Stock | 153.4 | 157.2 | 152.032 | 156.6 | 2132000.0 |
| 2006-11-30 | AAME | Stock | 2.85 | 2.85 | 2.85 | 2.85 | 2800.0 |
| 2006-11-30 | AAON | Stock | 3.5582 | 3.6872 | 3.5582 | 3.6767 | 239203.0 |
| 2006-11-30 | AAP | Stock | 34.91 | 35.8 | 34.91 | 35.6 | 2616900.0 |
| 2006-11-30 | AATI-DELISTED | Stock | 5.56 | 5.68 | 5.47 | 5.57 | 122639.0 |
| 2006-11-30 | AAU-DELISTED | Stock | 2.79 | 2.81 | 2.56 | 2.56 | 97563.0 |
| 2006-11-30 | AAUAF-DELISTED | Stock | 2.64 | 2.66 | 2.42 | 2.42 | 103200.0 |
| 2006-11-30 | AAV-DELISTED | Stock | 12.69 | 12.79 | 12.59 | 12.62 | 538700.0 |
| 2006-11-30 | AAWW-DELISTED | Stock | 42.14 | 42.58 | 41.94 | 42.47 | 285681.0 |
| 2006-11-30 | AAXN-DELISTED | Stock | 8.60000038146973 | 8.60000038146973 | 8.38000011444092 | 8.47999954223633 | 638500.0 |
| 2006-11-30 | AB | Stock | 75.9 | 77.0 | 75.75 | 76.49 | 169400.0 |
| 2006-11-30 | ABAX-DELISTED | Stock | 19.31 | 19.63 | 19.3 | 19.32 | 129720.0 |
| 2006-11-30 | ABB-DELISTED | Stock | 16.25 | 16.38 | 16.151 | 16.27 | 1787200.0 |
| 2006-11-30 | ABBC-DELISTED | Stock | 19.01 | 19.74 | 19.01 | 19.4 | 303242.0 |
| 2006-11-30 | ABC-DELISTED | Stock | 22.9 | 23.1 | 22.78 | 23.01 | 2213600.0 |
| 2006-11-30 | ABCB | Stock | 27.4674 | 27.5939 | 26.9617 | 27.1464 | 18403.0 |
| 2006-11-30 | ABCO-DELISTED | Stock | 27.77 | 28.12 | 27.58 | 27.73 | 501128.0 |
| 2006-11-30 | ABCW-DELISTED | Stock | 28.41 | 28.9 | 28.4 | 28.66 | 35880.0 |
| 2006-11-30 | ABD-DELISTED | Stock | 25.22 | 25.63 | 25.18 | 25.39 | 212310.0 |
| 2006-11-30 | ABE-DELISTED | Stock | 17.16 | 17.19 | 16.9101 | 17.07 | 29000.0 |
| 2006-11-30 | ABFS-DELISTED | Stock | 37.74 | 38.21 | 37.72 | 37.94 | 596506.0 |
| 2006-11-30 | ABG | Stock | 23.51 | 23.72 | 23.38 | 23.54 | 222800.0 |
| 2006-11-30 | ABK-DELISTED | Stock | 86.22 | 86.3 | 84.51 | 85.63 | 1212300.0 |
| 2006-11-30 | ABM | Stock | 20.73 | 20.86 | 20.57 | 20.77 | 109900.0 |
| 2006-11-30 | ABMD-DELISTED | Stock | 12.26 | 12.7 | 12.07 | 12.62 | 127980.0 |
| 2006-11-30 | ABP-DELISTED | Stock | 4.2 | 4.34 | 4.17 | 4.23 | 321500.0 |
| 2006-11-30 | ABR | Stock | 28.18 | 28.43 | 28.11 | 28.24 | 231500.0 |
| 2006-11-30 | ABT | Stock | 22.5122 | 22.5506 | 22.2867 | 22.3875 | 9590246.0 |
| 2006-11-30 | ABTL-DELISTED | Stock | 14.85 | 15.2 | 14.75 | 15.1 | 109265.0 |
| 2006-11-30 | ABV-DELISTED | Stock | 45.87 | 46.42 | 45.78 | 46.13 | 413500.0 |
| 2006-11-30 | ABVA-DELISTED | Stock | 16.06 | 16.2 | 16.05 | 16.2 | 50800.0 |
| 2006-11-30 | ABX-DELISTED | Stock | 30.61 | 31.54 | 30.61 | 31.45 | 5665265.0 |
| 2006-11-30 | ACAD | Stock | 9.15 | 9.51 | 9.06 | 9.36 | 158100.0 |
| 2006-11-30 | ACAP-DELISTED | Stock | 39.44 | 40.1 | 39.39 | 39.97 | 87551.0 |
| 2006-11-30 | ACAS-DELISTED | Stock | 45.24 | 45.32 | 44.85 | 45.27 | 760851.0 |
| 2006-11-30 | ACAT-DELISTED | Stock | 16.905 | 16.955 | 16.525 | 16.555 | 68204.0 |
| 2006-11-30 | ACC-DELISTED | Stock | 28.81 | 30.23 | 28.61 | 29.75 | 394900.0 |
| 2006-11-30 | ACCL-DELISTED | Stock | 6.2 | 6.25 | 6.0 | 6.05 | 27024.0 |
> showing 50 of 4,619 rows — these rows as CSV