PREVIEW / stock_daily / 2002-01-31
file: by_date/stock_daily/2002/2002-01-31.parquet size: 105 KB rows: 3,052 symbols: 1,891
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-01-31 | AAPL | Stock | 0.4314 | 0.4416 | 0.4305 | 0.4414 | 468445600.0 |
| 2002-01-31 | MSFT | Stock | 31.53 | 31.905 | 31.06 | 31.855 | 69566200.0 |
| 2002-01-31 | NVDA | Stock | 0.5524 | 0.5567 | 0.5296 | 0.5478 | 973980000.0 |
| 2002-01-31 | AMZN | Stock | 0.706 | 0.7245 | 0.6705 | 0.7095 | 209706000.0 |
| 2002-01-31 | CL | Stock | 28.125 | 28.575 | 27.875 | 28.575 | 3966800.0 |
| 2002-01-31 | A | Stock | 20.9585 | 21.731 | 20.8584 | 21.7096 | 2756716.0 |
| 2002-01-31 | AABA-DELISTED | Stock | 8.85000038146973 | 8.89999961853027 | 8.39500045776367 | 8.61999988555908 | 15431600.0 |
| 2002-01-31 | AAI-DELISTED | Stock | 6.75 | 6.75 | 6.44 | 6.48 | 334900.0 |
| 2002-01-31 | AAIC-DELISTED | Stock | 131.0 | 146.4 | 131.0 | 145.4 | 206500.0 |
| 2002-01-31 | AAME | Stock | 2.35 | 2.35 | 2.35 | 2.35 | 5200.0 |
| 2002-01-31 | AAON | Stock | 1.7558 | 1.7558 | 1.7119 | 1.7286 | 91125.0 |
| 2002-01-31 | AAP | Stock | 15.5833 | 15.7 | 15.4833 | 15.6167 | 36600.0 |
| 2002-01-31 | AAXN-DELISTED | Stock | 1.48666667938232 | 1.48666667938232 | 1.39666664600372 | 1.41666662693024 | 1023600.0 |
| 2002-01-31 | ABAX-DELISTED | Stock | 6.4 | 6.4 | 6.06 | 6.31 | 24600.0 |
| 2002-01-31 | ABB-DELISTED | Stock | 8.84 | 8.84 | 8.6 | 8.65 | 23700.0 |
| 2002-01-31 | ABC-DELISTED | Stock | 15.6 | 16.3 | 15.58 | 16.2 | 5484000.0 |
| 2002-01-31 | ABCB | Stock | 10.9422 | 10.9422 | 10.9422 | 10.9422 | 2468.0 |
| 2002-01-31 | ABCO-DELISTED | Stock | 15.83 | 16.425 | 15.818 | 16.39 | 139696.0 |
| 2002-01-31 | ABCW-DELISTED | Stock | 17.92 | 18.05 | 17.73 | 18.0 | 45700.0 |
| 2002-01-31 | ABE-DELISTED | Stock | 7.12 | 7.2 | 7.12 | 7.14 | 6300.0 |
| 2002-01-31 | ABFS-DELISTED | Stock | 29.3 | 30.16 | 28.49 | 30.16 | 165400.0 |
| 2002-01-31 | ABK-DELISTED | Stock | 58.96 | 59.6 | 58.55 | 59.55 | 505700.0 |
| 2002-01-31 | ABM | Stock | 15.05 | 15.25 | 15.0 | 15.25 | 72400.0 |
| 2002-01-31 | ABMD-DELISTED | Stock | 14.12 | 14.9 | 14.12 | 14.85 | 73800.0 |
| 2002-01-31 | ABP-DELISTED | Stock | 1.12 | 1.18 | 1.09 | 1.11 | 90900.0 |
| 2002-01-31 | ABT | Stock | 25.4527 | 25.9106 | 25.318 | 25.9016 | 7543313.0 |
| 2002-01-31 | ABTL-DELISTED | Stock | 13.3 | 15.1 | 12.6 | 14.85 | 41000.0 |
| 2002-01-31 | ABV-DELISTED | Stock | 19.3 | 19.44 | 18.94 | 19.08 | 182300.0 |
| 2002-01-31 | ABVA-DELISTED | Stock | 8.0 | 8.1 | 8.0 | 8.0 | 21000.0 |
| 2002-01-31 | ABX-DELISTED | Stock | 16.98 | 17.1 | 16.7 | 17.1 | 2321536.0 |
| 2002-01-31 | ACAP-DELISTED | Stock | 21.24 | 21.35 | 21.0 | 21.16 | 26000.0 |
| 2002-01-31 | ACAS-DELISTED | Stock | 27.01 | 27.36 | 26.82 | 27.13 | 376000.0 |
| 2002-01-31 | ACAT-DELISTED | Stock | 17.35 | 17.95 | 17.05 | 17.95 | 135700.0 |
| 2002-01-31 | ACCL-DELISTED | Stock | 9.623459815979 | 9.70310974121094 | 9.4424295425415 | 9.70310974121094 | 479500.0 |
| 2002-01-31 | ACE-DELISTED | Stock | 38.39 | 38.9 | 38.07 | 38.8 | 2262371.0 |
| 2002-01-31 | ACF-DELISTED | Stock | 21.09 | 22.55 | 21.09 | 22.3 | 2364700.0 |
| 2002-01-31 | ACG-DELISTED | Stock | 7.61 | 7.61 | 7.55 | 7.58 | 538000.0 |
| 2002-01-31 | ACGL | Stock | 2.8333 | 2.9167 | 2.8333 | 2.8356 | 32400.0 |
| 2002-01-31 | ACGN-DELISTED | Stock | 1858.6712 | 1858.6712 | 1768.0 | 1813.3288 | 16700.0 |
| 2002-01-31 | ACH | Stock | 12.6667 | 13.0333 | 12.1667 | 12.9667 | 240300.0 |
| 2002-01-31 | ACH-DELISTED | Stock | 5.2625 | 5.2625 | 5.25 | 5.25 | 116000.0 |
| 2002-01-31 | ACLS | Stock | 52.8 | 55.0 | 52.12 | 54.96 | 162425.0 |
| 2002-01-31 | ACO-DELISTED | Stock | 7.1 | 7.12 | 6.9 | 7.0 | 20000.0 |
| 2002-01-31 | ACPW-DELISTED | Stock | 23.65 | 25.1 | 22.5 | 22.9 | 83080.0 |
| 2002-01-31 | ACS-DELISTED | Stock | 46.75 | 47.83 | 46.35 | 47.825 | 1097600.0 |
| 2002-01-31 | ACTA-DELISTED | Stock | 21.0 | 21.4 | 20.4 | 21.0 | 54800.0 |
| 2002-01-31 | ACTT-DELISTED | Stock | 5.56 | 6.25 | 5.25 | 6.25 | 127600.0 |
| 2002-01-31 | ACTU-DELISTED | Stock | 6.33 | 6.8 | 6.33 | 6.6 | 282600.0 |
| 2002-01-31 | ACXM-DELISTED | Stock | 14.03 | 14.68 | 13.66 | 14.04 | 3799240.0 |
| 2002-01-31 | ACY-DELISTED | Stock | 4.3 | 4.39 | 4.3 | 4.32 | 3100.0 |
> showing 50 of 3,052 rows — these rows as CSV