PREVIEW / stock_daily / 2002-09-24
file: by_date/stock_daily/2002/2002-09-24.parquet size: 107 KB rows: 3,187 symbols: 1,969
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-24 | AAPL | Stock | 0.2571 | 0.2646 | 0.2571 | 0.2614 | 250661600.0 |
| 2002-09-24 | MSFT | Stock | 22.415 | 23.24 | 22.315 | 22.82 | 104142200.0 |
| 2002-09-24 | NVDA | Stock | 0.0726 | 0.0775 | 0.0712 | 0.074 | 624444000.0 |
| 2002-09-24 | AMZN | Stock | 0.7935 | 0.8185 | 0.78 | 0.7965 | 141458000.0 |
| 2002-09-24 | CL | Stock | 26.75 | 26.81 | 26.25 | 26.25 | 4816000.0 |
| 2002-09-24 | A | Stock | 9.4778 | 9.7997 | 9.3634 | 9.4421 | 4394333.0 |
| 2002-09-24 | AABA-DELISTED | Stock | 4.47499990463257 | 4.73000001907349 | 4.46999979019165 | 4.5 | 18029000.0 |
| 2002-09-24 | AAI-DELISTED | Stock | 2.35 | 2.88 | 2.34 | 2.71 | 453500.0 |
| 2002-09-24 | AAIC-DELISTED | Stock | 180.4 | 182.0 | 178.4 | 179.0 | 98600.0 |
| 2002-09-24 | AAME | Stock | 1.75 | 1.77 | 1.75 | 1.76 | 500.0 |
| 2002-09-24 | AAON | Stock | 2.1215 | 2.3388 | 2.1202 | 2.1992 | 157191.0 |
| 2002-09-24 | AAP | Stock | 16.7467 | 16.81 | 15.9667 | 16.3867 | 1480800.0 |
| 2002-09-24 | AAXN-DELISTED | Stock | 0.483333319425583 | 0.495833337306976 | 0.47583332657814 | 0.483333319425583 | 74400.0 |
| 2002-09-24 | ABAX-DELISTED | Stock | 3.07 | 3.09 | 2.9 | 3.05 | 40400.0 |
| 2002-09-24 | ABB-DELISTED | Stock | 3.24 | 3.58 | 3.23 | 3.46 | 77700.0 |
| 2002-09-24 | ABC-DELISTED | Stock | 17.13 | 17.6 | 17.05 | 17.4 | 4603600.0 |
| 2002-09-24 | ABCB | Stock | 10.3424 | 10.772 | 10.3424 | 10.537 | 16533.0 |
| 2002-09-24 | ABCO-DELISTED | Stock | 13.76 | 14.1 | 13.76 | 13.955 | 31820.0 |
| 2002-09-24 | ABCW-DELISTED | Stock | 19.75 | 20.24 | 19.57 | 19.63 | 25500.0 |
| 2002-09-24 | ABE-DELISTED | Stock | 5.55 | 5.57 | 5.51 | 5.51 | 25000.0 |
| 2002-09-24 | ABFS-DELISTED | Stock | 27.56 | 29.41 | 27.55 | 29.08 | 626175.0 |
| 2002-09-24 | ABG | Stock | 8.65 | 9.07 | 8.5 | 8.71 | 107400.0 |
| 2002-09-24 | ABK-DELISTED | Stock | 53.25 | 53.8 | 52.5 | 53.0 | 1326400.0 |
| 2002-09-24 | ABM | Stock | 13.9 | 14.13 | 13.77 | 13.85 | 165400.0 |
| 2002-09-24 | ABMD-DELISTED | Stock | 4.04 | 4.04 | 3.75 | 3.9 | 48100.0 |
| 2002-09-24 | ABP-DELISTED | Stock | 0.83 | 0.83 | 0.79 | 0.83 | 23900.0 |
| 2002-09-24 | ABT | Stock | 18.5172 | 19.0334 | 18.36 | 18.8987 | 11127624.0 |
| 2002-09-24 | ABTL-DELISTED | Stock | 11.65 | 12.9 | 11.0 | 12.5 | 115500.0 |
| 2002-09-24 | ABV-DELISTED | Stock | 11.45 | 11.7 | 11.26 | 11.31 | 798200.0 |
| 2002-09-24 | ABX-DELISTED | Stock | 17.72 | 18.19 | 17.51 | 18.1 | 5092500.0 |
| 2002-09-24 | ACAP-DELISTED | Stock | 17.16 | 17.85 | 17.12 | 17.15 | 27464.0 |
| 2002-09-24 | ACAS-DELISTED | Stock | 17.7 | 18.2 | 17.14 | 17.38 | 2123347.0 |
| 2002-09-24 | ACAT-DELISTED | Stock | 13.9 | 13.95 | 13.75 | 13.75 | 31100.0 |
| 2002-09-24 | ACCL-DELISTED | Stock | 5.87256002426147 | 6.06878995895386 | 5.87256002426147 | 6.06878995895386 | 531300.0 |
| 2002-09-24 | ACE-DELISTED | Stock | 30.51 | 31.24 | 29.61 | 29.97 | 1964600.0 |
| 2002-09-24 | ACF-DELISTED | Stock | 6.2 | 7.05 | 6.2 | 6.88 | 2208500.0 |
| 2002-09-24 | ACG-DELISTED | Stock | 8.2 | 8.21 | 8.18 | 8.19 | 521900.0 |
| 2002-09-24 | ACGL | Stock | 3.0444 | 3.0756 | 3.0144 | 3.0222 | 468000.0 |
| 2002-09-24 | ACGN-DELISTED | Stock | 861.3288 | 918.0 | 804.6712 | 918.0 | 23500.0 |
| 2002-09-24 | ACH | Stock | 9.3 | 9.5 | 9.2667 | 9.3067 | 107700.0 |
| 2002-09-24 | ACH-DELISTED | Stock | 2.685 | 2.6975 | 2.65 | 2.65 | 3200.0 |
| 2002-09-24 | ACLS | Stock | 18.44 | 18.68 | 17.6 | 17.84 | 264025.0 |
| 2002-09-24 | ACO-DELISTED | Stock | 5.91 | 6.05 | 5.82 | 6.0 | 28800.0 |
| 2002-09-24 | ACPW-DELISTED | Stock | 6.0939 | 6.7433 | 5.5 | 5.5 | 44147.0 |
| 2002-09-24 | ACS-DELISTED | Stock | 40.2 | 40.53 | 38.1 | 39.0 | 2934600.0 |
| 2002-09-24 | ACTA-DELISTED | Stock | 3.6 | 4.0 | 3.6 | 3.8 | 44800.0 |
| 2002-09-24 | ACTT-DELISTED | Stock | 1.53 | 1.53 | 1.27 | 1.27 | 24000.0 |
| 2002-09-24 | ACTU-DELISTED | Stock | 0.76 | 0.79 | 0.69 | 0.74 | 821922.0 |
| 2002-09-24 | ACXM-DELISTED | Stock | 15.6 | 16.59 | 15.42 | 16.25 | 803314.0 |
| 2002-09-24 | ACY-DELISTED | Stock | 3.98 | 4.08 | 3.98 | 4.0 | 1700.0 |
> showing 50 of 3,187 rows — these rows as CSV