PREVIEW / stock_daily / 2005-12-27
file: by_date/stock_daily/2005/2005-12-27.parquet size: 145 KB rows: 4,340 symbols: 2,753
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-27 | AAPL | Stock | 2.6429 | 2.685 | 2.6411 | 2.6511 | 590590000.0 |
| 2005-12-27 | MSFT | Stock | 26.68 | 26.85 | 26.45 | 26.46 | 37819000.0 |
| 2005-12-27 | NVDA | Stock | 0.3125 | 0.3182 | 0.3115 | 0.3147 | 367968000.0 |
| 2005-12-27 | AMZN | Stock | 2.445 | 2.455 | 2.418 | 2.428 | 116374000.0 |
| 2005-12-27 | CL | Stock | 27.73 | 27.77 | 27.485 | 27.515 | 1972200.0 |
| 2005-12-27 | A | Stock | 24.8927 | 24.9285 | 24.2775 | 24.3062 | 2991021.0 |
| 2005-12-27 | AABA-DELISTED | Stock | 40.6500015258789 | 40.939998626709 | 39.8499984741211 | 39.939998626709 | 11672900.0 |
| 2005-12-27 | AACC-DELISTED | Stock | 22.35 | 22.5 | 21.9 | 22.38 | 96967.0 |
| 2005-12-27 | AACQ-DELISTED | Stock | 5.2 | 5.23 | 5.2 | 5.23 | 13700.0 |
| 2005-12-27 | AACQW-DELISTED | Stock | 0.52 | 0.54 | 0.52 | 0.54 | 6000.0 |
| 2005-12-27 | AAI-DELISTED | Stock | 15.58 | 16.04 | 15.5 | 15.61 | 2151800.0 |
| 2005-12-27 | AAIC-DELISTED | Stock | 216.2 | 217.8 | 212.2 | 216.0 | 1224700.0 |
| 2005-12-27 | AAON | Stock | 2.3717 | 2.3928 | 2.3559 | 2.3677 | 49359.0 |
| 2005-12-27 | AAP | Stock | 43.17 | 43.58 | 42.42 | 42.45 | 352200.0 |
| 2005-12-27 | AATI-DELISTED | Stock | 14.25 | 14.5 | 14.2 | 14.24 | 40514.0 |
| 2005-12-27 | AAU-DELISTED | Stock | 2.0 | 2.27 | 2.0 | 2.24 | 95500.0 |
| 2005-12-27 | AAUAF-DELISTED | Stock | 2.0 | 2.27 | 2.0 | 2.24 | 95500.0 |
| 2005-12-27 | AAV-DELISTED | Stock | 19.54 | 19.59 | 18.95 | 19.04 | 226300.0 |
| 2005-12-27 | AAWW-DELISTED | Stock | 43.75 | 44.5 | 43.75 | 43.85 | 1000.0 |
| 2005-12-27 | AAXN-DELISTED | Stock | 7.80999994277954 | 7.98000001907349 | 7.26000022888184 | 7.30999994277954 | 3593800.0 |
| 2005-12-27 | ABAX-DELISTED | Stock | 16.89 | 17.0 | 16.69 | 16.78 | 68213.0 |
| 2005-12-27 | ABB-DELISTED | Stock | 9.46 | 9.53 | 9.45 | 9.48 | 1889600.0 |
| 2005-12-27 | ABBC-DELISTED | Stock | 13.19 | 13.19 | 13.028 | 13.1 | 3653.0 |
| 2005-12-27 | ABC-DELISTED | Stock | 20.39 | 20.51 | 20.3 | 20.43 | 2075200.0 |
| 2005-12-27 | ABCB | Stock | 19.7057 | 19.9197 | 19.696 | 19.8614 | 20254.0 |
| 2005-12-27 | ABCO-DELISTED | Stock | 24.31 | 24.62 | 23.92 | 24.0 | 76153.0 |
| 2005-12-27 | ABCW-DELISTED | Stock | 30.96 | 30.98 | 30.68 | 30.72 | 115300.0 |
| 2005-12-27 | ABD-DELISTED | Stock | 23.46 | 23.95 | 23.41 | 23.89 | 178900.0 |
| 2005-12-27 | ABE-DELISTED | Stock | 11.94 | 11.94 | 11.6701 | 11.9 | 17400.0 |
| 2005-12-27 | ABFS-DELISTED | Stock | 45.45 | 45.63 | 43.811 | 44.09 | 289193.0 |
| 2005-12-27 | ABG | Stock | 17.38 | 17.38 | 16.65 | 16.65 | 29000.0 |
| 2005-12-27 | ABK-DELISTED | Stock | 78.75 | 79.2 | 78.08 | 78.22 | 344100.0 |
| 2005-12-27 | ABM | Stock | 19.94 | 20.18 | 19.71 | 19.75 | 257600.0 |
| 2005-12-27 | ABMD-DELISTED | Stock | 9.35 | 9.54 | 9.35 | 9.5 | 86215.0 |
| 2005-12-27 | ABP-DELISTED | Stock | 5.71 | 5.73 | 5.4 | 5.41 | 822100.0 |
| 2005-12-27 | ABR | Stock | 26.45 | 26.51 | 25.6 | 25.87 | 60700.0 |
| 2005-12-27 | ABT | Stock | 19.6718 | 19.7438 | 19.3647 | 19.3839 | 8610463.0 |
| 2005-12-27 | ABTL-DELISTED | Stock | 24.72 | 24.72 | 24.13 | 24.23 | 28079.0 |
| 2005-12-27 | ABV-DELISTED | Stock | 38.0 | 38.65 | 37.71 | 38.2 | 642200.0 |
| 2005-12-27 | ABVA-DELISTED | Stock | 16.46 | 16.46 | 16.0 | 16.01 | 3124.0 |
| 2005-12-27 | ABX-DELISTED | Stock | 27.7 | 27.7 | 27.21 | 27.33 | 3118500.0 |
| 2005-12-27 | ACAD | Stock | 10.05 | 10.05 | 9.61 | 9.71 | 40000.0 |
| 2005-12-27 | ACAP-DELISTED | Stock | 46.61 | 47.24 | 45.72 | 45.72 | 57340.0 |
| 2005-12-27 | ACAS-DELISTED | Stock | 36.81 | 37.0 | 36.51 | 36.59 | 479348.0 |
| 2005-12-27 | ACAT-DELISTED | Stock | 20.03 | 20.25 | 19.885 | 19.995 | 66843.0 |
| 2005-12-27 | ACC-DELISTED | Stock | 24.98 | 25.04 | 24.74 | 24.82 | 54062.0 |
| 2005-12-27 | ACCL-DELISTED | Stock | 7.55 | 7.77 | 7.5 | 7.65 | 84532.0 |
| 2005-12-27 | ACCO | Stock | 23.46 | 23.95 | 23.41 | 23.89 | 183900.0 |
| 2005-12-27 | ACE-DELISTED | Stock | 54.0 | 54.59 | 53.36 | 53.47 | 489700.0 |
| 2005-12-27 | ACF-DELISTED | Stock | 25.87 | 25.99 | 25.3 | 25.37 | 780900.0 |
> showing 50 of 4,340 rows — these rows as CSV