PREVIEW / stock_daily / 2004-11-16
file: by_date/stock_daily/2004/2004-11-16.parquet size: 131 KB rows: 3,907 symbols: 2,446
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-11-16 | AAPL | Stock | 0.985 | 0.9857 | 0.9729 | 0.9811 | 295103200.0 |
| 2004-11-16 | MSFT | Stock | 27.33 | 27.34 | 27.05 | 27.12 | 64522600.0 |
| 2004-11-16 | NVDA | Stock | 0.1536 | 0.1552 | 0.1497 | 0.1526 | 472728000.0 |
| 2004-11-16 | AMZN | Stock | 2.025 | 2.033 | 1.9875 | 2.0035 | 128026000.0 |
| 2004-11-16 | CL | Stock | 23.95 | 24.195 | 23.85 | 24.07 | 4716800.0 |
| 2004-11-16 | A | Stock | 16.1731 | 16.4735 | 16.1373 | 16.4163 | 4765502.0 |
| 2004-11-16 | AABA-DELISTED | Stock | 37.2900009155273 | 37.4099998474121 | 36.560001373291 | 36.7400016784668 | 15160100.0 |
| 2004-11-16 | AACC-DELISTED | Stock | 18.44 | 18.7 | 18.31 | 18.31 | 12894.0 |
| 2004-11-16 | AAI-DELISTED | Stock | 12.8 | 12.9 | 12.7 | 12.77 | 983000.0 |
| 2004-11-16 | AAIC-DELISTED | Stock | 356.8 | 357.0 | 352.0 | 353.0 | 959300.0 |
| 2004-11-16 | AAME | Stock | 3.06 | 3.06 | 3.05 | 3.06 | 1800.0 |
| 2004-11-16 | AAON | Stock | 2.0912 | 2.1663 | 2.0912 | 2.1399 | 130612.0 |
| 2004-11-16 | AAP | Stock | 28.0667 | 28.1 | 27.78 | 28.0333 | 940500.0 |
| 2004-11-16 | AAV-DELISTED | Stock | 17.61 | 17.75 | 17.51 | 17.61 | 29600.0 |
| 2004-11-16 | AAXN-DELISTED | Stock | 29.9699993133545 | 30.4349994659424 | 29.2849998474121 | 29.8299999237061 | 17100000.0 |
| 2004-11-16 | ABAX-DELISTED | Stock | 12.87 | 12.87 | 12.46 | 12.7 | 102007.0 |
| 2004-11-16 | ABB-DELISTED | Stock | 5.99 | 6.01 | 5.93 | 6.0 | 326300.0 |
| 2004-11-16 | ABC-DELISTED | Stock | 14.76 | 14.775 | 14.58 | 14.59 | 3781600.0 |
| 2004-11-16 | ABCB | Stock | 17.1509 | 17.7345 | 17.1509 | 17.2887 | 5182.0 |
| 2004-11-16 | ABCO-DELISTED | Stock | 17.445 | 17.66 | 17.125 | 17.165 | 437418.0 |
| 2004-11-16 | ABCW-DELISTED | Stock | 28.7 | 29.14 | 28.38 | 28.95 | 94000.0 |
| 2004-11-16 | ABE-DELISTED | Stock | 9.06 | 9.09 | 8.9 | 9.04 | 19300.0 |
| 2004-11-16 | ABFS-DELISTED | Stock | 40.71 | 40.96 | 40.18 | 40.2 | 132086.0 |
| 2004-11-16 | ABG | Stock | 14.0 | 14.0 | 13.06 | 13.47 | 45000.0 |
| 2004-11-16 | ABK-DELISTED | Stock | 80.41 | 80.78 | 79.79 | 79.79 | 369600.0 |
| 2004-11-16 | ABM | Stock | 21.7 | 21.97 | 21.59 | 21.65 | 79800.0 |
| 2004-11-16 | ABMD-DELISTED | Stock | 15.5 | 15.85 | 15.45 | 15.77 | 84289.0 |
| 2004-11-16 | ABP-DELISTED | Stock | 2.68 | 2.68 | 2.57 | 2.59 | 90800.0 |
| 2004-11-16 | ABR | Stock | 21.74 | 21.96 | 21.57 | 21.85 | 103500.0 |
| 2004-11-16 | ABT | Stock | 21.3463 | 21.4567 | 21.1832 | 21.2024 | 6089621.0 |
| 2004-11-16 | ABTL-DELISTED | Stock | 32.0 | 34.15 | 31.5 | 32.65 | 280300.0 |
| 2004-11-16 | ABV-DELISTED | Stock | 24.25 | 24.4 | 24.2 | 24.38 | 183300.0 |
| 2004-11-16 | ABVA-DELISTED | Stock | 14.7 | 14.7 | 14.7 | 14.7 | 1000.0 |
| 2004-11-16 | ABVT-DELISTED | Stock | 26.23 | 30.0 | 26.23 | 29.5 | 8600.0 |
| 2004-11-16 | ABX-DELISTED | Stock | 23.15 | 23.39 | 23.12 | 23.35 | 2031800.0 |
| 2004-11-16 | ACAD | Stock | 7.03 | 7.33 | 7.03 | 7.2 | 2500.0 |
| 2004-11-16 | ACAP-DELISTED | Stock | 33.84 | 33.84 | 33.34 | 33.53 | 43734.0 |
| 2004-11-16 | ACAS-DELISTED | Stock | 31.44 | 31.5 | 31.19 | 31.28 | 623516.0 |
| 2004-11-16 | ACAT-DELISTED | Stock | 25.92 | 26.14 | 25.58 | 25.58 | 35223.0 |
| 2004-11-16 | ACC-DELISTED | Stock | 19.3 | 19.9 | 19.3 | 19.84 | 88100.0 |
| 2004-11-16 | ACCL-DELISTED | Stock | 6.75 | 6.75 | 6.44 | 6.46 | 78622.0 |
| 2004-11-16 | ACE-DELISTED | Stock | 38.76 | 38.96 | 38.5 | 38.71 | 1749168.0 |
| 2004-11-16 | ACF-DELISTED | Stock | 21.05 | 21.05 | 20.63 | 20.81 | 1185800.0 |
| 2004-11-16 | ACFC-DELISTED | Stock | 66.89 | 67.55 | 66.89 | 67.55 | 1773.0 |
| 2004-11-16 | ACG-DELISTED | Stock | 8.14 | 8.16 | 8.13 | 8.14 | 383000.0 |
| 2004-11-16 | ACGL | Stock | 4.2411 | 4.2644 | 4.2256 | 4.2356 | 913500.0 |
| 2004-11-16 | ACGN-DELISTED | Stock | 521.3288 | 532.6712 | 498.6712 | 521.3288 | 153900.0 |
| 2004-11-16 | ACH | Stock | 18.5267 | 18.6667 | 18.36 | 18.4267 | 160200.0 |
| 2004-11-16 | ACH-DELISTED | Stock | 15.501 | 15.591 | 15.375 | 15.448 | 427198.0 |
| 2004-11-16 | ACLS | Stock | 28.24 | 28.64 | 27.68 | 27.84 | 199075.0 |
> showing 50 of 3,907 rows — these rows as CSV