PREVIEW / stock_daily / 2004-01-21
file: by_date/stock_daily/2004/2004-01-21.parquet size: 125 KB rows: 3,646 symbols: 2,275
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-21 | AAPL | Stock | 0.4054 | 0.4102 | 0.4005 | 0.4038 | 226660000.0 |
| 2004-01-21 | MSFT | Stock | 28.13 | 28.3 | 27.85 | 28.3 | 53570600.0 |
| 2004-01-21 | NVDA | Stock | 0.2095 | 0.2103 | 0.2012 | 0.2015 | 494460000.0 |
| 2004-01-21 | AMZN | Stock | 2.808 | 2.847 | 2.782 | 2.81 | 135672000.0 |
| 2004-01-21 | CL | Stock | 25.65 | 25.745 | 25.615 | 25.725 | 5002000.0 |
| 2004-01-21 | A | Stock | 24.392 | 25.0 | 24.1702 | 24.8712 | 6111217.0 |
| 2004-01-21 | AABA-DELISTED | Stock | 23.6200008392334 | 23.9850006103516 | 23.4549999237061 | 23.6900005340576 | 15065800.0 |
| 2004-01-21 | AAI-DELISTED | Stock | 12.72 | 13.09 | 12.39 | 13.02 | 1314900.0 |
| 2004-01-21 | AAIC-DELISTED | Stock | 496.0 | 504.0 | 491.0 | 500.0 | 633600.0 |
| 2004-01-21 | AAME | Stock | 3.08 | 3.08 | 3.0 | 3.0 | 47100.0 |
| 2004-01-21 | AAON | Stock | 2.8655 | 2.9537 | 2.8655 | 2.8971 | 921122.0 |
| 2004-01-21 | AAP | Stock | 27.3933 | 27.88 | 27.3 | 27.8667 | 653250.0 |
| 2004-01-21 | AAXN-DELISTED | Stock | 9.76249980926514 | 10.1291666030884 | 9.53333377838135 | 9.90833377838135 | 10443600.0 |
| 2004-01-21 | ABAX-DELISTED | Stock | 20.1 | 20.7 | 19.8 | 19.97 | 467875.0 |
| 2004-01-21 | ABB-DELISTED | Stock | 5.97 | 6.12 | 5.9 | 6.06 | 122600.0 |
| 2004-01-21 | ABC-DELISTED | Stock | 13.86 | 14.02 | 13.84 | 13.94 | 4864000.0 |
| 2004-01-21 | ABCB | Stock | 14.5896 | 14.8409 | 14.4438 | 14.8004 | 44909.0 |
| 2004-01-21 | ABCO-DELISTED | Stock | 17.21 | 17.21 | 16.76 | 17.03 | 540950.0 |
| 2004-01-21 | ABCW-DELISTED | Stock | 25.87 | 25.95 | 25.77 | 25.95 | 140790.0 |
| 2004-01-21 | ABE-DELISTED | Stock | 8.67 | 8.88 | 8.54 | 8.88 | 49400.0 |
| 2004-01-21 | ABFS-DELISTED | Stock | 32.16 | 33.0 | 31.95 | 32.93 | 86076.0 |
| 2004-01-21 | ABG | Stock | 18.95 | 19.26 | 18.85 | 19.2 | 36500.0 |
| 2004-01-21 | ABK-DELISTED | Stock | 74.64 | 75.13 | 74.17 | 74.76 | 380700.0 |
| 2004-01-21 | ABM | Stock | 18.6 | 18.75 | 18.4 | 18.63 | 110500.0 |
| 2004-01-21 | ABMD-DELISTED | Stock | 7.999 | 8.0 | 7.74 | 7.92 | 19145.0 |
| 2004-01-21 | ABP-DELISTED | Stock | 1.8 | 1.83 | 1.67 | 1.83 | 219400.0 |
| 2004-01-21 | ABT | Stock | 19.415 | 19.801 | 19.3297 | 19.617 | 13352836.0 |
| 2004-01-21 | ABTL-DELISTED | Stock | 59.65 | 59.65 | 56.4 | 57.95 | 78800.0 |
| 2004-01-21 | ABV-DELISTED | Stock | 25.5 | 25.8 | 25.08 | 25.71 | 559200.0 |
| 2004-01-21 | ABVA-DELISTED | Stock | 19.04 | 19.04 | 18.51 | 18.74 | 15101.0 |
| 2004-01-21 | ABX-DELISTED | Stock | 20.99 | 21.31 | 20.74 | 21.03 | 2189436.0 |
| 2004-01-21 | ACAP-DELISTED | Stock | 17.05 | 17.05 | 16.64 | 16.98 | 48537.0 |
| 2004-01-21 | ACAS-DELISTED | Stock | 30.95 | 32.15 | 30.8 | 32.13 | 800650.0 |
| 2004-01-21 | ACAT-DELISTED | Stock | 27.08 | 27.5 | 26.83 | 27.495 | 27681.0 |
| 2004-01-21 | ACCL-DELISTED | Stock | 15.6999998092651 | 15.7130002975464 | 14.78600025177 | 15.3290004730225 | 267500.0 |
| 2004-01-21 | ACE-DELISTED | Stock | 42.95 | 43.59 | 42.69 | 43.55 | 1180770.0 |
| 2004-01-21 | ACF-DELISTED | Stock | 17.8 | 18.0 | 17.5 | 17.7 | 1362500.0 |
| 2004-01-21 | ACG-DELISTED | Stock | 8.81 | 8.85 | 8.81 | 8.84 | 459200.0 |
| 2004-01-21 | ACGL | Stock | 4.8333 | 4.8544 | 4.7889 | 4.8533 | 925200.0 |
| 2004-01-21 | ACGN-DELISTED | Stock | 1212.6712 | 1360.0 | 1201.3288 | 1360.0 | 394400.0 |
| 2004-01-21 | ACH | Stock | 15.5 | 15.7933 | 15.3333 | 15.7933 | 123150.0 |
| 2004-01-21 | ACH-DELISTED | Stock | 18.612 | 18.829 | 18.15 | 18.257 | 583203.0 |
| 2004-01-21 | ACLS | Stock | 52.32 | 52.4 | 49.52 | 51.08 | 480750.0 |
| 2004-01-21 | ACO-DELISTED | Stock | 22.55 | 22.55 | 21.0 | 21.2 | 727100.0 |
| 2004-01-21 | ACPW-DELISTED | Stock | 18.95 | 19.3 | 18.05 | 18.65 | 35071.0 |
| 2004-01-21 | ACS-DELISTED | Stock | 55.0 | 56.0 | 54.73 | 55.6 | 1359300.0 |
| 2004-01-21 | ACTA-DELISTED | Stock | 10.0 | 10.0 | 9.2 | 9.4 | 5368300.0 |
| 2004-01-21 | ACTG | Stock | 6.65 | 6.99 | 6.31 | 6.75 | 220100.0 |
| 2004-01-21 | ACTI-DELISTED | Stock | 7.75 | 7.9 | 7.73 | 7.86 | 178332.0 |
| 2004-01-21 | ACTT-DELISTED | Stock | 1.55 | 1.62 | 1.51 | 1.57 | 623532.0 |
> showing 50 of 3,646 rows — these rows as CSV