PREVIEW / stock_daily / 2003-07-01
file: by_date/stock_daily/2003/2003-07-01.parquet size: 115 KB rows: 3,366 symbols: 2,074
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-07-01 | AAPL | Stock | 0.337 | 0.3425 | 0.3305 | 0.3409 | 180992000.0 |
| 2003-07-01 | MSFT | Stock | 25.59 | 26.2 | 25.39 | 26.15 | 60926000.0 |
| 2003-07-01 | NVDA | Stock | 0.1885 | 0.199 | 0.1867 | 0.1987 | 977016000.0 |
| 2003-07-01 | AMZN | Stock | 1.8165 | 1.8645 | 1.785 | 1.8625 | 144856000.0 |
| 2003-07-01 | CL | Stock | 28.975 | 29.3 | 28.725 | 29.125 | 4033000.0 |
| 2003-07-01 | A | Stock | 13.9199 | 14.2418 | 13.8054 | 14.2418 | 4405797.0 |
| 2003-07-01 | AABA-DELISTED | Stock | 16.4300003051758 | 16.8250007629395 | 16.1000003814697 | 16.8199996948242 | 20227600.0 |
| 2003-07-01 | AAI-DELISTED | Stock | 10.47 | 11.25 | 10.46 | 11.19 | 1811900.0 |
| 2003-07-01 | AAIC-DELISTED | Stock | 268.8 | 278.0 | 265.8 | 277.6 | 764300.0 |
| 2003-07-01 | AAME | Stock | 2.37 | 2.55 | 2.36 | 2.55 | 5500.0 |
| 2003-07-01 | AAON | Stock | 2.4928 | 2.4928 | 2.4191 | 2.4362 | 290081.0 |
| 2003-07-01 | AAP | Stock | 20.1333 | 20.21 | 19.7667 | 20.15 | 1873800.0 |
| 2003-07-01 | AAXN-DELISTED | Stock | 1.08749997615814 | 1.08749997615814 | 0.983333349227905 | 1.02083337306976 | 794400.0 |
| 2003-07-01 | ABAX-DELISTED | Stock | 6.51 | 6.54 | 6.25 | 6.4 | 25000.0 |
| 2003-07-01 | ABB-DELISTED | Stock | 3.42 | 3.45 | 3.31 | 3.44 | 541400.0 |
| 2003-07-01 | ABC-DELISTED | Stock | 17.31 | 17.56 | 17.19 | 17.53 | 6175200.0 |
| 2003-07-01 | ABCB | Stock | 12.1175 | 12.1742 | 11.6312 | 12.1742 | 7279.0 |
| 2003-07-01 | ABCO-DELISTED | Stock | 20.11 | 20.11 | 19.432 | 19.537 | 392868.0 |
| 2003-07-01 | ABCW-DELISTED | Stock | 23.89 | 24.84 | 23.87 | 24.84 | 61290.0 |
| 2003-07-01 | ABE-DELISTED | Stock | 6.09 | 6.09 | 6.03 | 6.09 | 6900.0 |
| 2003-07-01 | ABFS-DELISTED | Stock | 23.51 | 24.17 | 23.4899 | 23.93 | 205520.0 |
| 2003-07-01 | ABG | Stock | 13.48 | 13.55 | 13.31 | 13.45 | 43500.0 |
| 2003-07-01 | ABK-DELISTED | Stock | 66.25 | 66.74 | 64.91 | 66.7 | 556500.0 |
| 2003-07-01 | ABM | Stock | 15.26 | 15.6 | 14.85 | 15.55 | 100800.0 |
| 2003-07-01 | ABMD-DELISTED | Stock | 5.35 | 5.48 | 5.26 | 5.3 | 71700.0 |
| 2003-07-01 | ABP-DELISTED | Stock | 1.11 | 1.11 | 1.05 | 1.11 | 18900.0 |
| 2003-07-01 | ABT | Stock | 19.5945 | 19.6574 | 18.9885 | 19.5496 | 10387594.0 |
| 2003-07-01 | ABTL-DELISTED | Stock | 31.0 | 31.35 | 28.7 | 29.0 | 91100.0 |
| 2003-07-01 | ABV-DELISTED | Stock | 20.3 | 20.8 | 20.14 | 20.73 | 489600.0 |
| 2003-07-01 | ABVA-DELISTED | Stock | 16.7 | 16.75 | 16.6 | 16.6 | 4500.0 |
| 2003-07-01 | ABX-DELISTED | Stock | 17.99 | 18.52 | 17.98 | 18.52 | 2422583.0 |
| 2003-07-01 | ACAP-DELISTED | Stock | 24.86 | 25.2 | 24.44 | 24.64 | 29803.0 |
| 2003-07-01 | ACAS-DELISTED | Stock | 25.19 | 26.06 | 25.12 | 26.0 | 493713.0 |
| 2003-07-01 | ACAT-DELISTED | Stock | 18.98 | 19.28 | 18.25 | 18.99 | 36273.0 |
| 2003-07-01 | ACCL-DELISTED | Stock | 5.96999979019165 | 5.97399997711182 | 5.43100023269653 | 5.88700008392334 | 275300.0 |
| 2003-07-01 | ACE-DELISTED | Stock | 34.32 | 34.61 | 33.96 | 34.47 | 1603630.0 |
| 2003-07-01 | ACF-DELISTED | Stock | 8.56 | 8.68 | 8.36 | 8.5 | 1675100.0 |
| 2003-07-01 | ACG-DELISTED | Stock | 9.45 | 9.46 | 9.41 | 9.45 | 408600.0 |
| 2003-07-01 | ACGL | Stock | 3.8544 | 3.8889 | 3.8456 | 3.8567 | 1990800.0 |
| 2003-07-01 | ACGN-DELISTED | Stock | 929.3288 | 940.6712 | 918.0 | 940.6712 | 45100.0 |
| 2003-07-01 | ACH | Stock | 14.9333 | 15.04 | 14.64 | 15.0 | 232800.0 |
| 2003-07-01 | ACH-DELISTED | Stock | 5.5 | 5.55 | 5.5 | 5.5 | 6000.0 |
| 2003-07-01 | ACLS | Stock | 24.44 | 24.92 | 23.0 | 24.32 | 211375.0 |
| 2003-07-01 | ACO-DELISTED | Stock | 7.99 | 8.45 | 7.83 | 8.25 | 69900.0 |
| 2003-07-01 | ACPW-DELISTED | Stock | 8.815 | 9.789 | 7.79 | 8.2 | 58863.0 |
| 2003-07-01 | ACS-DELISTED | Stock | 46.65 | 47.25 | 45.95 | 46.62 | 2170600.0 |
| 2003-07-01 | ACTA-DELISTED | Stock | 9.6 | 9.8 | 9.4 | 9.8 | 255300.0 |
| 2003-07-01 | ACTG | Stock | 1.33 | 1.38 | 1.25 | 1.35 | 334900.0 |
| 2003-07-01 | ACTI-DELISTED | Stock | 9.14 | 9.38 | 8.87 | 9.15 | 319686.0 |
| 2003-07-01 | ACTT-DELISTED | Stock | 1.95 | 1.95 | 1.77 | 1.88 | 35600.0 |
> showing 50 of 3,366 rows — these rows as CSV