PREVIEW / stock_daily / 2006-11-10
file: by_date/stock_daily/2006/2006-11-10.parquet size: 153 KB rows: 4,587 symbols: 2,911
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-10 | AAPL | Stock | 2.9839 | 2.9857 | 2.9464 | 2.9686 | 373864400.0 |
| 2006-11-10 | MSFT | Stock | 29.17 | 29.29 | 29.15 | 29.24 | 37855100.0 |
| 2006-11-10 | NVDA | Stock | 0.5832 | 0.586 | 0.5595 | 0.574 | 1317192000.0 |
| 2006-11-10 | AMZN | Stock | 1.9395 | 1.968 | 1.938 | 1.963 | 89902000.0 |
| 2006-11-10 | CL | Stock | 32.61 | 32.675 | 32.405 | 32.62 | 2165200.0 |
| 2006-11-10 | A | Stock | 24.3777 | 24.6137 | 24.3419 | 24.5637 | 2835004.0 |
| 2006-11-10 | AABA-DELISTED | Stock | 27.3999996185303 | 27.5 | 27.0300006866455 | 27.3899993896484 | 21366600.0 |
| 2006-11-10 | AACC-DELISTED | Stock | 17.01 | 17.42 | 17.0 | 17.22 | 109966.0 |
| 2006-11-10 | AACQ-DELISTED | Stock | 5.44 | 5.44 | 5.44 | 5.44 | 12500.0 |
| 2006-11-10 | AACQU-DELISTED | Stock | 6.55 | 6.55 | 6.55 | 6.55 | 10000.0 |
| 2006-11-10 | AACQW-DELISTED | Stock | 0.57 | 0.59 | 0.57 | 0.57 | 39000.0 |
| 2006-11-10 | AAI-DELISTED | Stock | 10.06 | 10.34 | 10.0 | 10.34 | 1776700.0 |
| 2006-11-10 | AAIC-DELISTED | Stock | 140.0 | 144.4 | 140.0 | 143.4 | 2381600.0 |
| 2006-11-10 | AAON | Stock | 3.2356 | 3.4542 | 3.2356 | 3.4384 | 348553.0 |
| 2006-11-10 | AAP | Stock | 37.15 | 37.44 | 37.08 | 37.35 | 575300.0 |
| 2006-11-10 | AATI-DELISTED | Stock | 5.32 | 5.5 | 5.32 | 5.42 | 160678.0 |
| 2006-11-10 | AAU-DELISTED | Stock | 2.67 | 2.67 | 2.6 | 2.67 | 67900.0 |
| 2006-11-10 | AAUAF-DELISTED | Stock | 2.67 | 2.67 | 2.6 | 2.67 | 67900.0 |
| 2006-11-10 | AAV-DELISTED | Stock | 11.8 | 11.87 | 11.28 | 11.44 | 1004200.0 |
| 2006-11-10 | AAWW-DELISTED | Stock | 39.18 | 39.36 | 37.11 | 37.97 | 260189.0 |
| 2006-11-10 | AAXN-DELISTED | Stock | 9.06999969482422 | 9.35000038146973 | 9.0 | 9.22000026702881 | 1059300.0 |
| 2006-11-10 | AB | Stock | 75.65 | 76.7 | 75.5 | 76.03 | 395700.0 |
| 2006-11-10 | ABAX-DELISTED | Stock | 19.98 | 20.53 | 19.98 | 20.388 | 131334.0 |
| 2006-11-10 | ABB-DELISTED | Stock | 15.48 | 15.56 | 15.47 | 15.56 | 1891100.0 |
| 2006-11-10 | ABBC-DELISTED | Stock | 15.73 | 16.05 | 15.73 | 15.85 | 8781.0 |
| 2006-11-10 | ABC-DELISTED | Stock | 22.52 | 22.72 | 22.43 | 22.58 | 2931400.0 |
| 2006-11-10 | ABCB | Stock | 26.0571 | 26.699 | 26.0571 | 26.6504 | 11823.0 |
| 2006-11-10 | ABCO-DELISTED | Stock | 28.13 | 28.26 | 27.79 | 28.09 | 107333.0 |
| 2006-11-10 | ABCW-DELISTED | Stock | 28.63 | 29.18 | 28.52 | 29.17 | 44620.0 |
| 2006-11-10 | ABD-DELISTED | Stock | 24.4 | 24.53 | 24.14 | 24.45 | 289400.0 |
| 2006-11-10 | ABE-DELISTED | Stock | 16.52 | 16.8509 | 15.66 | 16.05 | 156800.0 |
| 2006-11-10 | ABFS-DELISTED | Stock | 39.39 | 40.15 | 39.31 | 40.0 | 253932.0 |
| 2006-11-10 | ABG | Stock | 24.98 | 25.04 | 24.6 | 24.89 | 233100.0 |
| 2006-11-10 | ABK-DELISTED | Stock | 84.65 | 84.91 | 84.52 | 84.72 | 548000.0 |
| 2006-11-10 | ABM | Stock | 19.97 | 20.31 | 19.94 | 20.31 | 101200.0 |
| 2006-11-10 | ABMD-DELISTED | Stock | 13.02 | 13.16 | 12.63 | 12.85 | 216042.0 |
| 2006-11-10 | ABP-DELISTED | Stock | 3.54 | 3.6 | 3.35 | 3.6 | 164500.0 |
| 2006-11-10 | ABR | Stock | 27.42 | 28.0 | 27.42 | 28.0 | 48400.0 |
| 2006-11-10 | ABT | Stock | 21.9508 | 22.2531 | 21.7877 | 22.0564 | 13233431.0 |
| 2006-11-10 | ABTL-DELISTED | Stock | 17.156 | 17.459 | 15.995 | 16.5 | 27006.0 |
| 2006-11-10 | ABV-DELISTED | Stock | 45.3 | 46.12 | 45.04 | 45.8 | 472900.0 |
| 2006-11-10 | ABVA-DELISTED | Stock | 15.94 | 15.95 | 15.94 | 15.95 | 745.0 |
| 2006-11-10 | ABVT-DELISTED | Stock | 50.0 | 60.0 | 50.0 | 60.0 | 136.0 |
| 2006-11-10 | ABX-DELISTED | Stock | 29.88 | 29.96 | 29.19 | 29.45 | 5453400.0 |
| 2006-11-10 | ACAD | Stock | 9.43 | 9.43 | 9.15 | 9.29 | 222800.0 |
| 2006-11-10 | ACAP-DELISTED | Stock | 36.58 | 37.4 | 36.51 | 37.37 | 19957.0 |
| 2006-11-10 | ACAS-DELISTED | Stock | 42.5 | 43.15 | 42.49 | 43.06 | 683095.0 |
| 2006-11-10 | ACAT-DELISTED | Stock | 17.57 | 17.65 | 17.28 | 17.43 | 101445.0 |
| 2006-11-10 | ACC-DELISTED | Stock | 27.38 | 27.78 | 27.29 | 27.66 | 99561.0 |
| 2006-11-10 | ACCL-DELISTED | Stock | 6.3 | 6.34 | 6.16 | 6.24 | 34347.0 |
> showing 50 of 4,587 rows — these rows as CSV