PREVIEW / stock_daily / 2002-06-19
file: by_date/stock_daily/2002/2002-06-19.parquet size: 108 KB rows: 3,146 symbols: 1,950
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-06-19 | AAPL | Stock | 0.3102 | 0.3143 | 0.3014 | 0.3057 | 1709467200.0 |
| 2002-06-19 | MSFT | Stock | 27.735 | 27.97 | 27.16 | 27.18 | 81247000.0 |
| 2002-06-19 | NVDA | Stock | 0.2242 | 0.2242 | 0.197 | 0.1987 | 2593620000.0 |
| 2002-06-19 | AMZN | Stock | 0.9245 | 0.955 | 0.9135 | 0.915 | 148406000.0 |
| 2002-06-19 | CL | Stock | 26.3 | 26.57 | 26.19 | 26.395 | 3874400.0 |
| 2002-06-19 | A | Stock | 17.6824 | 17.8684 | 17.0601 | 17.382 | 3960254.0 |
| 2002-06-19 | AABA-DELISTED | Stock | 8.22999954223633 | 8.4350004196167 | 8.00500011444092 | 8.01000022888184 | 13765800.0 |
| 2002-06-19 | AAI-DELISTED | Stock | 5.71 | 5.74 | 5.52 | 5.63 | 222300.0 |
| 2002-06-19 | AAIC-DELISTED | Stock | 223.6 | 231.0 | 222.6 | 228.0 | 76100.0 |
| 2002-06-19 | AAME | Stock | 2.6 | 2.6 | 2.25 | 2.26 | 6800.0 |
| 2002-06-19 | AAON | Stock | 2.6601 | 2.6772 | 2.5877 | 2.614 | 233887.0 |
| 2002-06-19 | AAP | Stock | 19.7833 | 20.4 | 19.7533 | 20.1 | 1203300.0 |
| 2002-06-19 | AAXN-DELISTED | Stock | 1.25 | 1.30499994754791 | 1.22916662693024 | 1.24666666984558 | 457200.0 |
| 2002-06-19 | ABAX-DELISTED | Stock | 4.69 | 4.87 | 4.5 | 4.75 | 25300.0 |
| 2002-06-19 | ABB-DELISTED | Stock | 8.5 | 8.62 | 8.45 | 8.62 | 27300.0 |
| 2002-06-19 | ABC-DELISTED | Stock | 20.3 | 20.71 | 20.28 | 20.53 | 4679200.0 |
| 2002-06-19 | ABCB | Stock | 11.9473 | 11.9878 | 11.7122 | 11.85 | 19987.0 |
| 2002-06-19 | ABCO-DELISTED | Stock | 19.65 | 19.865 | 19.1 | 19.165 | 368800.0 |
| 2002-06-19 | ABCW-DELISTED | Stock | 22.4 | 22.75 | 21.9 | 22.41 | 27000.0 |
| 2002-06-19 | ABE-DELISTED | Stock | 7.03 | 7.05 | 6.85 | 7.0 | 11400.0 |
| 2002-06-19 | ABFS-DELISTED | Stock | 23.995 | 25.32 | 23.771 | 24.8 | 306500.0 |
| 2002-06-19 | ABG | Stock | 15.3 | 16.0 | 15.3 | 15.65 | 129400.0 |
| 2002-06-19 | ABK-DELISTED | Stock | 68.52 | 68.97 | 68.22 | 68.45 | 701000.0 |
| 2002-06-19 | ABM | Stock | 17.07 | 17.23 | 15.8 | 15.9 | 270900.0 |
| 2002-06-19 | ABMD-DELISTED | Stock | 6.21 | 6.65 | 6.02 | 6.39 | 64900.0 |
| 2002-06-19 | ABP-DELISTED | Stock | 0.6 | 0.62 | 0.55 | 0.57 | 16400.0 |
| 2002-06-19 | ABT | Stock | 17.5071 | 17.5924 | 16.8068 | 16.9011 | 12484493.0 |
| 2002-06-19 | ABTL-DELISTED | Stock | 14.65 | 14.65 | 13.65 | 13.75 | 16800.0 |
| 2002-06-19 | ABV-DELISTED | Stock | 16.4 | 16.5 | 15.62 | 15.64 | 354100.0 |
| 2002-06-19 | ABX-DELISTED | Stock | 20.35 | 20.39 | 19.53 | 19.7 | 2548300.0 |
| 2002-06-19 | ACAP-DELISTED | Stock | 17.81 | 17.86 | 17.29 | 17.42 | 51000.0 |
| 2002-06-19 | ACAS-DELISTED | Stock | 27.16 | 27.59 | 26.64 | 27.2 | 525600.0 |
| 2002-06-19 | ACAT-DELISTED | Stock | 17.75 | 18.45 | 17.51 | 17.76 | 97800.0 |
| 2002-06-19 | ACCL-DELISTED | Stock | 6.56769990921021 | 6.61839008331299 | 6.44461011886597 | 6.61839008331299 | 182700.0 |
| 2002-06-19 | ACE-DELISTED | Stock | 33.6 | 33.7 | 33.11 | 33.13 | 1892578.0 |
| 2002-06-19 | ACF-DELISTED | Stock | 27.3 | 28.75 | 27.2 | 27.51 | 1699600.0 |
| 2002-06-19 | ACG-DELISTED | Stock | 8.15 | 8.16 | 8.11 | 8.15 | 472600.0 |
| 2002-06-19 | ACGL | Stock | 3.2967 | 3.3333 | 3.2233 | 3.2233 | 366300.0 |
| 2002-06-19 | ACGN-DELISTED | Stock | 1337.3288 | 1496.0 | 1337.3288 | 1496.0 | 68500.0 |
| 2002-06-19 | ACH | Stock | 12.6667 | 13.0667 | 12.6667 | 12.98 | 248700.0 |
| 2002-06-19 | ACH-DELISTED | Stock | 4.287 | 4.367 | 4.287 | 4.367 | 15601.0 |
| 2002-06-19 | ACLS | Stock | 45.84 | 45.84 | 43.16 | 44.04 | 257475.0 |
| 2002-06-19 | ACO-DELISTED | Stock | 5.81 | 5.97 | 5.8 | 5.8 | 16500.0 |
| 2002-06-19 | ACPW-DELISTED | Stock | 19.9 | 20.44 | 18.75 | 18.75 | 22960.0 |
| 2002-06-19 | ACS-DELISTED | Stock | 53.22 | 54.3 | 53.15 | 53.75 | 761700.0 |
| 2002-06-19 | ACTA-DELISTED | Stock | 6.6 | 7.4 | 6.6 | 7.0 | 31600.0 |
| 2002-06-19 | ACTT-DELISTED | Stock | 3.0 | 3.03 | 2.9 | 2.92 | 38500.0 |
| 2002-06-19 | ACTU-DELISTED | Stock | 5.78 | 5.9 | 5.25 | 5.33 | 147700.0 |
| 2002-06-19 | ACXM-DELISTED | Stock | 17.3 | 17.63 | 17.0 | 17.26 | 468700.0 |
| 2002-06-19 | ACY-DELISTED | Stock | 4.1 | 4.1 | 4.1 | 4.1 | 100.0 |
> showing 50 of 3,146 rows — these rows as CSV