PREVIEW / stock_daily / 2003-07-17
file: by_date/stock_daily/2003/2003-07-17.parquet size: 115 KB rows: 3,387 symbols: 2,080
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-17 | AAPL | Stock | 0.3605 | 0.3741 | 0.3595 | 0.3732 | 751212000.0 |
| 2003-07-17 | MSFT | Stock | 27.14 | 27.27 | 26.54 | 26.69 | 72805000.0 |
| 2003-07-17 | NVDA | Stock | 0.1872 | 0.1896 | 0.1808 | 0.1833 | 853764000.0 |
| 2003-07-17 | AMZN | Stock | 1.8575 | 1.865 | 1.802 | 1.816 | 152840000.0 |
| 2003-07-17 | CL | Stock | 28.225 | 28.25 | 27.865 | 27.98 | 4403200.0 |
| 2003-07-17 | A | Stock | 15.5222 | 15.6009 | 14.8641 | 15.093 | 5362029.0 |
| 2003-07-17 | AABA-DELISTED | Stock | 15.8249998092651 | 15.8249998092651 | 15.164999961853 | 15.3050003051758 | 26308600.0 |
| 2003-07-17 | AAI-DELISTED | Stock | 11.1 | 11.14 | 10.68 | 10.73 | 1149400.0 |
| 2003-07-17 | AAIC-DELISTED | Stock | 294.0 | 299.0 | 279.0 | 282.4 | 1413700.0 |
| 2003-07-17 | AAME | Stock | 2.4 | 2.4 | 2.4 | 2.4 | 600.0 |
| 2003-07-17 | AAON | Stock | 2.6127 | 2.6179 | 2.5798 | 2.5824 | 102516.0 |
| 2003-07-17 | AAP | Stock | 21.6833 | 21.8 | 21.4033 | 21.5333 | 1467300.0 |
| 2003-07-17 | AAXN-DELISTED | Stock | 1.0625 | 1.07500004768372 | 1.0 | 1.0533332824707 | 349200.0 |
| 2003-07-17 | ABAX-DELISTED | Stock | 6.5 | 6.74 | 6.5 | 6.621 | 23700.0 |
| 2003-07-17 | ABB-DELISTED | Stock | 3.09 | 3.15 | 2.98 | 3.01 | 652800.0 |
| 2003-07-17 | ABC-DELISTED | Stock | 17.3 | 17.34 | 17.02 | 17.104 | 2412400.0 |
| 2003-07-17 | ABCB | Stock | 12.6849 | 12.6849 | 12.2877 | 12.3607 | 15298.0 |
| 2003-07-17 | ABCO-DELISTED | Stock | 21.18 | 21.18 | 20.22 | 20.71 | 162086.0 |
| 2003-07-17 | ABCW-DELISTED | Stock | 25.75 | 25.93 | 25.45 | 25.55 | 86210.0 |
| 2003-07-17 | ABE-DELISTED | Stock | 6.18 | 6.18 | 6.05 | 6.05 | 11800.0 |
| 2003-07-17 | ABFS-DELISTED | Stock | 27.19 | 27.19 | 26.32 | 26.77 | 373900.0 |
| 2003-07-17 | ABG | Stock | 14.85 | 15.0 | 14.55 | 14.55 | 28700.0 |
| 2003-07-17 | ABK-DELISTED | Stock | 68.95 | 69.0 | 66.2 | 66.51 | 1779400.0 |
| 2003-07-17 | ABM | Stock | 16.1 | 16.23 | 15.82 | 15.84 | 105400.0 |
| 2003-07-17 | ABMD-DELISTED | Stock | 5.77 | 5.89 | 5.47 | 5.53 | 58736.0 |
| 2003-07-17 | ABP-DELISTED | Stock | 1.03 | 1.04 | 1.01 | 1.01 | 17100.0 |
| 2003-07-17 | ABT | Stock | 19.0379 | 19.2803 | 18.6788 | 18.8763 | 6512574.0 |
| 2003-07-17 | ABTL-DELISTED | Stock | 32.55 | 33.7 | 30.8 | 31.75 | 47600.0 |
| 2003-07-17 | ABV-DELISTED | Stock | 20.68 | 20.8 | 20.26 | 20.39 | 260400.0 |
| 2003-07-17 | ABVA-DELISTED | Stock | 17.77 | 18.0 | 17.77 | 18.0 | 400.0 |
| 2003-07-17 | ABX-DELISTED | Stock | 16.8 | 17.05 | 16.78 | 16.98 | 1288700.0 |
| 2003-07-17 | ACAP-DELISTED | Stock | 26.66 | 26.66 | 25.5 | 25.5 | 15190.0 |
| 2003-07-17 | ACAS-DELISTED | Stock | 27.69 | 27.7 | 27.04 | 27.24 | 375454.0 |
| 2003-07-17 | ACAT-DELISTED | Stock | 20.05 | 21.0 | 19.25 | 19.32 | 43400.0 |
| 2003-07-17 | ACCL-DELISTED | Stock | 7.11999988555908 | 7.13299989700317 | 6.87200021743774 | 7.05299997329712 | 111700.0 |
| 2003-07-17 | ACE-DELISTED | Stock | 33.59 | 33.7 | 32.98 | 33.11 | 1568600.0 |
| 2003-07-17 | ACF-DELISTED | Stock | 9.05 | 9.12 | 8.3 | 8.54 | 3035800.0 |
| 2003-07-17 | ACG-DELISTED | Stock | 8.38 | 8.54 | 8.34 | 8.51 | 1333000.0 |
| 2003-07-17 | ACGL | Stock | 3.9167 | 3.9344 | 3.7911 | 3.8111 | 1553400.0 |
| 2003-07-17 | ACGN-DELISTED | Stock | 1122.0 | 1122.0 | 1020.0 | 1076.6712 | 25000.0 |
| 2003-07-17 | ACH | Stock | 15.3933 | 15.9333 | 15.3933 | 15.8 | 1287750.0 |
| 2003-07-17 | ACH-DELISTED | Stock | 7.25 | 7.25 | 7.15 | 7.175 | 32800.0 |
| 2003-07-17 | ACLS | Stock | 32.8 | 33.0 | 30.88 | 31.2 | 540600.0 |
| 2003-07-17 | ACO-DELISTED | Stock | 9.7 | 9.75 | 9.25 | 9.48 | 82700.0 |
| 2003-07-17 | ACPW-DELISTED | Stock | 8.3 | 8.5 | 8.0 | 8.0 | 7231.0 |
| 2003-07-17 | ACS-DELISTED | Stock | 44.85 | 44.97 | 43.95 | 44.2 | 1478100.0 |
| 2003-07-17 | ACTA-DELISTED | Stock | 11.8 | 11.8 | 11.2 | 11.2 | 460700.0 |
| 2003-07-17 | ACTG | Stock | 1.77 | 1.78 | 1.5 | 1.62 | 105500.0 |
| 2003-07-17 | ACTI-DELISTED | Stock | 9.39 | 9.4 | 9.21 | 9.21 | 74800.0 |
| 2003-07-17 | ACTT-DELISTED | Stock | 2.1 | 2.14 | 1.93 | 2.0 | 22390.0 |
> showing 50 of 3,387 rows — these rows as CSV