PREVIEW / stock_daily / 2000-04-28
file: by_date/stock_daily/2000/2000-04-28.parquet size: 86 KB rows: 2,745 symbols: 1,716
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-04-28 | AAPL | Stock | 1.135 | 1.1384 | 1.0831 | 1.1077 | 249580800.0 |
| 2000-04-28 | MSFT | Stock | 35.375 | 35.5 | 34.125 | 34.875 | 78082600.0 |
| 2000-04-28 | NVDA | Stock | 0.1926 | 0.2 | 0.1857 | 0.1857 | 179040000.0 |
| 2000-04-28 | AMZN | Stock | 2.7 | 2.7812 | 2.6562 | 2.7594 | 136676000.0 |
| 2000-04-28 | CL | Stock | 28.25 | 28.875 | 27.4375 | 28.5625 | 3996600.0 |
| 2000-04-28 | A | Stock | 64.3777 | 64.4224 | 62.1871 | 63.3941 | 1779374.0 |
| 2000-04-28 | AABA-DELISTED | Stock | 63.375 | 65.9375 | 62.75 | 65.125 | 14908800.0 |
| 2000-04-28 | AAI-DELISTED | Stock | 4.28 | 4.38 | 4.16 | 4.25 | 269300.0 |
| 2000-04-28 | AAIC-DELISTED | Stock | 127.5 | 170.0 | 125.0 | 156.25 | 331300.0 |
| 2000-04-28 | AAME | Stock | 2.625 | 2.6875 | 2.625 | 2.6875 | 3500.0 |
| 2000-04-28 | AAON | Stock | 1.1559 | 1.2291 | 1.1559 | 1.2291 | 189654.0 |
| 2000-04-28 | ABAX-DELISTED | Stock | 7.5 | 7.5 | 6.875 | 7.125 | 63700.0 |
| 2000-04-28 | ABC-DELISTED | Stock | 4.90625 | 5.0 | 4.859375 | 5.0 | 758800.0 |
| 2000-04-28 | ABCB | Stock | 8.0547 | 8.0547 | 8.004 | 8.004 | 5552.0 |
| 2000-04-28 | ABCW-DELISTED | Stock | 15.0 | 15.811 | 14.379 | 15.75 | 44900.0 |
| 2000-04-28 | ABE-DELISTED | Stock | 15.5 | 15.5 | 15.4375 | 15.4375 | 25900.0 |
| 2000-04-28 | ABFS-DELISTED | Stock | 12.9375 | 13.125 | 12.875 | 12.9375 | 51900.0 |
| 2000-04-28 | ABK-DELISTED | Stock | 48.94 | 49.0 | 46.69 | 47.94 | 366500.0 |
| 2000-04-28 | ABM | Stock | 12.5625 | 12.625 | 12.5312 | 12.625 | 29000.0 |
| 2000-04-28 | ABMD-DELISTED | Stock | 17.2 | 19.2188 | 16.5 | 18.562 | 81600.0 |
| 2000-04-28 | ABT | Stock | 17.3949 | 17.3949 | 16.918 | 17.2546 | 6870336.0 |
| 2000-04-28 | ABTL-DELISTED | Stock | 31.25 | 31.25 | 27.66 | 29.53 | 37600.0 |
| 2000-04-28 | ABV-DELISTED | Stock | 14.13 | 15.5 | 14.13 | 15.5 | 60500.0 |
| 2000-04-28 | ABX-DELISTED | Stock | 16.657 | 16.97 | 16.594 | 16.782 | 888311.0 |
| 2000-04-28 | ACAS-DELISTED | Stock | 23.5625 | 24.5625 | 23.375 | 24.3125 | 63300.0 |
| 2000-04-28 | ACAT-DELISTED | Stock | 9.969 | 10.157 | 9.969 | 10.032 | 111547.0 |
| 2000-04-28 | ACCL-DELISTED | Stock | 29.4099998474121 | 30.0510005950928 | 27.8780002593994 | 29.7789993286133 | 370800.0 |
| 2000-04-28 | ACE-DELISTED | Stock | 24.44 | 24.5 | 23.13 | 23.94 | 704900.0 |
| 2000-04-28 | ACF-DELISTED | Stock | 18.75 | 18.75 | 18.31 | 18.69 | 209600.0 |
| 2000-04-28 | ACG-DELISTED | Stock | 6.9375 | 7.0625 | 6.9375 | 7.0 | 94100.0 |
| 2000-04-28 | ACGN-DELISTED | Stock | 1983.3288 | 2125.0 | 1841.6712 | 1841.6712 | 52100.0 |
| 2000-04-28 | ACH | Stock | 7.875 | 8.0 | 7.875 | 8.0 | 56850.0 |
| 2000-04-28 | ACO-DELISTED | Stock | 14.75 | 16.4375 | 14.75 | 16.3125 | 246700.0 |
| 2000-04-28 | ACS-DELISTED | Stock | 16.5 | 16.7813 | 16.4063 | 16.5625 | 691800.0 |
| 2000-04-28 | ACTA-DELISTED | Stock | 817.5 | 875.0 | 805.0 | 847.5 | 163200.0 |
| 2000-04-28 | ACTT-DELISTED | Stock | 8.9375 | 8.9375 | 7.9375 | 8.3125 | 12600.0 |
| 2000-04-28 | ACTU-DELISTED | Stock | 26.5 | 30.0 | 26.5 | 29.94 | 290600.0 |
| 2000-04-28 | ACXM-DELISTED | Stock | 27.5929 | 28.1535 | 26.9077 | 27.0946 | 336538.0 |
| 2000-04-28 | ACY-DELISTED | Stock | 7.75 | 7.75 | 7.62 | 7.75 | 7400.0 |
| 2000-04-28 | AD | Stock | 41.1667 | 41.25 | 40.0 | 40.0417 | 481800.0 |
| 2000-04-28 | ADAT-DELISTED | Stock | 183.37 | 187.31 | 168.75 | 178.88 | 4600.0 |
| 2000-04-28 | ADBE | Stock | 31.2031 | 31.9688 | 29.5 | 30.2344 | 11328800.0 |
| 2000-04-28 | ADC | Stock | 14.25 | 14.5 | 14.1875 | 14.1875 | 15600.0 |
| 2000-04-28 | ADEP-DELISTED | Stock | 57.19 | 58.75 | 55.0 | 58.75 | 2700.0 |
| 2000-04-28 | ADGF-DELISTED | Stock | 1.31 | 1.44 | 1.25 | 1.44 | 51900.0 |
| 2000-04-28 | ADI | Stock | 73.0 | 77.5312 | 72.125 | 76.8125 | 2354600.0 |
| 2000-04-28 | ADM | Stock | 8.9569 | 9.1837 | 8.9002 | 9.0136 | 1329835.0 |
| 2000-04-28 | ADMP-DELISTED | Stock | 1168.75 | 1243.125 | 1168.75 | 1243.125 | 200.0 |
| 2000-04-28 | ADPI-DELISTED | Stock | 7.25 | 7.63 | 7.25 | 7.63 | 9100.0 |
| 2000-04-28 | ADSK | Stock | 9.2188 | 9.6562 | 9.1875 | 9.5938 | 754800.0 |
> showing 50 of 2,745 rows — these rows as CSV