PREVIEW / stock_daily / 2000-08-02
file: by_date/stock_daily/2000/2000-08-02.parquet size: 87 KB rows: 2,781 symbols: 1,729
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-02 | AAPL | Stock | 0.875 | 0.8917 | 0.8426 | 0.8438 | 162355200.0 |
| 2000-08-02 | MSFT | Stock | 34.2812 | 35.2188 | 34.25 | 34.6875 | 48269200.0 |
| 2000-08-02 | NVDA | Stock | 0.2417 | 0.254 | 0.2378 | 0.25 | 345432000.0 |
| 2000-08-02 | AMZN | Stock | 1.5125 | 1.6 | 1.5109 | 1.5406 | 99058000.0 |
| 2000-08-02 | CL | Stock | 28.5625 | 28.6875 | 27.6875 | 28.2812 | 1903600.0 |
| 2000-08-02 | A | Stock | 28.7017 | 29.4617 | 28.2546 | 28.7017 | 6748845.0 |
| 2000-08-02 | AABA-DELISTED | Stock | 63.34375 | 66.53125 | 63.125 | 63.5625 | 9287400.0 |
| 2000-08-02 | AAI-DELISTED | Stock | 4.31 | 4.44 | 4.31 | 4.31 | 106600.0 |
| 2000-08-02 | AAIC-DELISTED | Stock | 140.0 | 141.25 | 133.75 | 141.25 | 53500.0 |
| 2000-08-02 | AAME | Stock | 2.0 | 2.0 | 2.0 | 2.0 | 8400.0 |
| 2000-08-02 | AAON | Stock | 1.4339 | 1.4888 | 1.401 | 1.4522 | 160608.0 |
| 2000-08-02 | ABAX-DELISTED | Stock | 5.75 | 5.75 | 5.6875 | 5.6875 | 3300.0 |
| 2000-08-02 | ABC-DELISTED | Stock | 8.765625 | 8.875 | 8.59375 | 8.65625 | 488000.0 |
| 2000-08-02 | ABCB | Stock | 7.3454 | 7.3454 | 7.3454 | 7.3454 | 1481.0 |
| 2000-08-02 | ABCW-DELISTED | Stock | 15.5 | 15.69 | 15.5 | 15.56 | 12800.0 |
| 2000-08-02 | ABE-DELISTED | Stock | 13.8125 | 13.9375 | 13.8125 | 13.875 | 19100.0 |
| 2000-08-02 | ABFS-DELISTED | Stock | 14.1875 | 14.375 | 14.125 | 14.25 | 231100.0 |
| 2000-08-02 | ABK-DELISTED | Stock | 64.13 | 64.13 | 63.06 | 63.25 | 214900.0 |
| 2000-08-02 | ABM | Stock | 12.2188 | 12.4062 | 11.9688 | 12.4062 | 44000.0 |
| 2000-08-02 | ABMD-DELISTED | Stock | 19.938 | 20.0625 | 18.8 | 19.5 | 49600.0 |
| 2000-08-02 | ABT | Stock | 18.9099 | 19.1905 | 18.5733 | 19.1905 | 11376008.0 |
| 2000-08-02 | ABTL-DELISTED | Stock | 24.69 | 25.0 | 22.5 | 24.38 | 20100.0 |
| 2000-08-02 | ABV-DELISTED | Stock | 20.37 | 20.81 | 20.0 | 20.25 | 145100.0 |
| 2000-08-02 | ABX-DELISTED | Stock | 16.407 | 16.532 | 16.157 | 16.469 | 850283.0 |
| 2000-08-02 | ACAS-DELISTED | Stock | 25.5 | 25.5 | 24.63 | 24.69 | 87900.0 |
| 2000-08-02 | ACAT-DELISTED | Stock | 12.563 | 12.625 | 12.063 | 12.094 | 197096.0 |
| 2000-08-02 | ACCL-DELISTED | Stock | 26.7600002288818 | 28.8740005493164 | 26.4759998321533 | 28.1499996185303 | 111700.0 |
| 2000-08-02 | ACE-DELISTED | Stock | 33.5625 | 34.375 | 32.3125 | 32.625 | 1763200.0 |
| 2000-08-02 | ACF-DELISTED | Stock | 21.0 | 21.19 | 20.19 | 20.31 | 293400.0 |
| 2000-08-02 | ACG-DELISTED | Stock | 7.5 | 7.5625 | 7.4375 | 7.4375 | 78400.0 |
| 2000-08-02 | ACGN-DELISTED | Stock | 885.4688 | 920.8288 | 708.3288 | 708.3288 | 98800.0 |
| 2000-08-02 | ACH | Stock | 11.1667 | 11.2917 | 10.75 | 11.1667 | 272250.0 |
| 2000-08-02 | ACLS | Stock | 64.25 | 69.0 | 64.0 | 66.0 | 194850.0 |
| 2000-08-02 | ACO-DELISTED | Stock | 3.6875 | 3.875 | 3.6875 | 3.875 | 86200.0 |
| 2000-08-02 | ACS-DELISTED | Stock | 23.3438 | 24.375 | 23.125 | 23.875 | 365600.0 |
| 2000-08-02 | ACTA-DELISTED | Stock | 607.5 | 685.0 | 601.25 | 645.0 | 197300.0 |
| 2000-08-02 | ACTT-DELISTED | Stock | 5.625 | 6.0625 | 5.625 | 6.0625 | 30100.0 |
| 2000-08-02 | ACTU-DELISTED | Stock | 45.25 | 48.0 | 44.63 | 45.0 | 178700.0 |
| 2000-08-02 | ACXM-DELISTED | Stock | 21.0 | 22.125 | 20.8125 | 21.75 | 1401100.0 |
| 2000-08-02 | AD | Stock | 45.3333 | 45.9167 | 45.2917 | 45.5 | 118650.0 |
| 2000-08-02 | ADAT-DELISTED | Stock | 80.44 | 83.81 | 72.56 | 73.12 | 17900.0 |
| 2000-08-02 | ADBE | Stock | 28.7656 | 29.7148 | 28.5 | 29.0781 | 5342000.0 |
| 2000-08-02 | ADC | Stock | 15.5 | 15.875 | 15.1875 | 15.6875 | 12400.0 |
| 2000-08-02 | ADEP-DELISTED | Stock | 120.0 | 120.0 | 110.0 | 120.0 | 45300.0 |
| 2000-08-02 | ADGF-DELISTED | Stock | 1.22 | 1.25 | 1.06 | 1.19 | 34700.0 |
| 2000-08-02 | ADI | Stock | 65.0625 | 66.5 | 61.5 | 63.75 | 2133400.0 |
| 2000-08-02 | ADM | Stock | 8.9569 | 9.1837 | 8.9002 | 9.0703 | 3798443.0 |
| 2000-08-02 | ADMP-DELISTED | Stock | 1508.75 | 1530.0 | 1508.75 | 1508.75 | 200.0 |
| 2000-08-02 | ADSK | Stock | 5.1797 | 5.4844 | 5.125 | 5.3594 | 2554400.0 |
| 2000-08-02 | ADTN | Stock | 29.875 | 32.25 | 29.875 | 31.7812 | 1058200.0 |
> showing 50 of 2,781 rows — these rows as CSV