PREVIEW / stock_daily / 2002-07-24
file: by_date/stock_daily/2002/2002-07-24.parquet size: 107 KB rows: 3,192 symbols: 1,988
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-24 | AAPL | Stock | 0.2559 | 0.2718 | 0.2545 | 0.2714 | 406593600.0 |
| 2002-07-24 | MSFT | Stock | 20.875 | 23.18 | 20.705 | 23.115 | 202307800.0 |
| 2002-07-24 | NVDA | Stock | 0.1315 | 0.144 | 0.1314 | 0.1418 | 1175100000.0 |
| 2002-07-24 | AMZN | Stock | 0.6185 | 0.708 | 0.613 | 0.705 | 395326000.0 |
| 2002-07-24 | CL | Stock | 23.51 | 25.25 | 23.455 | 24.995 | 8307000.0 |
| 2002-07-24 | A | Stock | 13.9485 | 14.0129 | 12.9256 | 13.5479 | 6324552.0 |
| 2002-07-24 | AABA-DELISTED | Stock | 6.15000009536743 | 6.79500007629395 | 5.94999980926514 | 6.78999996185303 | 30755600.0 |
| 2002-07-24 | AAI-DELISTED | Stock | 3.69 | 3.91 | 3.53 | 3.75 | 708000.0 |
| 2002-07-24 | AAIC-DELISTED | Stock | 161.8 | 166.8 | 152.0 | 166.0 | 103900.0 |
| 2002-07-24 | AAME | Stock | 1.95 | 2.2 | 1.86 | 2.15 | 4500.0 |
| 2002-07-24 | AAON | Stock | 2.0293 | 2.2426 | 2.0293 | 2.2189 | 302991.0 |
| 2002-07-24 | AAP | Stock | 14.0833 | 15.9 | 13.8633 | 15.75 | 2589000.0 |
| 2002-07-24 | AAXN-DELISTED | Stock | 0.462500005960464 | 0.512499988079071 | 0.441666662693024 | 0.486666679382324 | 813600.0 |
| 2002-07-24 | ABAX-DELISTED | Stock | 2.84 | 3.03 | 2.5 | 3.0 | 24100.0 |
| 2002-07-24 | ABB-DELISTED | Stock | 5.25 | 6.2 | 4.85 | 6.2 | 198600.0 |
| 2002-07-24 | ABC-DELISTED | Stock | 14.35 | 15.55 | 14.34 | 15.54 | 4757200.0 |
| 2002-07-24 | ABCB | Stock | 9.929 | 11.3637 | 9.54 | 11.3475 | 65512.0 |
| 2002-07-24 | ABCO-DELISTED | Stock | 13.55 | 14.285 | 13.255 | 14.17 | 151100.0 |
| 2002-07-24 | ABCW-DELISTED | Stock | 17.95 | 19.51 | 17.19 | 18.75 | 128500.0 |
| 2002-07-24 | ABE-DELISTED | Stock | 6.14 | 6.4 | 6.11 | 6.4 | 46800.0 |
| 2002-07-24 | ABFS-DELISTED | Stock | 18.34 | 19.83 | 17.83 | 19.51 | 328915.0 |
| 2002-07-24 | ABG | Stock | 10.55 | 11.15 | 9.75 | 11.15 | 138600.0 |
| 2002-07-24 | ABK-DELISTED | Stock | 51.75 | 53.66 | 49.86 | 53.33 | 2267500.0 |
| 2002-07-24 | ABM | Stock | 14.7 | 15.86 | 14.0 | 15.85 | 148800.0 |
| 2002-07-24 | ABMD-DELISTED | Stock | 5.7 | 6.19 | 5.47 | 5.75 | 96094.0 |
| 2002-07-24 | ABP-DELISTED | Stock | 0.57 | 0.58 | 0.48 | 0.58 | 94400.0 |
| 2002-07-24 | ABT | Stock | 13.5793 | 15.1728 | 13.3772 | 15.0157 | 18482922.0 |
| 2002-07-24 | ABTL-DELISTED | Stock | 11.25 | 11.4 | 9.5 | 10.3 | 18500.0 |
| 2002-07-24 | ABV-DELISTED | Stock | 14.25 | 14.76 | 14.24 | 14.63 | 768300.0 |
| 2002-07-24 | ABVA-DELISTED | Stock | 8.2 | 8.2 | 8.02 | 8.2 | 7300.0 |
| 2002-07-24 | ABX-DELISTED | Stock | 13.7 | 14.7 | 13.65 | 14.7 | 9387100.0 |
| 2002-07-24 | ACAP-DELISTED | Stock | 15.95 | 16.03 | 15.78 | 16.03 | 59700.0 |
| 2002-07-24 | ACAS-DELISTED | Stock | 22.08 | 23.88 | 20.3 | 23.28 | 1081403.0 |
| 2002-07-24 | ACAT-DELISTED | Stock | 15.02 | 15.225 | 14.77 | 15.1 | 63932.0 |
| 2002-07-24 | ACCL-DELISTED | Stock | 4.73000001907349 | 5.28599977493286 | 4.63399982452393 | 5.14099979400635 | 223600.0 |
| 2002-07-24 | ACE-DELISTED | Stock | 23.33 | 24.54 | 22.01 | 24.24 | 3330600.0 |
| 2002-07-24 | ACF-DELISTED | Stock | 14.9 | 17.75 | 14.16 | 17.45 | 3445800.0 |
| 2002-07-24 | ACG-DELISTED | Stock | 7.87 | 7.98 | 7.78 | 7.88 | 803000.0 |
| 2002-07-24 | ACGL | Stock | 2.6889 | 2.7889 | 2.5833 | 2.7778 | 500400.0 |
| 2002-07-24 | ACGN-DELISTED | Stock | 1054.0 | 1076.6712 | 986.0 | 1020.0 | 32500.0 |
| 2002-07-24 | ACH | Stock | 9.1667 | 9.7133 | 8.8467 | 9.6867 | 254550.0 |
| 2002-07-24 | ACH-DELISTED | Stock | 3.8732 | 3.8732 | 3.8433 | 3.8732 | 204492.0 |
| 2002-07-24 | ACLS | Stock | 32.0 | 34.8 | 30.8 | 33.6 | 290400.0 |
| 2002-07-24 | ACO-DELISTED | Stock | 5.24 | 5.33 | 5.0 | 5.15 | 36700.0 |
| 2002-07-24 | ACPW-DELISTED | Stock | 8.528 | 9.342 | 8.384 | 9.05 | 70262.0 |
| 2002-07-24 | ACS-DELISTED | Stock | 34.9 | 38.94 | 34.84 | 38.5 | 1926900.0 |
| 2002-07-24 | ACTA-DELISTED | Stock | 4.6 | 5.0 | 4.2 | 4.6 | 39000.0 |
| 2002-07-24 | ACTT-DELISTED | Stock | 2.61 | 2.61 | 2.05 | 2.14 | 100500.0 |
| 2002-07-24 | ACTU-DELISTED | Stock | 1.85 | 2.04 | 1.48 | 1.98 | 1007030.0 |
| 2002-07-24 | ACXM-DELISTED | Stock | 12.75 | 14.55 | 12.67 | 14.53 | 1175203.0 |
> showing 50 of 3,192 rows — these rows as CSV