PREVIEW / stock_daily / 2003-11-20
file: by_date/stock_daily/2003/2003-11-20.parquet size: 121 KB rows: 3,549 symbols: 2,211
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-20 | AAPL | Stock | 0.3589 | 0.3764 | 0.3589 | 0.3639 | 239590400.0 |
| 2003-11-20 | MSFT | Stock | 25.17 | 25.63 | 25.08 | 25.1 | 106845700.0 |
| 2003-11-20 | NVDA | Stock | 0.1658 | 0.1695 | 0.1633 | 0.164 | 738852000.0 |
| 2003-11-20 | AMZN | Stock | 2.455 | 2.523 | 2.417 | 2.4425 | 246752000.0 |
| 2003-11-20 | CL | Stock | 25.75 | 26.045 | 25.75 | 25.885 | 5807600.0 |
| 2003-11-20 | A | Stock | 19.6352 | 20.0143 | 19.4778 | 19.485 | 2583504.0 |
| 2003-11-20 | AABA-DELISTED | Stock | 19.4549999237061 | 19.9799995422363 | 19.3150005340576 | 19.3449993133545 | 21760400.0 |
| 2003-11-20 | AAI-DELISTED | Stock | 13.8 | 14.62 | 13.8 | 14.22 | 3550800.0 |
| 2003-11-20 | AAIC-DELISTED | Stock | 404.0 | 406.4 | 396.0 | 397.0 | 914500.0 |
| 2003-11-20 | AAME | Stock | 2.53 | 2.63 | 2.53 | 2.63 | 1500.0 |
| 2003-11-20 | AAON | Stock | 2.344 | 2.3585 | 2.3164 | 2.3309 | 99478.0 |
| 2003-11-20 | AAP | Stock | 25.8167 | 25.9933 | 25.64 | 25.8567 | 1102200.0 |
| 2003-11-20 | AAXN-DELISTED | Stock | 5.66666650772095 | 5.91249990463257 | 5.62666654586792 | 5.72499990463257 | 12274800.0 |
| 2003-11-20 | ABAX-DELISTED | Stock | 16.8 | 17.46 | 16.65 | 17.1 | 118312.0 |
| 2003-11-20 | ABB-DELISTED | Stock | 6.15 | 6.2 | 6.07 | 6.11 | 170100.0 |
| 2003-11-20 | ABC-DELISTED | Stock | 16.04 | 16.36 | 16.0 | 16.05 | 3441600.0 |
| 2003-11-20 | ABCB | Stock | 13.6251 | 13.771 | 13.2684 | 13.5278 | 8143.0 |
| 2003-11-20 | ABCO-DELISTED | Stock | 17.935 | 18.04 | 17.5 | 18.0 | 360866.0 |
| 2003-11-20 | ABCW-DELISTED | Stock | 24.72 | 25.13 | 24.71 | 25.13 | 108700.0 |
| 2003-11-20 | ABE-DELISTED | Stock | 6.69 | 6.73 | 6.63 | 6.68 | 13100.0 |
| 2003-11-20 | ABFS-DELISTED | Stock | 32.36 | 32.79 | 32.25 | 32.51 | 130571.0 |
| 2003-11-20 | ABG | Stock | 15.62 | 15.77 | 15.41 | 15.48 | 24100.0 |
| 2003-11-20 | ABK-DELISTED | Stock | 68.3 | 68.36 | 67.27 | 67.6 | 410500.0 |
| 2003-11-20 | ABM | Stock | 15.42 | 15.53 | 15.35 | 15.42 | 133200.0 |
| 2003-11-20 | ABMD-DELISTED | Stock | 7.25 | 7.67 | 7.2 | 7.39 | 32290.0 |
| 2003-11-20 | ABP-DELISTED | Stock | 0.99 | 0.99 | 0.93 | 0.97 | 40400.0 |
| 2003-11-20 | ABT | Stock | 19.8998 | 19.8998 | 19.4643 | 19.5451 | 6903083.0 |
| 2003-11-20 | ABTL-DELISTED | Stock | 41.9 | 45.2 | 41.9 | 42.9 | 103000.0 |
| 2003-11-20 | ABV-DELISTED | Stock | 22.4 | 23.05 | 22.4 | 22.95 | 423400.0 |
| 2003-11-20 | ABVA-DELISTED | Stock | 16.43 | 16.8 | 16.1 | 16.1 | 11800.0 |
| 2003-11-20 | ABX-DELISTED | Stock | 21.8 | 21.84 | 21.29 | 21.52 | 2044900.0 |
| 2003-11-20 | ACAP-DELISTED | Stock | 15.82 | 16.3 | 15.7 | 16.3 | 48379.0 |
| 2003-11-20 | ACAS-DELISTED | Stock | 27.99 | 28.01 | 27.57 | 27.66 | 478633.0 |
| 2003-11-20 | ACAT-DELISTED | Stock | 22.1 | 22.69 | 21.9 | 22.66 | 35650.0 |
| 2003-11-20 | ACCL-DELISTED | Stock | 8.29109001159668 | 8.48371028900146 | 7.97247982025146 | 8.48371028900146 | 177100.0 |
| 2003-11-20 | ACE-DELISTED | Stock | 34.35 | 34.63 | 34.02 | 34.16 | 1155400.0 |
| 2003-11-20 | ACF-DELISTED | Stock | 13.02 | 13.35 | 12.88 | 13.11 | 1174200.0 |
| 2003-11-20 | ACG-DELISTED | Stock | 8.26 | 8.35 | 8.26 | 8.34 | 568400.0 |
| 2003-11-20 | ACGL | Stock | 4.2222 | 4.23 | 4.0722 | 4.0856 | 612900.0 |
| 2003-11-20 | ACGN-DELISTED | Stock | 1292.0 | 1348.6712 | 1224.0 | 1337.3288 | 246970.0 |
| 2003-11-20 | ACH | Stock | 14.0067 | 14.0067 | 13.6333 | 13.84 | 207150.0 |
| 2003-11-20 | ACH-DELISTED | Stock | 11.625 | 11.898 | 11.508 | 11.755 | 270400.0 |
| 2003-11-20 | ACLS | Stock | 42.64 | 42.96 | 41.16 | 41.88 | 336100.0 |
| 2003-11-20 | ACO-DELISTED | Stock | 14.63 | 14.63 | 13.5 | 13.83 | 456300.0 |
| 2003-11-20 | ACPW-DELISTED | Stock | 16.5 | 16.75 | 16.25 | 16.25 | 22410.0 |
| 2003-11-20 | ACS-DELISTED | Stock | 46.11 | 47.32 | 46.0 | 46.87 | 1226900.0 |
| 2003-11-20 | ACTA-DELISTED | Stock | 8.0 | 8.2 | 7.4 | 7.6 | 634700.0 |
| 2003-11-20 | ACTG | Stock | 5.79 | 5.9 | 5.64 | 5.7 | 39600.0 |
| 2003-11-20 | ACTI-DELISTED | Stock | 8.375 | 8.5 | 8.1 | 8.16 | 140653.0 |
| 2003-11-20 | ACTT-DELISTED | Stock | 1.22 | 1.25 | 1.16 | 1.21 | 78765.0 |
> showing 50 of 3,549 rows — these rows as CSV