PREVIEW / stock_daily / 2000-07-18
file: by_date/stock_daily/2000/2000-07-18.parquet size: 88 KB rows: 2,783 symbols: 1,734
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-18 | AAPL | Stock | 1.0446 | 1.0513 | 1.0156 | 1.0223 | 318404800.0 |
| 2000-07-18 | MSFT | Stock | 38.8125 | 39.75 | 38.7188 | 39.25 | 70617200.0 |
| 2000-07-18 | NVDA | Stock | 0.2875 | 0.3125 | 0.2875 | 0.2982 | 183672000.0 |
| 2000-07-18 | AMZN | Stock | 2.0062 | 2.1812 | 1.975 | 2.0875 | 159168000.0 |
| 2000-07-18 | CL | Stock | 27.75 | 27.75 | 27.3438 | 27.4688 | 3507200.0 |
| 2000-07-18 | A | Stock | 55.794 | 55.794 | 52.9328 | 54.8104 | 3661502.0 |
| 2000-07-18 | AABA-DELISTED | Stock | 64.6875 | 66.6875 | 63.5625 | 64.96875 | 15129400.0 |
| 2000-07-18 | AAI-DELISTED | Stock | 4.81 | 4.94 | 4.75 | 4.81 | 285400.0 |
| 2000-07-18 | AAIC-DELISTED | Stock | 151.25 | 151.25 | 140.0 | 146.25 | 58300.0 |
| 2000-07-18 | AAME | Stock | 2.75 | 2.75 | 2.75 | 2.75 | 700.0 |
| 2000-07-18 | AAON | Stock | 1.3973 | 1.4193 | 1.39 | 1.4193 | 206740.0 |
| 2000-07-18 | ABAX-DELISTED | Stock | 6.5 | 6.5 | 6.375 | 6.4375 | 18300.0 |
| 2000-07-18 | ABC-DELISTED | Stock | 7.6875 | 8.09375 | 7.6875 | 7.703125 | 982800.0 |
| 2000-07-18 | ABCB | Stock | 7.9028 | 7.9028 | 7.8014 | 7.8014 | 3456.0 |
| 2000-07-18 | ABCW-DELISTED | Stock | 16.0 | 16.125 | 15.936 | 16.0 | 86600.0 |
| 2000-07-18 | ABE-DELISTED | Stock | 15.75 | 15.75 | 15.625 | 15.75 | 7200.0 |
| 2000-07-18 | ABFS-DELISTED | Stock | 10.9375 | 11.0625 | 10.9375 | 11.0 | 119900.0 |
| 2000-07-18 | ABK-DELISTED | Stock | 56.5 | 56.5 | 55.38 | 55.81 | 217500.0 |
| 2000-07-18 | ABM | Stock | 12.8125 | 13.0938 | 12.8125 | 13.0 | 93600.0 |
| 2000-07-18 | ABMD-DELISTED | Stock | 23.9375 | 24.062 | 21.0312 | 21.938 | 247400.0 |
| 2000-07-18 | ABT | Stock | 19.1625 | 19.4711 | 18.5733 | 18.8258 | 5274216.0 |
| 2000-07-18 | ABTL-DELISTED | Stock | 33.13 | 34.38 | 32.19 | 32.81 | 18300.0 |
| 2000-07-18 | ABV-DELISTED | Stock | 20.0 | 20.19 | 19.62 | 20.13 | 1441700.0 |
| 2000-07-18 | ABX-DELISTED | Stock | 17.719 | 17.969 | 17.657 | 17.844 | 587914.0 |
| 2000-07-18 | ACAS-DELISTED | Stock | 25.875 | 25.9375 | 25.3125 | 25.5 | 160200.0 |
| 2000-07-18 | ACAT-DELISTED | Stock | 12.375 | 12.4375 | 12.25 | 12.25 | 15600.0 |
| 2000-07-18 | ACCL-DELISTED | Stock | 30.7700004577637 | 32.9469985961914 | 30.1410007476807 | 30.1410007476807 | 248700.0 |
| 2000-07-18 | ACE-DELISTED | Stock | 31.19 | 31.19 | 30.13 | 30.44 | 437900.0 |
| 2000-07-18 | ACF-DELISTED | Stock | 19.5 | 19.94 | 19.5 | 19.75 | 890000.0 |
| 2000-07-18 | ACG-DELISTED | Stock | 7.625 | 7.625 | 7.5 | 7.5 | 60100.0 |
| 2000-07-18 | ACGL | Stock | 1.7431 | 1.7639 | 1.7361 | 1.7569 | 52200.0 |
| 2000-07-18 | ACGN-DELISTED | Stock | 1115.6488 | 1151.0088 | 1115.6488 | 1133.3288 | 146600.0 |
| 2000-07-18 | ACH | Stock | 11.4583 | 12.1667 | 11.375 | 11.9583 | 1603500.0 |
| 2000-07-18 | ACLS | Stock | 97.5 | 102.0 | 92.25 | 101.0 | 536950.0 |
| 2000-07-18 | ACO-DELISTED | Stock | 3.875 | 3.9375 | 3.8125 | 3.875 | 30400.0 |
| 2000-07-18 | ACS-DELISTED | Stock | 20.1875 | 20.8438 | 20.0313 | 20.5313 | 697900.0 |
| 2000-07-18 | ACTA-DELISTED | Stock | 837.5 | 903.75 | 808.75 | 892.5 | 386900.0 |
| 2000-07-18 | ACTT-DELISTED | Stock | 6.2813 | 6.2813 | 6.125 | 6.25 | 21500.0 |
| 2000-07-18 | ACTU-DELISTED | Stock | 56.56 | 58.19 | 56.5 | 57.0 | 391500.0 |
| 2000-07-18 | ACXM-DELISTED | Stock | 28.625 | 28.625 | 27.5 | 27.625 | 206900.0 |
| 2000-07-18 | ACY-DELISTED | Stock | 6.62 | 6.62 | 6.5 | 6.5 | 1300.0 |
| 2000-07-18 | AD | Stock | 44.0 | 44.0 | 42.3333 | 42.6667 | 338100.0 |
| 2000-07-18 | ADAT-DELISTED | Stock | 109.12 | 114.75 | 108.0 | 108.0 | 2000.0 |
| 2000-07-18 | ADBE | Stock | 33.7812 | 33.8125 | 32.5 | 32.7344 | 3682400.0 |
| 2000-07-18 | ADC | Stock | 16.9375 | 17.125 | 16.5 | 16.5 | 14700.0 |
| 2000-07-18 | ADEP-DELISTED | Stock | 155.78 | 204.69 | 155.31 | 204.69 | 141000.0 |
| 2000-07-18 | ADGF-DELISTED | Stock | 1.3 | 1.34 | 1.25 | 1.25 | 30400.0 |
| 2000-07-18 | ADI | Stock | 86.5 | 86.875 | 81.5625 | 83.0 | 2259800.0 |
| 2000-07-18 | ADM | Stock | 9.0136 | 9.0703 | 8.9002 | 9.0136 | 1494659.0 |
| 2000-07-18 | ADMP-DELISTED | Stock | 1519.375 | 1519.375 | 1445.0 | 1487.5 | 100.0 |
> showing 50 of 2,783 rows — these rows as CSV