PREVIEW / stock_daily / 2004-09-14
file: by_date/stock_daily/2004/2004-09-14.parquet size: 127 KB rows: 3,799 symbols: 2,362
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-14 | AAPL | Stock | 0.6293 | 0.6348 | 0.6211 | 0.6338 | 254822400.0 |
| 2004-09-14 | MSFT | Stock | 27.37 | 27.51 | 27.27 | 27.44 | 55920000.0 |
| 2004-09-14 | NVDA | Stock | 0.1184 | 0.1208 | 0.1175 | 0.12 | 683556000.0 |
| 2004-09-14 | AMZN | Stock | 2.01 | 2.1375 | 1.995 | 2.1335 | 317442000.0 |
| 2004-09-14 | CL | Stock | 27.25 | 27.315 | 26.95 | 27.175 | 2898000.0 |
| 2004-09-14 | A | Stock | 16.3233 | 16.4235 | 16.0014 | 16.3805 | 2627261.0 |
| 2004-09-14 | AABA-DELISTED | Stock | 31.6200008392334 | 33.5499992370605 | 31.4400005340576 | 33.2000007629395 | 28245600.0 |
| 2004-09-14 | AACC-DELISTED | Stock | 18.0 | 18.27 | 17.72 | 17.79 | 9623.0 |
| 2004-09-14 | AAI-DELISTED | Stock | 11.5 | 11.58 | 11.35 | 11.45 | 908100.0 |
| 2004-09-14 | AAIC-DELISTED | Stock | 388.6 | 398.2 | 383.0 | 395.4 | 1230800.0 |
| 2004-09-14 | AAME | Stock | 2.99 | 3.09 | 2.95 | 3.0 | 18100.0 |
| 2004-09-14 | AAON | Stock | 2.319 | 2.4257 | 2.2874 | 2.3914 | 64547.0 |
| 2004-09-14 | AAP | Stock | 24.3733 | 24.3733 | 23.7867 | 23.88 | 1373550.0 |
| 2004-09-14 | AAV-DELISTED | Stock | 15.68 | 16.05 | 15.65 | 15.68 | 24300.0 |
| 2004-09-14 | AAXN-DELISTED | Stock | 17.5450000762939 | 17.7900009155273 | 17.25 | 17.6749992370605 | 17811400.0 |
| 2004-09-14 | ABAX-DELISTED | Stock | 14.85 | 14.85 | 14.39 | 14.71 | 37771.0 |
| 2004-09-14 | ABB-DELISTED | Stock | 6.06 | 6.15 | 6.06 | 6.1 | 193400.0 |
| 2004-09-14 | ABC-DELISTED | Stock | 13.44 | 13.79 | 13.4 | 13.74 | 10555200.0 |
| 2004-09-14 | ABCB | Stock | 15.1408 | 15.4893 | 15.1408 | 15.4893 | 10117.0 |
| 2004-09-14 | ABCO-DELISTED | Stock | 16.91 | 16.91 | 16.71 | 16.79 | 157944.0 |
| 2004-09-14 | ABCW-DELISTED | Stock | 25.79 | 25.93 | 25.52 | 25.8 | 21410.0 |
| 2004-09-14 | ABE-DELISTED | Stock | 7.82 | 7.87 | 7.8 | 7.87 | 12500.0 |
| 2004-09-14 | ABFS-DELISTED | Stock | 36.34 | 36.35 | 35.56 | 35.7 | 174214.0 |
| 2004-09-14 | ABG | Stock | 14.15 | 14.17 | 13.85 | 13.99 | 25200.0 |
| 2004-09-14 | ABK-DELISTED | Stock | 77.68 | 78.04 | 77.42 | 77.88 | 384100.0 |
| 2004-09-14 | ABM | Stock | 20.02 | 20.14 | 19.6 | 19.7 | 115700.0 |
| 2004-09-14 | ABMD-DELISTED | Stock | 11.1 | 11.12 | 10.7 | 11.0 | 62507.0 |
| 2004-09-14 | ABP-DELISTED | Stock | 1.75 | 1.85 | 1.75 | 1.85 | 87700.0 |
| 2004-09-14 | ABR | Stock | 21.45 | 21.5 | 21.25 | 21.48 | 54600.0 |
| 2004-09-14 | ABT | Stock | 20.5594 | 20.6266 | 20.4155 | 20.6026 | 6700083.0 |
| 2004-09-14 | ABTL-DELISTED | Stock | 39.8 | 41.05 | 38.8 | 39.7 | 41300.0 |
| 2004-09-14 | ABV-DELISTED | Stock | 21.29 | 21.4 | 21.05 | 21.1 | 489300.0 |
| 2004-09-14 | ABVA-DELISTED | Stock | 14.95 | 14.96 | 14.95 | 14.96 | 1162.0 |
| 2004-09-14 | ABVT-DELISTED | Stock | 23.28 | 23.28 | 23.0 | 23.0 | 16400.0 |
| 2004-09-14 | ABX-DELISTED | Stock | 19.75 | 19.95 | 19.64 | 19.83 | 1016800.0 |
| 2004-09-14 | ACAD | Stock | 7.75 | 7.95 | 7.6 | 7.76 | 29300.0 |
| 2004-09-14 | ACAP-DELISTED | Stock | 31.49 | 31.49 | 31.1 | 31.11 | 108449.0 |
| 2004-09-14 | ACAS-DELISTED | Stock | 32.04 | 32.2 | 31.82 | 31.98 | 423380.0 |
| 2004-09-14 | ACAT-DELISTED | Stock | 26.22 | 26.22 | 25.83 | 25.98 | 55144.0 |
| 2004-09-14 | ACC-DELISTED | Stock | 18.05 | 18.4 | 18.05 | 18.3 | 61300.0 |
| 2004-09-14 | ACCL-DELISTED | Stock | 6.38 | 6.69 | 6.07 | 6.64 | 100627.0 |
| 2004-09-14 | ACE-DELISTED | Stock | 39.51 | 39.8 | 39.43 | 39.61 | 1136200.0 |
| 2004-09-14 | ACF-DELISTED | Stock | 20.98 | 21.05 | 20.65 | 20.93 | 822000.0 |
| 2004-09-14 | ACG-DELISTED | Stock | 8.09 | 8.1 | 8.07 | 8.1 | 357200.0 |
| 2004-09-14 | ACGL | Stock | 4.3744 | 4.4344 | 4.3744 | 4.4244 | 2098800.0 |
| 2004-09-14 | ACGN-DELISTED | Stock | 623.3288 | 623.3288 | 589.3288 | 589.3288 | 116700.0 |
| 2004-09-14 | ACH | Stock | 16.86 | 16.9933 | 16.6267 | 16.82 | 94200.0 |
| 2004-09-14 | ACH-DELISTED | Stock | 12.228 | 12.501 | 12.216 | 12.458 | 288732.0 |
| 2004-09-14 | ACLS | Stock | 33.44 | 33.64 | 32.44 | 33.44 | 276925.0 |
| 2004-09-14 | ACO-DELISTED | Stock | 17.24 | 17.61 | 17.24 | 17.58 | 64800.0 |
> showing 50 of 3,799 rows — these rows as CSV