PREVIEW / stock_daily / 2000-08-18
file: by_date/stock_daily/2000/2000-08-18.parquet size: 87 KB rows: 2,807 symbols: 1,735
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-08-18 | AAPL | Stock | 0.9174 | 0.9252 | 0.8906 | 0.8929 | 190176000.0 |
| 2000-08-18 | MSFT | Stock | 35.5625 | 35.7188 | 35.0 | 35.5 | 54438800.0 |
| 2000-08-18 | NVDA | Stock | 0.3086 | 0.3245 | 0.3081 | 0.3208 | 204720000.0 |
| 2000-08-18 | AMZN | Stock | 1.9625 | 2.0062 | 1.9469 | 1.95 | 147422000.0 |
| 2000-08-18 | CL | Stock | 26.4375 | 26.4688 | 25.8438 | 26.1875 | 3528800.0 |
| 2000-08-18 | A | Stock | 41.309 | 41.5773 | 39.3866 | 40.3255 | 17783678.0 |
| 2000-08-18 | AABA-DELISTED | Stock | 65.1875 | 65.6875 | 62.5 | 62.59375 | 14911600.0 |
| 2000-08-18 | AAI-DELISTED | Stock | 4.31 | 4.38 | 4.19 | 4.25 | 73200.0 |
| 2000-08-18 | AAIC-DELISTED | Stock | 147.5 | 147.5 | 145.0 | 145.0 | 11900.0 |
| 2000-08-18 | AAME | Stock | 2.25 | 2.25 | 2.25 | 2.25 | 1000.0 |
| 2000-08-18 | AAON | Stock | 1.4925 | 1.5217 | 1.4778 | 1.5217 | 116184.0 |
| 2000-08-18 | ABAX-DELISTED | Stock | 5.46875 | 5.53125 | 5.46875 | 5.53125 | 2200.0 |
| 2000-08-18 | ABC-DELISTED | Stock | 9.203125 | 9.203125 | 8.921875 | 8.921875 | 164800.0 |
| 2000-08-18 | ABCB | Stock | 7.3962 | 7.5987 | 7.3962 | 7.5987 | 38740.0 |
| 2000-08-18 | ABCW-DELISTED | Stock | 15.94 | 16.17 | 15.94 | 16.12 | 39390.0 |
| 2000-08-18 | ABE-DELISTED | Stock | 14.375 | 14.4375 | 14.375 | 14.375 | 10700.0 |
| 2000-08-18 | ABFS-DELISTED | Stock | 16.0 | 16.0 | 14.5625 | 14.8125 | 116800.0 |
| 2000-08-18 | ABK-DELISTED | Stock | 64.25 | 64.38 | 63.19 | 63.88 | 175000.0 |
| 2000-08-18 | ABM | Stock | 12.7188 | 13.0 | 12.7188 | 12.9375 | 20200.0 |
| 2000-08-18 | ABMD-DELISTED | Stock | 21.5938 | 22.5 | 21.5938 | 22.5 | 69200.0 |
| 2000-08-18 | ABP-DELISTED | Stock | 3.0 | 3.0 | 2.75 | 3.0 | 39500.0 |
| 2000-08-18 | ABT | Stock | 18.2085 | 18.3208 | 17.7877 | 18.0402 | 8320545.0 |
| 2000-08-18 | ABTL-DELISTED | Stock | 28.28 | 35.0 | 27.5 | 33.59 | 112300.0 |
| 2000-08-18 | ABV-DELISTED | Stock | 20.19 | 20.19 | 19.81 | 19.88 | 862000.0 |
| 2000-08-18 | ABX-DELISTED | Stock | 16.7501 | 16.8124 | 16.501 | 16.812 | 1298209.0 |
| 2000-08-18 | ACAS-DELISTED | Stock | 23.56 | 23.63 | 22.75 | 22.94 | 75100.0 |
| 2000-08-18 | ACAT-DELISTED | Stock | 11.9375 | 11.9375 | 11.875 | 11.875 | 500.0 |
| 2000-08-18 | ACCL-DELISTED | Stock | 25.8199996948242 | 26.068000793457 | 24.257999420166 | 24.3939990997314 | 338100.0 |
| 2000-08-18 | ACE-DELISTED | Stock | 35.88 | 35.88 | 35.0 | 35.44 | 649000.0 |
| 2000-08-18 | ACF-DELISTED | Stock | 24.69 | 24.94 | 23.75 | 23.88 | 697900.0 |
| 2000-08-18 | ACG-DELISTED | Stock | 7.75 | 7.75 | 7.6875 | 7.75 | 64500.0 |
| 2000-08-18 | ACGL | Stock | 1.6597 | 1.6667 | 1.6597 | 1.6667 | 200700.0 |
| 2000-08-18 | ACGN-DELISTED | Stock | 793.3288 | 920.8288 | 793.3288 | 850.0 | 19100.0 |
| 2000-08-18 | ACH | Stock | 11.3333 | 11.3333 | 11.0 | 11.0 | 118650.0 |
| 2000-08-18 | ACLS | Stock | 76.5 | 76.5 | 71.5 | 73.5 | 211550.0 |
| 2000-08-18 | ACO-DELISTED | Stock | 3.625 | 3.6875 | 3.5625 | 3.6875 | 19300.0 |
| 2000-08-18 | ACPW-DELISTED | Stock | 257.34 | 265.0 | 243.75 | 245.62 | 75780.0 |
| 2000-08-18 | ACS-DELISTED | Stock | 23.6563 | 23.8125 | 23.0625 | 23.375 | 131800.0 |
| 2000-08-18 | ACTA-DELISTED | Stock | 615.0 | 625.0 | 598.75 | 608.75 | 76600.0 |
| 2000-08-18 | ACTT-DELISTED | Stock | 6.375 | 6.4375 | 6.125 | 6.125 | 12700.0 |
| 2000-08-18 | ACTU-DELISTED | Stock | 26.72 | 26.94 | 24.5 | 24.63 | 438600.0 |
| 2000-08-18 | ACXM-DELISTED | Stock | 24.625 | 25.25 | 24.3125 | 25.0 | 393000.0 |
| 2000-08-18 | ACY-DELISTED | Stock | 6.25 | 6.38 | 6.25 | 6.38 | 2400.0 |
| 2000-08-18 | AD | Stock | 47.5833 | 49.6667 | 47.5833 | 48.5417 | 339300.0 |
| 2000-08-18 | ADAT-DELISTED | Stock | 81.84 | 82.69 | 74.25 | 81.0 | 4300.0 |
| 2000-08-18 | ADBE | Stock | 30.8281 | 31.0312 | 30.0938 | 30.6406 | 4222800.0 |
| 2000-08-18 | ADC | Stock | 14.5 | 15.1875 | 14.5 | 14.8125 | 12900.0 |
| 2000-08-18 | ADEP-DELISTED | Stock | 163.91 | 170.0 | 162.5 | 162.81 | 16700.0 |
| 2000-08-18 | ADGF-DELISTED | Stock | 1.12 | 1.12 | 1.09 | 1.09 | 4800.0 |
| 2000-08-18 | ADI | Stock | 96.0 | 97.75 | 93.8125 | 94.25 | 3260400.0 |
> showing 50 of 2,807 rows — these rows as CSV