PREVIEW / stock_daily / 2005-09-07
file: by_date/stock_daily/2005/2005-09-07.parquet size: 140 KB rows: 4,186 symbols: 2,632
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-09-07 | AAPL | Stock | 1.7518 | 1.7643 | 1.7114 | 1.7386 | 963074000.0 |
| 2005-09-07 | MSFT | Stock | 26.94 | 27.11 | 26.82 | 26.85 | 44656100.0 |
| 2005-09-07 | NVDA | Stock | 0.2533 | 0.2624 | 0.2527 | 0.2617 | 588012000.0 |
| 2005-09-07 | AMZN | Stock | 2.175 | 2.215 | 2.1725 | 2.1865 | 122830000.0 |
| 2005-09-07 | CL | Stock | 26.8 | 27.15 | 26.78 | 27.03 | 5519800.0 |
| 2005-09-07 | A | Stock | 23.0901 | 23.3262 | 23.0901 | 23.2403 | 4619691.0 |
| 2005-09-07 | AABA-DELISTED | Stock | 33.5 | 34.2599983215332 | 33.2999992370605 | 34.060001373291 | 12545300.0 |
| 2005-09-07 | AACC-DELISTED | Stock | 29.87 | 30.69 | 29.23 | 29.75 | 183044.0 |
| 2005-09-07 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 8000.0 |
| 2005-09-07 | AACQW-DELISTED | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 8000.0 |
| 2005-09-07 | AAI-DELISTED | Stock | 10.35 | 10.4 | 10.14 | 10.36 | 888400.0 |
| 2005-09-07 | AAIC-DELISTED | Stock | 242.8 | 242.8 | 236.42 | 237.2 | 1203900.0 |
| 2005-09-07 | AAME | Stock | 2.76 | 2.81 | 2.75 | 2.8 | 6600.0 |
| 2005-09-07 | AAON | Stock | 2.3453 | 2.3704 | 2.3309 | 2.3559 | 73659.0 |
| 2005-09-07 | AAP | Stock | 40.1667 | 40.94 | 39.9067 | 40.72 | 1556250.0 |
| 2005-09-07 | AATI-DELISTED | Stock | 12.95 | 13.29 | 12.95 | 13.21 | 116119.0 |
| 2005-09-07 | AAV-DELISTED | Stock | 16.86 | 16.89 | 16.57 | 16.86 | 47400.0 |
| 2005-09-07 | AAXN-DELISTED | Stock | 8.35000038146973 | 8.36999988555908 | 8.30000019073486 | 8.35000038146973 | 923600.0 |
| 2005-09-07 | ABAX-DELISTED | Stock | 12.18 | 12.39 | 12.1 | 12.27 | 143497.0 |
| 2005-09-07 | ABB-DELISTED | Stock | 7.58 | 7.6 | 7.53 | 7.55 | 950700.0 |
| 2005-09-07 | ABBC-DELISTED | Stock | 12.78 | 12.8 | 12.72 | 12.72 | 3687.0 |
| 2005-09-07 | ABC-DELISTED | Stock | 18.55 | 18.77 | 18.49 | 18.75 | 4201200.0 |
| 2005-09-07 | ABCB | Stock | 19.4042 | 19.4334 | 19.2486 | 19.3555 | 24778.0 |
| 2005-09-07 | ABCO-DELISTED | Stock | 26.19 | 26.43 | 25.95 | 26.39 | 107193.0 |
| 2005-09-07 | ABCW-DELISTED | Stock | 31.01 | 31.34 | 30.82 | 31.13 | 19480.0 |
| 2005-09-07 | ABD-DELISTED | Stock | 25.52 | 25.74 | 25.2 | 25.5 | 319810.0 |
| 2005-09-07 | ABE-DELISTED | Stock | 10.73 | 10.9 | 10.73 | 10.82 | 28700.0 |
| 2005-09-07 | ABFS-DELISTED | Stock | 34.99 | 35.04 | 34.49 | 34.92 | 143486.0 |
| 2005-09-07 | ABG | Stock | 16.68 | 16.87 | 16.52 | 16.87 | 78300.0 |
| 2005-09-07 | ABK-DELISTED | Stock | 67.0 | 67.19 | 66.97 | 67.07 | 816600.0 |
| 2005-09-07 | ABM | Stock | 20.0 | 20.2 | 19.74 | 20.19 | 69500.0 |
| 2005-09-07 | ABMD-DELISTED | Stock | 10.26 | 10.54 | 10.1 | 10.44 | 69071.0 |
| 2005-09-07 | ABP-DELISTED | Stock | 4.33 | 4.43 | 4.3 | 4.34 | 179200.0 |
| 2005-09-07 | ABR | Stock | 28.64 | 28.89 | 28.55 | 28.64 | 171000.0 |
| 2005-09-07 | ABT | Stock | 21.7349 | 22.018 | 21.6918 | 21.9173 | 5962276.0 |
| 2005-09-07 | ABTL-DELISTED | Stock | 25.75 | 26.05 | 25.0 | 25.75 | 57514.0 |
| 2005-09-07 | ABV-DELISTED | Stock | 34.55 | 34.71 | 34.11 | 34.67 | 169100.0 |
| 2005-09-07 | ABVA-DELISTED | Stock | 16.25 | 16.25 | 16.2 | 16.2 | 1200.0 |
| 2005-09-07 | ABVT-DELISTED | Stock | 28.0 | 28.0 | 28.0 | 28.0 | 12700.0 |
| 2005-09-07 | ABX-DELISTED | Stock | 27.08 | 27.52 | 27.08 | 27.21 | 1543900.0 |
| 2005-09-07 | ACAD | Stock | 10.18 | 10.36 | 10.04 | 10.35 | 39700.0 |
| 2005-09-07 | ACAP-DELISTED | Stock | 44.48 | 45.1 | 44.3 | 45.05 | 26634.0 |
| 2005-09-07 | ACAS-DELISTED | Stock | 37.78 | 37.85 | 37.4 | 37.67 | 405576.0 |
| 2005-09-07 | ACAT-DELISTED | Stock | 21.92 | 21.93 | 20.85 | 21.38 | 114510.0 |
| 2005-09-07 | ACC-DELISTED | Stock | 23.97 | 23.97 | 23.53 | 23.63 | 49531.0 |
| 2005-09-07 | ACCL-DELISTED | Stock | 5.57 | 5.58 | 5.37 | 5.46 | 44340.0 |
| 2005-09-07 | ACCO | Stock | 25.6 | 25.82 | 25.28 | 25.42 | 320900.0 |
| 2005-09-07 | ACE-DELISTED | Stock | 45.1 | 45.35 | 44.88 | 45.09 | 756000.0 |
| 2005-09-07 | ACF-DELISTED | Stock | 24.8 | 25.26 | 24.8 | 25.13 | 946400.0 |
| 2005-09-07 | ACFC-DELISTED | Stock | 73.11 | 73.47 | 72.5 | 72.55 | 4760.0 |
> showing 50 of 4,186 rows — these rows as CSV