PREVIEW / stock_daily / 2000-04-20
file: by_date/stock_daily/2000/2000-04-20.parquet size: 84 KB rows: 2,717 symbols: 1,688
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-20 | AAPL | Stock | 1.1044 | 1.1138 | 1.0452 | 1.0614 | 722120000.0 |
| 2000-04-20 | MSFT | Stock | 39.3125 | 39.9375 | 38.75 | 39.4688 | 52387400.0 |
| 2000-04-20 | NVDA | Stock | 0.1734 | 0.1767 | 0.1656 | 0.168 | 153936000.0 |
| 2000-04-20 | AMZN | Stock | 2.6688 | 2.6844 | 2.4938 | 2.6188 | 98506000.0 |
| 2000-04-20 | CL | Stock | 27.625 | 28.6875 | 27.3125 | 28.5625 | 5521400.0 |
| 2000-04-20 | A | Stock | 62.8577 | 65.6295 | 62.5 | 64.333 | 1453081.0 |
| 2000-04-20 | AABA-DELISTED | Stock | 63.25 | 64.5625 | 59.75 | 61.5625 | 13100600.0 |
| 2000-04-20 | AAI-DELISTED | Stock | 4.09 | 4.25 | 4.06 | 4.22 | 248100.0 |
| 2000-04-20 | AAIC-DELISTED | Stock | 142.5 | 157.5 | 142.5 | 150.0 | 67700.0 |
| 2000-04-20 | AAME | Stock | 2.625 | 2.6875 | 2.625 | 2.625 | 6100.0 |
| 2000-04-20 | AAON | Stock | 1.1925 | 1.2218 | 1.1742 | 1.2108 | 681729.0 |
| 2000-04-20 | ABAX-DELISTED | Stock | 7.0625 | 7.625 | 6.9375 | 7.0 | 44200.0 |
| 2000-04-20 | ABC-DELISTED | Stock | 4.515625 | 4.609375 | 4.515625 | 4.515625 | 406000.0 |
| 2000-04-20 | ABCW-DELISTED | Stock | 14.5 | 15.501 | 14.44 | 15.38 | 21100.0 |
| 2000-04-20 | ABE-DELISTED | Stock | 15.875 | 15.875 | 15.0625 | 15.125 | 21400.0 |
| 2000-04-20 | ABFS-DELISTED | Stock | 13.5 | 13.875 | 13.125 | 13.125 | 52200.0 |
| 2000-04-20 | ABK-DELISTED | Stock | 47.5 | 48.94 | 46.81 | 48.19 | 380400.0 |
| 2000-04-20 | ABM | Stock | 11.875 | 12.3125 | 11.875 | 12.1875 | 42800.0 |
| 2000-04-20 | ABMD-DELISTED | Stock | 17.25 | 17.938 | 17.0312 | 17.7188 | 70600.0 |
| 2000-04-20 | ABT | Stock | 17.3107 | 17.6755 | 17.1705 | 17.6194 | 6094887.0 |
| 2000-04-20 | ABTL-DELISTED | Stock | 33.12 | 33.75 | 30.16 | 30.16 | 22700.0 |
| 2000-04-20 | ABV-DELISTED | Stock | 13.5 | 14.19 | 13.5 | 14.13 | 20100.0 |
| 2000-04-20 | ABX-DELISTED | Stock | 17.001 | 17.748 | 16.938 | 17.125 | 2128915.0 |
| 2000-04-20 | ACAS-DELISTED | Stock | 22.75 | 24.9375 | 22.75 | 24.625 | 55800.0 |
| 2000-04-20 | ACAT-DELISTED | Stock | 10.0 | 10.0625 | 9.9375 | 10.0 | 58200.0 |
| 2000-04-20 | ACCL-DELISTED | Stock | 24.6100006103516 | 26.068000793457 | 24.257999420166 | 24.6200008392334 | 519000.0 |
| 2000-04-20 | ACE-DELISTED | Stock | 20.5 | 20.75 | 20.0 | 20.75 | 804200.0 |
| 2000-04-20 | ACF-DELISTED | Stock | 16.94 | 18.19 | 16.81 | 17.63 | 486600.0 |
| 2000-04-20 | ACG-DELISTED | Stock | 6.9375 | 7.0625 | 6.9375 | 6.9375 | 92000.0 |
| 2000-04-20 | ACGN-DELISTED | Stock | 2691.6712 | 2975.0 | 2408.3288 | 2550.0 | 67500.0 |
| 2000-04-20 | ACH | Stock | 7.8333 | 8.0 | 7.6667 | 8.0 | 57750.0 |
| 2000-04-20 | ACO-DELISTED | Stock | 13.1875 | 13.3125 | 13.125 | 13.3125 | 18400.0 |
| 2000-04-20 | ACS-DELISTED | Stock | 18.0 | 18.25 | 17.8438 | 18.1875 | 107900.0 |
| 2000-04-20 | ACTA-DELISTED | Stock | 870.0 | 920.0 | 833.75 | 875.0 | 186800.0 |
| 2000-04-20 | ACTT-DELISTED | Stock | 7.9688 | 8.1875 | 7.125 | 7.75 | 45700.0 |
| 2000-04-20 | ACTU-DELISTED | Stock | 30.28 | 30.5 | 25.0 | 28.25 | 161000.0 |
| 2000-04-20 | ACXM-DELISTED | Stock | 28.25 | 28.375 | 26.75 | 26.75 | 147600.0 |
| 2000-04-20 | ACY-DELISTED | Stock | 7.0 | 7.5 | 7.0 | 7.5 | 9700.0 |
| 2000-04-20 | AD | Stock | 41.0833 | 41.0833 | 39.9167 | 40.5833 | 233100.0 |
| 2000-04-20 | ADAT-DELISTED | Stock | 172.12 | 172.12 | 166.5 | 172.12 | 7900.0 |
| 2000-04-20 | ADBE | Stock | 28.2031 | 28.6211 | 26.625 | 28.1562 | 6578800.0 |
| 2000-04-20 | ADC | Stock | 14.1875 | 14.25 | 13.875 | 13.875 | 9200.0 |
| 2000-04-20 | ADEP-DELISTED | Stock | 55.0 | 55.0 | 53.12 | 53.12 | 18900.0 |
| 2000-04-20 | ADGF-DELISTED | Stock | 1.53 | 1.59 | 1.47 | 1.56 | 53300.0 |
| 2000-04-20 | ADI | Stock | 62.625 | 65.0 | 61.25 | 64.75 | 1590800.0 |
| 2000-04-20 | ADM | Stock | 8.9569 | 9.2404 | 8.7868 | 8.8435 | 2938273.0 |
| 2000-04-20 | ADMP-DELISTED | Stock | 1147.5 | 1338.75 | 1105.0 | 1190.0 | 600.0 |
| 2000-04-20 | ADPI-DELISTED | Stock | 7.37 | 7.37 | 7.0 | 7.0 | 2300.0 |
| 2000-04-20 | ADSK | Stock | 9.9453 | 9.9531 | 9.0625 | 9.1562 | 2578400.0 |
| 2000-04-20 | ADTN | Stock | 32.25 | 32.2812 | 29.9453 | 31.3125 | 235800.0 |
> showing 50 of 2,717 rows — these rows as CSV