PREVIEW / stock_daily / 2004-08-19
file: by_date/stock_daily/2004/2004-08-19.parquet size: 127 KB rows: 3,801 symbols: 2,370
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-08-19 | AAPL | Stock | 0.5627 | 0.5689 | 0.5421 | 0.5484 | 388920000.0 |
| 2004-08-19 | MSFT | Stock | 27.35 | 27.45 | 27.01 | 27.12 | 46293000.0 |
| 2004-08-19 | NVDA | Stock | 0.0969 | 0.0987 | 0.0957 | 0.0972 | 724404000.0 |
| 2004-08-19 | AMZN | Stock | 2.013 | 2.024 | 1.8175 | 1.9315 | 253922000.0 |
| 2004-08-19 | CL | Stock | 25.975 | 25.995 | 25.705 | 25.94 | 2802200.0 |
| 2004-08-19 | A | Stock | 15.5722 | 15.7225 | 15.4506 | 15.6009 | 3080353.0 |
| 2004-08-19 | AABA-DELISTED | Stock | 28.3400001525879 | 28.9699993133545 | 27.8999996185303 | 28.1100006103516 | 27657500.0 |
| 2004-08-19 | AACC-DELISTED | Stock | 17.81 | 18.25 | 17.56 | 17.85 | 54847.0 |
| 2004-08-19 | AAI-DELISTED | Stock | 11.48 | 11.48 | 10.89 | 10.94 | 1438100.0 |
| 2004-08-19 | AAIC-DELISTED | Stock | 346.2 | 348.8 | 340.4 | 341.2 | 908400.0 |
| 2004-08-19 | AAME | Stock | 2.98 | 3.07 | 2.97 | 3.01 | 2000.0 |
| 2004-08-19 | AAON | Stock | 2.2163 | 2.3546 | 2.2163 | 2.3072 | 117703.0 |
| 2004-08-19 | AAP | Stock | 23.8 | 24.1533 | 23.68 | 24.1533 | 1203450.0 |
| 2004-08-19 | AAV-DELISTED | Stock | 14.69 | 14.69 | 14.38 | 14.69 | 33900.0 |
| 2004-08-19 | AAXN-DELISTED | Stock | 13.7399997711182 | 14.0950002670288 | 13.5150003433228 | 13.875 | 6184400.0 |
| 2004-08-19 | ABAX-DELISTED | Stock | 14.27 | 14.5 | 14.02 | 14.04 | 171485.0 |
| 2004-08-19 | ABB-DELISTED | Stock | 5.59 | 5.59 | 5.5 | 5.51 | 88300.0 |
| 2004-08-19 | ABC-DELISTED | Stock | 13.1 | 13.2 | 13.0 | 13.2 | 5741600.0 |
| 2004-08-19 | ABCB | Stock | 14.2087 | 14.2087 | 14.0709 | 14.0709 | 5675.0 |
| 2004-08-19 | ABCO-DELISTED | Stock | 15.192 | 15.252 | 14.983 | 15.088 | 144221.0 |
| 2004-08-19 | ABCW-DELISTED | Stock | 25.36 | 25.6 | 25.12 | 25.19 | 49110.0 |
| 2004-08-19 | ABE-DELISTED | Stock | 7.5 | 7.8 | 7.5 | 7.7 | 14800.0 |
| 2004-08-19 | ABFS-DELISTED | Stock | 36.65 | 36.75 | 35.6 | 35.86 | 205956.0 |
| 2004-08-19 | ABG | Stock | 12.9 | 13.2 | 12.82 | 13.15 | 21100.0 |
| 2004-08-19 | ABK-DELISTED | Stock | 71.95 | 72.77 | 71.73 | 72.77 | 395700.0 |
| 2004-08-19 | ABM | Stock | 17.8 | 17.9 | 17.53 | 17.7 | 62400.0 |
| 2004-08-19 | ABMD-DELISTED | Stock | 10.06 | 10.06 | 9.54 | 9.68 | 55667.0 |
| 2004-08-19 | ABP-DELISTED | Stock | 1.8 | 1.86 | 1.78 | 1.83 | 122900.0 |
| 2004-08-19 | ABR | Stock | 20.0 | 20.1 | 19.9 | 19.98 | 217400.0 |
| 2004-08-19 | ABT | Stock | 19.4415 | 19.5758 | 19.312 | 19.5327 | 7430805.0 |
| 2004-08-19 | ABTL-DELISTED | Stock | 32.0 | 32.5 | 31.6 | 31.7 | 47400.0 |
| 2004-08-19 | ABV-DELISTED | Stock | 22.05 | 22.37 | 22.05 | 22.36 | 309500.0 |
| 2004-08-19 | ABVA-DELISTED | Stock | 14.65 | 14.86 | 14.45 | 14.63 | 5800.0 |
| 2004-08-19 | ABX-DELISTED | Stock | 19.5 | 20.09 | 19.5 | 19.99 | 2385400.0 |
| 2004-08-19 | ACAD | Stock | 5.7 | 5.7 | 5.45 | 5.6 | 2200.0 |
| 2004-08-19 | ACAP-DELISTED | Stock | 27.75 | 27.75 | 27.1 | 27.42 | 80799.0 |
| 2004-08-19 | ACAS-DELISTED | Stock | 31.44 | 31.52 | 31.15 | 31.33 | 661013.0 |
| 2004-08-19 | ACAT-DELISTED | Stock | 25.9 | 26.09 | 25.63 | 25.92 | 79155.0 |
| 2004-08-19 | ACC-DELISTED | Stock | 17.1 | 17.4 | 17.09 | 17.09 | 63700.0 |
| 2004-08-19 | ACCL-DELISTED | Stock | 6.67 | 6.67 | 6.31 | 6.359 | 65014.0 |
| 2004-08-19 | ACE-DELISTED | Stock | 39.32 | 39.45 | 39.03 | 39.42 | 576815.0 |
| 2004-08-19 | ACF-DELISTED | Stock | 20.77 | 20.81 | 20.25 | 20.35 | 1327600.0 |
| 2004-08-19 | ACG-DELISTED | Stock | 8.35 | 8.37 | 8.33 | 8.34 | 320500.0 |
| 2004-08-19 | ACGL | Stock | 4.19 | 4.1989 | 4.1756 | 4.1811 | 1609200.0 |
| 2004-08-19 | ACGN-DELISTED | Stock | 623.3288 | 623.3288 | 566.6712 | 623.3288 | 20100.0 |
| 2004-08-19 | ACH | Stock | 16.84 | 16.84 | 16.2933 | 16.4267 | 118950.0 |
| 2004-08-19 | ACH-DELISTED | Stock | 11.837 | 11.974 | 11.782 | 11.894 | 643079.0 |
| 2004-08-19 | ACLS | Stock | 34.76 | 35.6 | 34.44 | 34.6 | 135725.0 |
| 2004-08-19 | ACO-DELISTED | Stock | 17.65 | 17.91 | 17.47 | 17.49 | 173300.0 |
| 2004-08-19 | ACPW-DELISTED | Stock | 14.2 | 14.65 | 14.2 | 14.25 | 17079.0 |
> showing 50 of 3,801 rows — these rows as CSV