PREVIEW / stock_daily / 2002-11-19
file: by_date/stock_daily/2002/2002-11-19.parquet size: 110 KB rows: 3,235 symbols: 2,000
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-11-19 | AAPL | Stock | 0.2777 | 0.2813 | 0.268 | 0.2727 | 210952000.0 |
| 2002-11-19 | MSFT | Stock | 27.775 | 27.9 | 27.155 | 27.43 | 76403400.0 |
| 2002-11-19 | NVDA | Stock | 0.1157 | 0.124 | 0.1145 | 0.1181 | 1971948000.0 |
| 2002-11-19 | AMZN | Stock | 1.094 | 1.0945 | 1.0615 | 1.0645 | 245178000.0 |
| 2002-11-19 | CL | Stock | 26.2 | 26.72 | 26.2 | 26.395 | 3369600.0 |
| 2002-11-19 | A | Stock | 10.5508 | 12.2103 | 10.515 | 11.8741 | 18513155.0 |
| 2002-11-19 | AABA-DELISTED | Stock | 8.63000011444092 | 8.79500007629395 | 8.28499984741211 | 8.375 | 21809200.0 |
| 2002-11-19 | AAI-DELISTED | Stock | 3.82 | 3.84 | 3.73 | 3.76 | 129200.0 |
| 2002-11-19 | AAIC-DELISTED | Stock | 174.0 | 174.2 | 171.2 | 171.2 | 300000.0 |
| 2002-11-19 | AAME | Stock | 1.69 | 1.69 | 1.67 | 1.69 | 600.0 |
| 2002-11-19 | AAON | Stock | 2.5034 | 2.5771 | 2.5021 | 2.5152 | 93403.0 |
| 2002-11-19 | AAP | Stock | 17.47 | 17.9933 | 17.15 | 17.65 | 2984100.0 |
| 2002-11-19 | AAXN-DELISTED | Stock | 0.349999994039536 | 0.370833337306976 | 0.349999994039536 | 0.362500011920929 | 546000.0 |
| 2002-11-19 | ABAX-DELISTED | Stock | 4.0 | 4.04 | 3.9 | 3.99 | 14000.0 |
| 2002-11-19 | ABB-DELISTED | Stock | 2.54 | 2.56 | 2.46 | 2.55 | 361400.0 |
| 2002-11-19 | ABC-DELISTED | Stock | 14.06 | 14.84 | 14.06 | 14.73 | 32426400.0 |
| 2002-11-19 | ABCB | Stock | 10.156 | 10.6423 | 10.156 | 10.4397 | 8390.0 |
| 2002-11-19 | ABCO-DELISTED | Stock | 15.465 | 15.545 | 15.145 | 15.16 | 177688.0 |
| 2002-11-19 | ABCW-DELISTED | Stock | 20.41 | 20.84 | 19.87 | 20.03 | 43100.0 |
| 2002-11-19 | ABE-DELISTED | Stock | 5.9 | 6.0 | 5.85 | 5.9 | 19900.0 |
| 2002-11-19 | ABFS-DELISTED | Stock | 28.3 | 28.55 | 27.53 | 27.8 | 146800.0 |
| 2002-11-19 | ABG | Stock | 8.35 | 8.35 | 8.2 | 8.2 | 10100.0 |
| 2002-11-19 | ABK-DELISTED | Stock | 56.34 | 58.75 | 54.95 | 57.37 | 1258000.0 |
| 2002-11-19 | ABM | Stock | 14.5 | 14.81 | 14.3 | 14.39 | 71300.0 |
| 2002-11-19 | ABMD-DELISTED | Stock | 4.57 | 4.93 | 4.57 | 4.8 | 59900.0 |
| 2002-11-19 | ABP-DELISTED | Stock | 0.61 | 0.61 | 0.55 | 0.57 | 22800.0 |
| 2002-11-19 | ABT | Stock | 19.9851 | 20.2005 | 19.7561 | 19.9492 | 7458662.0 |
| 2002-11-19 | ABTL-DELISTED | Stock | 14.0 | 14.0 | 12.4 | 13.15 | 10900.0 |
| 2002-11-19 | ABV-DELISTED | Stock | 14.96 | 14.96 | 14.4 | 14.42 | 297400.0 |
| 2002-11-19 | ABX-DELISTED | Stock | 15.81 | 15.88 | 15.36 | 15.39 | 1228347.0 |
| 2002-11-19 | ACAP-DELISTED | Stock | 16.96 | 17.09 | 16.8 | 16.91 | 13757.0 |
| 2002-11-19 | ACAS-DELISTED | Stock | 19.09 | 19.52 | 18.89 | 19.12 | 483890.0 |
| 2002-11-19 | ACAT-DELISTED | Stock | 16.1 | 16.35 | 16.08 | 16.23 | 36500.0 |
| 2002-11-19 | ACCL-DELISTED | Stock | 7.23389005661011 | 7.32077980041504 | 7.23389005661011 | 7.32077980041504 | 55000.0 |
| 2002-11-19 | ACE-DELISTED | Stock | 31.9 | 32.25 | 31.76 | 32.18 | 1143593.0 |
| 2002-11-19 | ACF-DELISTED | Stock | 7.5 | 7.6 | 7.37 | 7.49 | 1655500.0 |
| 2002-11-19 | ACG-DELISTED | Stock | 8.11 | 8.17 | 8.09 | 8.15 | 375100.0 |
| 2002-11-19 | ACGL | Stock | 3.4444 | 3.5222 | 3.39 | 3.43 | 1485000.0 |
| 2002-11-19 | ACGN-DELISTED | Stock | 1303.3288 | 1326.0 | 1144.6712 | 1246.6712 | 46000.0 |
| 2002-11-19 | ACH | Stock | 9.6667 | 10.1733 | 9.6667 | 10.0267 | 190800.0 |
| 2002-11-19 | ACH-DELISTED | Stock | 2.8875 | 2.8925 | 2.885 | 2.885 | 6000.0 |
| 2002-11-19 | ACLS | Stock | 25.28 | 26.0 | 24.48 | 24.84 | 298700.0 |
| 2002-11-19 | ACO-DELISTED | Stock | 5.65 | 5.69 | 5.25 | 5.34 | 15200.0 |
| 2002-11-19 | ACPW-DELISTED | Stock | 9.6 | 9.7 | 8.8 | 9.15 | 12275.0 |
| 2002-11-19 | ACS-DELISTED | Stock | 43.95 | 44.43 | 43.19 | 44.28 | 1356100.0 |
| 2002-11-19 | ACTA-DELISTED | Stock | 9.6 | 9.6 | 9.0 | 9.2 | 69800.0 |
| 2002-11-19 | ACTT-DELISTED | Stock | 1.32 | 1.37 | 1.32 | 1.35 | 10300.0 |
| 2002-11-19 | ACTU-DELISTED | Stock | 1.95 | 1.95 | 1.8 | 1.8 | 114900.0 |
| 2002-11-19 | ACXM-DELISTED | Stock | 13.56 | 13.56 | 12.54 | 12.86 | 984068.0 |
| 2002-11-19 | ACY-DELISTED | Stock | 3.85 | 3.85 | 3.85 | 3.85 | 400.0 |
> showing 50 of 3,235 rows — these rows as CSV