PREVIEW / stock_daily / 2004-09-15
file: by_date/stock_daily/2004/2004-09-15.parquet size: 127 KB rows: 3,789 symbols: 2,359
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-15 | AAPL | Stock | 0.6314 | 0.6336 | 0.6214 | 0.6286 | 232668800.0 |
| 2004-09-15 | MSFT | Stock | 27.36 | 27.4 | 27.14 | 27.19 | 52605700.0 |
| 2004-09-15 | NVDA | Stock | 0.1163 | 0.1167 | 0.1118 | 0.1133 | 1163904000.0 |
| 2004-09-15 | AMZN | Stock | 2.1025 | 2.159 | 2.0935 | 2.1105 | 222716000.0 |
| 2004-09-15 | CL | Stock | 27.175 | 27.25 | 27.01 | 27.185 | 2410200.0 |
| 2004-09-15 | A | Stock | 16.3448 | 16.3519 | 15.8798 | 16.0086 | 2235542.0 |
| 2004-09-15 | AABA-DELISTED | Stock | 32.7000007629395 | 33.4000015258789 | 32.4099998474121 | 32.9000015258789 | 16915900.0 |
| 2004-09-15 | AACC-DELISTED | Stock | 17.62 | 17.75 | 17.33 | 17.46 | 15886.0 |
| 2004-09-15 | AAI-DELISTED | Stock | 11.26 | 11.43 | 11.08 | 11.31 | 1008900.0 |
| 2004-09-15 | AAIC-DELISTED | Stock | 392.4 | 394.6 | 387.0 | 392.6 | 929500.0 |
| 2004-09-15 | AAME | Stock | 3.01 | 3.01 | 3.0 | 3.0 | 2900.0 |
| 2004-09-15 | AAON | Stock | 2.377 | 2.4362 | 2.3269 | 2.4362 | 123778.0 |
| 2004-09-15 | AAP | Stock | 23.88 | 24.02 | 23.7533 | 23.8333 | 1213500.0 |
| 2004-09-15 | AAV-DELISTED | Stock | 15.64 | 15.74 | 15.46 | 15.64 | 46400.0 |
| 2004-09-15 | AAXN-DELISTED | Stock | 17.9850006103516 | 23.0 | 17.7999992370605 | 21.5450000762939 | 80313400.0 |
| 2004-09-15 | ABAX-DELISTED | Stock | 14.46 | 14.63 | 14.16 | 14.38 | 46554.0 |
| 2004-09-15 | ABB-DELISTED | Stock | 6.08 | 6.11 | 5.99 | 6.09 | 371600.0 |
| 2004-09-15 | ABC-DELISTED | Stock | 13.69 | 13.76 | 13.63 | 13.68 | 4628400.0 |
| 2004-09-15 | ABCB | Stock | 15.5055 | 15.5542 | 15.1246 | 15.5542 | 18383.0 |
| 2004-09-15 | ABCO-DELISTED | Stock | 16.93 | 17.13 | 16.7 | 16.85 | 160139.0 |
| 2004-09-15 | ABCW-DELISTED | Stock | 25.54 | 25.88 | 25.46 | 25.88 | 38250.0 |
| 2004-09-15 | ABE-DELISTED | Stock | 7.85 | 7.85 | 7.77 | 7.8 | 10100.0 |
| 2004-09-15 | ABFS-DELISTED | Stock | 35.92 | 35.94 | 35.34 | 35.83 | 178239.0 |
| 2004-09-15 | ABG | Stock | 14.16 | 14.16 | 13.63 | 13.71 | 26900.0 |
| 2004-09-15 | ABK-DELISTED | Stock | 77.95 | 78.55 | 77.43 | 77.58 | 336800.0 |
| 2004-09-15 | ABM | Stock | 19.58 | 20.13 | 19.58 | 19.92 | 192000.0 |
| 2004-09-15 | ABMD-DELISTED | Stock | 11.17 | 11.17 | 10.75 | 10.83 | 63733.0 |
| 2004-09-15 | ABP-DELISTED | Stock | 1.8 | 1.81 | 1.78 | 1.78 | 33600.0 |
| 2004-09-15 | ABR | Stock | 21.48 | 21.7 | 21.16 | 21.16 | 51600.0 |
| 2004-09-15 | ABT | Stock | 20.5594 | 20.665 | 20.3867 | 20.3963 | 6595456.0 |
| 2004-09-15 | ABTL-DELISTED | Stock | 39.75 | 39.8 | 38.1 | 39.05 | 50500.0 |
| 2004-09-15 | ABV-DELISTED | Stock | 21.5 | 21.63 | 21.02 | 21.05 | 1086500.0 |
| 2004-09-15 | ABVA-DELISTED | Stock | 15.4 | 15.4 | 14.95 | 15.141 | 3150.0 |
| 2004-09-15 | ABVT-DELISTED | Stock | 23.0 | 23.1 | 23.0 | 23.0 | 34100.0 |
| 2004-09-15 | ABX-DELISTED | Stock | 19.72 | 19.77 | 19.59 | 19.59 | 614600.0 |
| 2004-09-15 | ACAD | Stock | 7.89 | 7.95 | 7.69 | 7.95 | 15600.0 |
| 2004-09-15 | ACAP-DELISTED | Stock | 31.5 | 31.5 | 31.01 | 31.02 | 68188.0 |
| 2004-09-15 | ACAS-DELISTED | Stock | 32.02 | 32.06 | 31.54 | 31.82 | 759280.0 |
| 2004-09-15 | ACAT-DELISTED | Stock | 26.1 | 26.27 | 25.96 | 26.1 | 76721.0 |
| 2004-09-15 | ACC-DELISTED | Stock | 18.11 | 18.25 | 17.9 | 18.24 | 58200.0 |
| 2004-09-15 | ACCL-DELISTED | Stock | 6.7 | 6.7 | 6.13 | 6.3 | 156579.0 |
| 2004-09-15 | ACE-DELISTED | Stock | 39.38 | 40.3 | 39.0 | 39.77 | 1382400.0 |
| 2004-09-15 | ACF-DELISTED | Stock | 20.85 | 20.86 | 20.39 | 20.6 | 641200.0 |
| 2004-09-15 | ACG-DELISTED | Stock | 8.09 | 8.11 | 8.08 | 8.11 | 315100.0 |
| 2004-09-15 | ACGL | Stock | 4.4111 | 4.4567 | 4.4078 | 4.4411 | 3537900.0 |
| 2004-09-15 | ACGN-DELISTED | Stock | 612.0 | 623.3288 | 589.3288 | 623.3288 | 71000.0 |
| 2004-09-15 | ACH | Stock | 16.7333 | 16.9133 | 16.6333 | 16.7867 | 68250.0 |
| 2004-09-15 | ACH-DELISTED | Stock | 12.463 | 12.55 | 12.263 | 12.275 | 280400.0 |
| 2004-09-15 | ACLS | Stock | 33.32 | 33.32 | 31.48 | 32.32 | 213600.0 |
| 2004-09-15 | ACO-DELISTED | Stock | 17.4 | 17.75 | 17.26 | 17.28 | 117300.0 |
> showing 50 of 3,789 rows — these rows as CSV