PREVIEW / stock_daily / 2006-11-29
file: by_date/stock_daily/2006/2006-11-29.parquet size: 155 KB rows: 4,631 symbols: 2,934
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-29 | AAPL | Stock | 3.3214 | 3.3268 | 3.2232 | 3.2786 | 1157083200.0 |
| 2006-11-29 | MSFT | Stock | 29.44 | 29.78 | 29.43 | 29.57 | 58775100.0 |
| 2006-11-29 | NVDA | Stock | 0.605 | 0.6157 | 0.6027 | 0.6083 | 579792000.0 |
| 2006-11-29 | AMZN | Stock | 2.024 | 2.055 | 2.0 | 2.0315 | 157092000.0 |
| 2006-11-29 | CL | Stock | 32.5 | 32.605 | 32.255 | 32.57 | 2505800.0 |
| 2006-11-29 | A | Stock | 23.319 | 23.3548 | 22.6824 | 22.9185 | 8453706.0 |
| 2006-11-29 | AABA-DELISTED | Stock | 27.3999996185303 | 27.3999996185303 | 26.7099990844727 | 27.0400009155273 | 19375100.0 |
| 2006-11-29 | AACC-DELISTED | Stock | 16.69 | 16.94 | 16.45 | 16.55 | 54108.0 |
| 2006-11-29 | AACQ-DELISTED | Stock | 5.485 | 5.5 | 5.485 | 5.5 | 10000.0 |
| 2006-11-29 | AACQU-DELISTED | Stock | 6.55 | 6.55 | 6.55 | 6.55 | 400.0 |
| 2006-11-29 | AACQW-DELISTED | Stock | 0.6 | 0.6 | 0.6 | 0.6 | 24990.0 |
| 2006-11-29 | AAI-DELISTED | Stock | 12.78 | 13.0 | 12.48 | 12.52 | 1411300.0 |
| 2006-11-29 | AAIC-DELISTED | Stock | 147.2 | 155.2 | 147.0 | 153.4 | 3852400.0 |
| 2006-11-29 | AAME | Stock | 2.85 | 2.85 | 2.75 | 2.75 | 2200.0 |
| 2006-11-29 | AAON | Stock | 3.416 | 3.5556 | 3.4041 | 3.5556 | 220978.0 |
| 2006-11-29 | AAP | Stock | 36.65 | 37.28 | 34.14 | 34.83 | 5454900.0 |
| 2006-11-29 | AATI-DELISTED | Stock | 5.65 | 5.8 | 5.5 | 5.56 | 261138.0 |
| 2006-11-29 | AAU-DELISTED | Stock | 2.56 | 2.6499 | 2.54 | 2.6 | 38100.0 |
| 2006-11-29 | AAUAF-DELISTED | Stock | 2.56 | 2.6499 | 2.54 | 2.6 | 38100.0 |
| 2006-11-29 | AAV-DELISTED | Stock | 12.48 | 12.78 | 12.48 | 12.66 | 565900.0 |
| 2006-11-29 | AAWW-DELISTED | Stock | 40.77 | 42.31 | 40.49 | 42.03 | 790178.0 |
| 2006-11-29 | AAXN-DELISTED | Stock | 8.47999954223633 | 8.56999969482422 | 8.36999988555908 | 8.53999996185303 | 662400.0 |
| 2006-11-29 | AB | Stock | 75.37 | 75.85 | 75.15 | 75.62 | 158600.0 |
| 2006-11-29 | ABAX-DELISTED | Stock | 19.39 | 19.94 | 19.12 | 19.39 | 156714.0 |
| 2006-11-29 | ABB-DELISTED | Stock | 16.01 | 16.23 | 16.01 | 16.22 | 1563400.0 |
| 2006-11-29 | ABBC-DELISTED | Stock | 15.56 | 15.9 | 15.56 | 15.88 | 5967.0 |
| 2006-11-29 | ABC-DELISTED | Stock | 22.72 | 22.82 | 22.58 | 22.7 | 1408400.0 |
| 2006-11-29 | ABCB | Stock | 27.2535 | 27.5258 | 27.1367 | 27.3215 | 14394.0 |
| 2006-11-29 | ABCO-DELISTED | Stock | 28.12 | 28.27 | 27.67 | 27.87 | 723650.0 |
| 2006-11-29 | ABCW-DELISTED | Stock | 28.67 | 28.69 | 28.4 | 28.51 | 27490.0 |
| 2006-11-29 | ABD-DELISTED | Stock | 25.23 | 25.47 | 25.16 | 25.31 | 214220.0 |
| 2006-11-29 | ABE-DELISTED | Stock | 17.25 | 17.34 | 16.85 | 17.12 | 28200.0 |
| 2006-11-29 | ABFS-DELISTED | Stock | 37.68 | 37.82 | 36.51 | 37.7 | 1013583.0 |
| 2006-11-29 | ABG | Stock | 23.49 | 23.62 | 23.35 | 23.5 | 211700.0 |
| 2006-11-29 | ABK-DELISTED | Stock | 84.6 | 87.3 | 84.6 | 86.14 | 1369700.0 |
| 2006-11-29 | ABM | Stock | 20.64 | 20.85 | 20.46 | 20.77 | 82900.0 |
| 2006-11-29 | ABMD-DELISTED | Stock | 12.51 | 12.53 | 12.22 | 12.29 | 63700.0 |
| 2006-11-29 | ABP-DELISTED | Stock | 3.9 | 4.19 | 3.87 | 4.17 | 473600.0 |
| 2006-11-29 | ABR | Stock | 28.45 | 28.5 | 28.1 | 28.18 | 85600.0 |
| 2006-11-29 | ABT | Stock | 22.3587 | 22.5074 | 22.3347 | 22.4402 | 7247395.0 |
| 2006-11-29 | ABTL-DELISTED | Stock | 14.9 | 15.0 | 14.25 | 15.0 | 48649.0 |
| 2006-11-29 | ABV-DELISTED | Stock | 45.7 | 46.17 | 45.43 | 45.9999 | 616400.0 |
| 2006-11-29 | ABVA-DELISTED | Stock | 16.15 | 16.2 | 16.04 | 16.15 | 74131.0 |
| 2006-11-29 | ABX-DELISTED | Stock | 29.95 | 30.37 | 29.94 | 30.23 | 3286575.0 |
| 2006-11-29 | ACAD | Stock | 9.0 | 9.24 | 8.88 | 9.18 | 235600.0 |
| 2006-11-29 | ACAP-DELISTED | Stock | 38.34 | 39.55 | 38.17 | 39.49 | 46500.0 |
| 2006-11-29 | ACAS-DELISTED | Stock | 44.5 | 45.23 | 44.43 | 45.05 | 1053036.0 |
| 2006-11-29 | ACAT-DELISTED | Stock | 16.95 | 17.01 | 16.62 | 16.86 | 76747.0 |
| 2006-11-29 | ACC-DELISTED | Stock | 28.5 | 28.93 | 28.49 | 28.84 | 117548.0 |
| 2006-11-29 | ACCL-DELISTED | Stock | 6.2 | 6.31 | 6.12 | 6.23 | 36424.0 |
> showing 50 of 4,631 rows — these rows as CSV