PREVIEW / stock_daily / 2002-05-20
file: by_date/stock_daily/2002/2002-05-20.parquet size: 107 KB rows: 3,112 symbols: 1,932
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-05-20 | AAPL | Stock | 0.4388 | 0.4452 | 0.438 | 0.4418 | 269914400.0 |
| 2002-05-20 | MSFT | Stock | 27.75 | 27.775 | 26.75 | 27.005 | 52115800.0 |
| 2002-05-20 | NVDA | Stock | 0.3237 | 0.3321 | 0.3222 | 0.3299 | 953412000.0 |
| 2002-05-20 | AMZN | Stock | 0.94 | 0.974 | 0.9385 | 0.9695 | 169216000.0 |
| 2002-05-20 | CL | Stock | 27.4 | 27.65 | 27.33 | 27.425 | 2018400.0 |
| 2002-05-20 | A | Stock | 21.1731 | 21.2732 | 20.8941 | 21.03 | 2588956.0 |
| 2002-05-20 | AABA-DELISTED | Stock | 8.85499954223633 | 8.85999965667725 | 8.44499969482422 | 8.58500003814697 | 14262800.0 |
| 2002-05-20 | AAI-DELISTED | Stock | 6.0 | 6.0 | 5.72 | 5.9 | 196200.0 |
| 2002-05-20 | AAIC-DELISTED | Stock | 193.2 | 198.0 | 190.0 | 193.8 | 78400.0 |
| 2002-05-20 | AAME | Stock | 2.49 | 2.5 | 2.3 | 2.5 | 2200.0 |
| 2002-05-20 | AAON | Stock | 2.8093 | 2.8093 | 2.6434 | 2.6601 | 142383.0 |
| 2002-05-20 | AAP | Stock | 20.3833 | 20.4967 | 20.35 | 20.4833 | 331800.0 |
| 2002-05-20 | AAXN-DELISTED | Stock | 1.31166660785675 | 1.36249995231628 | 1.27916669845581 | 1.36249995231628 | 804000.0 |
| 2002-05-20 | ABAX-DELISTED | Stock | 5.61 | 5.68 | 5.5 | 5.68 | 10300.0 |
| 2002-05-20 | ABB-DELISTED | Stock | 9.62 | 9.77 | 9.6 | 9.77 | 13200.0 |
| 2002-05-20 | ABC-DELISTED | Stock | 19.4 | 19.5 | 19.3 | 19.33 | 2283200.0 |
| 2002-05-20 | ABCB | Stock | 11.5907 | 11.7527 | 11.469 | 11.6312 | 20110.0 |
| 2002-05-20 | ABCO-DELISTED | Stock | 18.87 | 18.87 | 18.41 | 18.455 | 56200.0 |
| 2002-05-20 | ABCW-DELISTED | Stock | 22.02 | 22.58 | 21.96 | 22.43 | 59700.0 |
| 2002-05-20 | ABE-DELISTED | Stock | 7.8 | 7.8 | 7.55 | 7.65 | 30100.0 |
| 2002-05-20 | ABFS-DELISTED | Stock | 24.91 | 24.95 | 24.3 | 24.5 | 113800.0 |
| 2002-05-20 | ABG | Stock | 19.5 | 20.98 | 19.4 | 20.9 | 78900.0 |
| 2002-05-20 | ABK-DELISTED | Stock | 66.73 | 66.73 | 65.39 | 65.58 | 356500.0 |
| 2002-05-20 | ABM | Stock | 18.75 | 18.85 | 18.41 | 18.72 | 65600.0 |
| 2002-05-20 | ABMD-DELISTED | Stock | 6.795 | 7.05 | 6.671 | 6.69 | 55800.0 |
| 2002-05-20 | ABP-DELISTED | Stock | 0.87 | 0.88 | 0.78 | 0.87 | 42300.0 |
| 2002-05-20 | ABT | Stock | 21.2555 | 21.5338 | 20.9861 | 21.1028 | 12494963.0 |
| 2002-05-20 | ABTL-DELISTED | Stock | 17.55 | 19.15 | 17.4 | 19.1 | 25900.0 |
| 2002-05-20 | ABV-DELISTED | Stock | 19.34 | 19.34 | 19.04 | 19.22 | 188800.0 |
| 2002-05-20 | ABVA-DELISTED | Stock | 8.0 | 8.0 | 8.0 | 8.0 | 500.0 |
| 2002-05-20 | ABX-DELISTED | Stock | 21.95 | 22.56 | 21.74 | 22.53 | 3240021.0 |
| 2002-05-20 | ACAP-DELISTED | Stock | 16.62 | 16.67 | 16.53 | 16.55 | 94400.0 |
| 2002-05-20 | ACAS-DELISTED | Stock | 30.55 | 30.89 | 29.94 | 30.4 | 557700.0 |
| 2002-05-20 | ACAT-DELISTED | Stock | 19.55 | 19.55 | 19.0 | 19.21 | 39700.0 |
| 2002-05-20 | ACCL-DELISTED | Stock | 8.31282043457031 | 8.31282043457031 | 7.86387014389038 | 8.31282043457031 | 83300.0 |
| 2002-05-20 | ACE-DELISTED | Stock | 33.36 | 34.36 | 32.55 | 32.8 | 2526100.0 |
| 2002-05-20 | ACF-DELISTED | Stock | 37.9 | 39.23 | 37.6 | 38.23 | 1374700.0 |
| 2002-05-20 | ACG-DELISTED | Stock | 7.82 | 7.82 | 7.73 | 7.78 | 944700.0 |
| 2002-05-20 | ACGL | Stock | 3.3889 | 3.4056 | 3.3322 | 3.3522 | 359100.0 |
| 2002-05-20 | ACGN-DELISTED | Stock | 1428.0 | 1450.6712 | 1314.6712 | 1450.6712 | 47500.0 |
| 2002-05-20 | ACH | Stock | 12.9 | 13.2533 | 12.8333 | 12.9667 | 67650.0 |
| 2002-05-20 | ACH-DELISTED | Stock | 4.975 | 5.005 | 4.975 | 5.005 | 20000.0 |
| 2002-05-20 | ACLS | Stock | 58.64 | 59.0 | 57.44 | 57.96 | 95425.0 |
| 2002-05-20 | ACO-DELISTED | Stock | 5.9 | 6.04 | 5.9 | 6.0 | 74600.0 |
| 2002-05-20 | ACPW-DELISTED | Stock | 21.66 | 23.09 | 20.89 | 22.59 | 42294.0 |
| 2002-05-20 | ACS-DELISTED | Stock | 56.0 | 56.63 | 55.65 | 55.9 | 1125900.0 |
| 2002-05-20 | ACTA-DELISTED | Stock | 6.8 | 6.8 | 5.8 | 6.2 | 34000.0 |
| 2002-05-20 | ACTT-DELISTED | Stock | 4.0 | 4.12 | 3.9 | 3.95 | 43600.0 |
| 2002-05-20 | ACTU-DELISTED | Stock | 5.91 | 5.95 | 5.6 | 5.65 | 194400.0 |
| 2002-05-20 | ACXM-DELISTED | Stock | 17.2 | 17.3 | 16.6 | 16.86 | 466000.0 |
> showing 50 of 3,112 rows — these rows as CSV