PREVIEW / stock_daily / 2004-12-22
file: by_date/stock_daily/2004/2004-12-22.parquet size: 133 KB rows: 3,956 symbols: 2,481
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-22 | AAPL | Stock | 1.1368 | 1.1493 | 1.1321 | 1.1384 | 565829600.0 |
| 2004-12-22 | MSFT | Stock | 26.84 | 27.15 | 26.78 | 26.97 | 63651900.0 |
| 2004-12-22 | NVDA | Stock | 0.1953 | 0.1962 | 0.1913 | 0.1917 | 421824000.0 |
| 2004-12-22 | AMZN | Stock | 1.9305 | 1.9795 | 1.9275 | 1.976 | 105526000.0 |
| 2004-12-22 | CL | Stock | 25.15 | 25.315 | 25.125 | 25.25 | 4247600.0 |
| 2004-12-22 | A | Stock | 17.0601 | 17.289 | 16.9242 | 17.1674 | 2248124.0 |
| 2004-12-22 | AABA-DELISTED | Stock | 36.4700012207031 | 37.3499984741211 | 36.4099998474121 | 37.2900009155273 | 11297700.0 |
| 2004-12-22 | AACC-DELISTED | Stock | 20.62 | 21.84 | 20.62 | 21.16 | 61920.0 |
| 2004-12-22 | AAI-DELISTED | Stock | 10.83 | 11.04 | 10.81 | 10.99 | 1265900.0 |
| 2004-12-22 | AAIC-DELISTED | Stock | 397.0 | 403.2 | 396.0 | 401.6 | 1029500.0 |
| 2004-12-22 | AAME | Stock | 3.01 | 3.01 | 3.0 | 3.0 | 3000.0 |
| 2004-12-22 | AAON | Stock | 1.949 | 1.9819 | 1.9029 | 1.9477 | 185287.0 |
| 2004-12-22 | AAP | Stock | 28.4 | 28.66 | 27.9333 | 27.9333 | 4278600.0 |
| 2004-12-22 | AAV-DELISTED | Stock | 17.94 | 18.28 | 17.85 | 17.94 | 60800.0 |
| 2004-12-22 | AAXN-DELISTED | Stock | 27.8999996185303 | 28.9500007629395 | 27.7999992370605 | 28.6399993896484 | 8060200.0 |
| 2004-12-22 | ABAX-DELISTED | Stock | 14.58 | 14.7 | 14.46 | 14.55 | 143475.0 |
| 2004-12-22 | ABB-DELISTED | Stock | 5.53 | 5.59 | 5.5 | 5.55 | 456500.0 |
| 2004-12-22 | ABBC-DELISTED | Stock | 13.26 | 13.38 | 13.25 | 13.26 | 221272.0 |
| 2004-12-22 | ABC-DELISTED | Stock | 14.64 | 14.64 | 14.15 | 14.26 | 21380000.0 |
| 2004-12-22 | ABCB | Stock | 17.2401 | 17.7589 | 17.2401 | 17.5967 | 3948.0 |
| 2004-12-22 | ABCO-DELISTED | Stock | 18.307 | 18.523 | 18.307 | 18.378 | 105317.0 |
| 2004-12-22 | ABCW-DELISTED | Stock | 29.15 | 29.68 | 29.02 | 29.21 | 38160.0 |
| 2004-12-22 | ABE-DELISTED | Stock | 9.79 | 9.79 | 9.68 | 9.72 | 31900.0 |
| 2004-12-22 | ABFS-DELISTED | Stock | 45.0 | 46.6 | 44.99 | 46.1 | 233343.0 |
| 2004-12-22 | ABG | Stock | 13.97 | 13.99 | 13.84 | 13.97 | 42900.0 |
| 2004-12-22 | ABK-DELISTED | Stock | 82.95 | 83.01 | 81.87 | 82.33 | 381000.0 |
| 2004-12-22 | ABM | Stock | 19.38 | 19.76 | 19.32 | 19.73 | 97100.0 |
| 2004-12-22 | ABMD-DELISTED | Stock | 13.65 | 14.08 | 13.65 | 13.66 | 120337.0 |
| 2004-12-22 | ABP-DELISTED | Stock | 2.52 | 2.54 | 2.46 | 2.46 | 90900.0 |
| 2004-12-22 | ABR | Stock | 24.0 | 24.4 | 24.0 | 24.08 | 37000.0 |
| 2004-12-22 | ABT | Stock | 22.0804 | 22.4067 | 22.0372 | 22.3107 | 5566486.0 |
| 2004-12-22 | ABTL-DELISTED | Stock | 27.5 | 27.5 | 27.0 | 27.15 | 120600.0 |
| 2004-12-22 | ABV-DELISTED | Stock | 27.62 | 27.62 | 27.05 | 27.15 | 117400.0 |
| 2004-12-22 | ABVA-DELISTED | Stock | 14.89 | 15.43 | 14.89 | 15.2 | 1900.0 |
| 2004-12-22 | ABX-DELISTED | Stock | 24.0 | 24.0 | 23.6 | 23.72 | 1432100.0 |
| 2004-12-22 | ACAD | Stock | 6.95 | 6.95 | 6.88 | 6.9 | 7400.0 |
| 2004-12-22 | ACAP-DELISTED | Stock | 37.78 | 37.91 | 37.26 | 37.5 | 50583.0 |
| 2004-12-22 | ACAS-DELISTED | Stock | 32.83 | 33.08 | 32.75 | 33.0 | 539327.0 |
| 2004-12-22 | ACAT-DELISTED | Stock | 26.21 | 27.17 | 26.21 | 27.12 | 53024.0 |
| 2004-12-22 | ACC-DELISTED | Stock | 22.1 | 22.34 | 22.02 | 22.31 | 116000.0 |
| 2004-12-22 | ACCL-DELISTED | Stock | 7.6 | 7.97 | 7.56 | 7.84 | 130455.0 |
| 2004-12-22 | ACE-DELISTED | Stock | 42.24 | 42.76 | 42.01 | 42.42 | 751289.0 |
| 2004-12-22 | ACF-DELISTED | Stock | 23.5 | 23.99 | 23.47 | 23.91 | 1427600.0 |
| 2004-12-22 | ACFC-DELISTED | Stock | 70.46 | 71.84 | 70.36 | 71.22 | 2317.0 |
| 2004-12-22 | ACG-DELISTED | Stock | 8.16 | 8.16 | 8.13 | 8.14 | 349300.0 |
| 2004-12-22 | ACGL | Stock | 4.3333 | 4.3389 | 4.29 | 4.2944 | 1621800.0 |
| 2004-12-22 | ACGN-DELISTED | Stock | 555.3288 | 566.6712 | 521.3288 | 544.0 | 186700.0 |
| 2004-12-22 | ACH | Stock | 18.6467 | 18.8467 | 18.4667 | 18.6533 | 236550.0 |
| 2004-12-22 | ACH-DELISTED | Stock | 14.496 | 14.556 | 14.369 | 14.429 | 317269.0 |
| 2004-12-22 | ACLS | Stock | 32.16 | 32.96 | 32.0 | 32.44 | 129075.0 |
> showing 50 of 3,956 rows — these rows as CSV