PREVIEW / stock_daily / 2002-01-03
file: by_date/stock_daily/2002/2002-01-03.parquet size: 104 KB rows: 3,047 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-03 | AAPL | Stock | 0.4107 | 0.4241 | 0.4066 | 0.4211 | 612007200.0 |
| 2002-01-03 | MSFT | Stock | 33.555 | 34.625 | 33.545 | 34.615 | 67590800.0 |
| 2002-01-03 | NVDA | Stock | 0.562 | 0.6 | 0.5617 | 0.5976 | 1414752000.0 |
| 2002-01-03 | AMZN | Stock | 0.5565 | 0.597 | 0.5525 | 0.595 | 217514000.0 |
| 2002-01-03 | CL | Stock | 28.685 | 28.71 | 28.435 | 28.71 | 2003200.0 |
| 2002-01-03 | A | Stock | 21.0944 | 22.3176 | 21.0443 | 22.2461 | 4558319.0 |
| 2002-01-03 | AABA-DELISTED | Stock | 9.35000038146973 | 9.64500045776367 | 9.27000045776367 | 9.5649995803833 | 23668000.0 |
| 2002-01-03 | AAI-DELISTED | Stock | 6.54 | 6.82 | 6.44 | 6.8 | 324700.0 |
| 2002-01-03 | AAIC-DELISTED | Stock | 105.0 | 116.0 | 105.0 | 116.0 | 33400.0 |
| 2002-01-03 | AAME | Stock | 2.23 | 2.3 | 2.23 | 2.3 | 8000.0 |
| 2002-01-03 | AAON | Stock | 1.9226 | 1.9314 | 1.769 | 1.7962 | 1530900.0 |
| 2002-01-03 | AAP | Stock | 15.9 | 15.9033 | 15.1 | 15.1 | 89700.0 |
| 2002-01-03 | AAXN-DELISTED | Stock | 1.12583339214325 | 1.13999998569489 | 1.10833334922791 | 1.12083327770233 | 416400.0 |
| 2002-01-03 | ABAX-DELISTED | Stock | 5.85 | 5.85 | 5.54 | 5.7 | 23500.0 |
| 2002-01-03 | ABB-DELISTED | Stock | 10.57 | 10.73 | 10.57 | 10.61 | 30600.0 |
| 2002-01-03 | ABC-DELISTED | Stock | 15.65 | 15.65 | 15.2 | 15.4 | 4768000.0 |
| 2002-01-03 | ABCB | Stock | 10.8207 | 11.0638 | 10.7801 | 10.8774 | 48857.0 |
| 2002-01-03 | ABCO-DELISTED | Stock | 14.03 | 14.575 | 13.895 | 14.575 | 52200.0 |
| 2002-01-03 | ABCW-DELISTED | Stock | 17.6 | 18.05 | 17.45 | 18.0 | 22900.0 |
| 2002-01-03 | ABE-DELISTED | Stock | 7.26 | 7.31 | 7.21 | 7.25 | 15000.0 |
| 2002-01-03 | ABFS-DELISTED | Stock | 28.55 | 30.15 | 28.45 | 29.75 | 159200.0 |
| 2002-01-03 | ABK-DELISTED | Stock | 58.3 | 58.55 | 57.2 | 57.9 | 442700.0 |
| 2002-01-03 | ABM | Stock | 15.28 | 15.49 | 15.125 | 15.32 | 102200.0 |
| 2002-01-03 | ABMD-DELISTED | Stock | 16.0 | 16.05 | 15.45 | 15.45 | 209100.0 |
| 2002-01-03 | ABP-DELISTED | Stock | 1.5 | 1.53 | 1.44 | 1.45 | 201600.0 |
| 2002-01-03 | ABT | Stock | 25.0487 | 25.0936 | 24.8512 | 25.0891 | 5920015.0 |
| 2002-01-03 | ABTL-DELISTED | Stock | 9.1 | 9.45 | 9.0 | 9.0 | 16200.0 |
| 2002-01-03 | ABV-DELISTED | Stock | 22.0 | 22.0 | 21.45 | 21.56 | 403600.0 |
| 2002-01-03 | ABVA-DELISTED | Stock | 8.35 | 8.35 | 8.0 | 8.0 | 1700.0 |
| 2002-01-03 | ABX-DELISTED | Stock | 16.2 | 16.67 | 16.2 | 16.54 | 2149100.0 |
| 2002-01-03 | ACAP-DELISTED | Stock | 21.45 | 21.85 | 21.35 | 21.35 | 102300.0 |
| 2002-01-03 | ACAS-DELISTED | Stock | 28.56 | 28.91 | 28.35 | 28.79 | 223100.0 |
| 2002-01-03 | ACAT-DELISTED | Stock | 17.04 | 17.35 | 16.9 | 17.35 | 31900.0 |
| 2002-01-03 | ACCL-DELISTED | Stock | 9.57999992370605 | 10.0509996414185 | 9.57999992370605 | 9.96399974822998 | 107300.0 |
| 2002-01-03 | ACE-DELISTED | Stock | 39.82 | 39.98 | 38.79 | 39.02 | 1654900.0 |
| 2002-01-03 | ACF-DELISTED | Stock | 29.7 | 31.14 | 29.61 | 30.42 | 1120100.0 |
| 2002-01-03 | ACG-DELISTED | Stock | 7.32 | 7.38 | 7.3 | 7.36 | 1013300.0 |
| 2002-01-03 | ACGL | Stock | 2.8667 | 3.0089 | 2.8667 | 3.0089 | 225900.0 |
| 2002-01-03 | ACGN-DELISTED | Stock | 1870.0 | 2040.0 | 1813.3288 | 1983.3288 | 179800.0 |
| 2002-01-03 | ACH | Stock | 12.1 | 12.4667 | 12.1 | 12.4 | 238500.0 |
| 2002-01-03 | ACH-DELISTED | Stock | 4.427 | 4.482 | 4.3996 | 4.462 | 915512.0 |
| 2002-01-03 | ACLS | Stock | 52.48 | 59.08 | 52.44 | 58.84 | 372450.0 |
| 2002-01-03 | ACO-DELISTED | Stock | 6.9 | 7.3 | 6.9 | 7.1 | 106300.0 |
| 2002-01-03 | ACPW-DELISTED | Stock | 34.13 | 35.08 | 32.87 | 33.42 | 33106.0 |
| 2002-01-03 | ACS-DELISTED | Stock | 52.5 | 52.92 | 51.05 | 51.49 | 757100.0 |
| 2002-01-03 | ACTA-DELISTED | Stock | 25.2 | 27.0 | 24.4 | 26.4 | 76300.0 |
| 2002-01-03 | ACTT-DELISTED | Stock | 7.69 | 7.73 | 7.22 | 7.4 | 100300.0 |
| 2002-01-03 | ACTU-DELISTED | Stock | 5.29 | 5.6 | 5.25 | 5.35 | 610600.0 |
| 2002-01-03 | ACXM-DELISTED | Stock | 17.65 | 18.08 | 17.53 | 17.98 | 434500.0 |
| 2002-01-03 | ACY-DELISTED | Stock | 4.85 | 4.95 | 4.75 | 4.9 | 7900.0 |
> showing 50 of 3,047 rows — these rows as CSV