PREVIEW / stock_daily / 2006-01-26
file: by_date/stock_daily/2006/2006-01-26.parquet size: 145 KB rows: 4,348 symbols: 2,754
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-01-26 | AAPL | Stock | 2.6618 | 2.6939 | 2.5689 | 2.5832 | 1181387200.0 |
| 2006-01-26 | MSFT | Stock | 26.56 | 26.72 | 26.31 | 26.5 | 69509300.0 |
| 2006-01-26 | NVDA | Stock | 0.3711 | 0.3786 | 0.3687 | 0.3782 | 448836000.0 |
| 2006-01-26 | AMZN | Stock | 2.1975 | 2.239 | 2.1895 | 2.234 | 97790000.0 |
| 2006-01-26 | CL | Stock | 27.89 | 27.9 | 27.195 | 27.305 | 6338600.0 |
| 2006-01-26 | A | Stock | 24.6352 | 24.671 | 24.0987 | 24.3991 | 3194570.0 |
| 2006-01-26 | AABA-DELISTED | Stock | 34.939998626709 | 35.25 | 34.4900016784668 | 35.1699981689453 | 28471400.0 |
| 2006-01-26 | AACC-DELISTED | Stock | 23.51 | 23.98 | 23.403 | 23.6 | 62374.0 |
| 2006-01-26 | AACQ-DELISTED | Stock | 5.34 | 5.37 | 5.34 | 5.37 | 22000.0 |
| 2006-01-26 | AACQU-DELISTED | Stock | 6.6 | 6.65 | 6.6 | 6.6 | 13000.0 |
| 2006-01-26 | AACQW-DELISTED | Stock | 0.68 | 0.68 | 0.68 | 0.68 | 2500.0 |
| 2006-01-26 | AAI-DELISTED | Stock | 15.69 | 16.09 | 15.47 | 15.9899 | 1995100.0 |
| 2006-01-26 | AAIC-DELISTED | Stock | 237.4 | 237.4 | 230.0 | 233.0 | 1309600.0 |
| 2006-01-26 | AAME | Stock | 2.65 | 2.65 | 2.65 | 2.65 | 800.0 |
| 2006-01-26 | AAON | Stock | 2.51 | 2.5481 | 2.4994 | 2.5442 | 767728.0 |
| 2006-01-26 | AAP | Stock | 42.92 | 43.53 | 42.75 | 43.52 | 495700.0 |
| 2006-01-26 | AATI-DELISTED | Stock | 14.13 | 14.24 | 13.95 | 14.01 | 122375.0 |
| 2006-01-26 | AAU-DELISTED | Stock | 3.06 | 3.06 | 2.84 | 2.95 | 231800.0 |
| 2006-01-26 | AAUAF-DELISTED | Stock | 3.06 | 3.06 | 2.84 | 2.95 | 231800.0 |
| 2006-01-26 | AAV-DELISTED | Stock | 20.74 | 20.75 | 20.27 | 20.74 | 1074100.0 |
| 2006-01-26 | AAWW-DELISTED | Stock | 44.0 | 45.5 | 44.0 | 44.5 | 82400.0 |
| 2006-01-26 | AAXN-DELISTED | Stock | 9.02000045776367 | 9.78999996185303 | 8.72000026702881 | 9.77000045776367 | 6595300.0 |
| 2006-01-26 | ABAX-DELISTED | Stock | 17.09 | 17.56 | 16.81 | 17.39 | 158335.0 |
| 2006-01-26 | ABB-DELISTED | Stock | 10.9 | 11.22 | 10.89 | 11.13 | 2321200.0 |
| 2006-01-26 | ABBC-DELISTED | Stock | 13.1 | 13.1295 | 13.1 | 13.11 | 9991.0 |
| 2006-01-26 | ABC-DELISTED | Stock | 21.5 | 21.63 | 21.48 | 21.55 | 6113200.0 |
| 2006-01-26 | ABCB | Stock | 19.9391 | 20.4158 | 19.8127 | 20.3769 | 16347.0 |
| 2006-01-26 | ABCO-DELISTED | Stock | 23.9 | 24.04 | 23.8 | 23.93 | 176762.0 |
| 2006-01-26 | ABCW-DELISTED | Stock | 31.95 | 32.78 | 31.72 | 32.78 | 59810.0 |
| 2006-01-26 | ABD-DELISTED | Stock | 24.38 | 24.59 | 24.36 | 24.49 | 548800.0 |
| 2006-01-26 | ABE-DELISTED | Stock | 12.86 | 12.89 | 12.75 | 12.87 | 15100.0 |
| 2006-01-26 | ABFS-DELISTED | Stock | 45.1 | 46.42 | 42.27 | 43.68 | 1626846.0 |
| 2006-01-26 | ABG | Stock | 17.7 | 17.72 | 17.35 | 17.69 | 42600.0 |
| 2006-01-26 | ABK-DELISTED | Stock | 75.94 | 77.25 | 75.82 | 76.71 | 601000.0 |
| 2006-01-26 | ABM | Stock | 19.29 | 19.47 | 19.01 | 19.37 | 197200.0 |
| 2006-01-26 | ABMD-DELISTED | Stock | 10.72 | 11.05 | 10.43 | 10.9 | 113796.0 |
| 2006-01-26 | ABP-DELISTED | Stock | 6.44 | 6.49 | 6.26 | 6.44 | 481600.0 |
| 2006-01-26 | ABR | Stock | 26.58 | 26.58 | 26.11 | 26.24 | 132100.0 |
| 2006-01-26 | ABT | Stock | 20.5114 | 20.9001 | 20.4875 | 20.7849 | 15737807.0 |
| 2006-01-26 | ABTL-DELISTED | Stock | 25.0 | 25.0 | 24.2 | 24.8 | 44013.0 |
| 2006-01-26 | ABV-DELISTED | Stock | 41.27 | 41.29 | 40.84 | 41.15 | 866000.0 |
| 2006-01-26 | ABVA-DELISTED | Stock | 16.51 | 16.51 | 16.5 | 16.5 | 3301.0 |
| 2006-01-26 | ABVT-DELISTED | Stock | 30.0 | 30.0 | 29.75 | 30.0 | 1600.0 |
| 2006-01-26 | ABX-DELISTED | Stock | 29.61 | 30.23 | 29.47 | 29.99 | 3138300.0 |
| 2006-01-26 | ACAD | Stock | 10.91 | 10.91 | 10.4 | 10.55 | 59500.0 |
| 2006-01-26 | ACAP-DELISTED | Stock | 47.65 | 49.4 | 47.1 | 47.79 | 49971.0 |
| 2006-01-26 | ACAS-DELISTED | Stock | 34.97 | 34.97 | 34.72 | 34.79 | 839334.0 |
| 2006-01-26 | ACAT-DELISTED | Stock | 23.3 | 23.3 | 22.7 | 22.87 | 139071.0 |
| 2006-01-26 | ACC-DELISTED | Stock | 24.72 | 25.01 | 24.67 | 24.99 | 82090.0 |
| 2006-01-26 | ACCL-DELISTED | Stock | 6.85 | 7.0 | 6.82 | 6.93 | 58625.0 |
> showing 50 of 4,348 rows — these rows as CSV