PREVIEW / stock_daily / 2005-10-07
file: by_date/stock_daily/2005/2005-10-07.parquet size: 140 KB rows: 4,185 symbols: 2,624
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-07 | AAPL | Stock | 1.8471 | 1.8546 | 1.8054 | 1.8321 | 677882800.0 |
| 2005-10-07 | MSFT | Stock | 24.77 | 24.84 | 24.52 | 24.59 | 50768700.0 |
| 2005-10-07 | NVDA | Stock | 0.2796 | 0.2824 | 0.2733 | 0.2755 | 551952000.0 |
| 2005-10-07 | AMZN | Stock | 2.2135 | 2.2305 | 2.169 | 2.186 | 67850000.0 |
| 2005-10-07 | CL | Stock | 26.225 | 26.35 | 25.99 | 26.32 | 3394600.0 |
| 2005-10-07 | A | Stock | 22.475 | 22.804 | 22.3319 | 22.7539 | 4799614.0 |
| 2005-10-07 | AABA-DELISTED | Stock | 34.0299987792969 | 34.2900009155273 | 33.9700012207031 | 34.1599998474121 | 12253200.0 |
| 2005-10-07 | AACC-DELISTED | Stock | 29.87 | 29.87 | 29.5 | 29.71 | 100006.0 |
| 2005-10-07 | AAI-DELISTED | Stock | 13.7 | 13.87 | 13.34 | 13.61 | 2955600.0 |
| 2005-10-07 | AAIC-DELISTED | Stock | 192.6 | 194.0 | 188.4 | 190.0 | 1563400.0 |
| 2005-10-07 | AAME | Stock | 2.88 | 2.88 | 2.86 | 2.86 | 200.0 |
| 2005-10-07 | AAON | Stock | 2.265 | 2.3717 | 2.265 | 2.3164 | 95681.0 |
| 2005-10-07 | AAP | Stock | 38.64 | 39.04 | 38.3 | 38.79 | 396900.0 |
| 2005-10-07 | AATI-DELISTED | Stock | 11.57 | 11.69 | 11.45 | 11.57 | 47689.0 |
| 2005-10-07 | AAV-DELISTED | Stock | 17.3 | 22.21 | 16.67 | 17.3 | 68900.0 |
| 2005-10-07 | AAXN-DELISTED | Stock | 5.55000019073486 | 5.69000005722046 | 5.38000011444092 | 5.42000007629395 | 2217700.0 |
| 2005-10-07 | ABAX-DELISTED | Stock | 13.8 | 14.0 | 13.68 | 13.8 | 113150.0 |
| 2005-10-07 | ABB-DELISTED | Stock | 7.47 | 7.49 | 7.39 | 7.43 | 324600.0 |
| 2005-10-07 | ABBC-DELISTED | Stock | 12.4701 | 12.4701 | 12.47 | 12.47 | 400.0 |
| 2005-10-07 | ABC-DELISTED | Stock | 19.12 | 19.17 | 18.84 | 18.99 | 2662800.0 |
| 2005-10-07 | ABCB | Stock | 17.9939 | 18.2371 | 17.6729 | 17.9842 | 18095.0 |
| 2005-10-07 | ABCO-DELISTED | Stock | 24.93 | 24.99 | 24.67 | 24.69 | 133034.0 |
| 2005-10-07 | ABCW-DELISTED | Stock | 29.32 | 29.53 | 29.04 | 29.25 | 34390.0 |
| 2005-10-07 | ABD-DELISTED | Stock | 27.57 | 27.68 | 27.15 | 27.51 | 151500.0 |
| 2005-10-07 | ABE-DELISTED | Stock | 10.89 | 11.02 | 10.85 | 11.0 | 25400.0 |
| 2005-10-07 | ABFS-DELISTED | Stock | 33.04 | 33.8 | 33.02 | 33.47 | 114567.0 |
| 2005-10-07 | ABG | Stock | 16.95 | 17.0 | 16.78 | 16.82 | 53300.0 |
| 2005-10-07 | ABK-DELISTED | Stock | 69.82 | 70.28 | 69.18 | 69.54 | 591300.0 |
| 2005-10-07 | ABM | Stock | 19.9 | 20.33 | 19.9 | 20.22 | 158400.0 |
| 2005-10-07 | ABMD-DELISTED | Stock | 9.68 | 9.68 | 9.5 | 9.59 | 32382.0 |
| 2005-10-07 | ABP-DELISTED | Stock | 6.8 | 7.06 | 6.65 | 7.05 | 1998000.0 |
| 2005-10-07 | ABR | Stock | 28.88 | 29.42 | 28.8 | 29.19 | 66200.0 |
| 2005-10-07 | ABT | Stock | 20.641 | 20.7226 | 20.4491 | 20.4875 | 8023968.0 |
| 2005-10-07 | ABTL-DELISTED | Stock | 24.22 | 24.32 | 23.78 | 24.22 | 33274.0 |
| 2005-10-07 | ABV-DELISTED | Stock | 35.6 | 36.82 | 35.51 | 36.79 | 503400.0 |
| 2005-10-07 | ABVA-DELISTED | Stock | 16.79 | 16.91 | 16.77 | 16.77 | 4200.0 |
| 2005-10-07 | ABVT-DELISTED | Stock | 26.05 | 26.05 | 26.05 | 26.05 | 128600.0 |
| 2005-10-07 | ABX-DELISTED | Stock | 27.8 | 28.66 | 27.78 | 28.6 | 2630300.0 |
| 2005-10-07 | ACAD | Stock | 10.51 | 11.07 | 10.51 | 10.8 | 14900.0 |
| 2005-10-07 | ACAP-DELISTED | Stock | 44.98 | 45.99 | 44.93 | 45.66 | 33478.0 |
| 2005-10-07 | ACAS-DELISTED | Stock | 36.01 | 36.46 | 36.01 | 36.44 | 395280.0 |
| 2005-10-07 | ACAT-DELISTED | Stock | 19.26 | 19.63 | 19.01 | 19.34 | 56769.0 |
| 2005-10-07 | ACC-DELISTED | Stock | 23.35 | 23.4 | 22.86 | 23.06 | 79400.0 |
| 2005-10-07 | ACCL-DELISTED | Stock | 6.49 | 6.57 | 6.3 | 6.48 | 39793.0 |
| 2005-10-07 | ACCO | Stock | 27.57 | 27.68 | 27.15 | 27.51 | 151500.0 |
| 2005-10-07 | ACE-DELISTED | Stock | 48.0 | 48.04 | 47.55 | 47.95 | 1512200.0 |
| 2005-10-07 | ACF-DELISTED | Stock | 22.5 | 22.79 | 22.4 | 22.56 | 1346000.0 |
| 2005-10-07 | ACFC-DELISTED | Stock | 70.92 | 71.38 | 70.92 | 71.07 | 604.0 |
| 2005-10-07 | ACG-DELISTED | Stock | 8.26 | 8.26 | 8.23 | 8.24 | 311000.0 |
| 2005-10-07 | ACGL | Stock | 5.2544 | 5.3556 | 5.2511 | 5.2989 | 589500.0 |
> showing 50 of 4,185 rows — these rows as CSV