PREVIEW / stock_daily / 2002-03-21
file: by_date/stock_daily/2002/2002-03-21.parquet size: 105 KB rows: 3,084 symbols: 1,919
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-03-21 | AAPL | Stock | 0.4261 | 0.4339 | 0.4154 | 0.4334 | 616352800.0 |
| 2002-03-21 | MSFT | Stock | 30.105 | 30.795 | 29.915 | 30.68 | 46123400.0 |
| 2002-03-21 | NVDA | Stock | 0.3942 | 0.4129 | 0.3838 | 0.4082 | 1721712000.0 |
| 2002-03-21 | AMZN | Stock | 0.731 | 0.762 | 0.728 | 0.7585 | 111558000.0 |
| 2002-03-21 | CL | Stock | 28.405 | 28.535 | 28.1 | 28.31 | 2782800.0 |
| 2002-03-21 | A | Stock | 24.6066 | 25.3362 | 24.5494 | 25.2647 | 2314529.0 |
| 2002-03-21 | AABA-DELISTED | Stock | 9.17500019073486 | 9.375 | 8.80000019073486 | 9.29500007629395 | 20458800.0 |
| 2002-03-21 | AAI-DELISTED | Stock | 5.7 | 5.95 | 5.69 | 5.79 | 664400.0 |
| 2002-03-21 | AAIC-DELISTED | Stock | 141.0 | 145.8 | 140.0 | 143.8 | 51100.0 |
| 2002-03-21 | AAON | Stock | 2.1684 | 2.2123 | 2.1684 | 2.2123 | 177694.0 |
| 2002-03-21 | AAP | Stock | 14.8167 | 14.8667 | 14.6 | 14.8333 | 522600.0 |
| 2002-03-21 | AAXN-DELISTED | Stock | 1.49416661262512 | 1.55750000476837 | 1.49416661262512 | 1.5533332824707 | 558000.0 |
| 2002-03-21 | ABAX-DELISTED | Stock | 6.34 | 6.425 | 6.34 | 6.38 | 7000.0 |
| 2002-03-21 | ABB-DELISTED | Stock | 8.0 | 8.16 | 7.8 | 8.04 | 62400.0 |
| 2002-03-21 | ABC-DELISTED | Stock | 17.08 | 17.6 | 17.08 | 17.47 | 2498400.0 |
| 2002-03-21 | ABCB | Stock | 10.9746 | 11.0233 | 10.8207 | 10.8612 | 9500.0 |
| 2002-03-21 | ABCO-DELISTED | Stock | 14.71 | 15.66 | 14.71 | 15.66 | 61000.0 |
| 2002-03-21 | ABCW-DELISTED | Stock | 20.98 | 21.1 | 20.85 | 21.1 | 43200.0 |
| 2002-03-21 | ABE-DELISTED | Stock | 7.36 | 7.4 | 7.36 | 7.38 | 6500.0 |
| 2002-03-21 | ABFS-DELISTED | Stock | 27.11 | 27.17 | 24.86 | 26.86 | 421700.0 |
| 2002-03-21 | ABK-DELISTED | Stock | 56.75 | 57.45 | 56.65 | 56.7 | 643700.0 |
| 2002-03-21 | ABM | Stock | 17.2 | 17.375 | 17.2 | 17.3 | 123400.0 |
| 2002-03-21 | ABMD-DELISTED | Stock | 11.2 | 11.2 | 10.35 | 10.49 | 208500.0 |
| 2002-03-21 | ABP-DELISTED | Stock | 1.6 | 1.6 | 1.5 | 1.52 | 168700.0 |
| 2002-03-21 | ABT | Stock | 23.4102 | 23.5718 | 23.1274 | 23.5045 | 9248144.0 |
| 2002-03-21 | ABTL-DELISTED | Stock | 16.3 | 19.65 | 16.25 | 18.55 | 344400.0 |
| 2002-03-21 | ABV-DELISTED | Stock | 19.75 | 19.77 | 19.53 | 19.63 | 180600.0 |
| 2002-03-21 | ABVA-DELISTED | Stock | 8.12 | 8.12 | 8.12 | 8.12 | 100.0 |
| 2002-03-21 | ABX-DELISTED | Stock | 18.11 | 18.25 | 17.85 | 17.92 | 3278900.0 |
| 2002-03-21 | ACAP-DELISTED | Stock | 18.7 | 19.5 | 18.69 | 19.07 | 294300.0 |
| 2002-03-21 | ACAS-DELISTED | Stock | 30.94 | 30.98 | 30.16 | 30.94 | 226312.0 |
| 2002-03-21 | ACAT-DELISTED | Stock | 17.31 | 18.48 | 17.3 | 18.4 | 35900.0 |
| 2002-03-21 | ACCL-DELISTED | Stock | 9.3989896774292 | 9.93482971191406 | 9.3989896774292 | 9.93482971191406 | 306600.0 |
| 2002-03-21 | ACE-DELISTED | Stock | 40.75 | 42.08 | 40.5 | 41.9 | 2884600.0 |
| 2002-03-21 | ACF-DELISTED | Stock | 40.0 | 40.21 | 38.8 | 39.33 | 1722900.0 |
| 2002-03-21 | ACG-DELISTED | Stock | 7.7 | 7.71 | 7.62 | 7.69 | 932900.0 |
| 2002-03-21 | ACGL | Stock | 2.9511 | 2.9511 | 2.9289 | 2.9333 | 77400.0 |
| 2002-03-21 | ACGN-DELISTED | Stock | 1598.0 | 1734.0 | 1598.0 | 1700.0 | 9700.0 |
| 2002-03-21 | ACH | Stock | 13.2267 | 13.34 | 13.2 | 13.3333 | 130500.0 |
| 2002-03-21 | ACH-DELISTED | Stock | 5.313 | 5.3405 | 5.303 | 5.3355 | 18394.0 |
| 2002-03-21 | ACLS | Stock | 51.64 | 53.12 | 50.6 | 53.04 | 109750.0 |
| 2002-03-21 | ACO-DELISTED | Stock | 6.15 | 6.5 | 6.1 | 6.5 | 13900.0 |
| 2002-03-21 | ACPW-DELISTED | Stock | 23.07 | 23.7 | 22.7 | 23.2 | 36795.0 |
| 2002-03-21 | ACS-DELISTED | Stock | 56.35 | 56.42 | 55.38 | 55.56 | 689700.0 |
| 2002-03-21 | ACTA-DELISTED | Stock | 15.8 | 16.0 | 15.0 | 15.6 | 34700.0 |
| 2002-03-21 | ACTT-DELISTED | Stock | 5.15 | 5.75 | 5.01 | 5.73 | 23200.0 |
| 2002-03-21 | ACTU-DELISTED | Stock | 6.7 | 6.75 | 6.35 | 6.65 | 529000.0 |
| 2002-03-21 | ACXM-DELISTED | Stock | 16.78 | 17.15 | 16.08 | 17.07 | 1577800.0 |
| 2002-03-21 | ACY-DELISTED | Stock | 4.65 | 4.65 | 4.65 | 4.65 | 700.0 |
| 2002-03-21 | AD | Stock | 25.8667 | 26.3133 | 25.4333 | 26.3133 | 147750.0 |
> showing 50 of 3,084 rows — these rows as CSV