PREVIEW / stock_daily / 2004-01-23
file: by_date/stock_daily/2004/2004-01-23.parquet size: 124 KB rows: 3,641 symbols: 2,274
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-23 | AAPL | Stock | 0.4004 | 0.4061 | 0.3973 | 0.4029 | 227169600.0 |
| 2004-01-23 | MSFT | Stock | 28.28 | 28.76 | 28.22 | 28.48 | 127259100.0 |
| 2004-01-23 | NVDA | Stock | 0.1958 | 0.1997 | 0.192 | 0.1924 | 482472000.0 |
| 2004-01-23 | AMZN | Stock | 2.855 | 2.8805 | 2.831 | 2.8555 | 120780000.0 |
| 2004-01-23 | CL | Stock | 25.665 | 25.8 | 25.475 | 25.495 | 3283400.0 |
| 2004-01-23 | A | Stock | 24.3133 | 24.4349 | 23.7768 | 23.9199 | 3013249.0 |
| 2004-01-23 | AABA-DELISTED | Stock | 23.6200008392334 | 23.6749992370605 | 23.375 | 23.5450000762939 | 11179400.0 |
| 2004-01-23 | AAI-DELISTED | Stock | 13.96 | 14.25 | 13.6 | 13.77 | 2013400.0 |
| 2004-01-23 | AAIC-DELISTED | Stock | 515.4 | 526.0 | 497.6 | 504.6 | 1246800.0 |
| 2004-01-23 | AAME | Stock | 2.96 | 2.96 | 2.96 | 2.96 | 500.0 |
| 2004-01-23 | AAON | Stock | 2.7351 | 2.8379 | 2.7351 | 2.8142 | 106312.0 |
| 2004-01-23 | AAP | Stock | 27.7667 | 27.9933 | 27.5667 | 27.7467 | 666750.0 |
| 2004-01-23 | AAXN-DELISTED | Stock | 10.0358333587646 | 10.0358333587646 | 9.72916698455811 | 9.96416664123535 | 3675600.0 |
| 2004-01-23 | ABAX-DELISTED | Stock | 20.02 | 20.1 | 19.47 | 20.03 | 184988.0 |
| 2004-01-23 | ABB-DELISTED | Stock | 6.04 | 6.1 | 6.0 | 6.02 | 56000.0 |
| 2004-01-23 | ABC-DELISTED | Stock | 14.0 | 14.11 | 13.875 | 14.05 | 6910400.0 |
| 2004-01-23 | ABCB | Stock | 14.6707 | 14.9139 | 14.6301 | 14.9139 | 25661.0 |
| 2004-01-23 | ABCO-DELISTED | Stock | 17.555 | 17.705 | 17.375 | 17.525 | 282899.0 |
| 2004-01-23 | ABCW-DELISTED | Stock | 25.85 | 26.25 | 25.74 | 26.25 | 180650.0 |
| 2004-01-23 | ABE-DELISTED | Stock | 8.9 | 8.96 | 8.75 | 8.8 | 47400.0 |
| 2004-01-23 | ABFS-DELISTED | Stock | 33.48 | 34.15 | 33.01 | 34.15 | 116256.0 |
| 2004-01-23 | ABG | Stock | 19.22 | 19.22 | 18.37 | 18.8 | 29400.0 |
| 2004-01-23 | ABK-DELISTED | Stock | 73.97 | 74.3 | 73.44 | 73.71 | 326100.0 |
| 2004-01-23 | ABM | Stock | 18.2 | 18.68 | 18.2 | 18.68 | 130800.0 |
| 2004-01-23 | ABMD-DELISTED | Stock | 8.41 | 8.43 | 8.07 | 8.14 | 38518.0 |
| 2004-01-23 | ABP-DELISTED | Stock | 1.69 | 1.82 | 1.68 | 1.81 | 260100.0 |
| 2004-01-23 | ABT | Stock | 19.4284 | 19.5945 | 19.2668 | 19.2893 | 9337028.0 |
| 2004-01-23 | ABTL-DELISTED | Stock | 52.75 | 57.4 | 52.75 | 57.0 | 89600.0 |
| 2004-01-23 | ABV-DELISTED | Stock | 26.8 | 27.14 | 26.35 | 26.68 | 511800.0 |
| 2004-01-23 | ABVA-DELISTED | Stock | 19.0 | 19.0 | 18.11 | 18.38 | 7605.0 |
| 2004-01-23 | ABX-DELISTED | Stock | 20.46 | 20.5 | 20.18 | 20.21 | 2762800.0 |
| 2004-01-23 | ACAP-DELISTED | Stock | 16.89 | 17.9 | 16.89 | 17.9 | 58579.0 |
| 2004-01-23 | ACAS-DELISTED | Stock | 32.45 | 33.1 | 32.24 | 32.9 | 601896.0 |
| 2004-01-23 | ACAT-DELISTED | Stock | 27.36 | 28.55 | 26.67 | 28.15 | 73905.0 |
| 2004-01-23 | ACCL-DELISTED | Stock | 14.9899997711182 | 15.0249996185303 | 14.3369998931885 | 14.6339998245239 | 218600.0 |
| 2004-01-23 | ACE-DELISTED | Stock | 43.15 | 43.27 | 42.37 | 42.63 | 974500.0 |
| 2004-01-23 | ACF-DELISTED | Stock | 19.5 | 19.83 | 18.58 | 18.67 | 2592400.0 |
| 2004-01-23 | ACG-DELISTED | Stock | 8.85 | 8.86 | 8.7 | 8.74 | 792100.0 |
| 2004-01-23 | ACGL | Stock | 4.8556 | 4.8556 | 4.8133 | 4.8456 | 1080000.0 |
| 2004-01-23 | ACGN-DELISTED | Stock | 1337.3288 | 1337.3288 | 1269.3288 | 1314.6712 | 164900.0 |
| 2004-01-23 | ACH | Stock | 15.7067 | 15.8133 | 15.34 | 15.6667 | 179400.0 |
| 2004-01-23 | ACH-DELISTED | Stock | 18.285 | 18.585 | 18.035 | 18.14 | 441952.0 |
| 2004-01-23 | ACLS | Stock | 48.8 | 49.32 | 45.92 | 47.24 | 367875.0 |
| 2004-01-23 | ACO-DELISTED | Stock | 20.47 | 21.24 | 20.45 | 21.08 | 321600.0 |
| 2004-01-23 | ACPW-DELISTED | Stock | 17.2 | 19.35 | 16.35 | 18.3 | 107224.0 |
| 2004-01-23 | ACS-DELISTED | Stock | 54.59 | 54.95 | 54.34 | 54.51 | 720300.0 |
| 2004-01-23 | ACTA-DELISTED | Stock | 10.4 | 10.8 | 9.8 | 10.2 | 6142600.0 |
| 2004-01-23 | ACTG | Stock | 6.56 | 6.79 | 6.26 | 6.44 | 132300.0 |
| 2004-01-23 | ACTI-DELISTED | Stock | 7.65 | 7.65 | 7.43 | 7.53 | 242934.0 |
| 2004-01-23 | ACTT-DELISTED | Stock | 1.86 | 2.28 | 1.86 | 2.25 | 1151223.0 |
> showing 50 of 3,641 rows — these rows as CSV