PREVIEW / stock_daily / 2001-11-06
file: by_date/stock_daily/2001/2001-11-06.parquet size: 101 KB rows: 2,991 symbols: 1,860
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-06 | AAPL | Stock | 0.3386 | 0.3504 | 0.3309 | 0.3495 | 316019200.0 |
| 2001-11-06 | MSFT | Stock | 31.35 | 32.47 | 31.08 | 32.39 | 68612000.0 |
| 2001-11-06 | NVDA | Stock | 0.3937 | 0.4234 | 0.3917 | 0.4216 | 1415376000.0 |
| 2001-11-06 | AMZN | Stock | 0.354 | 0.3565 | 0.3455 | 0.3525 | 112156000.0 |
| 2001-11-06 | CL | Stock | 29.175 | 29.495 | 29.03 | 29.43 | 2187200.0 |
| 2001-11-06 | A | Stock | 17.6896 | 18.2332 | 17.2747 | 18.2332 | 2304044.0 |
| 2001-11-06 | AABA-DELISTED | Stock | 5.94999980926514 | 6.57499980926514 | 5.91499996185303 | 6.49499988555908 | 23447200.0 |
| 2001-11-06 | AAI-DELISTED | Stock | 4.35 | 5.09 | 4.35 | 5.04 | 2483800.0 |
| 2001-11-06 | AAIC-DELISTED | Stock | 100.0 | 102.0 | 96.0 | 102.0 | 24800.0 |
| 2001-11-06 | AAME | Stock | 1.49 | 1.5 | 1.49 | 1.5 | 7300.0 |
| 2001-11-06 | AAON | Stock | 1.5486 | 1.5486 | 1.4881 | 1.5021 | 69483.0 |
| 2001-11-06 | AAXN-DELISTED | Stock | 0.808333337306976 | 0.816666662693024 | 0.789166688919067 | 0.795833349227905 | 117600.0 |
| 2001-11-06 | ABAX-DELISTED | Stock | 3.85 | 4.25 | 3.85 | 4.2 | 36400.0 |
| 2001-11-06 | ABB-DELISTED | Stock | 9.14 | 9.22 | 9.14 | 9.21 | 32600.0 |
| 2001-11-06 | ABC-DELISTED | Stock | 15.8 | 16.0 | 15.68 | 15.98 | 4259200.0 |
| 2001-11-06 | ABCB | Stock | 10.3424 | 10.3829 | 10.3343 | 10.3829 | 35285.0 |
| 2001-11-06 | ABCW-DELISTED | Stock | 15.7 | 15.77 | 15.7 | 15.77 | 21300.0 |
| 2001-11-06 | ABE-DELISTED | Stock | 6.69 | 6.79 | 6.69 | 6.76 | 8000.0 |
| 2001-11-06 | ABFS-DELISTED | Stock | 24.03 | 25.05 | 24.03 | 25.05 | 177000.0 |
| 2001-11-06 | ABK-DELISTED | Stock | 52.75 | 53.0 | 50.5 | 51.77 | 501400.0 |
| 2001-11-06 | ABM | Stock | 13.825 | 14.085 | 13.75 | 14.02 | 156800.0 |
| 2001-11-06 | ABMD-DELISTED | Stock | 22.62 | 22.639 | 21.67 | 21.92 | 77900.0 |
| 2001-11-06 | ABP-DELISTED | Stock | 1.62 | 1.63 | 1.55 | 1.58 | 26900.0 |
| 2001-11-06 | ABT | Stock | 24.2406 | 24.5728 | 23.886 | 24.3529 | 7207827.0 |
| 2001-11-06 | ABTL-DELISTED | Stock | 7.25 | 7.3 | 6.65 | 6.65 | 14900.0 |
| 2001-11-06 | ABV-DELISTED | Stock | 18.5 | 19.25 | 18.39 | 18.91 | 327000.0 |
| 2001-11-06 | ABX-DELISTED | Stock | 15.69 | 15.93 | 15.64 | 15.72 | 1004831.0 |
| 2001-11-06 | ACAP-DELISTED | Stock | 18.7 | 18.7 | 16.6 | 17.12 | 307100.0 |
| 2001-11-06 | ACAS-DELISTED | Stock | 26.19 | 26.34 | 25.96 | 26.23 | 441600.0 |
| 2001-11-06 | ACAT-DELISTED | Stock | 15.89 | 15.89 | 15.543 | 15.82 | 16900.0 |
| 2001-11-06 | ACCL-DELISTED | Stock | 9.41347026824951 | 10.2461996078491 | 9.41347026824951 | 10.2461996078491 | 252900.0 |
| 2001-11-06 | ACE-DELISTED | Stock | 40.75 | 40.75 | 39.2 | 39.96 | 3345100.0 |
| 2001-11-06 | ACF-DELISTED | Stock | 15.01 | 16.57 | 14.85 | 16.15 | 3525100.0 |
| 2001-11-06 | ACG-DELISTED | Stock | 8.79 | 8.99 | 8.79 | 8.98 | 500100.0 |
| 2001-11-06 | ACGL | Stock | 2.6444 | 2.6444 | 2.55 | 2.6433 | 163800.0 |
| 2001-11-06 | ACH | Stock | 12.2667 | 12.3333 | 12.26 | 12.3 | 53100.0 |
| 2001-11-06 | ACLS | Stock | 55.16 | 56.0 | 53.2 | 55.52 | 278050.0 |
| 2001-11-06 | ACO-DELISTED | Stock | 5.75 | 6.0 | 5.7 | 6.0 | 56600.0 |
| 2001-11-06 | ACPW-DELISTED | Stock | 27.05 | 28.0 | 25.55 | 26.05 | 26260.0 |
| 2001-11-06 | ACS-DELISTED | Stock | 46.525 | 46.86 | 46.39 | 46.825 | 485300.0 |
| 2001-11-06 | ACTA-DELISTED | Stock | 20.6 | 23.0 | 20.2 | 22.8 | 185300.0 |
| 2001-11-06 | ACTT-DELISTED | Stock | 10.685 | 11.0 | 10.5 | 11.0 | 92100.0 |
| 2001-11-06 | ACTU-DELISTED | Stock | 5.61 | 6.1 | 5.3 | 5.53 | 979900.0 |
| 2001-11-06 | ACXM-DELISTED | Stock | 12.1 | 12.23 | 11.7 | 12.2 | 220100.0 |
| 2001-11-06 | ACY-DELISTED | Stock | 5.35 | 5.35 | 5.25 | 5.25 | 4700.0 |
| 2001-11-06 | AD | Stock | 29.8333 | 30.1667 | 29.5667 | 30.1667 | 241950.0 |
| 2001-11-06 | ADAT-DELISTED | Stock | 80.1 | 81.72 | 77.58 | 81.0 | 2157.0 |
| 2001-11-06 | ADBE | Stock | 13.945 | 14.315 | 13.645 | 14.29 | 7648800.0 |
| 2001-11-06 | ADC | Stock | 19.23 | 19.29 | 19.22 | 19.29 | 4500.0 |
| 2001-11-06 | ADEP-DELISTED | Stock | 17.65 | 19.3 | 17.5 | 19.15 | 19800.0 |
> showing 50 of 2,991 rows — these rows as CSV