PREVIEW / stock_daily / 2001-06-29
file: by_date/stock_daily/2001/2001-06-29.parquet size: 103 KB rows: 2,953 symbols: 1,837
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-06-29 | AAPL | Stock | 0.4225 | 0.4482 | 0.4143 | 0.4152 | 515390400.0 |
| 2001-06-29 | MSFT | Stock | 36.3 | 36.705 | 35.7 | 36.5 | 94283800.0 |
| 2001-06-29 | NVDA | Stock | 0.3844 | 0.3925 | 0.38 | 0.3865 | 730920000.0 |
| 2001-06-29 | AMZN | Stock | 0.7155 | 0.7325 | 0.686 | 0.7075 | 89780000.0 |
| 2001-06-29 | CL | Stock | 30.475 | 30.5 | 29.445 | 29.495 | 6990000.0 |
| 2001-06-29 | A | Stock | 22.5322 | 24.392 | 22.0315 | 23.2475 | 5617723.0 |
| 2001-06-29 | AABA-DELISTED | Stock | 9.72999954223633 | 10.0 | 9.55000019073486 | 9.99499988555908 | 11881000.0 |
| 2001-06-29 | AAI-DELISTED | Stock | 9.75 | 10.5 | 9.6 | 10.25 | 532900.0 |
| 2001-06-29 | AAIC-DELISTED | Stock | 129.8 | 140.0 | 129.8 | 140.0 | 178500.0 |
| 2001-06-29 | AAON | Stock | 1.5217 | 1.5364 | 1.4983 | 1.5188 | 169151.0 |
| 2001-06-29 | AAXN-DELISTED | Stock | 0.516666650772095 | 0.540833353996277 | 0.516666650772095 | 0.533333361148834 | 98400.0 |
| 2001-06-29 | ABAX-DELISTED | Stock | 5.27 | 5.35 | 5.26 | 5.27 | 22600.0 |
| 2001-06-29 | ABB-DELISTED | Stock | 15.05 | 15.15 | 14.85 | 15.15 | 14600.0 |
| 2001-06-29 | ABC-DELISTED | Stock | 14.3000001907349 | 14.3249998092651 | 13.75 | 13.8374996185303 | 6307600.0 |
| 2001-06-29 | ABCB | Stock | 9.0375 | 9.0375 | 9.0375 | 9.0375 | 1234.0 |
| 2001-06-29 | ABCW-DELISTED | Stock | 15.765 | 15.973 | 15.702 | 15.9 | 287900.0 |
| 2001-06-29 | ABE-DELISTED | Stock | 8.05 | 8.15 | 8.05 | 8.11 | 18100.0 |
| 2001-06-29 | ABFS-DELISTED | Stock | 22.0 | 23.17 | 21.87 | 23.15 | 281000.0 |
| 2001-06-29 | ABK-DELISTED | Stock | 58.1 | 58.35 | 56.85 | 57.97 | 675000.0 |
| 2001-06-29 | ABM | Stock | 17.375 | 18.75 | 17.3 | 18.625 | 260400.0 |
| 2001-06-29 | ABMD-DELISTED | Stock | 23.93 | 23.93 | 23.0 | 23.6 | 130500.0 |
| 2001-06-29 | ABP-DELISTED | Stock | 3.01 | 3.25 | 3.01 | 3.16 | 140700.0 |
| 2001-06-29 | ABT | Stock | 22.9388 | 22.9433 | 21.0983 | 21.5472 | 14815520.0 |
| 2001-06-29 | ABTL-DELISTED | Stock | 7.25 | 7.25 | 6.85 | 7.05 | 6000.0 |
| 2001-06-29 | ABV-DELISTED | Stock | 22.8 | 23.31 | 22.8 | 23.15 | 358500.0 |
| 2001-06-29 | ABX-DELISTED | Stock | 14.98 | 15.29 | 14.95 | 15.2 | 1988570.0 |
| 2001-06-29 | ACAP-DELISTED | Stock | 19.43 | 19.8 | 19.11 | 19.79 | 546200.0 |
| 2001-06-29 | ACAS-DELISTED | Stock | 27.63 | 28.09 | 27.33 | 28.06 | 416240.0 |
| 2001-06-29 | ACAT-DELISTED | Stock | 14.6 | 14.72 | 14.41 | 14.5 | 150518.0 |
| 2001-06-29 | ACCL-DELISTED | Stock | 14.8000001907349 | 18.2840003967285 | 14.3369998931885 | 17.378999710083 | 464700.0 |
| 2001-06-29 | ACE-DELISTED | Stock | 39.38 | 39.56 | 38.9 | 39.09 | 1263000.0 |
| 2001-06-29 | ACF-DELISTED | Stock | 52.75 | 53.33 | 51.8 | 51.99 | 1777100.0 |
| 2001-06-29 | ACG-DELISTED | Stock | 8.79 | 8.81 | 8.68 | 8.72 | 276500.0 |
| 2001-06-29 | ACGL | Stock | 1.7611 | 1.7978 | 1.7167 | 1.75 | 264600.0 |
| 2001-06-29 | ACGN-DELISTED | Stock | 1326.0 | 1360.0 | 1303.3288 | 1360.0 | 50800.0 |
| 2001-06-29 | ACH | Stock | 12.2667 | 12.8533 | 12.2667 | 12.6667 | 368400.0 |
| 2001-06-29 | ACLS | Stock | 60.92 | 62.28 | 57.6 | 59.2 | 701700.0 |
| 2001-06-29 | ACO-DELISTED | Stock | 5.59 | 5.9 | 5.59 | 5.85 | 102000.0 |
| 2001-06-29 | ACPW-DELISTED | Stock | 82.47 | 85.47 | 81.75 | 83.4 | 294454.0 |
| 2001-06-29 | ACS-DELISTED | Stock | 36.65 | 36.75 | 35.925 | 35.955 | 514500.0 |
| 2001-06-29 | ACTA-DELISTED | Stock | 37.8 | 41.2 | 36.6 | 40.0 | 121000.0 |
| 2001-06-29 | ACTT-DELISTED | Stock | 6.245 | 6.3 | 6.235 | 6.25 | 5600.0 |
| 2001-06-29 | ACTU-DELISTED | Stock | 7.41 | 8.6 | 7.33 | 8.45 | 2356900.0 |
| 2001-06-29 | ACXM-DELISTED | Stock | 12.42 | 13.27 | 12.32 | 13.09 | 1506090.0 |
| 2001-06-29 | ACY-DELISTED | Stock | 4.95 | 4.95 | 4.95 | 4.95 | 200.0 |
| 2001-06-29 | AD | Stock | 38.1 | 38.4333 | 37.6667 | 38.4333 | 137550.0 |
| 2001-06-29 | ADAT-DELISTED | Stock | 80.27 | 83.75 | 80.27 | 81.0 | 3204.0 |
| 2001-06-29 | ADBE | Stock | 23.665 | 24.0 | 23.245 | 23.5 | 9215200.0 |
| 2001-06-29 | ADC | Stock | 19.51 | 19.59 | 19.01 | 19.01 | 7400.0 |
| 2001-06-29 | ADEP-DELISTED | Stock | 47.5 | 51.25 | 47.5 | 49.5 | 42300.0 |
> showing 50 of 2,953 rows — these rows as CSV