PREVIEW / stock_daily / 2003-11-18
file: by_date/stock_daily/2003/2003-11-18.parquet size: 121 KB rows: 3,543 symbols: 2,204
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-18 | AAPL | Stock | 0.3788 | 0.3811 | 0.3634 | 0.3645 | 267192800.0 |
| 2003-11-18 | MSFT | Stock | 25.33 | 25.84 | 25.12 | 25.15 | 106868300.0 |
| 2003-11-18 | NVDA | Stock | 0.1704 | 0.1725 | 0.1633 | 0.1639 | 991428000.0 |
| 2003-11-18 | AMZN | Stock | 2.5365 | 2.549 | 2.4225 | 2.425 | 252004000.0 |
| 2003-11-18 | CL | Stock | 26.025 | 26.11 | 25.695 | 25.715 | 5491800.0 |
| 2003-11-18 | A | Stock | 20.6724 | 20.9943 | 19.7997 | 19.8641 | 11798141.0 |
| 2003-11-18 | AABA-DELISTED | Stock | 20.375 | 20.4950008392334 | 18.9750003814697 | 19.0049991607666 | 35245800.0 |
| 2003-11-18 | AAI-DELISTED | Stock | 14.1 | 14.46 | 13.87 | 13.96 | 1681700.0 |
| 2003-11-18 | AAIC-DELISTED | Stock | 405.0 | 420.0 | 405.0 | 411.0 | 835000.0 |
| 2003-11-18 | AAME | Stock | 2.63 | 2.63 | 2.55 | 2.56 | 16800.0 |
| 2003-11-18 | AAON | Stock | 2.3664 | 2.398 | 2.3348 | 2.3348 | 171619.0 |
| 2003-11-18 | AAP | Stock | 26.8267 | 26.8667 | 26.3833 | 26.4167 | 707100.0 |
| 2003-11-18 | AAXN-DELISTED | Stock | 5.29333353042603 | 5.32333326339722 | 5.04166650772095 | 5.16249990463257 | 2774400.0 |
| 2003-11-18 | ABAX-DELISTED | Stock | 17.1 | 18.1 | 16.59 | 16.87 | 213101.0 |
| 2003-11-18 | ABB-DELISTED | Stock | 6.03 | 6.08 | 5.94 | 6.02 | 85400.0 |
| 2003-11-18 | ABC-DELISTED | Stock | 16.2 | 16.27 | 15.94 | 15.95 | 2994000.0 |
| 2003-11-18 | ABCB | Stock | 13.4063 | 13.4711 | 13.0172 | 13.0172 | 8143.0 |
| 2003-11-18 | ABCO-DELISTED | Stock | 18.03 | 18.03 | 17.81 | 17.81 | 143914.0 |
| 2003-11-18 | ABCW-DELISTED | Stock | 24.79 | 25.19 | 24.73 | 24.73 | 44650.0 |
| 2003-11-18 | ABE-DELISTED | Stock | 6.86 | 6.86 | 6.76 | 6.76 | 16600.0 |
| 2003-11-18 | ABFS-DELISTED | Stock | 32.53 | 32.92 | 32.25 | 32.29 | 78674.0 |
| 2003-11-18 | ABG | Stock | 16.0 | 16.1 | 15.78 | 15.95 | 24800.0 |
| 2003-11-18 | ABK-DELISTED | Stock | 69.0 | 69.02 | 68.25 | 68.4 | 401500.0 |
| 2003-11-18 | ABM | Stock | 15.4 | 15.58 | 15.4 | 15.4 | 160900.0 |
| 2003-11-18 | ABMD-DELISTED | Stock | 7.74 | 7.93 | 7.35 | 7.45 | 32449.0 |
| 2003-11-18 | ABP-DELISTED | Stock | 0.99 | 1.01 | 0.97 | 0.99 | 32800.0 |
| 2003-11-18 | ABT | Stock | 19.9761 | 20.1063 | 19.7516 | 19.7876 | 7445964.0 |
| 2003-11-18 | ABTL-DELISTED | Stock | 48.0 | 49.0 | 44.45 | 45.2 | 141100.0 |
| 2003-11-18 | ABV-DELISTED | Stock | 22.4 | 22.49 | 22.08 | 22.16 | 318700.0 |
| 2003-11-18 | ABVA-DELISTED | Stock | 16.0 | 16.2 | 16.0 | 16.01 | 625.0 |
| 2003-11-18 | ABX-DELISTED | Stock | 20.84 | 21.59 | 20.8 | 21.58 | 2922027.0 |
| 2003-11-18 | ACAP-DELISTED | Stock | 16.3 | 16.43 | 16.16 | 16.21 | 87841.0 |
| 2003-11-18 | ACAS-DELISTED | Stock | 27.85 | 27.92 | 27.52 | 27.7 | 684302.0 |
| 2003-11-18 | ACAT-DELISTED | Stock | 22.7 | 22.96 | 22.04 | 22.18 | 23812.0 |
| 2003-11-18 | ACCL-DELISTED | Stock | 8.39970970153809 | 8.7183198928833 | 8.24765014648438 | 8.7183198928833 | 112700.0 |
| 2003-11-18 | ACE-DELISTED | Stock | 34.86 | 34.94 | 34.35 | 34.48 | 584300.0 |
| 2003-11-18 | ACF-DELISTED | Stock | 13.06 | 13.38 | 13.01 | 13.04 | 1175800.0 |
| 2003-11-18 | ACG-DELISTED | Stock | 8.26 | 8.28 | 8.25 | 8.26 | 427300.0 |
| 2003-11-18 | ACGL | Stock | 4.12 | 4.1611 | 4.0856 | 4.1567 | 477000.0 |
| 2003-11-18 | ACGN-DELISTED | Stock | 1178.6712 | 1224.0 | 1178.6712 | 1212.6712 | 39800.0 |
| 2003-11-18 | ACH | Stock | 14.0 | 14.1 | 13.78 | 13.78 | 199800.0 |
| 2003-11-18 | ACH-DELISTED | Stock | 12.581 | 12.581 | 12.049 | 12.106 | 625898.0 |
| 2003-11-18 | ACLS | Stock | 43.6 | 44.72 | 42.2 | 42.84 | 321750.0 |
| 2003-11-18 | ACO-DELISTED | Stock | 15.71 | 16.3 | 15.71 | 16.15 | 231200.0 |
| 2003-11-18 | ACPW-DELISTED | Stock | 17.65 | 17.65 | 16.85 | 17.25 | 13080.0 |
| 2003-11-18 | ACS-DELISTED | Stock | 47.16 | 47.55 | 46.66 | 46.7 | 809700.0 |
| 2003-11-18 | ACTA-DELISTED | Stock | 8.4 | 8.6 | 8.0 | 8.2 | 216600.0 |
| 2003-11-18 | ACTG | Stock | 6.1 | 6.1 | 5.8 | 5.86 | 51100.0 |
| 2003-11-18 | ACTI-DELISTED | Stock | 8.3 | 8.48 | 8.1 | 8.21 | 78280.0 |
| 2003-11-18 | ACTT-DELISTED | Stock | 1.3 | 1.33 | 1.28 | 1.33 | 36861.0 |
> showing 50 of 3,543 rows — these rows as CSV