PREVIEW / stock_daily / 2004-07-23
file: by_date/stock_daily/2004/2004-07-23.parquet size: 126 KB rows: 3,757 symbols: 2,341
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-07-23 | AAPL | Stock | 0.563 | 0.567 | 0.5443 | 0.5482 | 273571200.0 |
| 2004-07-23 | MSFT | Stock | 28.38 | 28.4 | 28.02 | 28.03 | 97372700.0 |
| 2004-07-23 | NVDA | Stock | 0.126 | 0.1262 | 0.121 | 0.1218 | 371496000.0 |
| 2004-07-23 | AMZN | Stock | 2.1235 | 2.138 | 1.978 | 1.999 | 718544000.0 |
| 2004-07-23 | CL | Stock | 26.825 | 26.945 | 26.15 | 26.32 | 5978600.0 |
| 2004-07-23 | A | Stock | 17.6323 | 17.6323 | 16.8526 | 16.8526 | 5388731.0 |
| 2004-07-23 | AABA-DELISTED | Stock | 28.2000007629395 | 28.9699993133545 | 28.0300006866455 | 28.1900005340576 | 15762300.0 |
| 2004-07-23 | AACC-DELISTED | Stock | 17.01 | 17.01 | 16.39 | 16.41 | 47642.0 |
| 2004-07-23 | AAI-DELISTED | Stock | 11.86 | 12.04 | 11.57 | 11.65 | 664600.0 |
| 2004-07-23 | AAIC-DELISTED | Stock | 336.0 | 339.8 | 330.2 | 333.4 | 936400.0 |
| 2004-07-23 | AAME | Stock | 2.86 | 2.86 | 2.66 | 2.8 | 5500.0 |
| 2004-07-23 | AAON | Stock | 2.3704 | 2.4138 | 2.3691 | 2.3704 | 110109.0 |
| 2004-07-23 | AAP | Stock | 24.28 | 24.42 | 24.14 | 24.14 | 1085100.0 |
| 2004-07-23 | AAV-DELISTED | Stock | 14.73 | 14.82 | 14.7 | 14.73 | 8600.0 |
| 2004-07-23 | AAXN-DELISTED | Stock | 15.0749998092651 | 15.2200002670288 | 14.4849996566772 | 14.7600002288818 | 9317800.0 |
| 2004-07-23 | ABAX-DELISTED | Stock | 15.1 | 15.1 | 14.68 | 14.9 | 557377.0 |
| 2004-07-23 | ABB-DELISTED | Stock | 5.06 | 5.07 | 4.95 | 4.98 | 391100.0 |
| 2004-07-23 | ABC-DELISTED | Stock | 13.67 | 13.86 | 13.66 | 13.85 | 5062000.0 |
| 2004-07-23 | ABCB | Stock | 14.1925 | 14.4438 | 14.1763 | 14.1844 | 13078.0 |
| 2004-07-23 | ABCO-DELISTED | Stock | 15.648 | 15.648 | 15.287 | 15.397 | 128700.0 |
| 2004-07-23 | ABCW-DELISTED | Stock | 25.17 | 25.56 | 25.02 | 25.05 | 32360.0 |
| 2004-07-23 | ABE-DELISTED | Stock | 7.72 | 7.72 | 7.52 | 7.59 | 15600.0 |
| 2004-07-23 | ABFS-DELISTED | Stock | 34.7 | 34.86 | 33.71 | 33.78 | 390120.0 |
| 2004-07-23 | ABG | Stock | 13.18 | 13.18 | 12.74 | 12.9 | 37200.0 |
| 2004-07-23 | ABK-DELISTED | Stock | 70.8 | 70.99 | 70.12 | 70.4 | 519900.0 |
| 2004-07-23 | ABM | Stock | 18.01 | 18.26 | 17.97 | 18.18 | 107600.0 |
| 2004-07-23 | ABMD-DELISTED | Stock | 10.14 | 10.14 | 8.96 | 9.07 | 164298.0 |
| 2004-07-23 | ABP-DELISTED | Stock | 1.27 | 1.3 | 1.21 | 1.26 | 46500.0 |
| 2004-07-23 | ABR | Stock | 18.75 | 18.79 | 18.41 | 18.73 | 20700.0 |
| 2004-07-23 | ABT | Stock | 18.8417 | 18.8753 | 18.4243 | 18.5347 | 5813881.0 |
| 2004-07-23 | ABTL-DELISTED | Stock | 35.35 | 35.35 | 32.75 | 32.95 | 104000.0 |
| 2004-07-23 | ABV-DELISTED | Stock | 20.3 | 20.5 | 20.18 | 20.2 | 301200.0 |
| 2004-07-23 | ABVA-DELISTED | Stock | 15.0 | 15.0 | 15.0 | 15.0 | 23900.0 |
| 2004-07-23 | ABVT-DELISTED | Stock | 27.0 | 29.0 | 21.25 | 28.0 | 3600.0 |
| 2004-07-23 | ABX-DELISTED | Stock | 19.69 | 19.8 | 19.49 | 19.49 | 1065237.0 |
| 2004-07-23 | ACAD | Stock | 6.3 | 6.3 | 6.02 | 6.17 | 1500.0 |
| 2004-07-23 | ACAP-DELISTED | Stock | 23.5 | 23.99 | 23.44 | 23.45 | 19169.0 |
| 2004-07-23 | ACAS-DELISTED | Stock | 28.97 | 29.02 | 28.5 | 28.59 | 397137.0 |
| 2004-07-23 | ACAT-DELISTED | Stock | 27.1 | 27.28 | 26.71 | 26.87 | 60456.0 |
| 2004-07-23 | ACCL-DELISTED | Stock | 6.71 | 7.0 | 6.4 | 6.43 | 159073.0 |
| 2004-07-23 | ACE-DELISTED | Stock | 38.72 | 39.18 | 38.26 | 38.63 | 1434646.0 |
| 2004-07-23 | ACF-DELISTED | Stock | 19.32 | 19.32 | 18.71 | 19.09 | 832600.0 |
| 2004-07-23 | ACG-DELISTED | Stock | 8.14 | 8.1452 | 8.12 | 8.13 | 322800.0 |
| 2004-07-23 | ACGL | Stock | 4.0833 | 4.1133 | 4.04 | 4.0656 | 1324800.0 |
| 2004-07-23 | ACGN-DELISTED | Stock | 623.3288 | 623.3288 | 566.6712 | 600.6712 | 226200.0 |
| 2004-07-23 | ACH | Stock | 16.84 | 16.9533 | 16.6733 | 16.8667 | 259200.0 |
| 2004-07-23 | ACH-DELISTED | Stock | 13.274 | 13.274 | 13.035 | 13.137 | 322801.0 |
| 2004-07-23 | ACLS | Stock | 37.2 | 37.32 | 34.96 | 35.0 | 267375.0 |
| 2004-07-23 | ACO-DELISTED | Stock | 19.17 | 19.17 | 18.4 | 18.44 | 114700.0 |
| 2004-07-23 | ACPW-DELISTED | Stock | 14.15 | 14.251 | 13.047 | 13.9 | 11393.0 |
> showing 50 of 3,757 rows — these rows as CSV