PREVIEW / stock_daily / 2002-09-27
file: by_date/stock_daily/2002/2002-09-27.parquet size: 107 KB rows: 3,160 symbols: 1,950
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-09-27 | AAPL | Stock | 0.2588 | 0.2652 | 0.2586 | 0.2629 | 206152800.0 |
| 2002-09-27 | MSFT | Stock | 23.02 | 23.55 | 22.595 | 22.625 | 81011600.0 |
| 2002-09-27 | NVDA | Stock | 0.0737 | 0.0757 | 0.0712 | 0.0713 | 650688000.0 |
| 2002-09-27 | AMZN | Stock | 0.8425 | 0.87 | 0.841 | 0.8505 | 140674000.0 |
| 2002-09-27 | CL | Stock | 27.775 | 27.825 | 27.25 | 27.355 | 6176000.0 |
| 2002-09-27 | A | Stock | 9.7854 | 10.0215 | 9.3634 | 9.3634 | 3408044.0 |
| 2002-09-27 | AABA-DELISTED | Stock | 5.09999990463257 | 5.40999984741211 | 5.07499980926514 | 5.28999996185303 | 14591000.0 |
| 2002-09-27 | AAI-DELISTED | Stock | 3.11 | 3.15 | 2.77 | 2.84 | 171800.0 |
| 2002-09-27 | AAIC-DELISTED | Stock | 198.0 | 206.0 | 198.0 | 203.0 | 254700.0 |
| 2002-09-27 | AAME | Stock | 1.71 | 1.71 | 1.71 | 1.71 | 800.0 |
| 2002-09-27 | AAON | Stock | 2.3019 | 2.3045 | 2.1096 | 2.244 | 65306.0 |
| 2002-09-27 | AAP | Stock | 18.2033 | 18.33 | 17.65 | 18.17 | 1559100.0 |
| 2002-09-27 | AAXN-DELISTED | Stock | 0.478333324193954 | 0.478333324193954 | 0.466666668653488 | 0.466666668653488 | 85200.0 |
| 2002-09-27 | ABAX-DELISTED | Stock | 3.121 | 3.24 | 3.0 | 3.2 | 10600.0 |
| 2002-09-27 | ABB-DELISTED | Stock | 3.35 | 3.55 | 3.3 | 3.5 | 64500.0 |
| 2002-09-27 | ABC-DELISTED | Stock | 18.0 | 18.45 | 17.54 | 17.69 | 5656400.0 |
| 2002-09-27 | ABCB | Stock | 10.4965 | 10.5613 | 10.2695 | 10.4965 | 8390.0 |
| 2002-09-27 | ABCO-DELISTED | Stock | 14.05 | 15.245 | 14.05 | 14.895 | 64600.0 |
| 2002-09-27 | ABCW-DELISTED | Stock | 20.8 | 20.8 | 20.0 | 20.02 | 25500.0 |
| 2002-09-27 | ABE-DELISTED | Stock | 5.63 | 5.71 | 5.5 | 5.55 | 10300.0 |
| 2002-09-27 | ABFS-DELISTED | Stock | 29.9 | 29.95 | 28.8 | 28.81 | 432360.0 |
| 2002-09-27 | ABG | Stock | 8.97 | 9.15 | 8.9 | 8.98 | 16000.0 |
| 2002-09-27 | ABK-DELISTED | Stock | 56.0 | 56.0 | 53.8 | 54.3 | 927700.0 |
| 2002-09-27 | ABM | Stock | 13.9 | 14.3 | 13.75 | 14.05 | 108500.0 |
| 2002-09-27 | ABMD-DELISTED | Stock | 3.85 | 3.9 | 3.65 | 3.65 | 52955.0 |
| 2002-09-27 | ABP-DELISTED | Stock | 0.8 | 0.8 | 0.75 | 0.75 | 13800.0 |
| 2002-09-27 | ABT | Stock | 18.6294 | 18.8 | 18.0009 | 18.1132 | 15895491.0 |
| 2002-09-27 | ABTL-DELISTED | Stock | 13.1 | 13.5 | 12.75 | 13.15 | 31800.0 |
| 2002-09-27 | ABV-DELISTED | Stock | 11.5 | 11.58 | 11.18 | 11.3 | 249800.0 |
| 2002-09-27 | ABVA-DELISTED | Stock | 10.25 | 10.25 | 10.25 | 10.25 | 1000.0 |
| 2002-09-27 | ABX-DELISTED | Stock | 15.8 | 15.87 | 14.9 | 15.08 | 5578000.0 |
| 2002-09-27 | ACAP-DELISTED | Stock | 17.47 | 17.5 | 16.8 | 16.99 | 15300.0 |
| 2002-09-27 | ACAS-DELISTED | Stock | 18.35 | 18.9 | 18.12 | 18.27 | 1107820.0 |
| 2002-09-27 | ACAT-DELISTED | Stock | 13.75 | 13.9 | 13.6175 | 13.894 | 20402.0 |
| 2002-09-27 | ACCL-DELISTED | Stock | 5.87979984283447 | 6.19841003417969 | 5.81463003158569 | 6.19841003417969 | 49900.0 |
| 2002-09-27 | ACE-DELISTED | Stock | 31.2 | 31.28 | 29.75 | 29.86 | 1190300.0 |
| 2002-09-27 | ACF-DELISTED | Stock | 8.1 | 8.84 | 8.1 | 8.45 | 17571900.0 |
| 2002-09-27 | ACG-DELISTED | Stock | 8.2 | 8.21 | 8.18 | 8.2 | 391200.0 |
| 2002-09-27 | ACGL | Stock | 3.1033 | 3.1111 | 3.0689 | 3.11 | 279000.0 |
| 2002-09-27 | ACGN-DELISTED | Stock | 940.6712 | 940.6712 | 940.6712 | 940.6712 | 2000.0 |
| 2002-09-27 | ACH | Stock | 9.9 | 9.9733 | 9.5533 | 9.58 | 98700.0 |
| 2002-09-27 | ACH-DELISTED | Stock | 2.475 | 2.475 | 2.475 | 2.475 | 5600.0 |
| 2002-09-27 | ACLS | Stock | 18.96 | 19.2 | 17.8 | 18.56 | 159525.0 |
| 2002-09-27 | ACO-DELISTED | Stock | 6.05 | 6.19 | 5.9 | 5.9 | 10000.0 |
| 2002-09-27 | ACPW-DELISTED | Stock | 6.3526 | 6.9473 | 6.2476 | 6.7474 | 22222.0 |
| 2002-09-27 | ACS-DELISTED | Stock | 42.58 | 43.22 | 41.85 | 42.6 | 1151000.0 |
| 2002-09-27 | ACTA-DELISTED | Stock | 3.6 | 3.8 | 3.6 | 3.6 | 27000.0 |
| 2002-09-27 | ACTT-DELISTED | Stock | 1.77 | 1.77 | 1.311 | 1.32 | 27200.0 |
| 2002-09-27 | ACTU-DELISTED | Stock | 0.9 | 1.0 | 0.88 | 0.95 | 565125.0 |
| 2002-09-27 | ACXM-DELISTED | Stock | 14.95 | 15.49 | 14.25 | 14.25 | 873642.0 |
> showing 50 of 3,160 rows — these rows as CSV