PREVIEW / stock_daily / 2001-07-24
file: by_date/stock_daily/2001/2001-07-24.parquet size: 101 KB rows: 2,959 symbols: 1,836
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-07-24 | AAPL | Stock | 0.3463 | 0.3557 | 0.3345 | 0.3409 | 348376000.0 |
| 2001-07-24 | MSFT | Stock | 33.5 | 33.995 | 32.85 | 33.16 | 67530200.0 |
| 2001-07-24 | NVDA | Stock | 0.2863 | 0.3019 | 0.2803 | 0.3016 | 1365312000.0 |
| 2001-07-24 | AMZN | Stock | 0.681 | 0.7 | 0.595 | 0.603 | 651458000.0 |
| 2001-07-24 | CL | Stock | 27.25 | 27.295 | 26.86 | 27.075 | 3723200.0 |
| 2001-07-24 | A | Stock | 19.7425 | 19.9928 | 19.3133 | 19.6352 | 2478794.0 |
| 2001-07-24 | AABA-DELISTED | Stock | 8.53999996185303 | 8.88500022888184 | 8.21500015258789 | 8.48499965667725 | 11831600.0 |
| 2001-07-24 | AAI-DELISTED | Stock | 9.11 | 9.11 | 8.6 | 8.8 | 225300.0 |
| 2001-07-24 | AAIC-DELISTED | Stock | 139.0 | 140.4 | 138.0 | 139.2 | 44600.0 |
| 2001-07-24 | AAME | Stock | 1.5 | 1.6 | 1.5 | 1.6 | 1900.0 |
| 2001-07-24 | AAON | Stock | 1.7541 | 1.7558 | 1.7441 | 1.75 | 883343.0 |
| 2001-07-24 | AAXN-DELISTED | Stock | 0.487500011920929 | 0.495833337306976 | 0.47583332657814 | 0.480833321809769 | 222000.0 |
| 2001-07-24 | ABAX-DELISTED | Stock | 5.4 | 5.49 | 5.4 | 5.47 | 3100.0 |
| 2001-07-24 | ABB-DELISTED | Stock | 11.65 | 11.67 | 11.2 | 11.35 | 215600.0 |
| 2001-07-24 | ABC-DELISTED | Stock | 14.0249996185303 | 14.0600004196167 | 13.6575002670288 | 13.8249998092651 | 3646400.0 |
| 2001-07-24 | ABCB | Stock | 9.929 | 10.3343 | 9.929 | 10.3343 | 36888.0 |
| 2001-07-24 | ABCW-DELISTED | Stock | 15.73 | 15.73 | 15.5 | 15.7 | 12400.0 |
| 2001-07-24 | ABE-DELISTED | Stock | 7.55 | 7.62 | 7.51 | 7.52 | 5800.0 |
| 2001-07-24 | ABFS-DELISTED | Stock | 27.46 | 27.46 | 26.25 | 26.35 | 489300.0 |
| 2001-07-24 | ABK-DELISTED | Stock | 56.78 | 57.1 | 55.1 | 55.24 | 785900.0 |
| 2001-07-24 | ABM | Stock | 18.675 | 18.675 | 18.125 | 18.355 | 122600.0 |
| 2001-07-24 | ABMD-DELISTED | Stock | 18.61 | 18.8 | 16.35 | 17.01 | 232100.0 |
| 2001-07-24 | ABP-DELISTED | Stock | 3.25 | 3.45 | 3.16 | 3.44 | 122200.0 |
| 2001-07-24 | ABT | Stock | 22.7458 | 23.3204 | 22.674 | 23.0196 | 7907314.0 |
| 2001-07-24 | ABTL-DELISTED | Stock | 5.5 | 5.55 | 5.2 | 5.5 | 43500.0 |
| 2001-07-24 | ABV-DELISTED | Stock | 20.96 | 21.04 | 20.29 | 20.3 | 311200.0 |
| 2001-07-24 | ABX-DELISTED | Stock | 15.34 | 15.73 | 15.24 | 15.66 | 1767500.0 |
| 2001-07-24 | ACAP-DELISTED | Stock | 19.02 | 19.6 | 18.85 | 19.6 | 209100.0 |
| 2001-07-24 | ACAS-DELISTED | Stock | 26.79 | 27.1 | 26.4 | 26.71 | 137400.0 |
| 2001-07-24 | ACAT-DELISTED | Stock | 14.64 | 14.75 | 14.48 | 14.55 | 55900.0 |
| 2001-07-24 | ACCL-DELISTED | Stock | 11.9109001159668 | 12.0920000076294 | 11.8175001144409 | 12.0920000076294 | 334600.0 |
| 2001-07-24 | ACE-DELISTED | Stock | 34.0 | 34.33 | 33.0 | 33.4 | 3090600.0 |
| 2001-07-24 | ACF-DELISTED | Stock | 58.2 | 58.61 | 57.55 | 57.75 | 864700.0 |
| 2001-07-24 | ACG-DELISTED | Stock | 8.74 | 8.75 | 8.35 | 8.39 | 528300.0 |
| 2001-07-24 | ACGL | Stock | 1.9178 | 1.98 | 1.9178 | 1.98 | 30600.0 |
| 2001-07-24 | ACGN-DELISTED | Stock | 963.3288 | 1020.0 | 963.3288 | 1008.6712 | 8600.0 |
| 2001-07-24 | ACH | Stock | 12.3867 | 12.3867 | 11.8667 | 12.0333 | 201450.0 |
| 2001-07-24 | ACLS | Stock | 57.12 | 57.52 | 55.6 | 56.2 | 256150.0 |
| 2001-07-24 | ACO-DELISTED | Stock | 5.85 | 5.93 | 5.85 | 5.93 | 61800.0 |
| 2001-07-24 | ACPW-DELISTED | Stock | 41.45 | 42.15 | 39.75 | 40.25 | 279260.0 |
| 2001-07-24 | ACS-DELISTED | Stock | 39.5 | 40.2 | 39.45 | 39.575 | 1021800.0 |
| 2001-07-24 | ACTA-DELISTED | Stock | 28.8 | 29.2 | 27.6 | 28.0 | 34300.0 |
| 2001-07-24 | ACTT-DELISTED | Stock | 4.85 | 4.9 | 4.25 | 4.5 | 56000.0 |
| 2001-07-24 | ACTU-DELISTED | Stock | 9.02 | 9.15 | 8.76 | 9.13 | 329400.0 |
| 2001-07-24 | ACXM-DELISTED | Stock | 11.55 | 13.24 | 11.43 | 12.41 | 3549000.0 |
| 2001-07-24 | ACY-DELISTED | Stock | 5.1 | 5.25 | 5.05 | 5.2 | 6900.0 |
| 2001-07-24 | AD | Stock | 37.8333 | 37.8867 | 37.3 | 37.3 | 63000.0 |
| 2001-07-24 | ADAT-DELISTED | Stock | 85.68 | 88.56 | 81.0 | 84.42 | 3028.0 |
| 2001-07-24 | ADBE | Stock | 20.295 | 20.75 | 19.925 | 19.99 | 8158000.0 |
| 2001-07-24 | ADC | Stock | 19.72 | 19.75 | 19.6 | 19.75 | 2800.0 |
> showing 50 of 2,959 rows — these rows as CSV