PREVIEW / stock_daily / 2001-10-04
file: by_date/stock_daily/2001/2001-10-04.parquet size: 102 KB rows: 2,995 symbols: 1,863
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-04 | AAPL | Stock | 0.2741 | 0.2902 | 0.2677 | 0.2836 | 401122400.0 |
| 2001-10-04 | MSFT | Stock | 28.46 | 29.2 | 28.105 | 28.22 | 101778000.0 |
| 2001-10-04 | NVDA | Stock | 0.2508 | 0.2817 | 0.2422 | 0.2691 | 1980576000.0 |
| 2001-10-04 | AMZN | Stock | 0.3545 | 0.3935 | 0.334 | 0.352 | 124344000.0 |
| 2001-10-04 | CL | Stock | 28.345 | 28.43 | 27.925 | 28.075 | 2733200.0 |
| 2001-10-04 | A | Stock | 15.1645 | 15.9156 | 15.0644 | 15.5222 | 3655490.0 |
| 2001-10-04 | AABA-DELISTED | Stock | 5.08500003814697 | 5.79500007629395 | 4.84000015258789 | 5.34000015258789 | 35863200.0 |
| 2001-10-04 | AAI-DELISTED | Stock | 4.59 | 4.59 | 4.25 | 4.4 | 426100.0 |
| 2001-10-04 | AAIC-DELISTED | Stock | 102.0 | 102.0 | 98.0 | 99.8 | 20600.0 |
| 2001-10-04 | AAON | Stock | 1.6768 | 1.7558 | 1.5759 | 1.5759 | 170859.0 |
| 2001-10-04 | AAXN-DELISTED | Stock | 0.741666674613953 | 0.742500007152557 | 0.736666679382324 | 0.736666679382324 | 369600.0 |
| 2001-10-04 | ABAX-DELISTED | Stock | 4.22 | 4.28 | 4.1 | 4.15 | 36300.0 |
| 2001-10-04 | ABB-DELISTED | Stock | 6.95 | 6.95 | 6.44 | 6.66 | 76300.0 |
| 2001-10-04 | ABC-DELISTED | Stock | 17.09 | 17.41 | 16.86 | 17.25 | 4300800.0 |
| 2001-10-04 | ABCB | Stock | 10.6585 | 10.6585 | 10.537 | 10.537 | 1973.0 |
| 2001-10-04 | ABCW-DELISTED | Stock | 16.49 | 16.55 | 16.21 | 16.37 | 9400.0 |
| 2001-10-04 | ABE-DELISTED | Stock | 6.28 | 6.42 | 6.28 | 6.42 | 11900.0 |
| 2001-10-04 | ABFS-DELISTED | Stock | 19.5 | 19.99 | 19.4 | 19.53 | 183700.0 |
| 2001-10-04 | ABK-DELISTED | Stock | 56.1 | 56.47 | 55.0 | 56.45 | 884000.0 |
| 2001-10-04 | ABM | Stock | 12.635 | 13.13 | 12.63 | 12.7 | 968800.0 |
| 2001-10-04 | ABMD-DELISTED | Stock | 18.35 | 19.62 | 17.8 | 18.63 | 144100.0 |
| 2001-10-04 | ABP-DELISTED | Stock | 1.76 | 1.76 | 1.54 | 1.69 | 146000.0 |
| 2001-10-04 | ABT | Stock | 23.096 | 23.3339 | 23.0376 | 23.1902 | 7417005.0 |
| 2001-10-04 | ABTL-DELISTED | Stock | 4.35 | 4.6 | 4.05 | 4.05 | 2800.0 |
| 2001-10-04 | ABV-DELISTED | Stock | 15.2 | 15.5 | 15.2 | 15.3 | 1703700.0 |
| 2001-10-04 | ABX-DELISTED | Stock | 17.2 | 17.37 | 16.97 | 17.0 | 1934400.0 |
| 2001-10-04 | ACAP-DELISTED | Stock | 21.13 | 23.57 | 21.0 | 22.9 | 89000.0 |
| 2001-10-04 | ACAS-DELISTED | Stock | 27.35 | 27.57 | 26.96 | 27.22 | 107558.0 |
| 2001-10-04 | ACAT-DELISTED | Stock | 13.7 | 14.05 | 13.31 | 13.4 | 26100.0 |
| 2001-10-04 | ACCL-DELISTED | Stock | 10.8199996948242 | 10.8249998092651 | 10.1960000991821 | 10.3190002441406 | 324500.0 |
| 2001-10-04 | ACE-DELISTED | Stock | 34.15 | 34.7 | 32.85 | 34.21 | 2811400.0 |
| 2001-10-04 | ACF-DELISTED | Stock | 35.4 | 36.9 | 34.8 | 35.15 | 1466300.0 |
| 2001-10-04 | ACG-DELISTED | Stock | 8.69 | 8.74 | 8.6 | 8.64 | 226700.0 |
| 2001-10-04 | ACGL | Stock | 1.8444 | 1.8444 | 1.8333 | 1.8333 | 18000.0 |
| 2001-10-04 | ACH | Stock | 12.6667 | 13.3333 | 12.6 | 12.9667 | 139050.0 |
| 2001-10-04 | ACLS | Stock | 41.76 | 42.28 | 39.84 | 40.88 | 230300.0 |
| 2001-10-04 | ACO-DELISTED | Stock | 5.93 | 6.25 | 5.65 | 5.8 | 18300.0 |
| 2001-10-04 | ACPW-DELISTED | Stock | 27.05 | 28.45 | 26.3 | 26.85 | 39600.0 |
| 2001-10-04 | ACS-DELISTED | Stock | 41.575 | 42.475 | 40.75 | 42.345 | 4966700.0 |
| 2001-10-04 | ACTA-DELISTED | Stock | 10.4 | 12.2 | 10.0 | 10.2 | 138700.0 |
| 2001-10-04 | ACTT-DELISTED | Stock | 8.9 | 9.26 | 8.5 | 8.59 | 84900.0 |
| 2001-10-04 | ACTU-DELISTED | Stock | 5.85 | 6.32 | 5.3 | 5.47 | 1039600.0 |
| 2001-10-04 | ACXM-DELISTED | Stock | 13.05 | 13.48 | 13.0 | 13.26 | 1858600.0 |
| 2001-10-04 | ACY-DELISTED | Stock | 5.63 | 5.63 | 5.63 | 5.63 | 100.0 |
| 2001-10-04 | AD | Stock | 31.6 | 31.7333 | 31.2 | 31.5 | 114750.0 |
| 2001-10-04 | ADAT-DELISTED | Stock | 77.3 | 77.32 | 71.74 | 74.98 | 4628.0 |
| 2001-10-04 | ADBE | Stock | 14.07 | 15.4 | 13.85 | 14.325 | 12103600.0 |
| 2001-10-04 | ADC | Stock | 17.95 | 18.55 | 17.95 | 18.55 | 8500.0 |
| 2001-10-04 | ADEP-DELISTED | Stock | 24.2 | 24.35 | 21.25 | 21.35 | 16600.0 |
| 2001-10-04 | ADGF-DELISTED | Stock | 0.43 | 0.43 | 0.36 | 0.43 | 32800.0 |
> showing 50 of 2,995 rows — these rows as CSV