PREVIEW / stock_daily / 2002-02-20
file: by_date/stock_daily/2002/2002-02-20.parquet size: 105 KB rows: 3,093 symbols: 1,924
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 |
|---|---|---|---|---|---|---|---|
| 2002-02-20 | AAPL | Stock | 0.4066 | 0.4143 | 0.3991 | 0.413 | 285443200.0 |
| 2002-02-20 | MSFT | Stock | 29.7 | 30.18 | 29.4 | 29.95 | 50492000.0 |
| 2002-02-20 | NVDA | Stock | 0.4383 | 0.4746 | 0.4375 | 0.4696 | 1838736000.0 |
| 2002-02-20 | AMZN | Stock | 0.6595 | 0.67 | 0.6075 | 0.648 | 160322000.0 |
| 2002-02-20 | CL | Stock | 27.8 | 28.19 | 27.53 | 28.095 | 2535200.0 |
| 2002-02-20 | A | Stock | 20.0286 | 21.3162 | 20.0286 | 20.6438 | 7024950.0 |
| 2002-02-20 | AABA-DELISTED | Stock | 7.36999988555908 | 7.71500015258789 | 7.00500011444092 | 7.64499998092651 | 25165200.0 |
| 2002-02-20 | AAI-DELISTED | Stock | 6.55 | 6.78 | 6.5 | 6.78 | 100900.0 |
| 2002-02-20 | AAIC-DELISTED | Stock | 126.0 | 137.0 | 125.0 | 137.0 | 274500.0 |
| 2002-02-20 | AAME | Stock | 2.06 | 2.19 | 2.06 | 2.19 | 300.0 |
| 2002-02-20 | AAON | Stock | 1.755 | 1.8129 | 1.755 | 1.8094 | 130992.0 |
| 2002-02-20 | AAP | Stock | 14.8 | 15.25 | 14.6333 | 14.7333 | 88500.0 |
| 2002-02-20 | AAXN-DELISTED | Stock | 1.40083336830139 | 1.44166672229767 | 1.37833333015442 | 1.39999997615814 | 541200.0 |
| 2002-02-20 | ABAX-DELISTED | Stock | 6.15 | 6.4 | 6.1 | 6.4 | 77700.0 |
| 2002-02-20 | ABB-DELISTED | Stock | 7.27 | 7.27 | 7.1 | 7.21 | 44400.0 |
| 2002-02-20 | ABC-DELISTED | Stock | 15.82 | 16.03 | 15.7 | 15.96 | 2870400.0 |
| 2002-02-20 | ABCB | Stock | 10.699 | 10.7801 | 10.699 | 10.7396 | 16656.0 |
| 2002-02-20 | ABCO-DELISTED | Stock | 16.63 | 16.65 | 16.135 | 16.33 | 81000.0 |
| 2002-02-20 | ABCW-DELISTED | Stock | 17.6 | 17.95 | 17.5 | 17.95 | 39300.0 |
| 2002-02-20 | ABE-DELISTED | Stock | 6.88 | 6.97 | 6.88 | 6.97 | 17000.0 |
| 2002-02-20 | ABFS-DELISTED | Stock | 24.3 | 25.3 | 24.01 | 25.3 | 120200.0 |
| 2002-02-20 | ABK-DELISTED | Stock | 61.4 | 62.19 | 60.25 | 62.14 | 348500.0 |
| 2002-02-20 | ABM | Stock | 15.56 | 15.825 | 15.56 | 15.825 | 81000.0 |
| 2002-02-20 | ABMD-DELISTED | Stock | 12.85 | 13.05 | 11.09 | 11.501 | 257400.0 |
| 2002-02-20 | ABP-DELISTED | Stock | 0.89 | 0.95 | 0.86 | 0.95 | 51400.0 |
| 2002-02-20 | ABT | Stock | 25.6322 | 25.924 | 25.5335 | 25.8477 | 6929815.0 |
| 2002-02-20 | ABTL-DELISTED | Stock | 11.55 | 13.05 | 11.55 | 12.75 | 16200.0 |
| 2002-02-20 | ABV-DELISTED | Stock | 19.35 | 19.78 | 19.25 | 19.25 | 341100.0 |
| 2002-02-20 | ABVA-DELISTED | Stock | 8.25 | 8.25 | 8.0 | 8.0 | 1200.0 |
| 2002-02-20 | ABX-DELISTED | Stock | 17.73 | 18.15 | 17.53 | 17.79 | 3476200.0 |
| 2002-02-20 | ACAP-DELISTED | Stock | 21.15 | 21.29 | 20.8 | 20.8 | 308700.0 |
| 2002-02-20 | ACAS-DELISTED | Stock | 28.2 | 28.85 | 28.1 | 28.45 | 298700.0 |
| 2002-02-20 | ACAT-DELISTED | Stock | 16.88 | 17.6 | 16.88 | 17.39 | 28700.0 |
| 2002-02-20 | ACCL-DELISTED | Stock | 8.39970970153809 | 8.50833034515381 | 8.39970970153809 | 8.50833034515381 | 325900.0 |
| 2002-02-20 | ACE-DELISTED | Stock | 42.25 | 42.75 | 41.8 | 42.49 | 1362400.0 |
| 2002-02-20 | ACF-DELISTED | Stock | 21.64 | 21.64 | 19.95 | 20.93 | 1725900.0 |
| 2002-02-20 | ACG-DELISTED | Stock | 7.64 | 7.75 | 7.63 | 7.74 | 2487600.0 |
| 2002-02-20 | ACGL | Stock | 2.9467 | 2.9889 | 2.9467 | 2.9889 | 66600.0 |
| 2002-02-20 | ACGN-DELISTED | Stock | 1722.6712 | 1722.6712 | 1564.0 | 1700.0 | 38800.0 |
| 2002-02-20 | ACH | Stock | 12.3267 | 12.6667 | 12.2067 | 12.5467 | 139500.0 |
| 2002-02-20 | ACH-DELISTED | Stock | 5.5195 | 5.5245 | 5.487 | 5.512 | 997689.0 |
| 2002-02-20 | ACLS | Stock | 47.88 | 49.72 | 47.4 | 48.92 | 179200.0 |
| 2002-02-20 | ACO-DELISTED | Stock | 7.09 | 7.1 | 6.94 | 7.1 | 18000.0 |
| 2002-02-20 | ACPW-DELISTED | Stock | 20.25 | 20.3 | 18.75 | 19.3 | 49820.0 |
| 2002-02-20 | ACS-DELISTED | Stock | 47.07 | 47.535 | 46.635 | 47.35 | 684300.0 |
| 2002-02-20 | ACTA-DELISTED | Stock | 15.6 | 16.4 | 15.4 | 16.4 | 48400.0 |
| 2002-02-20 | ACTT-DELISTED | Stock | 4.175 | 4.25 | 4.0 | 4.25 | 51600.0 |
| 2002-02-20 | ACTU-DELISTED | Stock | 4.98 | 5.07 | 4.82 | 4.95 | 594000.0 |
| 2002-02-20 | ACXM-DELISTED | Stock | 13.7 | 14.04 | 13.42 | 13.98 | 459800.0 |
| 2002-02-20 | ACY-DELISTED | Stock | 4.0 | 4.0 | 4.0 | 4.0 | 3600.0 |
> showing 50 of 3,093 rows — these rows as CSV