PREVIEW / stock_daily / 2004-11-09
file: by_date/stock_daily/2004/2004-11-09.parquet size: 130 KB rows: 3,887 symbols: 2,432
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-11-09 | AAPL | Stock | 0.9684 | 0.9741 | 0.9532 | 0.9652 | 475764800.0 |
| 2004-11-09 | MSFT | Stock | 29.43 | 29.89 | 29.35 | 29.77 | 100401000.0 |
| 2004-11-09 | NVDA | Stock | 0.1463 | 0.1498 | 0.1462 | 0.1477 | 615936000.0 |
| 2004-11-09 | AMZN | Stock | 1.859 | 1.8905 | 1.835 | 1.87 | 129598000.0 |
| 2004-11-09 | CL | Stock | 23.365 | 23.49 | 23.24 | 23.335 | 4527600.0 |
| 2004-11-09 | A | Stock | 18.2046 | 18.5265 | 18.083 | 18.2833 | 2274965.0 |
| 2004-11-09 | AABA-DELISTED | Stock | 37.2400016784668 | 37.6300010681152 | 36.8600006103516 | 37.0299987792969 | 14937800.0 |
| 2004-11-09 | AACC-DELISTED | Stock | 17.99 | 17.99 | 17.03 | 17.12 | 118005.0 |
| 2004-11-09 | AAI-DELISTED | Stock | 12.75 | 13.0 | 12.7 | 13.0 | 716800.0 |
| 2004-11-09 | AAIC-DELISTED | Stock | 349.0 | 355.2 | 348.6 | 351.8 | 804100.0 |
| 2004-11-09 | AAME | Stock | 3.03 | 3.03 | 3.02 | 3.02 | 4900.0 |
| 2004-11-09 | AAON | Stock | 2.1426 | 2.1439 | 2.107 | 2.107 | 72141.0 |
| 2004-11-09 | AAP | Stock | 27.3333 | 27.4333 | 27.0333 | 27.1733 | 819000.0 |
| 2004-11-09 | AAV-DELISTED | Stock | 17.41 | 17.95 | 17.22 | 17.41 | 43400.0 |
| 2004-11-09 | AAXN-DELISTED | Stock | 27.9699993133545 | 28.0 | 24.7099990844727 | 25.5 | 45786400.0 |
| 2004-11-09 | ABAX-DELISTED | Stock | 11.71 | 11.82 | 11.54 | 11.74 | 166931.0 |
| 2004-11-09 | ABB-DELISTED | Stock | 5.86 | 5.94 | 5.86 | 5.9 | 179700.0 |
| 2004-11-09 | ABC-DELISTED | Stock | 14.67 | 14.8 | 14.59 | 14.74 | 5596800.0 |
| 2004-11-09 | ABCB | Stock | 16.8591 | 16.8591 | 16.6241 | 16.8186 | 4935.0 |
| 2004-11-09 | ABCO-DELISTED | Stock | 17.225 | 17.356 | 16.87 | 16.87 | 341469.0 |
| 2004-11-09 | ABCW-DELISTED | Stock | 26.79 | 27.0 | 26.5 | 26.91 | 52480.0 |
| 2004-11-09 | ABE-DELISTED | Stock | 8.72 | 8.77 | 8.72 | 8.77 | 8100.0 |
| 2004-11-09 | ABFS-DELISTED | Stock | 40.54 | 40.75 | 40.13 | 40.47 | 110494.0 |
| 2004-11-09 | ABG | Stock | 13.94 | 13.99 | 13.65 | 13.96 | 17300.0 |
| 2004-11-09 | ABK-DELISTED | Stock | 79.13 | 79.58 | 78.53 | 79.31 | 309300.0 |
| 2004-11-09 | ABM | Stock | 21.01 | 21.21 | 20.97 | 21.1 | 84900.0 |
| 2004-11-09 | ABMD-DELISTED | Stock | 14.89 | 15.25 | 14.89 | 15.25 | 301511.0 |
| 2004-11-09 | ABP-DELISTED | Stock | 2.82 | 2.85 | 2.67 | 2.75 | 219000.0 |
| 2004-11-09 | ABR | Stock | 20.9 | 21.1 | 20.8 | 20.98 | 40000.0 |
| 2004-11-09 | ABT | Stock | 21.543 | 21.7349 | 21.4039 | 21.591 | 8333681.0 |
| 2004-11-09 | ABTL-DELISTED | Stock | 34.25 | 35.05 | 33.7 | 35.0 | 75200.0 |
| 2004-11-09 | ABV-DELISTED | Stock | 24.05 | 24.33 | 23.91 | 24.24 | 217000.0 |
| 2004-11-09 | ABVA-DELISTED | Stock | 15.1 | 15.1 | 15.1 | 15.1 | 200.0 |
| 2004-11-09 | ABVT-DELISTED | Stock | 24.0 | 26.5 | 24.0 | 26.5 | 7200.0 |
| 2004-11-09 | ABX-DELISTED | Stock | 22.97 | 23.3 | 22.9 | 23.17 | 1668800.0 |
| 2004-11-09 | ACAD | Stock | 7.38 | 7.48 | 7.38 | 7.4 | 3900.0 |
| 2004-11-09 | ACAP-DELISTED | Stock | 33.9 | 33.9 | 33.0 | 33.5 | 73956.0 |
| 2004-11-09 | ACAS-DELISTED | Stock | 32.0 | 32.05 | 31.71 | 32.05 | 1146521.0 |
| 2004-11-09 | ACAT-DELISTED | Stock | 25.03 | 25.98 | 25.03 | 25.98 | 36013.0 |
| 2004-11-09 | ACC-DELISTED | Stock | 19.05 | 19.1 | 18.7 | 18.96 | 27500.0 |
| 2004-11-09 | ACCL-DELISTED | Stock | 6.1 | 6.23 | 6.0 | 6.1 | 55756.0 |
| 2004-11-09 | ACE-DELISTED | Stock | 39.43 | 39.78 | 39.37 | 39.46 | 1001770.0 |
| 2004-11-09 | ACF-DELISTED | Stock | 20.41 | 20.75 | 20.15 | 20.15 | 1325500.0 |
| 2004-11-09 | ACFC-DELISTED | Stock | 67.5 | 68.42 | 67.09 | 68.42 | 8610.0 |
| 2004-11-09 | ACG-DELISTED | Stock | 7.9 | 8.0 | 7.9 | 7.99 | 592600.0 |
| 2004-11-09 | ACGL | Stock | 4.3044 | 4.3222 | 4.25 | 4.2756 | 842400.0 |
| 2004-11-09 | ACGN-DELISTED | Stock | 566.6712 | 566.6712 | 532.6712 | 555.3288 | 146700.0 |
| 2004-11-09 | ACH | Stock | 18.3533 | 18.6267 | 18.3533 | 18.4933 | 167400.0 |
| 2004-11-09 | ACH-DELISTED | Stock | 14.937 | 15.024 | 14.772 | 14.892 | 371603.0 |
| 2004-11-09 | ACLS | Stock | 27.48 | 27.96 | 27.04 | 27.44 | 253850.0 |
> showing 50 of 3,887 rows — these rows as CSV