PREVIEW / stock_daily / 2004-01-12
file: by_date/stock_daily/2004/2004-01-12.parquet size: 124 KB rows: 3,624 symbols: 2,259
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-01-12 | AAPL | Stock | 0.4152 | 0.4286 | 0.4125 | 0.4238 | 487547200.0 |
| 2004-01-12 | MSFT | Stock | 27.67 | 27.73 | 27.35 | 27.57 | 55845200.0 |
| 2004-01-12 | NVDA | Stock | 0.213 | 0.2153 | 0.211 | 0.2147 | 541980000.0 |
| 2004-01-12 | AMZN | Stock | 2.5805 | 2.6515 | 2.54 | 2.6475 | 189018000.0 |
| 2004-01-12 | CL | Stock | 25.29 | 25.32 | 25.05 | 25.18 | 6511200.0 |
| 2004-01-12 | A | Stock | 22.9256 | 23.1903 | 22.6037 | 23.176 | 3736854.0 |
| 2004-01-12 | AABA-DELISTED | Stock | 24.125 | 24.9300003051758 | 24.1000003814697 | 24.8700008392334 | 29919400.0 |
| 2004-01-12 | AAI-DELISTED | Stock | 12.93 | 13.02 | 12.62 | 12.81 | 1234400.0 |
| 2004-01-12 | AAIC-DELISTED | Stock | 456.0 | 465.0 | 456.0 | 464.4 | 1109400.0 |
| 2004-01-12 | AAME | Stock | 3.08 | 3.14 | 3.06 | 3.11 | 8300.0 |
| 2004-01-12 | AAON | Stock | 2.6008 | 2.6008 | 2.5534 | 2.5679 | 119981.0 |
| 2004-01-12 | AAP | Stock | 27.4533 | 27.8133 | 27.1067 | 27.78 | 931350.0 |
| 2004-01-12 | AAXN-DELISTED | Stock | 8.04166698455811 | 8.62166690826416 | 7.92666673660278 | 8.61916637420654 | 13306800.0 |
| 2004-01-12 | ABAX-DELISTED | Stock | 16.95 | 18.2 | 16.95 | 17.25 | 163121.0 |
| 2004-01-12 | ABB-DELISTED | Stock | 5.65 | 5.74 | 5.59 | 5.67 | 114100.0 |
| 2004-01-12 | ABC-DELISTED | Stock | 13.86 | 13.86 | 13.74 | 13.82 | 4926000.0 |
| 2004-01-12 | ABCB | Stock | 13.8358 | 13.9817 | 13.5683 | 13.9817 | 10364.0 |
| 2004-01-12 | ABCO-DELISTED | Stock | 16.28 | 16.595 | 16.065 | 16.35 | 1013602.0 |
| 2004-01-12 | ABCW-DELISTED | Stock | 25.2 | 25.47 | 25.2 | 25.47 | 62410.0 |
| 2004-01-12 | ABE-DELISTED | Stock | 8.44 | 8.68 | 8.35 | 8.68 | 106200.0 |
| 2004-01-12 | ABFS-DELISTED | Stock | 31.61 | 31.77 | 31.25 | 31.4 | 142747.0 |
| 2004-01-12 | ABG | Stock | 18.45 | 19.47 | 18.45 | 19.15 | 37900.0 |
| 2004-01-12 | ABK-DELISTED | Stock | 70.5 | 72.95 | 70.45 | 71.69 | 1245400.0 |
| 2004-01-12 | ABM | Stock | 17.88 | 18.0 | 17.73 | 17.93 | 97300.0 |
| 2004-01-12 | ABMD-DELISTED | Stock | 7.23 | 7.37 | 7.08 | 7.22 | 33112.0 |
| 2004-01-12 | ABP-DELISTED | Stock | 1.64 | 1.68 | 1.52 | 1.54 | 229800.0 |
| 2004-01-12 | ABT | Stock | 20.1691 | 20.1871 | 19.8818 | 19.9492 | 11558676.0 |
| 2004-01-12 | ABTL-DELISTED | Stock | 52.25 | 55.6 | 52.1 | 55.05 | 74400.0 |
| 2004-01-12 | ABV-DELISTED | Stock | 26.85 | 27.55 | 26.65 | 27.52 | 601300.0 |
| 2004-01-12 | ABVA-DELISTED | Stock | 19.05 | 19.05 | 19.02 | 19.02 | 1270.0 |
| 2004-01-12 | ABX-DELISTED | Stock | 22.6 | 22.7 | 22.16 | 22.34 | 1574400.0 |
| 2004-01-12 | ACAP-DELISTED | Stock | 18.03 | 18.05 | 17.48 | 17.75 | 21540.0 |
| 2004-01-12 | ACAS-DELISTED | Stock | 30.0 | 30.93 | 29.83 | 30.65 | 1019103.0 |
| 2004-01-12 | ACAT-DELISTED | Stock | 25.95 | 27.515 | 25.95 | 27.475 | 107208.0 |
| 2004-01-12 | ACCL-DELISTED | Stock | 12.7299995422363 | 13.6420001983643 | 12.2740001678467 | 13.5120000839233 | 419900.0 |
| 2004-01-12 | ACE-DELISTED | Stock | 42.19 | 42.98 | 42.03 | 42.97 | 1242706.0 |
| 2004-01-12 | ACF-DELISTED | Stock | 17.03 | 17.35 | 17.01 | 17.35 | 1220900.0 |
| 2004-01-12 | ACG-DELISTED | Stock | 8.67 | 8.7 | 8.67 | 8.7 | 459300.0 |
| 2004-01-12 | ACGL | Stock | 4.5778 | 4.6556 | 4.5778 | 4.6222 | 2661300.0 |
| 2004-01-12 | ACGN-DELISTED | Stock | 1224.0 | 1224.0 | 1178.6712 | 1212.6712 | 81100.0 |
| 2004-01-12 | ACH | Stock | 15.5333 | 15.6333 | 15.4733 | 15.56 | 165150.0 |
| 2004-01-12 | ACH-DELISTED | Stock | 17.994 | 18.049 | 17.494 | 17.894 | 2027443.0 |
| 2004-01-12 | ACLS | Stock | 45.28 | 47.44 | 45.2 | 47.0 | 250675.0 |
| 2004-01-12 | ACO-DELISTED | Stock | 22.4 | 22.96 | 22.3 | 22.51 | 265200.0 |
| 2004-01-12 | ACPW-DELISTED | Stock | 15.55 | 16.25 | 15.35 | 16.25 | 30344.0 |
| 2004-01-12 | ACS-DELISTED | Stock | 57.11 | 57.47 | 56.82 | 57.16 | 1100800.0 |
| 2004-01-12 | ACTA-DELISTED | Stock | 8.2 | 12.2 | 8.2 | 12.2 | 11167300.0 |
| 2004-01-12 | ACTG | Stock | 6.5 | 6.5 | 5.85 | 6.0 | 288500.0 |
| 2004-01-12 | ACTI-DELISTED | Stock | 7.45 | 7.79 | 7.35 | 7.77 | 205449.0 |
| 2004-01-12 | ACTT-DELISTED | Stock | 1.3 | 1.4 | 1.28 | 1.38 | 269549.0 |
> showing 50 of 3,624 rows — these rows as CSV