PREVIEW / stock_daily / 2001-10-31
file: by_date/stock_daily/2001/2001-10-31.parquet size: 103 KB rows: 3,016 symbols: 1,879
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-10-31 | AAPL | Stock | 0.3166 | 0.3286 | 0.3114 | 0.3136 | 273750400.0 |
| 2001-10-31 | MSFT | Stock | 29.65 | 30.365 | 29.05 | 29.075 | 64700000.0 |
| 2001-10-31 | NVDA | Stock | 0.3631 | 0.3729 | 0.3521 | 0.3572 | 989292000.0 |
| 2001-10-31 | AMZN | Stock | 0.3395 | 0.351 | 0.3275 | 0.349 | 154830000.0 |
| 2001-10-31 | CL | Stock | 28.8 | 28.9 | 28.545 | 28.76 | 2912000.0 |
| 2001-10-31 | A | Stock | 16.0229 | 16.5951 | 15.8441 | 15.9299 | 1724293.0 |
| 2001-10-31 | AABA-DELISTED | Stock | 5.7649998664856 | 5.84499979019165 | 5.43499994277954 | 5.44000005722046 | 11277200.0 |
| 2001-10-31 | AAI-DELISTED | Stock | 3.5 | 3.85 | 3.5 | 3.78 | 390200.0 |
| 2001-10-31 | AAIC-DELISTED | Stock | 97.0 | 102.0 | 96.0 | 96.0 | 15800.0 |
| 2001-10-31 | AAME | Stock | 1.46 | 1.46 | 1.3 | 1.3 | 800.0 |
| 2001-10-31 | AAON | Stock | 1.4617 | 1.5276 | 1.4617 | 1.4837 | 56953.0 |
| 2001-10-31 | AAXN-DELISTED | Stock | 0.798333346843719 | 0.833333313465118 | 0.791666686534882 | 0.795000016689301 | 510000.0 |
| 2001-10-31 | ABAX-DELISTED | Stock | 3.53 | 3.9 | 3.53 | 3.8 | 49300.0 |
| 2001-10-31 | ABB-DELISTED | Stock | 8.41 | 8.44 | 8.32 | 8.4 | 5500.0 |
| 2001-10-31 | ABC-DELISTED | Stock | 15.89 | 16.24 | 15.8 | 15.92 | 6356800.0 |
| 2001-10-31 | ABCB | Stock | 10.3343 | 10.3343 | 10.3343 | 10.3343 | 247.0 |
| 2001-10-31 | ABCW-DELISTED | Stock | 15.75 | 15.97 | 15.7 | 15.75 | 37400.0 |
| 2001-10-31 | ABE-DELISTED | Stock | 6.4 | 6.5 | 6.4 | 6.49 | 50900.0 |
| 2001-10-31 | ABFS-DELISTED | Stock | 23.05 | 23.68 | 23.04 | 23.52 | 66800.0 |
| 2001-10-31 | ABK-DELISTED | Stock | 48.5 | 48.75 | 47.75 | 47.99 | 482900.0 |
| 2001-10-31 | ABM | Stock | 13.35 | 13.74 | 13.275 | 13.65 | 566000.0 |
| 2001-10-31 | ABMD-DELISTED | Stock | 20.705 | 22.15 | 20.7 | 21.74 | 153800.0 |
| 2001-10-31 | ABP-DELISTED | Stock | 1.53 | 1.65 | 1.45 | 1.62 | 93600.0 |
| 2001-10-31 | ABT | Stock | 24.0162 | 24.2362 | 23.7828 | 23.7828 | 7748036.0 |
| 2001-10-31 | ABTL-DELISTED | Stock | 5.9 | 6.5 | 5.9 | 6.35 | 15000.0 |
| 2001-10-31 | ABV-DELISTED | Stock | 16.1 | 16.36 | 16.05 | 16.25 | 275500.0 |
| 2001-10-31 | ABX-DELISTED | Stock | 15.8 | 15.8 | 15.31 | 15.57 | 3308800.0 |
| 2001-10-31 | ACAP-DELISTED | Stock | 22.25 | 23.2 | 22.2 | 23.0 | 13500.0 |
| 2001-10-31 | ACAS-DELISTED | Stock | 26.85 | 26.85 | 24.48 | 24.76 | 573600.0 |
| 2001-10-31 | ACAT-DELISTED | Stock | 15.75 | 16.2 | 15.66 | 16.2 | 32500.0 |
| 2001-10-31 | ACCL-DELISTED | Stock | 11.5600004196167 | 11.83899974823 | 11.2449998855591 | 11.4409999847412 | 85300.0 |
| 2001-10-31 | ACE-DELISTED | Stock | 37.34 | 37.34 | 35.25 | 35.26 | 2646728.0 |
| 2001-10-31 | ACF-DELISTED | Stock | 16.19 | 16.45 | 15.0 | 15.47 | 3407300.0 |
| 2001-10-31 | ACG-DELISTED | Stock | 8.57 | 8.65 | 8.54 | 8.62 | 376800.0 |
| 2001-10-31 | ACGL | Stock | 2.5844 | 2.6556 | 2.5844 | 2.6111 | 207900.0 |
| 2001-10-31 | ACGN-DELISTED | Stock | 1178.6712 | 1178.6712 | 1144.6712 | 1178.6712 | 10700.0 |
| 2001-10-31 | ACH | Stock | 12.0 | 12.0 | 11.6333 | 11.74 | 127200.0 |
| 2001-10-31 | ACLS | Stock | 48.52 | 53.0 | 48.36 | 52.44 | 253575.0 |
| 2001-10-31 | ACO-DELISTED | Stock | 5.65 | 5.91 | 5.6 | 5.65 | 13400.0 |
| 2001-10-31 | ACPW-DELISTED | Stock | 25.0 | 26.25 | 24.35 | 26.05 | 28480.0 |
| 2001-10-31 | ACS-DELISTED | Stock | 45.3 | 45.625 | 43.925 | 44.025 | 535100.0 |
| 2001-10-31 | ACTA-DELISTED | Stock | 16.4 | 18.0 | 16.0 | 18.0 | 188000.0 |
| 2001-10-31 | ACTT-DELISTED | Stock | 10.245 | 10.4 | 9.57 | 9.57 | 107200.0 |
| 2001-10-31 | ACTU-DELISTED | Stock | 4.08 | 4.5 | 4.0 | 4.15 | 1397600.0 |
| 2001-10-31 | ACXM-DELISTED | Stock | 11.93 | 12.2 | 11.6 | 11.8 | 733000.0 |
| 2001-10-31 | AD | Stock | 28.7333 | 29.7667 | 28.6667 | 29.7667 | 185850.0 |
| 2001-10-31 | ADAT-DELISTED | Stock | 69.3 | 80.1 | 65.88 | 74.88 | 7584.0 |
| 2001-10-31 | ADBE | Stock | 12.075 | 13.315 | 12.075 | 13.2 | 46077600.0 |
| 2001-10-31 | ADC | Stock | 18.99 | 19.0 | 18.9 | 19.0 | 3500.0 |
| 2001-10-31 | ADEP-DELISTED | Stock | 19.6 | 19.65 | 16.75 | 17.1 | 21600.0 |
> showing 50 of 3,016 rows — these rows as CSV