PREVIEW / stock_daily / 2000-07-19
file: by_date/stock_daily/2000/2000-07-19.parquet size: 87 KB rows: 2,754 symbols: 1,710
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 |
|---|---|---|---|---|---|---|---|
| 2000-07-19 | AAPL | Stock | 0.9855 | 1.0145 | 0.9241 | 0.9408 | 457872800.0 |
| 2000-07-19 | MSFT | Stock | 38.0312 | 38.75 | 36.4062 | 36.5625 | 139924600.0 |
| 2000-07-19 | NVDA | Stock | 0.2875 | 0.2896 | 0.2732 | 0.2792 | 189504000.0 |
| 2000-07-19 | AMZN | Stock | 2.075 | 2.0781 | 1.95 | 2.0438 | 94874000.0 |
| 2000-07-19 | CL | Stock | 27.5 | 27.5938 | 26.5312 | 27.25 | 4077600.0 |
| 2000-07-19 | A | Stock | 54.3634 | 54.4081 | 52.0386 | 52.9775 | 3539037.0 |
| 2000-07-19 | AABA-DELISTED | Stock | 65.03125 | 69.0 | 65.0 | 67.0 | 20859200.0 |
| 2000-07-19 | AAI-DELISTED | Stock | 4.88 | 4.88 | 4.56 | 4.81 | 191900.0 |
| 2000-07-19 | AAIC-DELISTED | Stock | 143.75 | 150.0 | 143.75 | 150.0 | 52400.0 |
| 2000-07-19 | AAME | Stock | 2.6875 | 2.6875 | 2.6875 | 2.6875 | 300.0 |
| 2000-07-19 | AAON | Stock | 1.4156 | 1.4632 | 1.4047 | 1.4412 | 225534.0 |
| 2000-07-19 | ABAX-DELISTED | Stock | 6.375 | 6.75 | 6.3125 | 6.6875 | 180100.0 |
| 2000-07-19 | ABC-DELISTED | Stock | 7.71875 | 7.71875 | 7.375 | 7.40625 | 895600.0 |
| 2000-07-19 | ABCB | Stock | 7.8014 | 7.9534 | 7.7507 | 7.9534 | 127940.0 |
| 2000-07-19 | ABCW-DELISTED | Stock | 15.969 | 16.156 | 15.969 | 16.031 | 65050.0 |
| 2000-07-19 | ABE-DELISTED | Stock | 15.625 | 15.8125 | 15.625 | 15.625 | 11900.0 |
| 2000-07-19 | ABFS-DELISTED | Stock | 11.0625 | 11.0625 | 10.75 | 11.0 | 141900.0 |
| 2000-07-19 | ABK-DELISTED | Stock | 55.81 | 60.19 | 55.81 | 60.0 | 931000.0 |
| 2000-07-19 | ABM | Stock | 12.9375 | 12.9375 | 12.7812 | 12.8125 | 30000.0 |
| 2000-07-19 | ABMD-DELISTED | Stock | 22.0312 | 22.938 | 21.62 | 22.188 | 115600.0 |
| 2000-07-19 | ABT | Stock | 18.8819 | 19.0222 | 18.4049 | 18.461 | 3729554.0 |
| 2000-07-19 | ABTL-DELISTED | Stock | 32.81 | 33.75 | 32.19 | 32.19 | 8000.0 |
| 2000-07-19 | ABV-DELISTED | Stock | 20.19 | 20.25 | 19.94 | 20.06 | 498700.0 |
| 2000-07-19 | ABX-DELISTED | Stock | 17.563 | 17.626 | 17.25 | 17.313 | 1098678.0 |
| 2000-07-19 | ACAS-DELISTED | Stock | 25.5625 | 25.5625 | 23.875 | 23.875 | 180200.0 |
| 2000-07-19 | ACAT-DELISTED | Stock | 12.282 | 12.438 | 12.25 | 12.438 | 27499.0 |
| 2000-07-19 | ACCL-DELISTED | Stock | 30.1800003051758 | 31.318000793457 | 29.507999420166 | 30.6840000152588 | 210500.0 |
| 2000-07-19 | ACE-DELISTED | Stock | 30.25 | 30.625 | 29.4375 | 30.0 | 926900.0 |
| 2000-07-19 | ACF-DELISTED | Stock | 19.81 | 19.81 | 19.31 | 19.5 | 117400.0 |
| 2000-07-19 | ACG-DELISTED | Stock | 7.5625 | 7.5625 | 7.4375 | 7.4375 | 57000.0 |
| 2000-07-19 | ACGL | Stock | 1.7431 | 1.7569 | 1.7361 | 1.75 | 408600.0 |
| 2000-07-19 | ACGN-DELISTED | Stock | 1097.9688 | 1133.3288 | 1097.9688 | 1133.3288 | 76200.0 |
| 2000-07-19 | ACH | Stock | 12.125 | 12.125 | 11.4167 | 11.4583 | 240600.0 |
| 2000-07-19 | ACLS | Stock | 100.5 | 100.75 | 93.0 | 96.0 | 349800.0 |
| 2000-07-19 | ACO-DELISTED | Stock | 3.875 | 4.0 | 3.8125 | 3.875 | 40700.0 |
| 2000-07-19 | ACS-DELISTED | Stock | 20.5625 | 21.625 | 20.5625 | 21.1875 | 463500.0 |
| 2000-07-19 | ACTA-DELISTED | Stock | 847.5 | 860.0 | 800.0 | 803.75 | 219900.0 |
| 2000-07-19 | ACTT-DELISTED | Stock | 6.1875 | 6.25 | 6.125 | 6.125 | 2700.0 |
| 2000-07-19 | ACTU-DELISTED | Stock | 57.0 | 57.0 | 49.56 | 50.19 | 304400.0 |
| 2000-07-19 | ACXM-DELISTED | Stock | 27.94 | 28.19 | 26.13 | 26.19 | 881194.0 |
| 2000-07-19 | ACY-DELISTED | Stock | 6.62 | 6.62 | 6.62 | 6.62 | 1200.0 |
| 2000-07-19 | AD | Stock | 42.8333 | 44.9167 | 42.8333 | 44.3646 | 327750.0 |
| 2000-07-19 | ADAT-DELISTED | Stock | 108.56 | 108.84 | 104.63 | 107.44 | 5800.0 |
| 2000-07-19 | ADBE | Stock | 33.0547 | 33.9492 | 31.9062 | 32.4844 | 4300800.0 |
| 2000-07-19 | ADC | Stock | 16.5 | 16.5 | 16.125 | 16.125 | 4600.0 |
| 2000-07-19 | ADEP-DELISTED | Stock | 195.31 | 218.75 | 189.38 | 195.0 | 74800.0 |
| 2000-07-19 | ADGF-DELISTED | Stock | 1.3 | 1.38 | 1.25 | 1.25 | 20800.0 |
| 2000-07-19 | ADI | Stock | 83.0625 | 83.375 | 78.375 | 80.0 | 1780600.0 |
| 2000-07-19 | ADM | Stock | 9.0136 | 9.2404 | 8.9569 | 9.0136 | 1452985.0 |
| 2000-07-19 | ADMP-DELISTED | Stock | 1508.75 | 1567.1875 | 1508.75 | 1567.1875 | 400.0 |
> showing 50 of 2,754 rows — these rows as CSV