PREVIEW / stock_daily / 2002-09-06
file: by_date/stock_daily/2002/2002-09-06.parquet size: 107 KB rows: 3,169 symbols: 1,959
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-06 | AAPL | Stock | 0.2591 | 0.2616 | 0.2541 | 0.2568 | 181591200.0 |
| 2002-09-06 | MSFT | Stock | 23.875 | 24.135 | 23.735 | 23.91 | 69918400.0 |
| 2002-09-06 | NVDA | Stock | 0.0787 | 0.0793 | 0.076 | 0.0772 | 746460000.0 |
| 2002-09-06 | AMZN | Stock | 0.728 | 0.774 | 0.728 | 0.7655 | 99906000.0 |
| 2002-09-06 | CL | Stock | 28.0 | 28.1 | 27.365 | 27.45 | 5692000.0 |
| 2002-09-06 | A | Stock | 10.0501 | 10.2647 | 9.9356 | 10.1216 | 5318551.0 |
| 2002-09-06 | AABA-DELISTED | Stock | 4.78000020980835 | 5.01000022888184 | 4.75500011444092 | 4.96999979019165 | 17477400.0 |
| 2002-09-06 | AAI-DELISTED | Stock | 3.3 | 3.4 | 3.28 | 3.39 | 169200.0 |
| 2002-09-06 | AAIC-DELISTED | Stock | 215.8 | 217.6 | 212.8 | 217.6 | 111300.0 |
| 2002-09-06 | AAME | Stock | 1.77 | 2.03 | 1.75 | 1.8 | 1400.0 |
| 2002-09-06 | AAON | Stock | 2.1663 | 2.2123 | 2.1228 | 2.1702 | 178453.0 |
| 2002-09-06 | AAP | Stock | 16.5667 | 16.8333 | 16.55 | 16.7333 | 1107900.0 |
| 2002-09-06 | AAXN-DELISTED | Stock | 0.545000016689301 | 0.570833325386047 | 0.545000016689301 | 0.560000002384186 | 315600.0 |
| 2002-09-06 | ABAX-DELISTED | Stock | 2.9 | 3.45 | 2.9 | 3.25 | 36200.0 |
| 2002-09-06 | ABB-DELISTED | Stock | 5.42 | 5.71 | 5.42 | 5.6 | 21500.0 |
| 2002-09-06 | ABC-DELISTED | Stock | 18.25 | 18.41 | 18.06 | 18.18 | 3580000.0 |
| 2002-09-06 | ABCB | Stock | 11.0071 | 11.0152 | 10.4559 | 10.4721 | 8019.0 |
| 2002-09-06 | ABCO-DELISTED | Stock | 17.148 | 17.153 | 16.683 | 16.842 | 12787.0 |
| 2002-09-06 | ABCW-DELISTED | Stock | 21.75 | 22.35 | 21.75 | 22.02 | 60800.0 |
| 2002-09-06 | ABE-DELISTED | Stock | 5.95 | 5.96 | 5.86 | 5.96 | 2800.0 |
| 2002-09-06 | ABFS-DELISTED | Stock | 26.38 | 27.75 | 26.14 | 27.48 | 698945.0 |
| 2002-09-06 | ABG | Stock | 11.7 | 11.9 | 10.7 | 11.37 | 109600.0 |
| 2002-09-06 | ABK-DELISTED | Stock | 57.85 | 58.09 | 57.23 | 57.55 | 520300.0 |
| 2002-09-06 | ABM | Stock | 16.15 | 16.83 | 16.15 | 16.83 | 49700.0 |
| 2002-09-06 | ABMD-DELISTED | Stock | 5.36 | 5.5 | 5.175 | 5.355 | 31494.0 |
| 2002-09-06 | ABP-DELISTED | Stock | 0.73 | 0.82 | 0.73 | 0.77 | 16700.0 |
| 2002-09-06 | ABT | Stock | 17.0717 | 17.2288 | 16.744 | 16.8338 | 9386482.0 |
| 2002-09-06 | ABTL-DELISTED | Stock | 10.95 | 11.05 | 10.4 | 11.0 | 5700.0 |
| 2002-09-06 | ABV-DELISTED | Stock | 13.4 | 13.46 | 13.18 | 13.3 | 212600.0 |
| 2002-09-06 | ABVA-DELISTED | Stock | 9.86 | 9.86 | 9.86 | 9.86 | 100.0 |
| 2002-09-06 | ABX-DELISTED | Stock | 16.31 | 16.85 | 16.19 | 16.54 | 4537200.0 |
| 2002-09-06 | ACAP-DELISTED | Stock | 18.0 | 18.15 | 17.67 | 17.96 | 25800.0 |
| 2002-09-06 | ACAS-DELISTED | Stock | 21.38 | 21.48 | 21.05 | 21.05 | 729846.0 |
| 2002-09-06 | ACAT-DELISTED | Stock | 14.251 | 14.99 | 14.25 | 14.5 | 35700.0 |
| 2002-09-06 | ACCL-DELISTED | Stock | 5.64807987213135 | 6.15496015548706 | 5.64807987213135 | 6.15496015548706 | 65000.0 |
| 2002-09-06 | ACE-DELISTED | Stock | 31.44 | 31.65 | 31.0 | 31.09 | 833500.0 |
| 2002-09-06 | ACF-DELISTED | Stock | 13.71 | 13.98 | 13.35 | 13.8 | 1597000.0 |
| 2002-09-06 | ACG-DELISTED | Stock | 8.1 | 8.11 | 8.07 | 8.1 | 321400.0 |
| 2002-09-06 | ACGL | Stock | 3.0033 | 3.0556 | 2.9356 | 3.0 | 302400.0 |
| 2002-09-06 | ACGN-DELISTED | Stock | 736.6712 | 770.6712 | 668.6712 | 759.3288 | 185600.0 |
| 2002-09-06 | ACH | Stock | 9.7133 | 9.9667 | 9.7133 | 9.8333 | 109800.0 |
| 2002-09-06 | ACH-DELISTED | Stock | 3.3505 | 3.3531 | 3.3154 | 3.3255 | 57770.0 |
| 2002-09-06 | ACLS | Stock | 25.24 | 26.56 | 25.24 | 25.8 | 167875.0 |
| 2002-09-06 | ACO-DELISTED | Stock | 5.3 | 5.65 | 5.3 | 5.65 | 19400.0 |
| 2002-09-06 | ACPW-DELISTED | Stock | 10.074 | 10.174 | 9.021 | 9.176 | 21757.0 |
| 2002-09-06 | ACS-DELISTED | Stock | 46.2 | 46.85 | 44.96 | 45.13 | 850400.0 |
| 2002-09-06 | ACTA-DELISTED | Stock | 5.2 | 5.4 | 5.0 | 5.0 | 32400.0 |
| 2002-09-06 | ACTT-DELISTED | Stock | 1.82 | 2.49 | 1.8 | 2.4074 | 61500.0 |
| 2002-09-06 | ACTU-DELISTED | Stock | 1.92 | 1.94 | 1.75 | 1.8 | 166620.0 |
| 2002-09-06 | ACXM-DELISTED | Stock | 17.63 | 18.71 | 17.63 | 18.68 | 974286.0 |
> showing 50 of 3,169 rows — these rows as CSV