PREVIEW / stock_daily / 2005-10-26
file: by_date/stock_daily/2005/2005-10-26.parquet size: 140 KB rows: 4,200 symbols: 2,637
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-10-26 | AAPL | Stock | 2.01 | 2.0557 | 1.9971 | 2.0368 | 631593200.0 |
| 2005-10-26 | MSFT | Stock | 24.97 | 25.33 | 24.93 | 25.11 | 58178100.0 |
| 2005-10-26 | NVDA | Stock | 0.2752 | 0.2758 | 0.2672 | 0.2677 | 415344000.0 |
| 2005-10-26 | AMZN | Stock | 2.05 | 2.055 | 1.974 | 1.9875 | 602094000.0 |
| 2005-10-26 | CL | Stock | 26.05 | 26.395 | 26.045 | 26.075 | 3386000.0 |
| 2005-10-26 | A | Stock | 22.2461 | 22.4893 | 22.1531 | 22.1674 | 2405119.0 |
| 2005-10-26 | AABA-DELISTED | Stock | 35.060001373291 | 35.75 | 34.9700012207031 | 35.4599990844727 | 17125600.0 |
| 2005-10-26 | AACC-DELISTED | Stock | 27.18 | 27.62 | 26.66 | 26.72 | 251642.0 |
| 2005-10-26 | AACQ-DELISTED | Stock | 5.16 | 5.16 | 5.16 | 5.16 | 500.0 |
| 2005-10-26 | AACQW-DELISTED | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 7500.0 |
| 2005-10-26 | AAI-DELISTED | Stock | 13.8 | 14.07 | 13.72 | 13.96 | 1375800.0 |
| 2005-10-26 | AAIC-DELISTED | Stock | 169.0 | 186.0 | 167.4 | 186.0 | 6624400.0 |
| 2005-10-26 | AAON | Stock | 2.2123 | 2.244 | 2.1886 | 2.2058 | 189844.0 |
| 2005-10-26 | AAP | Stock | 37.0 | 37.11 | 36.37 | 36.52 | 1282600.0 |
| 2005-10-26 | AATI-DELISTED | Stock | 12.3 | 12.31 | 12.11 | 12.3 | 47452.0 |
| 2005-10-26 | AAV-DELISTED | Stock | 17.22 | 17.49 | 17.17 | 17.22 | 41400.0 |
| 2005-10-26 | AAXN-DELISTED | Stock | 7.01999998092651 | 7.15999984741211 | 6.34000015258789 | 6.53000020980835 | 8273900.0 |
| 2005-10-26 | ABAX-DELISTED | Stock | 16.99 | 17.1 | 16.68 | 16.85 | 597725.0 |
| 2005-10-26 | ABB-DELISTED | Stock | 7.09 | 7.16 | 7.09 | 7.11 | 328800.0 |
| 2005-10-26 | ABBC-DELISTED | Stock | 12.06 | 12.2 | 12.04 | 12.04 | 1200.0 |
| 2005-10-26 | ABC-DELISTED | Stock | 18.55 | 18.6 | 18.33 | 18.36 | 4593200.0 |
| 2005-10-26 | ABCB | Stock | 18.1106 | 18.4218 | 18.1106 | 18.3537 | 8225.0 |
| 2005-10-26 | ABCO-DELISTED | Stock | 23.6 | 23.85 | 23.41 | 23.83 | 349350.0 |
| 2005-10-26 | ABCW-DELISTED | Stock | 30.9 | 31.3 | 30.44 | 30.61 | 65420.0 |
| 2005-10-26 | ABD-DELISTED | Stock | 25.08 | 25.55 | 24.82 | 24.98 | 330760.0 |
| 2005-10-26 | ABE-DELISTED | Stock | 10.85 | 10.92 | 10.85 | 10.911 | 5700.0 |
| 2005-10-26 | ABFS-DELISTED | Stock | 38.54 | 39.26 | 37.94 | 38.3 | 669879.0 |
| 2005-10-26 | ABG | Stock | 17.3 | 17.3 | 16.71 | 16.97 | 65100.0 |
| 2005-10-26 | ABK-DELISTED | Stock | 69.2 | 69.4 | 68.33 | 68.44 | 601400.0 |
| 2005-10-26 | ABM | Stock | 19.8 | 19.94 | 19.46 | 19.54 | 126400.0 |
| 2005-10-26 | ABMD-DELISTED | Stock | 8.2 | 8.28 | 8.04 | 8.13 | 62949.0 |
| 2005-10-26 | ABP-DELISTED | Stock | 6.65 | 6.78 | 6.27 | 6.35 | 721200.0 |
| 2005-10-26 | ABR | Stock | 27.74 | 27.74 | 27.3 | 27.48 | 94400.0 |
| 2005-10-26 | ABT | Stock | 20.8377 | 20.9865 | 20.617 | 20.6362 | 6744060.0 |
| 2005-10-26 | ABTL-DELISTED | Stock | 22.7 | 22.85 | 22.05 | 22.2 | 105158.0 |
| 2005-10-26 | ABV-DELISTED | Stock | 34.9 | 35.38 | 34.86 | 35.0 | 281200.0 |
| 2005-10-26 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 200.0 |
| 2005-10-26 | ABX-DELISTED | Stock | 27.17 | 27.7 | 26.19 | 26.23 | 2470102.0 |
| 2005-10-26 | ACAD | Stock | 11.27 | 11.28 | 11.04 | 11.07 | 6500.0 |
| 2005-10-26 | ACAP-DELISTED | Stock | 43.99 | 44.24 | 43.23 | 43.53 | 45676.0 |
| 2005-10-26 | ACAS-DELISTED | Stock | 36.74 | 36.94 | 36.273 | 36.72 | 546919.0 |
| 2005-10-26 | ACAT-DELISTED | Stock | 18.59 | 19.07 | 18.58 | 18.82 | 50852.0 |
| 2005-10-26 | ACC-DELISTED | Stock | 23.92 | 23.99 | 23.6 | 23.74 | 54300.0 |
| 2005-10-26 | ACCL-DELISTED | Stock | 6.73 | 7.0 | 6.65 | 6.78 | 105672.0 |
| 2005-10-26 | ACCO | Stock | 25.05 | 25.52 | 24.8 | 25.01 | 335900.0 |
| 2005-10-26 | ACE-DELISTED | Stock | 50.25 | 52.42 | 50.21 | 50.96 | 5180200.0 |
| 2005-10-26 | ACF-DELISTED | Stock | 21.95 | 22.63 | 21.7 | 21.95 | 2434900.0 |
| 2005-10-26 | ACFC-DELISTED | Stock | 70.36 | 70.36 | 68.88 | 69.44 | 530.0 |
| 2005-10-26 | ACG-DELISTED | Stock | 8.19 | 8.23 | 8.16 | 8.21 | 342000.0 |
| 2005-10-26 | ACGL | Stock | 5.43 | 5.4667 | 5.3489 | 5.3667 | 1069200.0 |
> showing 50 of 4,200 rows — these rows as CSV