PREVIEW / stock_daily / 2004-01-02
file: by_date/stock_daily/2004/2004-01-02.parquet size: 123 KB rows: 3,592 symbols: 2,229
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-02 | AAPL | Stock | 0.3848 | 0.3884 | 0.3782 | 0.38 | 144642400.0 |
| 2004-01-02 | MSFT | Stock | 27.58 | 27.77 | 27.33 | 27.45 | 44487700.0 |
| 2004-01-02 | NVDA | Stock | 0.1964 | 0.1991 | 0.1923 | 0.1923 | 436416000.0 |
| 2004-01-02 | AMZN | Stock | 2.638 | 2.6565 | 2.5715 | 2.595 | 132798000.0 |
| 2004-01-02 | CL | Stock | 24.975 | 25.05 | 24.71 | 24.81 | 4031800.0 |
| 2004-01-02 | A | Stock | 20.9227 | 20.9514 | 20.5866 | 20.6009 | 2839478.0 |
| 2004-01-02 | AABA-DELISTED | Stock | 22.75 | 22.9150009155273 | 22.5599994659424 | 22.7000007629395 | 16480000.0 |
| 2004-01-02 | AAI-DELISTED | Stock | 12.1 | 12.3 | 12.02 | 12.26 | 1333300.0 |
| 2004-01-02 | AAIC-DELISTED | Stock | 457.8 | 464.0 | 451.4 | 457.6 | 1318600.0 |
| 2004-01-02 | AAME | Stock | 3.05 | 3.25 | 2.91 | 3.15 | 8400.0 |
| 2004-01-02 | AAON | Stock | 2.564 | 2.5653 | 2.4784 | 2.4928 | 16706.0 |
| 2004-01-02 | AAP | Stock | 27.2267 | 27.5633 | 27.1 | 27.14 | 1102500.0 |
| 2004-01-02 | AAXN-DELISTED | Stock | 6.90999984741211 | 7.15749979019165 | 6.87333345413208 | 7.07916688919067 | 3807600.0 |
| 2004-01-02 | ABAX-DELISTED | Stock | 18.18 | 18.19 | 16.2 | 16.7 | 415111.0 |
| 2004-01-02 | ABB-DELISTED | Stock | 5.1 | 5.26 | 5.08 | 5.1 | 85200.0 |
| 2004-01-02 | ABC-DELISTED | Stock | 13.48 | 13.57 | 13.25 | 13.52 | 44982622.0 |
| 2004-01-02 | ABCB | Stock | 13.0577 | 13.2036 | 12.8632 | 13.2036 | 13941.0 |
| 2004-01-02 | ABCO-DELISTED | Stock | 17.366 | 17.504 | 17.264 | 17.349 | 441365.0 |
| 2004-01-02 | ABCW-DELISTED | Stock | 25.11 | 25.26 | 24.9 | 25.06 | 36160.0 |
| 2004-01-02 | ABE-DELISTED | Stock | 7.44 | 7.58 | 7.44 | 7.5 | 36400.0 |
| 2004-01-02 | ABFS-DELISTED | Stock | 31.4 | 32.38 | 31.34 | 31.75 | 78169.0 |
| 2004-01-02 | ABG | Stock | 18.01 | 18.3 | 18.01 | 18.2 | 52300.0 |
| 2004-01-02 | ABK-DELISTED | Stock | 69.7 | 70.4 | 68.86 | 69.08 | 353600.0 |
| 2004-01-02 | ABM | Stock | 17.35 | 17.9 | 17.35 | 17.7 | 104300.0 |
| 2004-01-02 | ABMD-DELISTED | Stock | 7.0 | 7.0 | 6.85 | 7.0 | 11821.0 |
| 2004-01-02 | ABP-DELISTED | Stock | 1.29 | 1.6 | 1.29 | 1.52 | 794100.0 |
| 2004-01-02 | ABT | Stock | 20.9188 | 21.1657 | 20.8021 | 20.9861 | 6894172.0 |
| 2004-01-02 | ABTL-DELISTED | Stock | 45.75 | 47.35 | 45.15 | 45.45 | 52700.0 |
| 2004-01-02 | ABV-DELISTED | Stock | 25.65 | 26.0 | 25.55 | 25.92 | 197600.0 |
| 2004-01-02 | ABVA-DELISTED | Stock | 19.15 | 19.15 | 18.96 | 18.96 | 2000.0 |
| 2004-01-02 | ABX-DELISTED | Stock | 22.79 | 23.19 | 22.73 | 23.0 | 1327600.0 |
| 2004-01-02 | ACAP-DELISTED | Stock | 18.41 | 18.89 | 17.95 | 17.95 | 26093.0 |
| 2004-01-02 | ACAS-DELISTED | Stock | 29.68 | 29.81 | 29.26 | 29.44 | 533546.0 |
| 2004-01-02 | ACAT-DELISTED | Stock | 24.5 | 26.49 | 24.5 | 25.84 | 38238.0 |
| 2004-01-02 | ACCL-DELISTED | Stock | 10.7600002288818 | 11.3249998092651 | 10.7530002593994 | 11.1730003356934 | 163100.0 |
| 2004-01-02 | ACE-DELISTED | Stock | 41.42 | 42.01 | 40.91 | 41.1 | 954600.0 |
| 2004-01-02 | ACF-DELISTED | Stock | 15.95 | 16.19 | 15.85 | 15.9 | 1105100.0 |
| 2004-01-02 | ACG-DELISTED | Stock | 8.58 | 8.62 | 8.54 | 8.6 | 516200.0 |
| 2004-01-02 | ACGL | Stock | 4.43 | 4.4933 | 4.4144 | 4.4889 | 621900.0 |
| 2004-01-02 | ACGN-DELISTED | Stock | 1269.3288 | 1303.3288 | 1258.0 | 1280.6712 | 40600.0 |
| 2004-01-02 | ACH | Stock | 14.76 | 15.0133 | 14.72 | 15.0 | 265050.0 |
| 2004-01-02 | ACH-DELISTED | Stock | 19.587 | 20.2 | 19.587 | 19.962 | 1223208.0 |
| 2004-01-02 | ACLS | Stock | 41.6 | 41.72 | 39.56 | 40.0 | 143925.0 |
| 2004-01-02 | ACO-DELISTED | Stock | 20.4 | 21.99 | 20.4 | 21.89 | 555700.0 |
| 2004-01-02 | ACPW-DELISTED | Stock | 14.675 | 14.825 | 13.926 | 14.425 | 21400.0 |
| 2004-01-02 | ACS-DELISTED | Stock | 54.95 | 55.5 | 54.66 | 55.16 | 855100.0 |
| 2004-01-02 | ACTA-DELISTED | Stock | 7.0 | 7.4 | 7.0 | 7.4 | 994600.0 |
| 2004-01-02 | ACTG | Stock | 5.65 | 5.65 | 5.4 | 5.49 | 55800.0 |
| 2004-01-02 | ACTI-DELISTED | Stock | 7.98 | 7.99 | 7.82 | 7.84 | 72788.0 |
| 2004-01-02 | ACTT-DELISTED | Stock | 1.1 | 1.24 | 1.1 | 1.19 | 132014.0 |
> showing 50 of 3,592 rows — these rows as CSV