PREVIEW / stock_daily / 2005-10-21
file: by_date/stock_daily/2005/2005-10-21.parquet size: 140 KB rows: 4,178 symbols: 2,620
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-21 | AAPL | Stock | 2.03 | 2.035 | 1.9771 | 1.9879 | 796726000.0 |
| 2005-10-21 | MSFT | Stock | 24.91 | 25.0 | 24.57 | 24.78 | 69431200.0 |
| 2005-10-21 | NVDA | Stock | 0.2692 | 0.27 | 0.2643 | 0.2662 | 298368000.0 |
| 2005-10-21 | AMZN | Stock | 2.2835 | 2.3025 | 2.2575 | 2.2975 | 92496000.0 |
| 2005-10-21 | CL | Stock | 26.09 | 26.255 | 25.815 | 26.015 | 3905600.0 |
| 2005-10-21 | A | Stock | 22.103 | 22.4464 | 21.9742 | 22.2389 | 3116422.0 |
| 2005-10-21 | AABA-DELISTED | Stock | 35.9900016784668 | 36.3300018310547 | 35.189998626709 | 35.2900009155273 | 28423400.0 |
| 2005-10-21 | AACC-DELISTED | Stock | 24.75 | 25.43 | 24.67 | 25.42 | 367439.0 |
| 2005-10-21 | AACQW-DELISTED | Stock | 0.49 | 0.49 | 0.49 | 0.49 | 11000.0 |
| 2005-10-21 | AAI-DELISTED | Stock | 13.5 | 13.989 | 13.5 | 13.89 | 1260800.0 |
| 2005-10-21 | AAIC-DELISTED | Stock | 186.4 | 189.8 | 184.0 | 185.0 | 1599700.0 |
| 2005-10-21 | AAME | Stock | 2.67 | 2.68 | 2.52 | 2.55 | 2800.0 |
| 2005-10-21 | AAON | Stock | 2.1913 | 2.244 | 2.1623 | 2.215 | 212625.0 |
| 2005-10-21 | AAP | Stock | 37.49 | 37.49 | 35.81 | 35.93 | 1900900.0 |
| 2005-10-21 | AATI-DELISTED | Stock | 11.42 | 11.86 | 11.26 | 11.82 | 307105.0 |
| 2005-10-21 | AAV-DELISTED | Stock | 16.28 | 16.48 | 15.65 | 16.28 | 59200.0 |
| 2005-10-21 | AAXN-DELISTED | Stock | 5.61999988555908 | 5.65000009536743 | 5.44000005722046 | 5.46000003814697 | 1650400.0 |
| 2005-10-21 | ABAX-DELISTED | Stock | 14.02 | 14.14 | 13.85 | 14.1 | 59594.0 |
| 2005-10-21 | ABB-DELISTED | Stock | 6.99 | 7.01 | 6.92 | 6.96 | 301700.0 |
| 2005-10-21 | ABBC-DELISTED | Stock | 11.94 | 11.97 | 11.9 | 11.9 | 4600.0 |
| 2005-10-21 | ABC-DELISTED | Stock | 18.79 | 18.89 | 18.58 | 18.76 | 3781200.0 |
| 2005-10-21 | ABCB | Stock | 17.4103 | 17.8285 | 17.4103 | 17.6729 | 17170.0 |
| 2005-10-21 | ABCO-DELISTED | Stock | 24.13 | 24.74 | 23.95 | 24.12 | 82055.0 |
| 2005-10-21 | ABCW-DELISTED | Stock | 30.2 | 30.96 | 30.12 | 30.59 | 38090.0 |
| 2005-10-21 | ABD-DELISTED | Stock | 24.18 | 24.18 | 23.89 | 23.94 | 192300.0 |
| 2005-10-21 | ABE-DELISTED | Stock | 10.57 | 10.72 | 10.55 | 10.72 | 8800.0 |
| 2005-10-21 | ABFS-DELISTED | Stock | 33.23 | 34.21 | 32.78 | 33.54 | 298097.0 |
| 2005-10-21 | ABG | Stock | 16.56 | 16.74 | 16.26 | 16.61 | 53700.0 |
| 2005-10-21 | ABK-DELISTED | Stock | 69.05 | 69.22 | 68.01 | 68.5 | 653200.0 |
| 2005-10-21 | ABM | Stock | 19.71 | 20.03 | 19.54 | 19.6 | 93800.0 |
| 2005-10-21 | ABMD-DELISTED | Stock | 8.5 | 8.55 | 8.44 | 8.5 | 65706.0 |
| 2005-10-21 | ABP-DELISTED | Stock | 6.5 | 6.56 | 6.1 | 6.52 | 990600.0 |
| 2005-10-21 | ABR | Stock | 26.86 | 27.7 | 26.86 | 27.5 | 106800.0 |
| 2005-10-21 | ABT | Stock | 20.8521 | 20.8569 | 20.4059 | 20.5114 | 12781367.0 |
| 2005-10-21 | ABTL-DELISTED | Stock | 22.7 | 23.3 | 22.5 | 22.75 | 17076.0 |
| 2005-10-21 | ABV-DELISTED | Stock | 33.36 | 34.68 | 33.36 | 34.67 | 842300.0 |
| 2005-10-21 | ABVA-DELISTED | Stock | 16.6 | 16.85 | 16.5 | 16.77 | 15041.0 |
| 2005-10-21 | ABX-DELISTED | Stock | 25.5 | 26.55 | 25.45 | 26.34 | 2624200.0 |
| 2005-10-21 | ACAD | Stock | 11.22 | 11.35 | 11.06 | 11.16 | 29100.0 |
| 2005-10-21 | ACAP-DELISTED | Stock | 45.08 | 45.58 | 44.75 | 45.11 | 64942.0 |
| 2005-10-21 | ACAS-DELISTED | Stock | 36.66 | 36.86 | 36.41 | 36.63 | 431568.0 |
| 2005-10-21 | ACAT-DELISTED | Stock | 19.06 | 19.1402 | 18.4 | 18.4 | 89114.0 |
| 2005-10-21 | ACC-DELISTED | Stock | 23.25 | 23.73 | 23.05 | 23.33 | 169600.0 |
| 2005-10-21 | ACCL-DELISTED | Stock | 6.6 | 6.67 | 6.44 | 6.6699 | 47556.0 |
| 2005-10-21 | ACCO | Stock | 24.18 | 24.18 | 23.89 | 23.94 | 192400.0 |
| 2005-10-21 | ACE-DELISTED | Stock | 49.9 | 50.98 | 49.64 | 50.16 | 4178300.0 |
| 2005-10-21 | ACF-DELISTED | Stock | 22.59 | 23.55 | 22.52 | 23.34 | 1755300.0 |
| 2005-10-21 | ACFC-DELISTED | Stock | 69.9 | 70.2 | 69.74 | 69.74 | 375.0 |
| 2005-10-21 | ACG-DELISTED | Stock | 8.24 | 8.24 | 8.15 | 8.16 | 287100.0 |
| 2005-10-21 | ACGL | Stock | 5.2311 | 5.3522 | 5.2178 | 5.3311 | 712800.0 |
> showing 50 of 4,178 rows — these rows as CSV