PREVIEW / stock_daily / 2003-09-18
file: by_date/stock_daily/2003/2003-09-18.parquet size: 118 KB rows: 3,450 symbols: 2,120
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-09-18 | AAPL | Stock | 0.3946 | 0.4105 | 0.392 | 0.4086 | 252907200.0 |
| 2003-09-18 | MSFT | Stock | 28.49 | 29.51 | 28.42 | 29.5 | 67268100.0 |
| 2003-09-18 | NVDA | Stock | 0.1645 | 0.1667 | 0.1627 | 0.1667 | 603492000.0 |
| 2003-09-18 | AMZN | Stock | 2.308 | 2.412 | 2.297 | 2.3945 | 180770000.0 |
| 2003-09-18 | CL | Stock | 27.525 | 27.62 | 27.315 | 27.425 | 5787400.0 |
| 2003-09-18 | A | Stock | 17.4177 | 17.6896 | 17.3104 | 17.568 | 2813056.0 |
| 2003-09-18 | AABA-DELISTED | Stock | 17.8999996185303 | 18.9150009155273 | 17.8600006103516 | 18.7900009155273 | 35570800.0 |
| 2003-09-18 | AAI-DELISTED | Stock | 17.88 | 17.94 | 17.63 | 17.72 | 970000.0 |
| 2003-09-18 | AAIC-DELISTED | Stock | 347.0 | 356.2 | 347.0 | 352.2 | 1007200.0 |
| 2003-09-18 | AAME | Stock | 2.45 | 2.6 | 2.45 | 2.5 | 2000.0 |
| 2003-09-18 | AAON | Stock | 2.2993 | 2.3348 | 2.2979 | 2.3006 | 154153.0 |
| 2003-09-18 | AAP | Stock | 23.64 | 24.0433 | 23.58 | 23.9467 | 596400.0 |
| 2003-09-18 | AAXN-DELISTED | Stock | 2.50833344459534 | 2.70250010490417 | 2.40000009536743 | 2.49166655540466 | 11148000.0 |
| 2003-09-18 | ABAX-DELISTED | Stock | 11.4 | 12.69 | 11.25 | 12.69 | 440664.0 |
| 2003-09-18 | ABB-DELISTED | Stock | 5.88 | 5.9 | 5.77 | 5.86 | 130400.0 |
| 2003-09-18 | ABC-DELISTED | Stock | 14.1 | 14.3 | 14.1 | 14.16 | 4476000.0 |
| 2003-09-18 | ABCB | Stock | 14.079 | 14.079 | 13.6251 | 13.7548 | 11597.0 |
| 2003-09-18 | ABCO-DELISTED | Stock | 22.58 | 24.07 | 22.58 | 23.85 | 380306.0 |
| 2003-09-18 | ABCW-DELISTED | Stock | 24.58 | 24.7 | 24.58 | 24.7 | 48350.0 |
| 2003-09-18 | ABE-DELISTED | Stock | 6.66 | 6.68 | 6.6 | 6.65 | 24100.0 |
| 2003-09-18 | ABFS-DELISTED | Stock | 27.64 | 28.6 | 27.57 | 28.29 | 248344.0 |
| 2003-09-18 | ABG | Stock | 17.45 | 18.1 | 17.35 | 18.0 | 33700.0 |
| 2003-09-18 | ABK-DELISTED | Stock | 65.7 | 66.72 | 65.7 | 66.58 | 400200.0 |
| 2003-09-18 | ABM | Stock | 14.95 | 15.1 | 14.82 | 14.85 | 225000.0 |
| 2003-09-18 | ABMD-DELISTED | Stock | 6.85 | 7.01 | 6.61 | 6.86 | 48908.0 |
| 2003-09-18 | ABP-DELISTED | Stock | 1.0 | 1.0 | 0.97 | 0.99 | 32100.0 |
| 2003-09-18 | ABT | Stock | 19.7292 | 19.9402 | 19.7157 | 19.801 | 6398294.0 |
| 2003-09-18 | ABTL-DELISTED | Stock | 50.65 | 51.25 | 49.25 | 50.0 | 117400.0 |
| 2003-09-18 | ABV-DELISTED | Stock | 22.05 | 22.79 | 22.05 | 22.74 | 1106600.0 |
| 2003-09-18 | ABVA-DELISTED | Stock | 23.19 | 23.28 | 23.19 | 23.27 | 700.0 |
| 2003-09-18 | ABX-DELISTED | Stock | 20.1 | 20.1 | 19.5 | 19.53 | 2004400.0 |
| 2003-09-18 | ACAP-DELISTED | Stock | 28.67 | 28.95 | 28.67 | 28.81 | 22521.0 |
| 2003-09-18 | ACAS-DELISTED | Stock | 25.68 | 26.14 | 25.54 | 26.1 | 374431.0 |
| 2003-09-18 | ACAT-DELISTED | Stock | 21.53 | 21.53 | 21.07 | 21.39 | 19560.0 |
| 2003-09-18 | ACCL-DELISTED | Stock | 10.7819995880127 | 10.7819995880127 | 10.4924001693726 | 10.7819995880127 | 200100.0 |
| 2003-09-18 | ACE-DELISTED | Stock | 32.7 | 33.91 | 32.69 | 33.78 | 1438500.0 |
| 2003-09-18 | ACF-DELISTED | Stock | 11.1 | 12.2 | 10.96 | 11.98 | 3352000.0 |
| 2003-09-18 | ACG-DELISTED | Stock | 8.06 | 8.1 | 8.04 | 8.06 | 815700.0 |
| 2003-09-18 | ACGL | Stock | 3.7211 | 3.7656 | 3.7 | 3.7578 | 621000.0 |
| 2003-09-18 | ACGN-DELISTED | Stock | 1450.6712 | 1564.0 | 1371.3288 | 1428.0 | 513000.0 |
| 2003-09-18 | ACH | Stock | 16.8067 | 17.0267 | 16.5667 | 16.9667 | 144150.0 |
| 2003-09-18 | ACH-DELISTED | Stock | 7.507 | 7.507 | 7.419 | 7.457 | 27976.0 |
| 2003-09-18 | ACLS | Stock | 38.36 | 39.72 | 37.08 | 39.72 | 328050.0 |
| 2003-09-18 | ACO-DELISTED | Stock | 12.05 | 12.52 | 12.01 | 12.16 | 81300.0 |
| 2003-09-18 | ACPW-DELISTED | Stock | 16.047 | 16.196 | 15.453 | 15.75 | 24284.0 |
| 2003-09-18 | ACS-DELISTED | Stock | 51.5 | 52.52 | 51.2 | 52.45 | 1741600.0 |
| 2003-09-18 | ACTA-DELISTED | Stock | 10.2 | 10.8 | 10.0 | 10.4 | 1049200.0 |
| 2003-09-18 | ACTG | Stock | 4.25 | 5.13 | 4.21 | 5.04 | 1231200.0 |
| 2003-09-18 | ACTI-DELISTED | Stock | 7.95 | 8.49 | 7.9 | 8.105 | 879931.0 |
| 2003-09-18 | ACTT-DELISTED | Stock | 2.21 | 2.24 | 2.1 | 2.19 | 33480.0 |
> showing 50 of 3,450 rows — these rows as CSV