PREVIEW / stock_daily / 2004-10-28
file: by_date/stock_daily/2004/2004-10-28.parquet size: 129 KB rows: 3,845 symbols: 2,400
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-28 | AAPL | Stock | 0.8925 | 0.9325 | 0.8839 | 0.932 | 864264800.0 |
| 2004-10-28 | MSFT | Stock | 28.11 | 28.54 | 27.9 | 28.01 | 63059600.0 |
| 2004-10-28 | NVDA | Stock | 0.1224 | 0.125 | 0.1216 | 0.1227 | 561552000.0 |
| 2004-10-28 | AMZN | Stock | 1.712 | 1.7385 | 1.707 | 1.7225 | 144412000.0 |
| 2004-10-28 | CL | Stock | 22.835 | 22.885 | 22.465 | 22.475 | 7929600.0 |
| 2004-10-28 | A | Stock | 17.8684 | 18.1044 | 17.6395 | 17.7396 | 2952576.0 |
| 2004-10-28 | AABA-DELISTED | Stock | 35.8199996948242 | 36.5 | 35.8199996948242 | 36.4500007629395 | 13245200.0 |
| 2004-10-28 | AACC-DELISTED | Stock | 19.2 | 19.45 | 17.98 | 18.29 | 55057.0 |
| 2004-10-28 | AAI-DELISTED | Stock | 11.69 | 11.9 | 11.44 | 11.67 | 1783000.0 |
| 2004-10-28 | AAIC-DELISTED | Stock | 365.0 | 365.0 | 351.0 | 352.0 | 1786800.0 |
| 2004-10-28 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 11400.0 |
| 2004-10-28 | AAON | Stock | 1.9898 | 2.0385 | 1.9437 | 1.9542 | 179972.0 |
| 2004-10-28 | AAP | Stock | 26.0533 | 26.3333 | 25.9533 | 26.2133 | 606300.0 |
| 2004-10-28 | AAV-DELISTED | Stock | 16.9 | 17.35 | 16.75 | 16.9 | 30100.0 |
| 2004-10-28 | AAXN-DELISTED | Stock | 21.2649993896484 | 21.3299999237061 | 20.0049991607666 | 20.1749992370605 | 9464000.0 |
| 2004-10-28 | ABAX-DELISTED | Stock | 12.9 | 13.14 | 12.75 | 13.0 | 43907.0 |
| 2004-10-28 | ABB-DELISTED | Stock | 5.78 | 5.82 | 5.62 | 5.7 | 1952400.0 |
| 2004-10-28 | ABC-DELISTED | Stock | 13.8 | 13.83 | 13.7 | 13.74 | 4924800.0 |
| 2004-10-28 | ABCB | Stock | 16.7943 | 17.1266 | 16.4133 | 16.8996 | 21098.0 |
| 2004-10-28 | ABCO-DELISTED | Stock | 15.745 | 15.985 | 15.504 | 15.825 | 164176.0 |
| 2004-10-28 | ABCW-DELISTED | Stock | 26.21 | 26.38 | 25.92 | 26.2 | 23260.0 |
| 2004-10-28 | ABE-DELISTED | Stock | 8.44 | 8.5 | 8.44 | 8.47 | 16000.0 |
| 2004-10-28 | ABFS-DELISTED | Stock | 38.94 | 38.97 | 38.34 | 38.88 | 141097.0 |
| 2004-10-28 | ABG | Stock | 13.7 | 14.27 | 13.61 | 13.77 | 43200.0 |
| 2004-10-28 | ABK-DELISTED | Stock | 77.4 | 78.48 | 77.36 | 77.87 | 332100.0 |
| 2004-10-28 | ABM | Stock | 20.77 | 20.89 | 20.43 | 20.67 | 86600.0 |
| 2004-10-28 | ABMD-DELISTED | Stock | 11.79 | 11.79 | 11.42 | 11.51 | 85647.0 |
| 2004-10-28 | ABP-DELISTED | Stock | 2.65 | 2.7 | 2.5 | 2.6 | 207100.0 |
| 2004-10-28 | ABR | Stock | 20.95 | 21.0 | 20.8 | 20.85 | 59800.0 |
| 2004-10-28 | ABT | Stock | 20.2716 | 20.5114 | 20.2284 | 20.4923 | 6074406.0 |
| 2004-10-28 | ABTL-DELISTED | Stock | 34.85 | 35.25 | 32.95 | 33.25 | 104500.0 |
| 2004-10-28 | ABV-DELISTED | Stock | 23.81 | 24.39 | 23.79 | 24.32 | 195800.0 |
| 2004-10-28 | ABVA-DELISTED | Stock | 14.71 | 15.09 | 14.71 | 14.97 | 4941.0 |
| 2004-10-28 | ABVT-DELISTED | Stock | 24.0 | 25.0 | 24.0 | 25.0 | 4300.0 |
| 2004-10-28 | ABX-DELISTED | Stock | 22.05 | 22.44 | 21.97 | 22.03 | 1506016.0 |
| 2004-10-28 | ACAD | Stock | 7.64 | 7.64 | 7.2 | 7.63 | 17900.0 |
| 2004-10-28 | ACAP-DELISTED | Stock | 32.5 | 32.6 | 31.96 | 32.5 | 55383.0 |
| 2004-10-28 | ACAS-DELISTED | Stock | 30.69 | 31.08 | 30.52 | 30.85 | 648231.0 |
| 2004-10-28 | ACAT-DELISTED | Stock | 24.43 | 24.76 | 24.42 | 24.76 | 51389.0 |
| 2004-10-28 | ACC-DELISTED | Stock | 19.01 | 19.1 | 18.94 | 18.95 | 168200.0 |
| 2004-10-28 | ACCL-DELISTED | Stock | 6.21 | 6.3 | 6.06 | 6.14 | 62761.0 |
| 2004-10-28 | ACE-DELISTED | Stock | 37.1 | 38.15 | 36.89 | 38.0 | 1860200.0 |
| 2004-10-28 | ACF-DELISTED | Stock | 19.28 | 19.54 | 18.95 | 19.15 | 1072400.0 |
| 2004-10-28 | ACFC-DELISTED | Stock | 64.8 | 65.31 | 64.69 | 64.8 | 5941.0 |
| 2004-10-28 | ACG-DELISTED | Stock | 8.16 | 8.18 | 8.15 | 8.17 | 275300.0 |
| 2004-10-28 | ACGL | Stock | 4.1222 | 4.1833 | 4.0978 | 4.1833 | 822600.0 |
| 2004-10-28 | ACGN-DELISTED | Stock | 634.6712 | 634.6712 | 600.6712 | 623.3288 | 41000.0 |
| 2004-10-28 | ACH | Stock | 17.88 | 17.88 | 17.3667 | 17.5933 | 189600.0 |
| 2004-10-28 | ACH-DELISTED | Stock | 14.751 | 14.753 | 14.151 | 14.291 | 2181513.0 |
| 2004-10-28 | ACLS | Stock | 33.32 | 34.68 | 33.32 | 34.4 | 281750.0 |
> showing 50 of 3,845 rows — these rows as CSV