PREVIEW / stock_daily / 2002-10-07
file: by_date/stock_daily/2002/2002-10-07.parquet size: 108 KB rows: 3,217 symbols: 1,989
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-10-07 | AAPL | Stock | 0.2495 | 0.2538 | 0.2457 | 0.2459 | 244697600.0 |
| 2002-10-07 | MSFT | Stock | 21.905 | 22.53 | 21.845 | 22.025 | 89790000.0 |
| 2002-10-07 | NVDA | Stock | 0.0669 | 0.0682 | 0.064 | 0.0645 | 493068000.0 |
| 2002-10-07 | AMZN | Stock | 0.8275 | 0.848 | 0.8185 | 0.832 | 114962000.0 |
| 2002-10-07 | CL | Stock | 27.05 | 27.825 | 27.05 | 27.375 | 5263000.0 |
| 2002-10-07 | A | Stock | 8.4478 | 8.9413 | 8.2403 | 8.2403 | 3569374.0 |
| 2002-10-07 | AABA-DELISTED | Stock | 4.625 | 4.74499988555908 | 4.50500011444092 | 4.53999996185303 | 10617800.0 |
| 2002-10-07 | AAI-DELISTED | Stock | 3.05 | 3.05 | 2.85 | 2.86 | 104800.0 |
| 2002-10-07 | AAIC-DELISTED | Stock | 172.4 | 183.0 | 168.6 | 170.0 | 152200.0 |
| 2002-10-07 | AAME | Stock | 1.71 | 1.73 | 1.7 | 1.7 | 1800.0 |
| 2002-10-07 | AAON | Stock | 2.1807 | 2.186 | 2.0807 | 2.1123 | 204272.0 |
| 2002-10-07 | AAP | Stock | 17.7567 | 18.4333 | 17.5333 | 17.8333 | 1666800.0 |
| 2002-10-07 | AAXN-DELISTED | Stock | 0.335833340883255 | 0.347499996423721 | 0.320833325386047 | 0.347499996423721 | 406800.0 |
| 2002-10-07 | ABAX-DELISTED | Stock | 3.65 | 3.82 | 3.6495 | 3.75 | 18400.0 |
| 2002-10-07 | ABB-DELISTED | Stock | 2.75 | 2.75 | 2.58 | 2.65 | 170300.0 |
| 2002-10-07 | ABC-DELISTED | Stock | 17.7 | 18.1 | 17.58 | 17.6 | 3604000.0 |
| 2002-10-07 | ABCB | Stock | 10.845 | 10.845 | 10.3829 | 10.3829 | 6787.0 |
| 2002-10-07 | ABCO-DELISTED | Stock | 13.705 | 13.705 | 12.93 | 12.935 | 104400.0 |
| 2002-10-07 | ABCW-DELISTED | Stock | 19.8 | 19.81 | 19.63 | 19.65 | 25400.0 |
| 2002-10-07 | ABE-DELISTED | Stock | 5.54 | 5.54 | 5.49 | 5.49 | 17100.0 |
| 2002-10-07 | ABFS-DELISTED | Stock | 28.12 | 28.35 | 27.23 | 27.3 | 499640.0 |
| 2002-10-07 | ABG | Stock | 8.7 | 9.1 | 8.7 | 8.96 | 142200.0 |
| 2002-10-07 | ABK-DELISTED | Stock | 51.83 | 53.29 | 51.33 | 51.5 | 910900.0 |
| 2002-10-07 | ABM | Stock | 13.45 | 13.59 | 13.02 | 13.25 | 327200.0 |
| 2002-10-07 | ABMD-DELISTED | Stock | 3.15 | 3.28 | 2.79 | 2.9 | 197100.0 |
| 2002-10-07 | ABP-DELISTED | Stock | 0.61 | 0.65 | 0.61 | 0.62 | 45700.0 |
| 2002-10-07 | ABT | Stock | 18.1805 | 18.2658 | 17.6418 | 17.754 | 14064575.0 |
| 2002-10-07 | ABTL-DELISTED | Stock | 10.9 | 11.7 | 10.75 | 11.5 | 15500.0 |
| 2002-10-07 | ABV-DELISTED | Stock | 11.95 | 11.95 | 11.49 | 11.57 | 304900.0 |
| 2002-10-07 | ABVA-DELISTED | Stock | 9.85 | 9.85 | 9.7 | 9.7 | 3400.0 |
| 2002-10-07 | ABX-DELISTED | Stock | 15.55 | 15.67 | 15.28 | 15.31 | 2090800.0 |
| 2002-10-07 | ACAP-DELISTED | Stock | 16.62 | 16.67 | 16.2 | 16.2 | 4000.0 |
| 2002-10-07 | ACAS-DELISTED | Stock | 16.75 | 16.84 | 15.17 | 16.252 | 1061244.0 |
| 2002-10-07 | ACAT-DELISTED | Stock | 14.32 | 14.32 | 13.5 | 13.6 | 181200.0 |
| 2002-10-07 | ACCL-DELISTED | Stock | 6.09703016281128 | 6.25634002685547 | 5.94497013092041 | 6.25634002685547 | 86000.0 |
| 2002-10-07 | ACE-DELISTED | Stock | 28.75 | 29.25 | 26.9 | 27.35 | 2069500.0 |
| 2002-10-07 | ACF-DELISTED | Stock | 6.5 | 7.03 | 6.06 | 6.89 | 4048200.0 |
| 2002-10-07 | ACG-DELISTED | Stock | 8.22 | 8.22 | 8.01 | 8.03 | 514000.0 |
| 2002-10-07 | ACGL | Stock | 2.9333 | 2.9856 | 2.9222 | 2.9533 | 293400.0 |
| 2002-10-07 | ACGN-DELISTED | Stock | 940.6712 | 940.6712 | 940.6712 | 940.6712 | 1000.0 |
| 2002-10-07 | ACH | Stock | 9.2 | 9.3733 | 9.1333 | 9.3067 | 395550.0 |
| 2002-10-07 | ACH-DELISTED | Stock | 2.3625 | 2.3625 | 2.3425 | 2.345 | 10800.0 |
| 2002-10-07 | ACLS | Stock | 16.96 | 16.96 | 15.6 | 15.92 | 158900.0 |
| 2002-10-07 | ACO-DELISTED | Stock | 5.2 | 5.4 | 4.9 | 4.99 | 24400.0 |
| 2002-10-07 | ACPW-DELISTED | Stock | 7.5 | 10.7 | 7.3 | 9.0 | 59843.0 |
| 2002-10-07 | ACS-DELISTED | Stock | 38.55 | 39.2 | 36.0 | 36.03 | 1748300.0 |
| 2002-10-07 | ACTA-DELISTED | Stock | 3.8 | 3.8 | 3.4 | 3.4 | 20400.0 |
| 2002-10-07 | ACTT-DELISTED | Stock | 1.2 | 1.27 | 1.16 | 1.17 | 39900.0 |
| 2002-10-07 | ACTU-DELISTED | Stock | 0.86 | 0.86 | 0.8 | 0.8 | 173100.0 |
| 2002-10-07 | ACXM-DELISTED | Stock | 13.84 | 14.2 | 13.73 | 13.99 | 352337.0 |
> showing 50 of 3,217 rows — these rows as CSV