PREVIEW / stock_daily / 2004-10-27
file: by_date/stock_daily/2004/2004-10-27.parquet size: 129 KB rows: 3,858 symbols: 2,413
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-10-27 | AAPL | Stock | 0.8663 | 0.9039 | 0.8602 | 0.8982 | 1193494400.0 |
| 2004-10-27 | MSFT | Stock | 27.86 | 28.35 | 27.58 | 28.15 | 72392600.0 |
| 2004-10-27 | NVDA | Stock | 0.1186 | 0.1263 | 0.1186 | 0.1241 | 1074036000.0 |
| 2004-10-27 | AMZN | Stock | 1.6815 | 1.7315 | 1.681 | 1.7115 | 181214000.0 |
| 2004-10-27 | CL | Stock | 22.69 | 22.755 | 22.4 | 22.71 | 5769200.0 |
| 2004-10-27 | A | Stock | 17.3319 | 17.9614 | 17.2675 | 17.8684 | 3719798.0 |
| 2004-10-27 | AABA-DELISTED | Stock | 34.9000015258789 | 36.5200004577637 | 34.8499984741211 | 36.1800003051758 | 20968100.0 |
| 2004-10-27 | AACC-DELISTED | Stock | 19.23 | 19.56 | 19.13 | 19.18 | 72625.0 |
| 2004-10-27 | AAI-DELISTED | Stock | 10.75 | 11.89 | 10.63 | 11.64 | 4329200.0 |
| 2004-10-27 | AAIC-DELISTED | Stock | 373.0 | 373.2 | 350.0 | 360.2 | 3142200.0 |
| 2004-10-27 | AAON | Stock | 1.9727 | 2.0016 | 1.97 | 1.9885 | 167062.0 |
| 2004-10-27 | AAP | Stock | 25.9 | 26.18 | 25.8667 | 26.1067 | 1581900.0 |
| 2004-10-27 | AAV-DELISTED | Stock | 17.44 | 17.97 | 17.34 | 17.44 | 16800.0 |
| 2004-10-27 | AAXN-DELISTED | Stock | 21.7150001525879 | 21.75 | 21.0650005340576 | 21.1200008392334 | 8754800.0 |
| 2004-10-27 | ABAX-DELISTED | Stock | 12.69 | 13.27 | 12.41 | 12.91 | 187390.0 |
| 2004-10-27 | ABB-DELISTED | Stock | 6.57 | 6.73 | 6.56 | 6.7 | 581700.0 |
| 2004-10-27 | ABC-DELISTED | Stock | 13.3 | 13.96 | 13.3 | 13.85 | 19224000.0 |
| 2004-10-27 | ABCB | Stock | 16.3971 | 17.1266 | 16.2107 | 17.1023 | 12338.0 |
| 2004-10-27 | ABCO-DELISTED | Stock | 15.985 | 15.985 | 15.595 | 15.895 | 125386.0 |
| 2004-10-27 | ABCW-DELISTED | Stock | 26.17 | 26.25 | 25.44 | 26.25 | 50850.0 |
| 2004-10-27 | ABE-DELISTED | Stock | 8.17 | 8.41 | 8.17 | 8.37 | 30000.0 |
| 2004-10-27 | ABFS-DELISTED | Stock | 38.82 | 39.69 | 38.28 | 39.05 | 466168.0 |
| 2004-10-27 | ABG | Stock | 13.15 | 13.81 | 13.15 | 13.75 | 29200.0 |
| 2004-10-27 | ABK-DELISTED | Stock | 76.17 | 77.97 | 75.55 | 77.7 | 544900.0 |
| 2004-10-27 | ABM | Stock | 20.36 | 20.87 | 20.32 | 20.87 | 156000.0 |
| 2004-10-27 | ABMD-DELISTED | Stock | 11.0 | 11.72 | 10.77 | 11.69 | 195726.0 |
| 2004-10-27 | ABP-DELISTED | Stock | 2.65 | 2.77 | 2.6 | 2.64 | 228100.0 |
| 2004-10-27 | ABR | Stock | 20.9 | 21.0 | 20.6 | 20.9 | 25700.0 |
| 2004-10-27 | ABT | Stock | 19.5998 | 20.4251 | 19.5998 | 20.3579 | 10123176.0 |
| 2004-10-27 | ABTL-DELISTED | Stock | 32.55 | 34.9 | 31.4 | 34.2 | 345400.0 |
| 2004-10-27 | ABV-DELISTED | Stock | 23.92 | 24.05 | 23.7 | 24.0 | 281100.0 |
| 2004-10-27 | ABVA-DELISTED | Stock | 15.0 | 15.0 | 15.0 | 15.0 | 100.0 |
| 2004-10-27 | ABVT-DELISTED | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 16800.0 |
| 2004-10-27 | ABX-DELISTED | Stock | 22.45 | 22.62 | 22.14 | 22.18 | 2423700.0 |
| 2004-10-27 | ACAD | Stock | 6.85 | 7.64 | 6.85 | 7.64 | 16800.0 |
| 2004-10-27 | ACAP-DELISTED | Stock | 31.6 | 32.39 | 31.51 | 32.39 | 31922.0 |
| 2004-10-27 | ACAS-DELISTED | Stock | 30.19 | 30.67 | 30.08 | 30.63 | 644385.0 |
| 2004-10-27 | ACAT-DELISTED | Stock | 24.2 | 24.71 | 24.05 | 24.68 | 95278.0 |
| 2004-10-27 | ACC-DELISTED | Stock | 19.18 | 19.35 | 18.9 | 19.0 | 70200.0 |
| 2004-10-27 | ACCL-DELISTED | Stock | 6.11 | 6.25 | 6.03 | 6.22 | 76255.0 |
| 2004-10-27 | ACE-DELISTED | Stock | 36.93 | 37.47 | 36.31 | 37.1 | 2027000.0 |
| 2004-10-27 | ACF-DELISTED | Stock | 19.0 | 19.5 | 18.77 | 19.45 | 1303800.0 |
| 2004-10-27 | ACFC-DELISTED | Stock | 65.71 | 65.82 | 64.69 | 65.82 | 4771.0 |
| 2004-10-27 | ACG-DELISTED | Stock | 8.16 | 8.18 | 8.15 | 8.16 | 358200.0 |
| 2004-10-27 | ACGL | Stock | 4.0022 | 4.12 | 4.0022 | 4.1167 | 1668600.0 |
| 2004-10-27 | ACGN-DELISTED | Stock | 646.0 | 646.0 | 612.0 | 634.6712 | 48000.0 |
| 2004-10-27 | ACH | Stock | 17.08 | 17.88 | 16.8467 | 17.88 | 255450.0 |
| 2004-10-27 | ACH-DELISTED | Stock | 15.249 | 15.327 | 14.987 | 15.172 | 521443.0 |
| 2004-10-27 | ACLS | Stock | 31.56 | 33.88 | 31.4 | 33.8 | 326950.0 |
| 2004-10-27 | ACO-DELISTED | Stock | 17.9 | 18.16 | 17.75 | 18.16 | 115900.0 |
> showing 50 of 3,858 rows — these rows as CSV