PREVIEW / stock_daily / 2001-11-27
file: by_date/stock_daily/2001/2001-11-27.parquet size: 104 KB rows: 3,048 symbols: 1,903
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-11-27 | AAPL | Stock | 0.3786 | 0.3843 | 0.3661 | 0.375 | 268553600.0 |
| 2001-11-27 | MSFT | Stock | 32.395 | 32.535 | 31.375 | 31.87 | 90819000.0 |
| 2001-11-27 | NVDA | Stock | 0.4457 | 0.4608 | 0.4375 | 0.4507 | 1183992000.0 |
| 2001-11-27 | AMZN | Stock | 0.6025 | 0.6125 | 0.561 | 0.574 | 686176000.0 |
| 2001-11-27 | CL | Stock | 29.375 | 29.445 | 28.875 | 28.895 | 2843400.0 |
| 2001-11-27 | A | Stock | 18.7411 | 19.7353 | 18.6695 | 19.3133 | 8316143.0 |
| 2001-11-27 | AABA-DELISTED | Stock | 8.69999980926514 | 8.97000026702881 | 8.44999980926514 | 8.69999980926514 | 43562200.0 |
| 2001-11-27 | AAI-DELISTED | Stock | 6.14 | 6.22 | 6.02 | 6.06 | 294900.0 |
| 2001-11-27 | AAIC-DELISTED | Stock | 98.0 | 98.0 | 95.2 | 96.4 | 12400.0 |
| 2001-11-27 | AAME | Stock | 2.15 | 2.15 | 2.1 | 2.1 | 200.0 |
| 2001-11-27 | AAON | Stock | 1.7918 | 1.9095 | 1.7839 | 1.9086 | 183389.0 |
| 2001-11-27 | AAXN-DELISTED | Stock | 1.15416669845581 | 1.15499997138977 | 1.03999996185303 | 1.05250000953674 | 1298400.0 |
| 2001-11-27 | ABAX-DELISTED | Stock | 4.12 | 4.2 | 4.11 | 4.15 | 20900.0 |
| 2001-11-27 | ABB-DELISTED | Stock | 11.2 | 11.45 | 11.06 | 11.45 | 34700.0 |
| 2001-11-27 | ABC-DELISTED | Stock | 14.16 | 14.4 | 14.0 | 14.1 | 4404800.0 |
| 2001-11-27 | ABCO-DELISTED | Stock | 12.67 | 13.65 | 12.65 | 13.65 | 402800.0 |
| 2001-11-27 | ABCW-DELISTED | Stock | 17.67 | 17.67 | 17.22 | 17.23 | 12900.0 |
| 2001-11-27 | ABE-DELISTED | Stock | 7.01 | 7.01 | 6.88 | 6.91 | 33100.0 |
| 2001-11-27 | ABFS-DELISTED | Stock | 27.0 | 27.14 | 26.32 | 26.6 | 227800.0 |
| 2001-11-27 | ABK-DELISTED | Stock | 55.57 | 56.06 | 55.18 | 55.41 | 312700.0 |
| 2001-11-27 | ABM | Stock | 14.375 | 14.64 | 14.365 | 14.51 | 224000.0 |
| 2001-11-27 | ABMD-DELISTED | Stock | 20.23 | 20.49 | 19.8 | 19.9 | 80700.0 |
| 2001-11-27 | ABP-DELISTED | Stock | 1.07 | 1.12 | 1.0 | 1.01 | 192500.0 |
| 2001-11-27 | ABT | Stock | 23.9264 | 24.4561 | 23.8232 | 24.1419 | 5932713.0 |
| 2001-11-27 | ABTL-DELISTED | Stock | 6.8 | 7.5 | 6.8 | 7.1 | 19700.0 |
| 2001-11-27 | ABV-DELISTED | Stock | 20.81 | 21.19 | 20.8 | 21.1 | 344500.0 |
| 2001-11-27 | ABX-DELISTED | Stock | 14.2 | 14.68 | 14.2 | 14.68 | 2222200.0 |
| 2001-11-27 | ACAP-DELISTED | Stock | 18.9 | 19.24 | 18.85 | 19.23 | 293900.0 |
| 2001-11-27 | ACAS-DELISTED | Stock | 27.96 | 28.51 | 27.88 | 28.01 | 293319.0 |
| 2001-11-27 | ACAT-DELISTED | Stock | 16.9 | 17.2 | 16.4 | 16.83 | 80000.0 |
| 2001-11-27 | ACCL-DELISTED | Stock | 10.8617000579834 | 10.9268999099731 | 10.5648002624512 | 10.9268999099731 | 80600.0 |
| 2001-11-27 | ACE-DELISTED | Stock | 37.65 | 38.75 | 37.65 | 38.58 | 612000.0 |
| 2001-11-27 | ACF-DELISTED | Stock | 24.75 | 25.1 | 24.1 | 24.3 | 901000.0 |
| 2001-11-27 | ACG-DELISTED | Stock | 8.2 | 8.2 | 8.02 | 8.08 | 459400.0 |
| 2001-11-27 | ACGL | Stock | 2.6411 | 2.6411 | 2.6167 | 2.6167 | 6300.0 |
| 2001-11-27 | ACGN-DELISTED | Stock | 1802.0 | 1858.6712 | 1620.6712 | 1620.6712 | 102200.0 |
| 2001-11-27 | ACH | Stock | 12.0 | 12.1 | 12.0 | 12.0 | 99450.0 |
| 2001-11-27 | ACLS | Stock | 54.2 | 57.64 | 52.68 | 56.4 | 129175.0 |
| 2001-11-27 | ACO-DELISTED | Stock | 5.76 | 5.8 | 5.65 | 5.65 | 4200.0 |
| 2001-11-27 | ACPW-DELISTED | Stock | 28.75 | 30.85 | 28.0 | 29.75 | 32720.0 |
| 2001-11-27 | ACS-DELISTED | Stock | 48.095 | 48.125 | 47.32 | 47.995 | 386300.0 |
| 2001-11-27 | ACTA-DELISTED | Stock | 25.8 | 26.0 | 24.2 | 24.6 | 87500.0 |
| 2001-11-27 | ACTT-DELISTED | Stock | 10.3 | 10.65 | 10.0 | 10.65 | 87200.0 |
| 2001-11-27 | ACTU-DELISTED | Stock | 5.8 | 5.8 | 5.25 | 5.39 | 315600.0 |
| 2001-11-27 | ACXM-DELISTED | Stock | 12.59 | 13.6 | 12.45 | 13.42 | 1305300.0 |
| 2001-11-27 | AD | Stock | 29.6 | 29.6 | 29.1667 | 29.5333 | 235200.0 |
| 2001-11-27 | ADAT-DELISTED | Stock | 72.72 | 74.7 | 67.5 | 69.3 | 2724.0 |
| 2001-11-27 | ADBE | Stock | 17.4 | 17.495 | 16.75 | 17.12 | 7570400.0 |
| 2001-11-27 | ADC | Stock | 19.34 | 19.34 | 19.11 | 19.11 | 6100.0 |
| 2001-11-27 | ADEP-DELISTED | Stock | 17.95 | 19.1 | 16.95 | 18.75 | 55400.0 |
> showing 50 of 3,048 rows — these rows as CSV