PREVIEW / stock_daily / 2004-12-27
file: by_date/stock_daily/2004/2004-12-27.parquet size: 132 KB rows: 3,933 symbols: 2,458
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-27 | AAPL | Stock | 1.1571 | 1.1634 | 1.1229 | 1.1279 | 559490400.0 |
| 2004-12-27 | MSFT | Stock | 27.01 | 27.1 | 26.82 | 26.85 | 55958500.0 |
| 2004-12-27 | NVDA | Stock | 0.1949 | 0.1957 | 0.1896 | 0.1906 | 308208000.0 |
| 2004-12-27 | AMZN | Stock | 1.976 | 2.1465 | 1.9735 | 2.1125 | 445784000.0 |
| 2004-12-27 | CL | Stock | 25.385 | 25.465 | 25.14 | 25.14 | 2601000.0 |
| 2004-12-27 | A | Stock | 17.1102 | 17.2389 | 16.9528 | 17.0243 | 3111529.0 |
| 2004-12-27 | AABA-DELISTED | Stock | 37.4500007629395 | 38.0 | 37.4000015258789 | 37.7400016784668 | 11095800.0 |
| 2004-12-27 | AACC-DELISTED | Stock | 21.11 | 21.221 | 21.03 | 21.11 | 8944.0 |
| 2004-12-27 | AAI-DELISTED | Stock | 10.85 | 10.96 | 10.66 | 10.85 | 972200.0 |
| 2004-12-27 | AAIC-DELISTED | Stock | 398.0 | 400.0 | 393.4 | 396.2 | 706500.0 |
| 2004-12-27 | AAME | Stock | 3.0 | 3.18 | 3.0 | 3.08 | 45500.0 |
| 2004-12-27 | AAON | Stock | 1.949 | 1.9569 | 1.9187 | 1.9411 | 59991.0 |
| 2004-12-27 | AAP | Stock | 27.8267 | 28.0333 | 27.7333 | 27.9133 | 818400.0 |
| 2004-12-27 | AAXN-DELISTED | Stock | 28.3600006103516 | 28.5799999237061 | 27.5499992370605 | 27.7700004577637 | 4223400.0 |
| 2004-12-27 | ABAX-DELISTED | Stock | 14.4 | 14.696 | 14.22 | 14.44 | 159017.0 |
| 2004-12-27 | ABB-DELISTED | Stock | 5.64 | 5.7 | 5.61 | 5.63 | 211700.0 |
| 2004-12-27 | ABBC-DELISTED | Stock | 13.01 | 13.5 | 13.01 | 13.42 | 122066.0 |
| 2004-12-27 | ABC-DELISTED | Stock | 14.24 | 14.29 | 14.06 | 14.15 | 4420000.0 |
| 2004-12-27 | ABCB | Stock | 17.8318 | 17.8318 | 17.0537 | 17.2401 | 4688.0 |
| 2004-12-27 | ABCO-DELISTED | Stock | 18.653 | 18.658 | 18.277 | 18.372 | 181769.0 |
| 2004-12-27 | ABCW-DELISTED | Stock | 29.21 | 29.35 | 28.84 | 28.96 | 24820.0 |
| 2004-12-27 | ABE-DELISTED | Stock | 9.95 | 9.95 | 9.82 | 9.89 | 55600.0 |
| 2004-12-27 | ABFS-DELISTED | Stock | 45.7 | 45.7 | 44.76 | 44.76 | 88599.0 |
| 2004-12-27 | ABG | Stock | 13.99 | 13.99 | 13.82 | 13.9 | 11900.0 |
| 2004-12-27 | ABK-DELISTED | Stock | 82.58 | 82.64 | 81.86 | 82.27 | 210900.0 |
| 2004-12-27 | ABM | Stock | 19.95 | 19.99 | 19.33 | 19.45 | 118500.0 |
| 2004-12-27 | ABMD-DELISTED | Stock | 13.88 | 14.09 | 13.75 | 13.82 | 148313.0 |
| 2004-12-27 | ABP-DELISTED | Stock | 2.41 | 2.48 | 2.26 | 2.4 | 137700.0 |
| 2004-12-27 | ABR | Stock | 24.4 | 24.5 | 24.05 | 24.14 | 16600.0 |
| 2004-12-27 | ABT | Stock | 22.2675 | 22.3107 | 22.0708 | 22.0756 | 5378491.0 |
| 2004-12-27 | ABTL-DELISTED | Stock | 28.0 | 28.5 | 27.45 | 28.3 | 159200.0 |
| 2004-12-27 | ABV-DELISTED | Stock | 27.17 | 27.33 | 27.09 | 27.3 | 41600.0 |
| 2004-12-27 | ABVA-DELISTED | Stock | 15.1 | 15.15 | 15.08 | 15.09 | 2978.0 |
| 2004-12-27 | ABVT-DELISTED | Stock | 33.0 | 33.0 | 32.75 | 32.75 | 600.0 |
| 2004-12-27 | ABX-DELISTED | Stock | 23.99 | 24.32 | 23.91 | 24.05 | 991400.0 |
| 2004-12-27 | ACAD | Stock | 6.14 | 6.34 | 5.94 | 6.17 | 12900.0 |
| 2004-12-27 | ACAP-DELISTED | Stock | 36.95 | 37.25 | 36.69 | 36.75 | 21687.0 |
| 2004-12-27 | ACAS-DELISTED | Stock | 33.27 | 33.38 | 32.85 | 33.07 | 484857.0 |
| 2004-12-27 | ACAT-DELISTED | Stock | 26.89 | 27.06 | 26.38 | 26.41 | 16554.0 |
| 2004-12-27 | ACC-DELISTED | Stock | 22.37 | 22.47 | 22.15 | 22.15 | 12500.0 |
| 2004-12-27 | ACCL-DELISTED | Stock | 7.9 | 8.1 | 7.72 | 7.84 | 135166.0 |
| 2004-12-27 | ACE-DELISTED | Stock | 41.96 | 42.21 | 41.55 | 41.91 | 442200.0 |
| 2004-12-27 | ACF-DELISTED | Stock | 23.8 | 24.02 | 23.56 | 23.93 | 1039700.0 |
| 2004-12-27 | ACFC-DELISTED | Stock | 70.36 | 71.02 | 68.72 | 71.02 | 2563.0 |
| 2004-12-27 | ACG-DELISTED | Stock | 8.12 | 8.17 | 8.12 | 8.14 | 386700.0 |
| 2004-12-27 | ACGL | Stock | 4.3133 | 4.3233 | 4.2522 | 4.2567 | 491400.0 |
| 2004-12-27 | ACGN-DELISTED | Stock | 555.3288 | 566.6712 | 510.0 | 566.6712 | 385400.0 |
| 2004-12-27 | ACH | Stock | 18.6333 | 18.7533 | 18.1867 | 18.2667 | 208650.0 |
| 2004-12-27 | ACH-DELISTED | Stock | 14.433 | 14.47 | 14.32 | 14.407 | 271078.0 |
| 2004-12-27 | ACLS | Stock | 32.28 | 32.8 | 31.76 | 31.88 | 149875.0 |
> showing 50 of 3,933 rows — these rows as CSV