PREVIEW / stock_daily / 2004-12-28
file: by_date/stock_daily/2004/2004-12-28.parquet size: 132 KB rows: 3,950 symbols: 2,480
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-12-28 | AAPL | Stock | 1.1304 | 1.1473 | 1.108 | 1.1461 | 611755200.0 |
| 2004-12-28 | MSFT | Stock | 26.85 | 27.03 | 26.8 | 26.95 | 55075900.0 |
| 2004-12-28 | NVDA | Stock | 0.191 | 0.1925 | 0.1888 | 0.1896 | 291612000.0 |
| 2004-12-28 | AMZN | Stock | 2.195 | 2.256 | 2.175 | 2.2315 | 504756000.0 |
| 2004-12-28 | CL | Stock | 25.175 | 25.305 | 25.11 | 25.165 | 2657800.0 |
| 2004-12-28 | A | Stock | 17.0243 | 17.3247 | 17.0243 | 17.1745 | 1716325.0 |
| 2004-12-28 | AABA-DELISTED | Stock | 37.8499984741211 | 37.9900016784668 | 37.6500015258789 | 37.9000015258789 | 11291000.0 |
| 2004-12-28 | AACC-DELISTED | Stock | 21.3 | 21.67 | 21.13 | 21.24 | 9549.0 |
| 2004-12-28 | AAI-DELISTED | Stock | 10.94 | 11.08 | 10.71 | 10.9 | 752600.0 |
| 2004-12-28 | AAIC-DELISTED | Stock | 398.2 | 402.4 | 398.2 | 400.0 | 1166200.0 |
| 2004-12-28 | AAME | Stock | 3.04 | 3.15 | 3.0 | 3.05 | 4800.0 |
| 2004-12-28 | AAON | Stock | 1.9095 | 1.9648 | 1.9095 | 1.9556 | 132891.0 |
| 2004-12-28 | AAP | Stock | 28.0533 | 28.56 | 28.04 | 28.4867 | 8636400.0 |
| 2004-12-28 | AAXN-DELISTED | Stock | 27.7700004577637 | 28.6000003814697 | 27.7299995422363 | 28.4300003051758 | 3698000.0 |
| 2004-12-28 | ABAX-DELISTED | Stock | 14.63 | 14.67 | 14.3 | 14.5 | 83526.0 |
| 2004-12-28 | ABB-DELISTED | Stock | 5.67 | 5.68 | 5.64 | 5.66 | 210600.0 |
| 2004-12-28 | ABBC-DELISTED | Stock | 13.43 | 13.43 | 13.283 | 13.29 | 51564.0 |
| 2004-12-28 | ABC-DELISTED | Stock | 14.17 | 14.4 | 14.14 | 14.38 | 6058000.0 |
| 2004-12-28 | ABCB | Stock | 16.8186 | 17.7427 | 16.8186 | 17.7427 | 9254.0 |
| 2004-12-28 | ABCO-DELISTED | Stock | 18.48 | 19.38 | 18.415 | 19.28 | 387509.0 |
| 2004-12-28 | ABCW-DELISTED | Stock | 29.13 | 29.38 | 28.94 | 29.23 | 40110.0 |
| 2004-12-28 | ABE-DELISTED | Stock | 9.88 | 9.88 | 9.82 | 9.85 | 14400.0 |
| 2004-12-28 | ABFS-DELISTED | Stock | 45.18 | 46.68 | 45.16 | 46.13 | 165837.0 |
| 2004-12-28 | ABG | Stock | 13.65 | 14.0 | 13.65 | 13.99 | 97100.0 |
| 2004-12-28 | ABK-DELISTED | Stock | 82.65 | 83.2 | 82.65 | 83.09 | 192800.0 |
| 2004-12-28 | ABM | Stock | 19.37 | 19.7 | 19.24 | 19.46 | 142400.0 |
| 2004-12-28 | ABMD-DELISTED | Stock | 13.77 | 13.87 | 13.68 | 13.74 | 122619.0 |
| 2004-12-28 | ABP-DELISTED | Stock | 2.3 | 2.42 | 2.3 | 2.4 | 58800.0 |
| 2004-12-28 | ABR | Stock | 24.25 | 24.5 | 24.25 | 24.35 | 31000.0 |
| 2004-12-28 | ABT | Stock | 22.1284 | 22.4067 | 22.1284 | 22.2435 | 4503543.0 |
| 2004-12-28 | ABTL-DELISTED | Stock | 29.05 | 29.05 | 27.65 | 28.8 | 127800.0 |
| 2004-12-28 | ABV-DELISTED | Stock | 27.25 | 27.78 | 27.25 | 27.75 | 45200.0 |
| 2004-12-28 | ABVA-DELISTED | Stock | 15.6 | 15.6 | 15.06 | 15.26 | 4030.0 |
| 2004-12-28 | ABVT-DELISTED | Stock | 33.0 | 36.3 | 32.5 | 36.3 | 33500.0 |
| 2004-12-28 | ABX-DELISTED | Stock | 24.08 | 24.08 | 23.78 | 24.01 | 1169900.0 |
| 2004-12-28 | ACAD | Stock | 6.05 | 6.05 | 5.81 | 5.9 | 53000.0 |
| 2004-12-28 | ACAP-DELISTED | Stock | 36.67 | 37.22 | 36.55 | 37.09 | 47179.0 |
| 2004-12-28 | ACAS-DELISTED | Stock | 33.26 | 33.45 | 33.13 | 33.31 | 441081.0 |
| 2004-12-28 | ACAT-DELISTED | Stock | 26.35 | 27.19 | 26.2 | 27.19 | 39559.0 |
| 2004-12-28 | ACC-DELISTED | Stock | 22.22 | 22.65 | 22.22 | 22.48 | 9200.0 |
| 2004-12-28 | ACCL-DELISTED | Stock | 7.71 | 7.88 | 7.61 | 7.85 | 98763.0 |
| 2004-12-28 | ACE-DELISTED | Stock | 41.75 | 42.59 | 41.75 | 42.55 | 405400.0 |
| 2004-12-28 | ACF-DELISTED | Stock | 24.0 | 24.5 | 23.95 | 24.26 | 1300500.0 |
| 2004-12-28 | ACFC-DELISTED | Stock | 71.17 | 71.43 | 71.07 | 71.43 | 2732.0 |
| 2004-12-28 | ACG-DELISTED | Stock | 8.14 | 8.16 | 8.14 | 8.15 | 311700.0 |
| 2004-12-28 | ACGL | Stock | 4.2578 | 4.3422 | 4.2556 | 4.3056 | 923400.0 |
| 2004-12-28 | ACGN-DELISTED | Stock | 566.6712 | 566.6712 | 532.6712 | 555.3288 | 157400.0 |
| 2004-12-28 | ACH | Stock | 18.1667 | 18.7667 | 18.1667 | 18.66 | 294750.0 |
| 2004-12-28 | ACH-DELISTED | Stock | 14.385 | 14.57 | 14.323 | 14.467 | 358846.0 |
| 2004-12-28 | ACLS | Stock | 31.84 | 32.72 | 31.8 | 32.68 | 146875.0 |
> showing 50 of 3,950 rows — these rows as CSV