PREVIEW / stock_daily / 2000-03-27
file: by_date/stock_daily/2000/2000-03-27.parquet size: 86 KB rows: 2,746 symbols: 1,720
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-03-27 | AAPL | Stock | 1.2288 | 1.2924 | 1.2221 | 1.2461 | 279182400.0 |
| 2000-03-27 | MSFT | Stock | 53.8828 | 54.125 | 51.9688 | 52.0312 | 111434000.0 |
| 2000-03-27 | NVDA | Stock | 0.1937 | 0.2 | 0.1797 | 0.1814 | 388944000.0 |
| 2000-03-27 | AMZN | Stock | 3.6125 | 3.7562 | 3.5875 | 3.6562 | 94972000.0 |
| 2000-03-27 | CL | Stock | 27.5 | 27.75 | 26.9688 | 27.0938 | 3348600.0 |
| 2000-03-27 | A | Stock | 84.5404 | 85.4793 | 80.9639 | 81.7239 | 846769.0 |
| 2000-03-27 | AABA-DELISTED | Stock | 97.8125 | 102.59375 | 97.5 | 100.375 | 17279800.0 |
| 2000-03-27 | AAI-DELISTED | Stock | 4.63 | 4.66 | 4.19 | 4.31 | 528400.0 |
| 2000-03-27 | AAIC-DELISTED | Stock | 300.0 | 305.0 | 292.5 | 293.75 | 108700.0 |
| 2000-03-27 | AAME | Stock | 2.75 | 2.7812 | 2.6875 | 2.7812 | 26300.0 |
| 2000-03-27 | AAON | Stock | 1.0389 | 1.0389 | 1.0169 | 1.0316 | 239203.0 |
| 2000-03-27 | ABAX-DELISTED | Stock | 8.75 | 9.125 | 8.3125 | 8.625 | 68000.0 |
| 2000-03-27 | ABC-DELISTED | Stock | 3.75 | 3.765625 | 3.6875 | 3.734375 | 291600.0 |
| 2000-03-27 | ABCB | Stock | 8.1053 | 8.1053 | 8.0547 | 8.0547 | 6909.0 |
| 2000-03-27 | ABCW-DELISTED | Stock | 13.75 | 14.75 | 13.63 | 14.44 | 124490.0 |
| 2000-03-27 | ABE-DELISTED | Stock | 18.625 | 18.8125 | 18.4375 | 18.8125 | 20700.0 |
| 2000-03-27 | ABFS-DELISTED | Stock | 11.625 | 11.6875 | 11.0 | 11.0 | 37300.0 |
| 2000-03-27 | ABK-DELISTED | Stock | 52.25 | 52.25 | 49.13 | 49.31 | 409000.0 |
| 2000-03-27 | ABM | Stock | 13.125 | 13.125 | 11.9688 | 12.8438 | 209600.0 |
| 2000-03-27 | ABMD-DELISTED | Stock | 24.5313 | 24.5313 | 22.125 | 22.563 | 100600.0 |
| 2000-03-27 | ABT | Stock | 15.0382 | 15.2065 | 14.8698 | 14.926 | 7046990.0 |
| 2000-03-27 | ABTL-DELISTED | Stock | 40.62 | 43.75 | 40.0 | 41.88 | 42800.0 |
| 2000-03-27 | ABV-DELISTED | Stock | 16.0 | 16.25 | 15.25 | 15.5 | 89700.0 |
| 2000-03-27 | ABX-DELISTED | Stock | 16.5625 | 16.75 | 16.25 | 16.375 | 1081300.0 |
| 2000-03-27 | ACAS-DELISTED | Stock | 24.06 | 26.13 | 23.75 | 24.69 | 153000.0 |
| 2000-03-27 | ACAT-DELISTED | Stock | 10.0 | 10.063 | 10.0 | 10.063 | 17300.0 |
| 2000-03-27 | ACCL-DELISTED | Stock | 38.2799987792969 | 41.0029983520508 | 37.5629997253418 | 38.3779983520508 | 589800.0 |
| 2000-03-27 | ACE-DELISTED | Stock | 19.0 | 19.0 | 18.0 | 18.5 | 516200.0 |
| 2000-03-27 | ACF-DELISTED | Stock | 15.13 | 15.13 | 14.13 | 14.25 | 558400.0 |
| 2000-03-27 | ACG-DELISTED | Stock | 7.0625 | 7.0625 | 6.9375 | 6.9375 | 132500.0 |
| 2000-03-27 | ACGN-DELISTED | Stock | 3400.0 | 3400.0 | 3116.6712 | 3187.5 | 74400.0 |
| 2000-03-27 | ACH | Stock | 7.625 | 7.625 | 7.4167 | 7.4583 | 51300.0 |
| 2000-03-27 | ACO-DELISTED | Stock | 14.75 | 14.9375 | 14.5625 | 14.9375 | 5800.0 |
| 2000-03-27 | ACS-DELISTED | Stock | 17.875 | 17.9375 | 17.0625 | 17.4688 | 158400.0 |
| 2000-03-27 | ACTA-DELISTED | Stock | 2227.5 | 2227.5 | 2122.5 | 2131.25 | 98800.0 |
| 2000-03-27 | ACTT-DELISTED | Stock | 14.0 | 14.0 | 13.0 | 13.0 | 7900.0 |
| 2000-03-27 | ACTU-DELISTED | Stock | 63.88 | 65.56 | 61.06 | 64.0 | 83200.0 |
| 2000-03-27 | ACXM-DELISTED | Stock | 31.5 | 32.5 | 30.88 | 32.06 | 375700.0 |
| 2000-03-27 | ACY-DELISTED | Stock | 6.88 | 6.88 | 6.5 | 6.5 | 2500.0 |
| 2000-03-27 | AD | Stock | 44.5 | 44.5 | 42.8333 | 43.5 | 276450.0 |
| 2000-03-27 | ADAT-DELISTED | Stock | 259.88 | 265.5 | 249.75 | 254.25 | 7600.0 |
| 2000-03-27 | ADBE | Stock | 27.2188 | 28.6719 | 27.0 | 28.4062 | 6834400.0 |
| 2000-03-27 | ADC | Stock | 14.25 | 14.25 | 13.8125 | 14.0625 | 5100.0 |
| 2000-03-27 | ADEP-DELISTED | Stock | 67.5 | 68.75 | 63.75 | 65.0 | 5400.0 |
| 2000-03-27 | ADGF-DELISTED | Stock | 1.66 | 1.75 | 1.66 | 1.75 | 34400.0 |
| 2000-03-27 | ADI | Stock | 88.0 | 90.25 | 87.0 | 88.0 | 2045300.0 |
| 2000-03-27 | ADM | Stock | 9.1837 | 9.2971 | 9.0703 | 9.2971 | 848594.0 |
| 2000-03-27 | ADMP-DELISTED | Stock | 1349.375 | 1402.5 | 1349.375 | 1360.0 | 300.0 |
| 2000-03-27 | ADPI-DELISTED | Stock | 7.94 | 8.0 | 7.88 | 7.88 | 23700.0 |
| 2000-03-27 | ADSK | Stock | 12.5938 | 12.8125 | 12.4688 | 12.5469 | 2181600.0 |
> showing 50 of 2,746 rows — these rows as CSV