PREVIEW / stock_daily / 2006-11-24
file: by_date/stock_daily/2006/2006-11-24.parquet size: 147 KB rows: 4,439 symbols: 2,776
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-24 | AAPL | Stock | 3.1975 | 3.3243 | 3.1964 | 3.2725 | 518677600.0 |
| 2006-11-24 | MSFT | Stock | 29.66 | 29.84 | 29.64 | 29.76 | 20456700.0 |
| 2006-11-24 | NVDA | Stock | 0.6088 | 0.6177 | 0.6033 | 0.6163 | 144336000.0 |
| 2006-11-24 | AMZN | Stock | 2.128 | 2.147 | 2.1155 | 2.1205 | 44826000.0 |
| 2006-11-24 | CL | Stock | 33.15 | 33.26 | 32.75 | 32.985 | 1955400.0 |
| 2006-11-24 | A | Stock | 23.7625 | 24.1059 | 23.7482 | 24.0057 | 1347532.0 |
| 2006-11-24 | AABA-DELISTED | Stock | 28.2199993133545 | 28.4899997711182 | 27.7000007629395 | 28.0300006866455 | 9384400.0 |
| 2006-11-24 | AACC-DELISTED | Stock | 17.27 | 17.45 | 17.24 | 17.41 | 37893.0 |
| 2006-11-24 | AAI-DELISTED | Stock | 13.12 | 13.38 | 13.1 | 13.34 | 846700.0 |
| 2006-11-24 | AAIC-DELISTED | Stock | 149.0 | 150.8 | 148.4 | 150.4 | 356600.0 |
| 2006-11-24 | AAON | Stock | 3.6451 | 3.7083 | 3.6227 | 3.6991 | 61509.0 |
| 2006-11-24 | AAP | Stock | 37.9 | 38.3 | 37.68 | 38.07 | 148200.0 |
| 2006-11-24 | AATI-DELISTED | Stock | 5.56 | 5.71 | 5.56 | 5.66 | 41339.0 |
| 2006-11-24 | AAU-DELISTED | Stock | 2.51 | 2.68 | 2.5 | 2.63 | 111300.0 |
| 2006-11-24 | AAUAF-DELISTED | Stock | 2.51 | 2.68 | 2.5 | 2.63 | 111300.0 |
| 2006-11-24 | AAV-DELISTED | Stock | 12.45 | 12.68 | 12.45 | 12.62 | 451400.0 |
| 2006-11-24 | AAWW-DELISTED | Stock | 39.78 | 40.47 | 39.75 | 40.14 | 95139.0 |
| 2006-11-24 | AAXN-DELISTED | Stock | 8.76000022888184 | 9.05000019073486 | 8.6899995803833 | 8.97000026702881 | 436100.0 |
| 2006-11-24 | AB | Stock | 77.0 | 77.03 | 76.66 | 76.88 | 37000.0 |
| 2006-11-24 | ABAX-DELISTED | Stock | 19.9 | 20.12 | 19.76 | 20.03 | 32162.0 |
| 2006-11-24 | ABB-DELISTED | Stock | 16.1 | 16.23 | 16.06 | 16.11 | 541000.0 |
| 2006-11-24 | ABBC-DELISTED | Stock | 16.1 | 16.1 | 15.94 | 16.01 | 2534.0 |
| 2006-11-24 | ABC-DELISTED | Stock | 22.93 | 22.96 | 22.6 | 22.62 | 734600.0 |
| 2006-11-24 | ABCB | Stock | 27.2535 | 27.5161 | 27.234 | 27.2924 | 4010.0 |
| 2006-11-24 | ABCO-DELISTED | Stock | 28.63 | 28.88 | 28.36 | 28.43 | 1123878.0 |
| 2006-11-24 | ABCW-DELISTED | Stock | 28.65 | 29.03 | 28.65 | 28.98 | 4620.0 |
| 2006-11-24 | ABD-DELISTED | Stock | 25.07 | 25.54 | 25.03 | 25.48 | 104170.0 |
| 2006-11-24 | ABE-DELISTED | Stock | 17.24 | 17.24 | 17.08 | 17.17 | 25500.0 |
| 2006-11-24 | ABFS-DELISTED | Stock | 39.04 | 39.2608 | 38.78 | 39.05 | 122262.0 |
| 2006-11-24 | ABG | Stock | 24.0 | 24.0 | 22.76 | 23.08 | 389900.0 |
| 2006-11-24 | ABK-DELISTED | Stock | 83.57 | 84.24 | 83.42 | 84.13 | 157700.0 |
| 2006-11-24 | ABM | Stock | 20.56 | 20.86 | 20.53 | 20.82 | 19400.0 |
| 2006-11-24 | ABMD-DELISTED | Stock | 12.7 | 12.81 | 12.65 | 12.75 | 28241.0 |
| 2006-11-24 | ABP-DELISTED | Stock | 3.54 | 3.72 | 3.54 | 3.72 | 82300.0 |
| 2006-11-24 | ABR | Stock | 28.05 | 28.73 | 28.01 | 28.72 | 29500.0 |
| 2006-11-24 | ABT | Stock | 22.589 | 22.6466 | 22.4738 | 22.5266 | 4045019.0 |
| 2006-11-24 | ABTL-DELISTED | Stock | 15.801 | 15.801 | 15.497 | 15.75 | 15098.0 |
| 2006-11-24 | ABV-DELISTED | Stock | 46.55 | 46.79 | 46.42 | 46.65 | 200900.0 |
| 2006-11-24 | ABX-DELISTED | Stock | 29.82 | 29.97 | 29.67 | 29.725 | 2467623.0 |
| 2006-11-24 | ACAD | Stock | 9.24 | 9.46 | 9.18 | 9.3 | 41600.0 |
| 2006-11-24 | ACAP-DELISTED | Stock | 38.07 | 40.35 | 38.05 | 40.08 | 38313.0 |
| 2006-11-24 | ACAS-DELISTED | Stock | 44.76 | 45.06 | 44.61 | 44.99 | 235941.0 |
| 2006-11-24 | ACAT-DELISTED | Stock | 17.42 | 17.86 | 17.42 | 17.6 | 27766.0 |
| 2006-11-24 | ACC-DELISTED | Stock | 28.42 | 28.79 | 28.31 | 28.68 | 51700.0 |
| 2006-11-24 | ACCL-DELISTED | Stock | 6.33 | 6.36 | 6.27 | 6.36 | 13718.0 |
| 2006-11-24 | ACCO | Stock | 25.07 | 25.54 | 25.03 | 25.48 | 104700.0 |
| 2006-11-24 | ACCP-DELISTED | Stock | 1.35 | 1.35 | 1.35 | 1.35 | 200.0 |
| 2006-11-24 | ACE-DELISTED | Stock | 57.5 | 58.19 | 57.5 | 57.64 | 317200.0 |
| 2006-11-24 | ACF-DELISTED | Stock | 25.47 | 25.54 | 25.24 | 25.48 | 259300.0 |
| 2006-11-24 | ACFC-DELISTED | Stock | 92.04 | 92.09 | 92.04 | 92.09 | 65.0 |
> showing 50 of 4,439 rows — these rows as CSV