PREVIEW / stock_daily / 2004-01-05
file: by_date/stock_daily/2004/2004-01-05.parquet size: 124 KB rows: 3,627 symbols: 2,260
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-01-05 | AAPL | Stock | 0.3825 | 0.3998 | 0.3825 | 0.3959 | 395018400.0 |
| 2004-01-05 | MSFT | Stock | 27.73 | 28.18 | 27.72 | 28.14 | 67333700.0 |
| 2004-01-05 | NVDA | Stock | 0.1952 | 0.1999 | 0.1935 | 0.1986 | 575292000.0 |
| 2004-01-05 | AMZN | Stock | 2.6 | 2.68 | 2.5685 | 2.6635 | 225682000.0 |
| 2004-01-05 | CL | Stock | 24.91 | 25.04 | 24.825 | 25.025 | 10084600.0 |
| 2004-01-05 | A | Stock | 21.1016 | 21.1445 | 20.8941 | 21.1373 | 5234531.0 |
| 2004-01-05 | AABA-DELISTED | Stock | 22.8799991607666 | 23.5550003051758 | 22.6749992370605 | 23.4500007629395 | 23107800.0 |
| 2004-01-05 | AAI-DELISTED | Stock | 12.4 | 12.61 | 12.31 | 12.37 | 2186200.0 |
| 2004-01-05 | AAIC-DELISTED | Stock | 460.0 | 476.0 | 460.0 | 473.6 | 948400.0 |
| 2004-01-05 | AAME | Stock | 3.14 | 3.3 | 3.03 | 3.14 | 7900.0 |
| 2004-01-05 | AAON | Stock | 2.4626 | 2.5297 | 2.4626 | 2.5047 | 83531.0 |
| 2004-01-05 | AAP | Stock | 27.2 | 27.3933 | 26.6867 | 26.8933 | 867900.0 |
| 2004-01-05 | AAXN-DELISTED | Stock | 7.20666646957397 | 7.23750019073486 | 6.98416662216187 | 7.07499980926514 | 2720400.0 |
| 2004-01-05 | ABAX-DELISTED | Stock | 16.32 | 16.7 | 14.93 | 15.59 | 1289583.0 |
| 2004-01-05 | ABB-DELISTED | Stock | 5.12 | 5.16 | 5.1 | 5.16 | 131000.0 |
| 2004-01-05 | ABC-DELISTED | Stock | 13.5 | 14.0 | 13.5 | 13.92 | 21852800.0 |
| 2004-01-05 | ABCB | Stock | 13.4792 | 13.4873 | 12.9442 | 13.4225 | 7526.0 |
| 2004-01-05 | ABCO-DELISTED | Stock | 17.49 | 17.49 | 17.18 | 17.4 | 290653.0 |
| 2004-01-05 | ABCW-DELISTED | Stock | 25.03 | 25.28 | 25.03 | 25.08 | 99340.0 |
| 2004-01-05 | ABE-DELISTED | Stock | 7.52 | 7.83 | 7.52 | 7.8 | 68100.0 |
| 2004-01-05 | ABFS-DELISTED | Stock | 31.78 | 32.39 | 31.52 | 32.06 | 155343.0 |
| 2004-01-05 | ABG | Stock | 18.3 | 18.44 | 18.1 | 18.44 | 44200.0 |
| 2004-01-05 | ABK-DELISTED | Stock | 69.9 | 70.41 | 69.83 | 70.23 | 435700.0 |
| 2004-01-05 | ABM | Stock | 17.3 | 17.88 | 17.21 | 17.78 | 176400.0 |
| 2004-01-05 | ABMD-DELISTED | Stock | 7.0 | 7.0 | 6.71 | 6.91 | 76763.0 |
| 2004-01-05 | ABP-DELISTED | Stock | 1.54 | 1.65 | 1.52 | 1.64 | 585500.0 |
| 2004-01-05 | ABT | Stock | 21.1432 | 21.2106 | 20.7392 | 20.9861 | 14395828.0 |
| 2004-01-05 | ABTL-DELISTED | Stock | 45.5 | 47.5 | 45.3 | 46.6 | 68900.0 |
| 2004-01-05 | ABV-DELISTED | Stock | 26.25 | 26.95 | 26.25 | 26.67 | 399900.0 |
| 2004-01-05 | ABVA-DELISTED | Stock | 18.61 | 19.05 | 18.61 | 18.97 | 1873.0 |
| 2004-01-05 | ABX-DELISTED | Stock | 23.48 | 23.73 | 23.33 | 23.37 | 2926173.0 |
| 2004-01-05 | ACAP-DELISTED | Stock | 17.94 | 18.48 | 17.82 | 17.91 | 30194.0 |
| 2004-01-05 | ACAS-DELISTED | Stock | 29.53 | 29.619 | 29.35 | 29.43 | 376346.0 |
| 2004-01-05 | ACAT-DELISTED | Stock | 26.609 | 26.69 | 25.25 | 25.92 | 26691.0 |
| 2004-01-05 | ACCL-DELISTED | Stock | 11.3999996185303 | 12.1510000228882 | 11.3760004043579 | 11.9479999542236 | 360700.0 |
| 2004-01-05 | ACE-DELISTED | Stock | 41.28 | 41.62 | 41.03 | 41.47 | 905737.0 |
| 2004-01-05 | ACF-DELISTED | Stock | 15.97 | 16.1 | 15.91 | 16.05 | 1191000.0 |
| 2004-01-05 | ACG-DELISTED | Stock | 8.61 | 8.62 | 8.58 | 8.59 | 697000.0 |
| 2004-01-05 | ACGL | Stock | 4.4967 | 4.5156 | 4.4356 | 4.4556 | 972900.0 |
| 2004-01-05 | ACGN-DELISTED | Stock | 1280.6712 | 1280.6712 | 1190.0 | 1201.3288 | 79800.0 |
| 2004-01-05 | ACH | Stock | 15.0 | 15.2333 | 14.96 | 15.1933 | 320700.0 |
| 2004-01-05 | ACH-DELISTED | Stock | 20.07 | 20.48 | 19.412 | 19.92 | 1302835.0 |
| 2004-01-05 | ACLS | Stock | 41.04 | 42.52 | 40.96 | 42.08 | 223225.0 |
| 2004-01-05 | ACO-DELISTED | Stock | 22.69 | 23.08 | 22.05 | 23.06 | 635500.0 |
| 2004-01-05 | ACPW-DELISTED | Stock | 14.3 | 15.4 | 14.3 | 15.35 | 41554.0 |
| 2004-01-05 | ACS-DELISTED | Stock | 56.0 | 57.24 | 55.85 | 56.82 | 1703600.0 |
| 2004-01-05 | ACTA-DELISTED | Stock | 7.2 | 7.4 | 6.8 | 7.2 | 1173100.0 |
| 2004-01-05 | ACTG | Stock | 5.5 | 5.6 | 5.24 | 5.37 | 45800.0 |
| 2004-01-05 | ACTI-DELISTED | Stock | 7.9 | 7.95 | 7.76 | 7.76 | 273987.0 |
| 2004-01-05 | ACTT-DELISTED | Stock | 1.2 | 1.27 | 1.2 | 1.22 | 85501.0 |
> showing 50 of 3,627 rows — these rows as CSV