PREVIEW / stock_daily / 2002-09-17
file: by_date/stock_daily/2002/2002-09-17.parquet size: 107 KB rows: 3,161 symbols: 1,952
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-17 | AAPL | Stock | 0.2602 | 0.2684 | 0.2602 | 0.2643 | 427996800.0 |
| 2002-09-17 | MSFT | Stock | 24.335 | 24.45 | 23.605 | 23.645 | 73343400.0 |
| 2002-09-17 | NVDA | Stock | 0.0862 | 0.0882 | 0.0807 | 0.0812 | 884052000.0 |
| 2002-09-17 | AMZN | Stock | 0.85 | 0.8875 | 0.8385 | 0.8675 | 172424000.0 |
| 2002-09-17 | CL | Stock | 28.125 | 28.32 | 27.395 | 27.4 | 5354200.0 |
| 2002-09-17 | A | Stock | 10.6581 | 10.7654 | 10.4435 | 10.5579 | 3135295.0 |
| 2002-09-17 | AABA-DELISTED | Stock | 5.32499980926514 | 5.34000015258789 | 5.0 | 5.00500011444092 | 10153200.0 |
| 2002-09-17 | AAI-DELISTED | Stock | 3.48 | 3.5 | 3.3 | 3.31 | 148300.0 |
| 2002-09-17 | AAIC-DELISTED | Stock | 197.0 | 203.8 | 191.4 | 194.2 | 178400.0 |
| 2002-09-17 | AAME | Stock | 1.86 | 1.91 | 1.76 | 1.91 | 3000.0 |
| 2002-09-17 | AAON | Stock | 2.1294 | 2.1689 | 2.0556 | 2.0556 | 142762.0 |
| 2002-09-17 | AAP | Stock | 17.9 | 18.0833 | 17.66 | 17.9667 | 2830200.0 |
| 2002-09-17 | AAXN-DELISTED | Stock | 0.479166656732559 | 0.479166656732559 | 0.479166656732559 | 0.479166656732559 | 24000.0 |
| 2002-09-17 | ABAX-DELISTED | Stock | 3.29 | 3.29 | 3.2 | 3.25 | 4000.0 |
| 2002-09-17 | ABB-DELISTED | Stock | 4.0 | 4.08 | 3.95 | 4.03 | 61200.0 |
| 2002-09-17 | ABC-DELISTED | Stock | 17.75 | 18.23 | 17.4 | 17.41 | 9821200.0 |
| 2002-09-17 | ABCB | Stock | 10.7477 | 10.7801 | 10.1317 | 10.5208 | 13571.0 |
| 2002-09-17 | ABCO-DELISTED | Stock | 16.425 | 16.475 | 16.0 | 16.105 | 84542.0 |
| 2002-09-17 | ABCW-DELISTED | Stock | 20.69 | 20.69 | 20.38 | 20.45 | 30300.0 |
| 2002-09-17 | ABE-DELISTED | Stock | 5.9 | 5.93 | 5.88 | 5.93 | 4900.0 |
| 2002-09-17 | ABFS-DELISTED | Stock | 28.01 | 28.16 | 27.75 | 27.83 | 208692.0 |
| 2002-09-17 | ABG | Stock | 11.27 | 11.45 | 11.23 | 11.23 | 45800.0 |
| 2002-09-17 | ABK-DELISTED | Stock | 57.01 | 57.01 | 54.55 | 54.7 | 748800.0 |
| 2002-09-17 | ABM | Stock | 14.56 | 14.65 | 14.03 | 14.15 | 176200.0 |
| 2002-09-17 | ABMD-DELISTED | Stock | 4.97 | 5.04 | 4.68 | 4.78 | 88000.0 |
| 2002-09-17 | ABP-DELISTED | Stock | 0.78 | 0.87 | 0.77 | 0.77 | 23000.0 |
| 2002-09-17 | ABT | Stock | 17.5071 | 17.6194 | 17.2827 | 17.3231 | 9626847.0 |
| 2002-09-17 | ABTL-DELISTED | Stock | 9.0 | 9.0 | 7.9 | 8.7 | 15500.0 |
| 2002-09-17 | ABV-DELISTED | Stock | 13.42 | 13.43 | 13.16 | 13.26 | 253600.0 |
| 2002-09-17 | ABVA-DELISTED | Stock | 10.49 | 10.5 | 10.4 | 10.4 | 5000.0 |
| 2002-09-17 | ABX-DELISTED | Stock | 17.1 | 17.22 | 16.96 | 17.13 | 3246300.0 |
| 2002-09-17 | ACAP-DELISTED | Stock | 17.51 | 17.63 | 17.45 | 17.45 | 5700.0 |
| 2002-09-17 | ACAS-DELISTED | Stock | 19.33 | 19.97 | 18.4 | 18.52 | 1229910.0 |
| 2002-09-17 | ACAT-DELISTED | Stock | 14.38 | 14.63 | 14.38 | 14.38 | 39100.0 |
| 2002-09-17 | ACCL-DELISTED | Stock | 6.08978986740112 | 6.27082014083862 | 6.05357980728149 | 6.27082014083862 | 97600.0 |
| 2002-09-17 | ACE-DELISTED | Stock | 33.79 | 34.24 | 32.57 | 32.6 | 1046083.0 |
| 2002-09-17 | ACF-DELISTED | Stock | 10.01 | 11.49 | 8.4 | 8.49 | 11444100.0 |
| 2002-09-17 | ACG-DELISTED | Stock | 8.15 | 8.18 | 8.1 | 8.18 | 454000.0 |
| 2002-09-17 | ACGL | Stock | 3.09 | 3.1133 | 3.0689 | 3.1 | 403200.0 |
| 2002-09-17 | ACGN-DELISTED | Stock | 986.0 | 1076.6712 | 986.0 | 1076.6712 | 4500.0 |
| 2002-09-17 | ACH | Stock | 10.0333 | 10.1667 | 9.9 | 10.0 | 151200.0 |
| 2002-09-17 | ACH-DELISTED | Stock | 3.362 | 3.362 | 3.332 | 3.342 | 20003.0 |
| 2002-09-17 | ACLS | Stock | 23.88 | 23.92 | 22.04 | 22.04 | 172575.0 |
| 2002-09-17 | ACO-DELISTED | Stock | 6.0 | 6.08 | 6.0 | 6.01 | 17700.0 |
| 2002-09-17 | ACPW-DELISTED | Stock | 8.126 | 8.427 | 7.524 | 7.524 | 8218.0 |
| 2002-09-17 | ACS-DELISTED | Stock | 46.55 | 46.76 | 44.6 | 44.6 | 2217600.0 |
| 2002-09-17 | ACTA-DELISTED | Stock | 4.6 | 4.8 | 4.2 | 4.4 | 55600.0 |
| 2002-09-17 | ACTT-DELISTED | Stock | 2.199 | 2.199 | 2.0 | 2.0 | 9300.0 |
| 2002-09-17 | ACTU-DELISTED | Stock | 1.65 | 1.65 | 1.28 | 1.34 | 383200.0 |
| 2002-09-17 | ACXM-DELISTED | Stock | 18.07 | 18.36 | 17.7 | 17.74 | 956636.0 |
> showing 50 of 3,161 rows — these rows as CSV