PREVIEW / stock_daily / 2000-07-28
file: by_date/stock_daily/2000/2000-07-28.parquet size: 87 KB rows: 2,777 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-07-28 | AAPL | Stock | 0.9336 | 0.9375 | 0.8371 | 0.8627 | 237893600.0 |
| 2000-07-28 | MSFT | Stock | 35.4688 | 35.9062 | 34.8125 | 34.8438 | 75645600.0 |
| 2000-07-28 | NVDA | Stock | 0.2208 | 0.2414 | 0.2083 | 0.225 | 512664000.0 |
| 2000-07-28 | AMZN | Stock | 1.5719 | 1.6063 | 1.45 | 1.5 | 248940000.0 |
| 2000-07-28 | CL | Stock | 28.625 | 28.75 | 27.6562 | 28.0 | 2619800.0 |
| 2000-07-28 | A | Stock | 29.8641 | 29.9535 | 28.2546 | 29.5064 | 9616982.0 |
| 2000-07-28 | AABA-DELISTED | Stock | 67.34375 | 68.375 | 63.03125 | 63.375 | 14022600.0 |
| 2000-07-28 | AAI-DELISTED | Stock | 4.31 | 4.31 | 4.06 | 4.19 | 85100.0 |
| 2000-07-28 | AAIC-DELISTED | Stock | 138.75 | 140.0 | 132.5 | 135.0 | 19800.0 |
| 2000-07-28 | AAME | Stock | 2.0 | 2.0 | 2.0 | 2.0 | 700.0 |
| 2000-07-28 | AAON | Stock | 1.4266 | 1.4266 | 1.3973 | 1.3973 | 35880.0 |
| 2000-07-28 | ABAX-DELISTED | Stock | 5.65625 | 5.875 | 5.375 | 5.6875 | 56500.0 |
| 2000-07-28 | ABC-DELISTED | Stock | 8.875 | 9.0625 | 8.640625 | 8.6875 | 4063600.0 |
| 2000-07-28 | ABCB | Stock | 7.5987 | 7.5987 | 7.3962 | 7.3962 | 11352.0 |
| 2000-07-28 | ABCW-DELISTED | Stock | 15.185 | 15.247 | 15.06 | 15.06 | 20000.0 |
| 2000-07-28 | ABE-DELISTED | Stock | 14.5 | 14.5 | 14.125 | 14.25 | 12100.0 |
| 2000-07-28 | ABFS-DELISTED | Stock | 13.375 | 13.9375 | 13.375 | 13.8125 | 98600.0 |
| 2000-07-28 | ABK-DELISTED | Stock | 65.5 | 66.13 | 62.0 | 62.75 | 409400.0 |
| 2000-07-28 | ABM | Stock | 12.375 | 12.5938 | 12.25 | 12.5625 | 18400.0 |
| 2000-07-28 | ABMD-DELISTED | Stock | 21.0938 | 21.188 | 18.9375 | 20.04688 | 78600.0 |
| 2000-07-28 | ABT | Stock | 17.8719 | 18.9099 | 17.8438 | 18.6294 | 5858309.0 |
| 2000-07-28 | ABTL-DELISTED | Stock | 25.0 | 26.88 | 21.88 | 26.88 | 33600.0 |
| 2000-07-28 | ABV-DELISTED | Stock | 20.81 | 20.81 | 20.37 | 20.5 | 79700.0 |
| 2000-07-28 | ABX-DELISTED | Stock | 16.219 | 16.407 | 16.031 | 16.157 | 810411.0 |
| 2000-07-28 | ACAS-DELISTED | Stock | 25.13 | 25.44 | 24.5 | 25.06 | 93500.0 |
| 2000-07-28 | ACAT-DELISTED | Stock | 12.125 | 12.313 | 12.125 | 12.188 | 4200.0 |
| 2000-07-28 | ACCL-DELISTED | Stock | 28.25 | 29.2360000610352 | 25.886999130249 | 26.7919998168945 | 237700.0 |
| 2000-07-28 | ACE-DELISTED | Stock | 36.0 | 36.125 | 34.9375 | 35.5 | 1413800.0 |
| 2000-07-28 | ACF-DELISTED | Stock | 20.19 | 20.19 | 19.44 | 19.88 | 199800.0 |
| 2000-07-28 | ACG-DELISTED | Stock | 7.5 | 7.5 | 7.4375 | 7.4375 | 24700.0 |
| 2000-07-28 | ACGL | Stock | 1.7083 | 1.7361 | 1.6736 | 1.7101 | 45900.0 |
| 2000-07-28 | ACGN-DELISTED | Stock | 991.6712 | 1062.5 | 991.6712 | 991.6712 | 14200.0 |
| 2000-07-28 | ACH | Stock | 10.5 | 10.5833 | 10.3333 | 10.4167 | 25500.0 |
| 2000-07-28 | ACLS | Stock | 68.5 | 68.75 | 57.0 | 61.5 | 515300.0 |
| 2000-07-28 | ACO-DELISTED | Stock | 3.5625 | 3.5625 | 3.3125 | 3.3125 | 39300.0 |
| 2000-07-28 | ACS-DELISTED | Stock | 21.875 | 23.75 | 21.5625 | 23.0313 | 403300.0 |
| 2000-07-28 | ACTA-DELISTED | Stock | 667.5 | 668.75 | 620.0 | 641.25 | 137600.0 |
| 2000-07-28 | ACTT-DELISTED | Stock | 5.5625 | 5.875 | 5.5 | 5.875 | 25500.0 |
| 2000-07-28 | ACTU-DELISTED | Stock | 44.88 | 45.0 | 39.5 | 42.0 | 291300.0 |
| 2000-07-28 | ACXM-DELISTED | Stock | 22.0 | 22.13 | 20.06 | 20.13 | 3128354.0 |
| 2000-07-28 | ACY-DELISTED | Stock | 6.5 | 6.5 | 6.5 | 6.5 | 5400.0 |
| 2000-07-28 | AD | Stock | 45.125 | 45.2917 | 44.625 | 44.7083 | 159300.0 |
| 2000-07-28 | ADAT-DELISTED | Stock | 92.25 | 95.62 | 85.5 | 85.5 | 9000.0 |
| 2000-07-28 | ADBE | Stock | 28.5078 | 29.2812 | 26.5625 | 27.8438 | 6603600.0 |
| 2000-07-28 | ADC | Stock | 16.375 | 16.5 | 16.125 | 16.1875 | 4800.0 |
| 2000-07-28 | ADEP-DELISTED | Stock | 160.31 | 167.5 | 140.31 | 143.75 | 31700.0 |
| 2000-07-28 | ADGF-DELISTED | Stock | 1.25 | 1.31 | 1.19 | 1.25 | 62400.0 |
| 2000-07-28 | ADI | Stock | 63.8125 | 67.875 | 63.125 | 64.0 | 3850200.0 |
| 2000-07-28 | ADM | Stock | 8.7302 | 9.4671 | 8.6735 | 8.6735 | 1299847.0 |
| 2000-07-28 | ADMP-DELISTED | Stock | 1530.0 | 1530.0 | 1508.75 | 1508.75 | 100.0 |
> showing 50 of 2,777 rows — these rows as CSV