PREVIEW / stock_daily / 2002-07-03
file: by_date/stock_daily/2002/2002-07-03.parquet size: 107 KB rows: 3,158 symbols: 1,959
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-03 | AAPL | Stock | 0.3002 | 0.3157 | 0.2991 | 0.3134 | 199029600.0 |
| 2002-07-03 | MSFT | Stock | 25.62 | 26.26 | 25.225 | 25.92 | 80936600.0 |
| 2002-07-03 | NVDA | Stock | 0.133 | 0.1457 | 0.1329 | 0.1454 | 1073304000.0 |
| 2002-07-03 | AMZN | Stock | 0.669 | 0.723 | 0.6445 | 0.7125 | 154074000.0 |
| 2002-07-03 | CL | Stock | 25.25 | 25.43 | 24.77 | 25.075 | 4631800.0 |
| 2002-07-03 | A | Stock | 15.5579 | 16.5165 | 15.3934 | 16.4521 | 4723702.0 |
| 2002-07-03 | AABA-DELISTED | Stock | 5.97499990463257 | 6.48999977111816 | 5.93499994277954 | 6.3899998664856 | 25270400.0 |
| 2002-07-03 | AAI-DELISTED | Stock | 5.13 | 5.24 | 4.96 | 5.02 | 148500.0 |
| 2002-07-03 | AAIC-DELISTED | Stock | 208.8 | 212.2 | 207.4 | 211.6 | 68100.0 |
| 2002-07-03 | AAME | Stock | 2.2 | 2.35 | 2.01 | 2.2 | 2100.0 |
| 2002-07-03 | AAON | Stock | 2.1399 | 2.4151 | 2.1399 | 2.3796 | 531562.0 |
| 2002-07-03 | AAP | Stock | 16.8333 | 17.0667 | 15.8 | 16.97 | 2729100.0 |
| 2002-07-03 | AAXN-DELISTED | Stock | 0.970833361148834 | 0.991666674613953 | 0.919166684150696 | 0.969166696071625 | 349200.0 |
| 2002-07-03 | ABAX-DELISTED | Stock | 3.75 | 4.01 | 3.75 | 3.97 | 8300.0 |
| 2002-07-03 | ABB-DELISTED | Stock | 8.88 | 8.88 | 8.7 | 8.7 | 10200.0 |
| 2002-07-03 | ABC-DELISTED | Stock | 17.51 | 17.85 | 17.08 | 17.43 | 3974800.0 |
| 2002-07-03 | ABCB | Stock | 11.3475 | 11.7527 | 11.3475 | 11.5015 | 8513.0 |
| 2002-07-03 | ABCO-DELISTED | Stock | 17.185 | 17.835 | 17.185 | 17.5 | 132400.0 |
| 2002-07-03 | ABCW-DELISTED | Stock | 23.56 | 24.0 | 23.25 | 23.51 | 112800.0 |
| 2002-07-03 | ABE-DELISTED | Stock | 6.52 | 6.57 | 6.52 | 6.52 | 4100.0 |
| 2002-07-03 | ABFS-DELISTED | Stock | 22.94 | 23.3 | 22.65 | 23.25 | 202300.0 |
| 2002-07-03 | ABG | Stock | 12.55 | 12.55 | 12.2 | 12.25 | 29600.0 |
| 2002-07-03 | ABK-DELISTED | Stock | 65.45 | 65.9 | 64.86 | 65.79 | 810900.0 |
| 2002-07-03 | ABM | Stock | 17.65 | 17.8 | 16.86 | 17.15 | 124100.0 |
| 2002-07-03 | ABMD-DELISTED | Stock | 7.05 | 7.59 | 6.77 | 7.35 | 59400.0 |
| 2002-07-03 | ABP-DELISTED | Stock | 0.64 | 0.65 | 0.59 | 0.65 | 27700.0 |
| 2002-07-03 | ABT | Stock | 16.6093 | 16.7395 | 16.3759 | 16.6542 | 10273315.0 |
| 2002-07-03 | ABTL-DELISTED | Stock | 12.1 | 12.55 | 11.3 | 11.5 | 17200.0 |
| 2002-07-03 | ABV-DELISTED | Stock | 15.1 | 15.42 | 15.1 | 15.25 | 253700.0 |
| 2002-07-03 | ABVA-DELISTED | Stock | 8.05 | 8.1 | 8.05 | 8.1 | 4000.0 |
| 2002-07-03 | ABX-DELISTED | Stock | 18.49 | 18.65 | 18.33 | 18.44 | 2553544.0 |
| 2002-07-03 | ACAP-DELISTED | Stock | 17.77 | 18.05 | 17.7 | 17.87 | 28500.0 |
| 2002-07-03 | ACAS-DELISTED | Stock | 26.89 | 27.58 | 26.4 | 26.74 | 419800.0 |
| 2002-07-03 | ACAT-DELISTED | Stock | 16.29 | 16.6 | 16.01 | 16.58 | 41300.0 |
| 2002-07-03 | ACCL-DELISTED | Stock | 6.11875009536743 | 6.12599992752075 | 5.89427995681763 | 6.12599992752075 | 92500.0 |
| 2002-07-03 | ACE-DELISTED | Stock | 29.26 | 30.0 | 29.03 | 29.53 | 2910400.0 |
| 2002-07-03 | ACF-DELISTED | Stock | 23.21 | 24.26 | 22.5 | 24.2 | 1977000.0 |
| 2002-07-03 | ACG-DELISTED | Stock | 7.88 | 7.92 | 7.75 | 7.83 | 746700.0 |
| 2002-07-03 | ACGL | Stock | 2.9456 | 3.0022 | 2.9433 | 2.9789 | 262800.0 |
| 2002-07-03 | ACGN-DELISTED | Stock | 1190.0 | 1190.0 | 1076.6712 | 1144.6712 | 34400.0 |
| 2002-07-03 | ACH | Stock | 12.7667 | 12.7667 | 12.3867 | 12.6667 | 154800.0 |
| 2002-07-03 | ACH-DELISTED | Stock | 4.7745 | 4.7745 | 4.742 | 4.742 | 2400.0 |
| 2002-07-03 | ACLS | Stock | 40.4 | 42.36 | 40.08 | 42.0 | 169725.0 |
| 2002-07-03 | ACO-DELISTED | Stock | 6.15 | 6.5 | 6.15 | 6.35 | 16800.0 |
| 2002-07-03 | ACPW-DELISTED | Stock | 15.976 | 16.675 | 15.476 | 16.424 | 22325.0 |
| 2002-07-03 | ACS-DELISTED | Stock | 43.6 | 45.38 | 42.95 | 45.35 | 1268200.0 |
| 2002-07-03 | ACTA-DELISTED | Stock | 5.0 | 5.2 | 4.2 | 4.8 | 76500.0 |
| 2002-07-03 | ACTT-DELISTED | Stock | 2.08 | 2.19 | 1.9 | 2.0 | 214700.0 |
| 2002-07-03 | ACTU-DELISTED | Stock | 4.09 | 4.24 | 3.9 | 4.09 | 264500.0 |
| 2002-07-03 | ACXM-DELISTED | Stock | 15.79 | 16.89 | 15.75 | 16.86 | 223000.0 |
> showing 50 of 3,158 rows — these rows as CSV