PREVIEW / stock_daily / 2004-09-01
file: by_date/stock_daily/2004/2004-09-01.parquet size: 127 KB rows: 3,800 symbols: 2,372
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-01 | AAPL | Stock | 0.6125 | 0.6427 | 0.6105 | 0.6404 | 515726400.0 |
| 2004-09-01 | MSFT | Stock | 27.23 | 27.52 | 27.14 | 27.39 | 48507500.0 |
| 2004-09-01 | NVDA | Stock | 0.1025 | 0.1073 | 0.1012 | 0.1058 | 591744000.0 |
| 2004-09-01 | AMZN | Stock | 1.9115 | 1.9505 | 1.901 | 1.912 | 105050000.0 |
| 2004-09-01 | CL | Stock | 26.955 | 27.275 | 26.885 | 27.195 | 1967200.0 |
| 2004-09-01 | A | Stock | 14.6137 | 14.9857 | 14.4707 | 14.7997 | 4618992.0 |
| 2004-09-01 | AABA-DELISTED | Stock | 28.3899993896484 | 29.0400009155273 | 28.1299991607666 | 29.0100002288818 | 16668100.0 |
| 2004-09-01 | AACC-DELISTED | Stock | 17.61 | 18.63 | 17.24 | 17.35 | 65328.0 |
| 2004-09-01 | AAI-DELISTED | Stock | 12.07 | 12.52 | 11.94 | 12.08 | 1469400.0 |
| 2004-09-01 | AAIC-DELISTED | Stock | 377.0 | 379.4 | 372.6 | 375.8 | 1330100.0 |
| 2004-09-01 | AAME | Stock | 3.01 | 3.01 | 2.98 | 3.0 | 10500.0 |
| 2004-09-01 | AAON | Stock | 2.2914 | 2.4309 | 2.2137 | 2.2255 | 190603.0 |
| 2004-09-01 | AAP | Stock | 24.7067 | 24.9133 | 24.64 | 24.8933 | 771750.0 |
| 2004-09-01 | AAV-DELISTED | Stock | 15.13 | 15.17 | 14.96 | 15.13 | 26300.0 |
| 2004-09-01 | AAXN-DELISTED | Stock | 13.6049995422363 | 14.085000038147 | 13.5950002670288 | 13.875 | 3569800.0 |
| 2004-09-01 | ABAX-DELISTED | Stock | 15.32 | 15.95 | 14.85 | 14.9 | 302256.0 |
| 2004-09-01 | ABB-DELISTED | Stock | 5.79 | 5.88 | 5.756 | 5.81 | 189000.0 |
| 2004-09-01 | ABC-DELISTED | Stock | 13.56 | 13.8 | 13.55 | 13.78 | 4765483.0 |
| 2004-09-01 | ABCB | Stock | 14.8733 | 15.2705 | 14.4275 | 14.4762 | 24429.0 |
| 2004-09-01 | ABCO-DELISTED | Stock | 16.037 | 16.452 | 15.748 | 16.003 | 206441.0 |
| 2004-09-01 | ABCW-DELISTED | Stock | 25.24 | 25.91 | 25.24 | 25.49 | 36530.0 |
| 2004-09-01 | ABE-DELISTED | Stock | 7.74 | 7.8 | 7.74 | 7.78 | 16100.0 |
| 2004-09-01 | ABFS-DELISTED | Stock | 34.54 | 35.3 | 33.9 | 33.98 | 379375.0 |
| 2004-09-01 | ABG | Stock | 13.65 | 14.35 | 13.42 | 13.42 | 43900.0 |
| 2004-09-01 | ABK-DELISTED | Stock | 75.4 | 75.4 | 74.81 | 75.2 | 315700.0 |
| 2004-09-01 | ABM | Stock | 17.86 | 18.4 | 17.86 | 18.39 | 152300.0 |
| 2004-09-01 | ABMD-DELISTED | Stock | 9.74 | 10.44 | 9.57 | 10.05 | 82833.0 |
| 2004-09-01 | ABP-DELISTED | Stock | 1.64 | 1.65 | 1.55 | 1.59 | 59300.0 |
| 2004-09-01 | ABR | Stock | 20.8 | 21.0 | 20.75 | 20.75 | 108600.0 |
| 2004-09-01 | ABT | Stock | 20.0029 | 20.1996 | 19.9213 | 20.1804 | 6553356.0 |
| 2004-09-01 | ABTL-DELISTED | Stock | 34.85 | 38.1 | 34.85 | 35.0 | 48000.0 |
| 2004-09-01 | ABV-DELISTED | Stock | 21.8 | 21.95 | 21.37 | 21.5 | 310800.0 |
| 2004-09-01 | ABX-DELISTED | Stock | 20.0 | 20.25 | 19.77 | 20.25 | 1059900.0 |
| 2004-09-01 | ACAD | Stock | 6.45 | 6.89 | 6.38 | 6.89 | 8200.0 |
| 2004-09-01 | ACAP-DELISTED | Stock | 27.5 | 28.49 | 27.0 | 27.16 | 135948.0 |
| 2004-09-01 | ACAS-DELISTED | Stock | 31.05 | 31.68 | 31.01 | 31.55 | 682307.0 |
| 2004-09-01 | ACAT-DELISTED | Stock | 26.12 | 27.74 | 25.9 | 26.39 | 137028.0 |
| 2004-09-01 | ACC-DELISTED | Stock | 17.85 | 17.9 | 17.63 | 17.85 | 94400.0 |
| 2004-09-01 | ACCL-DELISTED | Stock | 5.69 | 6.44 | 5.69 | 6.13 | 172204.0 |
| 2004-09-01 | ACE-DELISTED | Stock | 38.38 | 38.38 | 37.37 | 37.5 | 1743000.0 |
| 2004-09-01 | ACF-DELISTED | Stock | 20.8 | 20.99 | 20.65 | 20.81 | 924000.0 |
| 2004-09-01 | ACG-DELISTED | Stock | 8.15 | 8.15 | 8.1 | 8.12 | 367000.0 |
| 2004-09-01 | ACGL | Stock | 4.0678 | 4.1244 | 4.0589 | 4.1244 | 2124900.0 |
| 2004-09-01 | ACGN-DELISTED | Stock | 612.0 | 646.0 | 566.6712 | 646.0 | 383400.0 |
| 2004-09-01 | ACH | Stock | 16.5 | 16.62 | 16.2 | 16.42 | 104250.0 |
| 2004-09-01 | ACH-DELISTED | Stock | 12.374 | 12.549 | 12.349 | 12.496 | 212005.0 |
| 2004-09-01 | ACLS | Stock | 31.6 | 33.88 | 30.88 | 31.4 | 517675.0 |
| 2004-09-01 | ACO-DELISTED | Stock | 16.96 | 17.3 | 16.71 | 17.09 | 115200.0 |
| 2004-09-01 | ACPW-DELISTED | Stock | 14.801 | 15.004 | 14.038 | 14.75 | 14604.0 |
| 2004-09-01 | ACS-DELISTED | Stock | 54.38 | 55.03 | 54.18 | 54.64 | 643000.0 |
> showing 50 of 3,800 rows — these rows as CSV