PREVIEW / stock_daily / 2001-12-28
file: by_date/stock_daily/2001/2001-12-28.parquet size: 106 KB rows: 3,091 symbols: 1,940
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-12-28 | AAPL | Stock | 0.3923 | 0.4107 | 0.3921 | 0.4005 | 299124000.0 |
| 2001-12-28 | MSFT | Stock | 34.115 | 34.425 | 33.85 | 33.935 | 28787200.0 |
| 2001-12-28 | NVDA | Stock | 0.5816 | 0.5854 | 0.5587 | 0.5642 | 757680000.0 |
| 2001-12-28 | AMZN | Stock | 0.5455 | 0.554 | 0.5345 | 0.545 | 205158000.0 |
| 2001-12-28 | CL | Stock | 29.08 | 29.15 | 28.76 | 29.07 | 2533000.0 |
| 2001-12-28 | A | Stock | 20.7439 | 20.8798 | 20.422 | 20.7082 | 1600430.0 |
| 2001-12-28 | AABA-DELISTED | Stock | 9.32499980926514 | 9.4399995803833 | 9.14500045776367 | 9.14999961853027 | 25317400.0 |
| 2001-12-28 | AAI-DELISTED | Stock | 6.15 | 6.71 | 6.12 | 6.66 | 457300.0 |
| 2001-12-28 | AAIC-DELISTED | Stock | 106.0 | 107.0 | 103.2 | 104.0 | 28400.0 |
| 2001-12-28 | AAME | Stock | 2.2 | 2.23 | 2.2 | 2.23 | 9500.0 |
| 2001-12-28 | AAON | Stock | 1.9867 | 2.0587 | 1.9095 | 2.0587 | 275653.0 |
| 2001-12-28 | AAP | Stock | 15.7333 | 15.7333 | 15.6333 | 15.6833 | 295500.0 |
| 2001-12-28 | AAXN-DELISTED | Stock | 1.02499997615814 | 1.04583334922791 | 1.0091667175293 | 1.04583334922791 | 391200.0 |
| 2001-12-28 | ABAX-DELISTED | Stock | 5.3488 | 5.7 | 5.26 | 5.65 | 13900.0 |
| 2001-12-28 | ABB-DELISTED | Stock | 9.61 | 9.61 | 9.42 | 9.42 | 20600.0 |
| 2001-12-28 | ABC-DELISTED | Stock | 15.68 | 16.05 | 15.66 | 15.96 | 1784000.0 |
| 2001-12-28 | ABCB | Stock | 10.8207 | 11.0638 | 10.8207 | 11.0638 | 3208.0 |
| 2001-12-28 | ABCO-DELISTED | Stock | 13.421 | 13.541 | 13.301 | 13.414 | 121792.0 |
| 2001-12-28 | ABCW-DELISTED | Stock | 17.74 | 17.99 | 17.72 | 17.72 | 8700.0 |
| 2001-12-28 | ABE-DELISTED | Stock | 6.98 | 7.04 | 6.98 | 7.0 | 32600.0 |
| 2001-12-28 | ABFS-DELISTED | Stock | 29.48 | 29.85 | 29.0 | 29.02 | 95500.0 |
| 2001-12-28 | ABK-DELISTED | Stock | 56.76 | 57.34 | 56.75 | 57.22 | 593200.0 |
| 2001-12-28 | ABM | Stock | 16.25 | 16.27 | 15.84 | 15.84 | 157800.0 |
| 2001-12-28 | ABMD-DELISTED | Stock | 16.0 | 17.0 | 16.0 | 16.93 | 192700.0 |
| 2001-12-28 | ABP-DELISTED | Stock | 1.21 | 1.3 | 1.2 | 1.3 | 249700.0 |
| 2001-12-28 | ABT | Stock | 25.4976 | 25.52 | 25.1923 | 25.3539 | 3475155.0 |
| 2001-12-28 | ABTL-DELISTED | Stock | 8.85 | 9.35 | 8.25 | 9.35 | 38900.0 |
| 2001-12-28 | ABV-DELISTED | Stock | 21.25 | 21.25 | 20.0 | 20.32 | 202600.0 |
| 2001-12-28 | ABX-DELISTED | Stock | 15.86 | 16.05 | 15.77 | 15.8 | 1464500.0 |
| 2001-12-28 | ACAP-DELISTED | Stock | 21.6 | 21.8 | 21.19 | 21.77 | 96900.0 |
| 2001-12-28 | ACAS-DELISTED | Stock | 28.67 | 29.52 | 28.25 | 28.89 | 221100.0 |
| 2001-12-28 | ACAT-DELISTED | Stock | 17.28 | 17.72 | 16.6 | 16.77 | 37500.0 |
| 2001-12-28 | ACCL-DELISTED | Stock | 9.88414001464844 | 10.2244997024536 | 9.88414001464844 | 10.2244997024536 | 201200.0 |
| 2001-12-28 | ACE-DELISTED | Stock | 40.16 | 40.36 | 39.8 | 40.25 | 1255491.0 |
| 2001-12-28 | ACF-DELISTED | Stock | 31.38 | 32.95 | 31.38 | 31.98 | 1161800.0 |
| 2001-12-28 | ACG-DELISTED | Stock | 7.31 | 7.32 | 7.29 | 7.32 | 1131800.0 |
| 2001-12-28 | ACGL | Stock | 2.9833 | 3.1489 | 2.8444 | 2.8444 | 82800.0 |
| 2001-12-28 | ACGN-DELISTED | Stock | 1790.6712 | 1892.6712 | 1790.6712 | 1870.0 | 99200.0 |
| 2001-12-28 | ACH | Stock | 12.5067 | 12.7 | 12.5067 | 12.5333 | 126450.0 |
| 2001-12-28 | ACH-DELISTED | Stock | 4.3 | 4.325 | 4.3 | 4.3 | 428800.0 |
| 2001-12-28 | ACLS | Stock | 54.48 | 55.0 | 52.4 | 52.4 | 136375.0 |
| 2001-12-28 | ACO-DELISTED | Stock | 6.93 | 7.04 | 6.86 | 6.96 | 24200.0 |
| 2001-12-28 | ACPW-DELISTED | Stock | 32.2 | 35.1 | 31.8 | 34.35 | 113800.0 |
| 2001-12-28 | ACS-DELISTED | Stock | 52.55 | 53.4 | 52.475 | 53.16 | 531300.0 |
| 2001-12-28 | ACTA-DELISTED | Stock | 23.0 | 25.4 | 22.2 | 25.0 | 128000.0 |
| 2001-12-28 | ACTT-DELISTED | Stock | 7.92 | 8.15 | 7.3 | 7.9986 | 124700.0 |
| 2001-12-28 | ACTU-DELISTED | Stock | 5.4 | 5.49 | 5.25 | 5.3 | 478200.0 |
| 2001-12-28 | ACXM-DELISTED | Stock | 17.98 | 18.51 | 17.7 | 17.97 | 619800.0 |
| 2001-12-28 | ACY-DELISTED | Stock | 4.85 | 4.85 | 4.7 | 4.75 | 5800.0 |
| 2001-12-28 | AD | Stock | 29.3333 | 29.9333 | 29.3333 | 29.9333 | 79950.0 |
> showing 50 of 3,091 rows — these rows as CSV