PREVIEW / stock_daily / 2002-10-17
file: by_date/stock_daily/2002/2002-10-17.parquet size: 107 KB rows: 3,222 symbols: 1,995
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-10-17 | AAPL | Stock | 0.2538 | 0.2568 | 0.2496 | 0.252 | 469296800.0 |
| 2002-10-17 | MSFT | Stock | 26.14 | 26.25 | 25.025 | 25.385 | 182602400.0 |
| 2002-10-17 | NVDA | Stock | 0.0783 | 0.0812 | 0.0764 | 0.0776 | 585792000.0 |
| 2002-10-17 | AMZN | Stock | 1.005 | 1.011 | 0.9215 | 0.937 | 283618000.0 |
| 2002-10-17 | CL | Stock | 28.15 | 28.165 | 27.515 | 27.85 | 4919400.0 |
| 2002-10-17 | A | Stock | 8.5479 | 8.6552 | 8.4406 | 8.6552 | 3689881.0 |
| 2002-10-17 | AABA-DELISTED | Stock | 7.36999988555908 | 7.48999977111816 | 6.95499992370605 | 7.33500003814697 | 45500400.0 |
| 2002-10-17 | AAI-DELISTED | Stock | 2.93 | 3.15 | 2.93 | 3.11 | 167100.0 |
| 2002-10-17 | AAIC-DELISTED | Stock | 199.0 | 203.0 | 199.0 | 201.2 | 26600.0 |
| 2002-10-17 | AAME | Stock | 1.75 | 1.75 | 1.62 | 1.62 | 3400.0 |
| 2002-10-17 | AAON | Stock | 2.2387 | 2.2887 | 2.2058 | 2.2821 | 463978.0 |
| 2002-10-17 | AAP | Stock | 19.0 | 19.4467 | 17.0 | 17.3667 | 6623100.0 |
| 2002-10-17 | AAXN-DELISTED | Stock | 0.307500004768372 | 0.307500004768372 | 0.298333346843719 | 0.300000011920929 | 28800.0 |
| 2002-10-17 | ABAX-DELISTED | Stock | 3.89 | 4.4 | 3.75 | 4.2938 | 36700.0 |
| 2002-10-17 | ABB-DELISTED | Stock | 3.27 | 3.3 | 3.16 | 3.25 | 28300.0 |
| 2002-10-17 | ABC-DELISTED | Stock | 18.71 | 18.74 | 17.7 | 17.85 | 6111600.0 |
| 2002-10-17 | ABCB | Stock | 10.6099 | 10.7396 | 10.5937 | 10.7071 | 5675.0 |
| 2002-10-17 | ABCO-DELISTED | Stock | 14.855 | 15.605 | 14.85 | 15.605 | 252600.0 |
| 2002-10-17 | ABCW-DELISTED | Stock | 20.38 | 20.4 | 20.08 | 20.39 | 31200.0 |
| 2002-10-17 | ABE-DELISTED | Stock | 5.7 | 5.8 | 5.67 | 5.8 | 47400.0 |
| 2002-10-17 | ABFS-DELISTED | Stock | 29.62 | 30.04 | 29.5 | 29.75 | 377968.0 |
| 2002-10-17 | ABG | Stock | 9.5 | 9.8 | 9.4 | 9.5 | 54100.0 |
| 2002-10-17 | ABK-DELISTED | Stock | 61.72 | 64.81 | 61.72 | 64.08 | 1110100.0 |
| 2002-10-17 | ABM | Stock | 13.6 | 14.29 | 13.6 | 14.25 | 68000.0 |
| 2002-10-17 | ABMD-DELISTED | Stock | 3.51 | 3.55 | 3.0 | 3.44 | 131700.0 |
| 2002-10-17 | ABP-DELISTED | Stock | 0.65 | 0.72 | 0.65 | 0.7 | 15100.0 |
| 2002-10-17 | ABT | Stock | 19.9536 | 20.03 | 19.6484 | 19.8414 | 8696797.0 |
| 2002-10-17 | ABTL-DELISTED | Stock | 12.0 | 12.0 | 11.5 | 11.55 | 12500.0 |
| 2002-10-17 | ABV-DELISTED | Stock | 10.8 | 11.68 | 10.8 | 11.62 | 985300.0 |
| 2002-10-17 | ABX-DELISTED | Stock | 13.93 | 14.64 | 13.91 | 14.52 | 3025971.0 |
| 2002-10-17 | ACAP-DELISTED | Stock | 15.65 | 16.0 | 15.55 | 16.0 | 19400.0 |
| 2002-10-17 | ACAS-DELISTED | Stock | 20.0 | 20.8 | 19.96 | 20.49 | 719869.0 |
| 2002-10-17 | ACAT-DELISTED | Stock | 14.05 | 14.3 | 14.03 | 14.3 | 14000.0 |
| 2002-10-17 | ACCL-DELISTED | Stock | 6.50253009796143 | 6.87906980514526 | 6.50253009796143 | 6.87906980514526 | 55000.0 |
| 2002-10-17 | ACE-DELISTED | Stock | 34.4 | 34.85 | 33.75 | 34.69 | 3289300.0 |
| 2002-10-17 | ACF-DELISTED | Stock | 6.58 | 6.88 | 6.34 | 6.71 | 1938600.0 |
| 2002-10-17 | ACG-DELISTED | Stock | 7.93 | 7.95 | 7.83 | 7.85 | 676700.0 |
| 2002-10-17 | ACGL | Stock | 3.0 | 3.0544 | 2.8889 | 2.9167 | 321300.0 |
| 2002-10-17 | ACGN-DELISTED | Stock | 804.6712 | 906.6712 | 804.6712 | 906.6712 | 70000.0 |
| 2002-10-17 | ACH | Stock | 9.5067 | 9.6533 | 9.4333 | 9.6333 | 116400.0 |
| 2002-10-17 | ACH-DELISTED | Stock | 2.8762 | 2.8988 | 2.8762 | 2.8988 | 15995.0 |
| 2002-10-17 | ACLS | Stock | 17.64 | 18.64 | 17.64 | 18.52 | 212375.0 |
| 2002-10-17 | ACO-DELISTED | Stock | 5.25 | 5.35 | 5.15 | 5.35 | 9200.0 |
| 2002-10-17 | ACPW-DELISTED | Stock | 10.1 | 10.55 | 9.6 | 10.0 | 21640.0 |
| 2002-10-17 | ACS-DELISTED | Stock | 44.9 | 44.9 | 41.6 | 42.85 | 1533200.0 |
| 2002-10-17 | ACTA-DELISTED | Stock | 3.8 | 4.4 | 3.8 | 4.4 | 134500.0 |
| 2002-10-17 | ACTT-DELISTED | Stock | 1.21 | 1.26 | 1.12 | 1.23 | 30500.0 |
| 2002-10-17 | ACTU-DELISTED | Stock | 0.96 | 1.01 | 0.96 | 1.0 | 115100.0 |
| 2002-10-17 | ACXM-DELISTED | Stock | 14.499 | 15.04 | 13.82 | 14.01 | 1956958.0 |
| 2002-10-17 | AD | Stock | 19.42 | 20.3333 | 19.3333 | 20.3267 | 194700.0 |
> showing 50 of 3,222 rows — these rows as CSV