PREVIEW / stock_daily / 2001-04-27
file: by_date/stock_daily/2001/2001-04-27.parquet size: 100 KB rows: 2,912 symbols: 1,810
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-27 | AAPL | Stock | 0.45 | 0.4695 | 0.442 | 0.4679 | 453012000.0 |
| 2001-04-27 | MSFT | Stock | 34.765 | 34.84 | 33.105 | 33.56 | 121572400.0 |
| 2001-04-27 | NVDA | Stock | 0.3192 | 0.3305 | 0.313 | 0.3292 | 915672000.0 |
| 2001-04-27 | AMZN | Stock | 0.786 | 0.7865 | 0.751 | 0.7635 | 88920000.0 |
| 2001-04-27 | CL | Stock | 27.25 | 27.925 | 27.125 | 27.825 | 3880600.0 |
| 2001-04-27 | A | Stock | 28.1831 | 28.7554 | 27.3605 | 27.7468 | 1713529.0 |
| 2001-04-27 | AABA-DELISTED | Stock | 9.55500030517578 | 9.92500019073486 | 9.38000011444092 | 9.75 | 15259400.0 |
| 2001-04-27 | AAI-DELISTED | Stock | 9.65 | 9.65 | 9.42 | 9.5 | 405300.0 |
| 2001-04-27 | AAIC-DELISTED | Stock | 107.2 | 122.0 | 107.2 | 119.0 | 79700.0 |
| 2001-04-27 | AAME | Stock | 1.8 | 1.8 | 1.8 | 1.8 | 1000.0 |
| 2001-04-27 | AAON | Stock | 1.1003 | 1.1231 | 1.0974 | 1.112 | 164025.0 |
| 2001-04-27 | ABAX-DELISTED | Stock | 4.86 | 4.99 | 4.86 | 4.91 | 7200.0 |
| 2001-04-27 | ABB-DELISTED | Stock | 17.29 | 17.61 | 17.29 | 17.59 | 188200.0 |
| 2001-04-27 | ABC-DELISTED | Stock | 12.9449996948242 | 13.272500038147 | 12.9449996948242 | 13.2299995422363 | 2409200.0 |
| 2001-04-27 | ABCB | Stock | 9.4671 | 9.5238 | 9.2806 | 9.5238 | 1109.0 |
| 2001-04-27 | ABCW-DELISTED | Stock | 14.05 | 15.2 | 14.05 | 15.2 | 81800.0 |
| 2001-04-27 | ABE-DELISTED | Stock | 8.07 | 8.22 | 8.05 | 8.21 | 12600.0 |
| 2001-04-27 | ABFS-DELISTED | Stock | 19.16 | 19.89 | 19.16 | 19.4 | 170000.0 |
| 2001-04-27 | ABK-DELISTED | Stock | 54.75 | 55.5 | 54.1 | 54.2 | 963300.0 |
| 2001-04-27 | ABM | Stock | 16.0 | 16.5 | 16.0 | 16.5 | 528400.0 |
| 2001-04-27 | ABMD-DELISTED | Stock | 19.25 | 19.32 | 18.1 | 19.04 | 47000.0 |
| 2001-04-27 | ABP-DELISTED | Stock | 4.5 | 4.56 | 4.5 | 4.5 | 39900.0 |
| 2001-04-27 | ABT | Stock | 20.2903 | 20.6943 | 20.1287 | 20.6405 | 4656039.0 |
| 2001-04-27 | ABTL-DELISTED | Stock | 6.5 | 6.5 | 6.05 | 6.2 | 26100.0 |
| 2001-04-27 | ABV-DELISTED | Stock | 23.56 | 24.7 | 23.56 | 24.62 | 376700.0 |
| 2001-04-27 | ABX-DELISTED | Stock | 16.37 | 16.88 | 16.08 | 16.77 | 2503200.0 |
| 2001-04-27 | ACAP-DELISTED | Stock | 17.95 | 18.05 | 17.91 | 18.01 | 150400.0 |
| 2001-04-27 | ACAS-DELISTED | Stock | 26.92 | 26.99 | 26.7 | 26.98 | 102111.0 |
| 2001-04-27 | ACAT-DELISTED | Stock | 13.1 | 13.1 | 13.0 | 13.07 | 5600.0 |
| 2001-04-27 | ACCL-DELISTED | Stock | 13.8299999237061 | 14.5839996337891 | 13.5410003662109 | 14.4969997406006 | 103400.0 |
| 2001-04-27 | ACE-DELISTED | Stock | 35.4 | 35.54 | 34.9 | 35.21 | 883900.0 |
| 2001-04-27 | ACF-DELISTED | Stock | 43.75 | 46.99 | 43.75 | 46.27 | 947400.0 |
| 2001-04-27 | ACG-DELISTED | Stock | 7.97 | 7.97 | 7.94 | 7.97 | 170000.0 |
| 2001-04-27 | ACGL | Stock | 1.77 | 1.7711 | 1.7611 | 1.7611 | 241200.0 |
| 2001-04-27 | ACGN-DELISTED | Stock | 674.3288 | 748.0 | 674.3288 | 748.0 | 87900.0 |
| 2001-04-27 | ACH | Stock | 12.6667 | 13.02 | 12.6667 | 12.9067 | 378300.0 |
| 2001-04-27 | ACLS | Stock | 60.0 | 60.4 | 58.88 | 59.2 | 353300.0 |
| 2001-04-27 | ACO-DELISTED | Stock | 4.87 | 4.87 | 4.75 | 4.82 | 25300.0 |
| 2001-04-27 | ACPW-DELISTED | Stock | 112.5 | 116.55 | 112.25 | 113.9 | 83000.0 |
| 2001-04-27 | ACS-DELISTED | Stock | 35.45 | 36.245 | 35.2 | 35.695 | 542000.0 |
| 2001-04-27 | ACTA-DELISTED | Stock | 40.8 | 42.8 | 40.2 | 41.4 | 42500.0 |
| 2001-04-27 | ACTT-DELISTED | Stock | 5.65 | 5.9 | 5.65 | 5.85 | 12600.0 |
| 2001-04-27 | ACTU-DELISTED | Stock | 11.15 | 11.6 | 10.95 | 11.58 | 151600.0 |
| 2001-04-27 | ACXM-DELISTED | Stock | 14.3 | 15.03 | 14.22 | 14.71 | 1025300.0 |
| 2001-04-27 | ACY-DELISTED | Stock | 5.0 | 5.0 | 5.0 | 5.0 | 600.0 |
| 2001-04-27 | AD | Stock | 43.7333 | 44.4 | 43.5667 | 44.4 | 91800.0 |
| 2001-04-27 | ADAT-DELISTED | Stock | 102.32 | 108.28 | 101.96 | 108.28 | 1995.0 |
| 2001-04-27 | ADBE | Stock | 23.245 | 23.395 | 21.84 | 22.81 | 5407600.0 |
| 2001-04-27 | ADC | Stock | 16.4 | 16.67 | 16.4 | 16.66 | 5000.0 |
| 2001-04-27 | ADEP-DELISTED | Stock | 51.25 | 51.55 | 49.95 | 51.1 | 25800.0 |
> showing 50 of 2,912 rows — these rows as CSV