PREVIEW / stock_daily / 2002-07-16
file: by_date/stock_daily/2002/2002-07-16.parquet size: 107 KB rows: 3,166 symbols: 1,968
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-07-16 | AAPL | Stock | 0.3241 | 0.3316 | 0.3145 | 0.3189 | 446768000.0 |
| 2002-07-16 | MSFT | Stock | 25.655 | 26.4 | 25.32 | 25.625 | 97154600.0 |
| 2002-07-16 | NVDA | Stock | 0.1779 | 0.1946 | 0.1746 | 0.1775 | 1773432000.0 |
| 2002-07-16 | AMZN | Stock | 0.7845 | 0.8535 | 0.783 | 0.8145 | 215814000.0 |
| 2002-07-16 | CL | Stock | 24.125 | 24.15 | 23.215 | 23.845 | 3683000.0 |
| 2002-07-16 | A | Stock | 16.3519 | 17.5036 | 16.2375 | 16.6595 | 3817519.0 |
| 2002-07-16 | AABA-DELISTED | Stock | 6.42999982833862 | 7.16499996185303 | 6.40999984741211 | 6.88000011444092 | 34376200.0 |
| 2002-07-16 | AAI-DELISTED | Stock | 3.85 | 4.04 | 3.76 | 3.8 | 1435100.0 |
| 2002-07-16 | AAIC-DELISTED | Stock | 211.0 | 215.8 | 208.2 | 214.8 | 81200.0 |
| 2002-07-16 | AAME | Stock | 2.2 | 2.2 | 2.2 | 2.2 | 2500.0 |
| 2002-07-16 | AAON | Stock | 2.2466 | 2.2466 | 2.057 | 2.2189 | 357666.0 |
| 2002-07-16 | AAP | Stock | 15.3333 | 15.3367 | 14.6667 | 14.9667 | 1597500.0 |
| 2002-07-16 | AAXN-DELISTED | Stock | 0.849166691303253 | 0.850000023841858 | 0.741666674613953 | 0.75 | 1128000.0 |
| 2002-07-16 | ABAX-DELISTED | Stock | 3.89 | 4.0 | 3.7 | 4.0 | 22000.0 |
| 2002-07-16 | ABB-DELISTED | Stock | 8.64 | 8.7 | 8.61 | 8.63 | 1900.0 |
| 2002-07-16 | ABC-DELISTED | Stock | 15.5 | 16.1 | 15.29 | 15.72 | 8854867.0 |
| 2002-07-16 | ABCB | Stock | 11.4366 | 11.9473 | 11.4366 | 11.7933 | 15915.0 |
| 2002-07-16 | ABCO-DELISTED | Stock | 14.33 | 14.685 | 14.0 | 14.145 | 264000.0 |
| 2002-07-16 | ABCW-DELISTED | Stock | 20.55 | 21.0 | 20.4 | 20.44 | 53600.0 |
| 2002-07-16 | ABE-DELISTED | Stock | 6.54 | 6.64 | 6.52 | 6.64 | 9800.0 |
| 2002-07-16 | ABFS-DELISTED | Stock | 22.05 | 22.35 | 21.7 | 22.15 | 248300.0 |
| 2002-07-16 | ABG | Stock | 12.75 | 12.8 | 12.5 | 12.6 | 65200.0 |
| 2002-07-16 | ABK-DELISTED | Stock | 61.75 | 62.15 | 59.5 | 59.81 | 1015100.0 |
| 2002-07-16 | ABM | Stock | 16.1 | 16.2 | 15.74 | 15.79 | 113100.0 |
| 2002-07-16 | ABMD-DELISTED | Stock | 6.51 | 6.7 | 6.11 | 6.4 | 36200.0 |
| 2002-07-16 | ABP-DELISTED | Stock | 0.59 | 0.67 | 0.58 | 0.59 | 52800.0 |
| 2002-07-16 | ABT | Stock | 15.4646 | 16.0796 | 15.0382 | 15.0831 | 13126060.0 |
| 2002-07-16 | ABTL-DELISTED | Stock | 10.0 | 12.65 | 9.75 | 12.0 | 10500.0 |
| 2002-07-16 | ABV-DELISTED | Stock | 15.45 | 15.7 | 15.34 | 15.39 | 656500.0 |
| 2002-07-16 | ABVA-DELISTED | Stock | 8.1 | 8.1 | 8.0 | 8.1 | 1400.0 |
| 2002-07-16 | ABX-DELISTED | Stock | 17.39 | 17.68 | 17.28 | 17.47 | 5072416.0 |
| 2002-07-16 | ACAP-DELISTED | Stock | 16.93 | 17.25 | 16.63 | 16.96 | 22800.0 |
| 2002-07-16 | ACAS-DELISTED | Stock | 26.39 | 26.68 | 26.05 | 26.3 | 332500.0 |
| 2002-07-16 | ACAT-DELISTED | Stock | 16.6 | 17.1 | 15.99 | 16.11 | 45200.0 |
| 2002-07-16 | ACCL-DELISTED | Stock | 5.8600001335144 | 5.86499977111816 | 5.43100023269653 | 5.61199998855591 | 171700.0 |
| 2002-07-16 | ACE-DELISTED | Stock | 28.95 | 29.16 | 28.35 | 28.63 | 2138000.0 |
| 2002-07-16 | ACF-DELISTED | Stock | 20.9 | 21.06 | 19.9 | 20.04 | 1997900.0 |
| 2002-07-16 | ACG-DELISTED | Stock | 8.0 | 8.06 | 7.97 | 7.99 | 426700.0 |
| 2002-07-16 | ACGL | Stock | 2.6778 | 2.8889 | 2.63 | 2.8433 | 811800.0 |
| 2002-07-16 | ACGN-DELISTED | Stock | 1156.0 | 1235.3288 | 1156.0 | 1190.0 | 24000.0 |
| 2002-07-16 | ACH | Stock | 11.6333 | 12.1867 | 11.5333 | 11.7333 | 209400.0 |
| 2002-07-16 | ACH-DELISTED | Stock | 4.35 | 4.375 | 4.35 | 4.37 | 6000.0 |
| 2002-07-16 | ACLS | Stock | 42.44 | 44.88 | 41.12 | 41.24 | 262000.0 |
| 2002-07-16 | ACO-DELISTED | Stock | 6.07 | 6.07 | 5.85 | 5.95 | 23300.0 |
| 2002-07-16 | ACPW-DELISTED | Stock | 11.5 | 11.75 | 10.505 | 11.25 | 62440.0 |
| 2002-07-16 | ACS-DELISTED | Stock | 44.1 | 44.62 | 43.42 | 44.48 | 795700.0 |
| 2002-07-16 | ACTA-DELISTED | Stock | 4.6 | 5.8 | 4.6 | 5.0 | 56500.0 |
| 2002-07-16 | ACTT-DELISTED | Stock | 3.05 | 3.1 | 2.91 | 2.91 | 39600.0 |
| 2002-07-16 | ACTU-DELISTED | Stock | 3.16 | 3.82 | 3.16 | 3.5 | 589000.0 |
| 2002-07-16 | ACXM-DELISTED | Stock | 15.13 | 15.97 | 15.086 | 15.91 | 406000.0 |
> showing 50 of 3,166 rows — these rows as CSV