PREVIEW / stock_daily / 2001-07-03
file: by_date/stock_daily/2001/2001-07-03.parquet size: 98 KB rows: 2,868 symbols: 1,769
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-03 | AAPL | Stock | 0.4198 | 0.4318 | 0.4196 | 0.4257 | 112543200.0 |
| 2001-07-03 | MSFT | Stock | 35.15 | 35.4 | 34.965 | 35.235 | 28037400.0 |
| 2001-07-03 | NVDA | Stock | 0.3668 | 0.3779 | 0.3649 | 0.374 | 406296000.0 |
| 2001-07-03 | AMZN | Stock | 0.7245 | 0.725 | 0.7 | 0.7065 | 54022000.0 |
| 2001-07-03 | CL | Stock | 30.0 | 30.225 | 29.69 | 30.125 | 1415000.0 |
| 2001-07-03 | A | Stock | 23.7482 | 23.7482 | 23.1187 | 23.2618 | 938897.0 |
| 2001-07-03 | AABA-DELISTED | Stock | 9.88000011444092 | 10.0749998092651 | 9.85000038146973 | 9.90499973297119 | 7351400.0 |
| 2001-07-03 | AAI-DELISTED | Stock | 9.6 | 10.09 | 9.52 | 9.95 | 177300.0 |
| 2001-07-03 | AAIC-DELISTED | Stock | 138.0 | 138.6 | 133.0 | 134.0 | 35200.0 |
| 2001-07-03 | AAON | Stock | 1.4813 | 1.5094 | 1.4749 | 1.5071 | 153773.0 |
| 2001-07-03 | AAXN-DELISTED | Stock | 0.529166638851166 | 0.529166638851166 | 0.529166638851166 | 0.529166638851166 | 12000.0 |
| 2001-07-03 | ABAX-DELISTED | Stock | 5.08 | 5.6 | 5.01 | 5.6 | 28500.0 |
| 2001-07-03 | ABB-DELISTED | Stock | 15.3 | 15.34 | 15.3 | 15.34 | 9400.0 |
| 2001-07-03 | ABC-DELISTED | Stock | 13.9875001907349 | 14.1400003433228 | 13.7449998855591 | 14.0974998474121 | 1681200.0 |
| 2001-07-03 | ABCB | Stock | 8.997 | 8.997 | 8.997 | 8.997 | 1358.0 |
| 2001-07-03 | ABCW-DELISTED | Stock | 15.35 | 15.49 | 15.35 | 15.39 | 5900.0 |
| 2001-07-03 | ABE-DELISTED | Stock | 8.08 | 8.1 | 8.05 | 8.09 | 9500.0 |
| 2001-07-03 | ABFS-DELISTED | Stock | 22.89 | 23.0 | 22.4 | 22.81 | 52400.0 |
| 2001-07-03 | ABK-DELISTED | Stock | 59.2 | 59.95 | 59.09 | 59.57 | 267600.0 |
| 2001-07-03 | ABM | Stock | 18.4 | 18.55 | 18.275 | 18.39 | 100600.0 |
| 2001-07-03 | ABMD-DELISTED | Stock | 25.57 | 27.43 | 25.4 | 26.5 | 901000.0 |
| 2001-07-03 | ABP-DELISTED | Stock | 3.2 | 3.2 | 3.07 | 3.1 | 37500.0 |
| 2001-07-03 | ABT | Stock | 22.2296 | 22.2296 | 21.8615 | 22.1173 | 3538198.0 |
| 2001-07-03 | ABTL-DELISTED | Stock | 7.3 | 7.75 | 7.25 | 7.75 | 10000.0 |
| 2001-07-03 | ABV-DELISTED | Stock | 23.0 | 23.0 | 22.3 | 22.42 | 25200.0 |
| 2001-07-03 | ABX-DELISTED | Stock | 14.53 | 14.96 | 14.52 | 14.82 | 3535762.0 |
| 2001-07-03 | ACAP-DELISTED | Stock | 19.8 | 20.25 | 19.79 | 19.94 | 65700.0 |
| 2001-07-03 | ACAS-DELISTED | Stock | 27.11 | 27.12 | 26.6 | 26.92 | 122300.0 |
| 2001-07-03 | ACAT-DELISTED | Stock | 15.02 | 15.15 | 14.95 | 15.01 | 45800.0 |
| 2001-07-03 | ACCL-DELISTED | Stock | 14.5104999542236 | 14.8001003265381 | 14.5104999542236 | 14.8001003265381 | 68400.0 |
| 2001-07-03 | ACE-DELISTED | Stock | 38.8 | 38.85 | 38.35 | 38.68 | 134500.0 |
| 2001-07-03 | ACF-DELISTED | Stock | 53.18 | 53.2 | 52.58 | 52.64 | 158700.0 |
| 2001-07-03 | ACG-DELISTED | Stock | 8.7 | 8.72 | 8.63 | 8.64 | 219200.0 |
| 2001-07-03 | ACGL | Stock | 1.8722 | 1.8722 | 1.8611 | 1.8722 | 112500.0 |
| 2001-07-03 | ACGN-DELISTED | Stock | 1337.3288 | 1337.3288 | 1303.3288 | 1303.3288 | 4300.0 |
| 2001-07-03 | ACH | Stock | 12.4867 | 12.7867 | 12.3933 | 12.4333 | 77100.0 |
| 2001-07-03 | ACLS | Stock | 57.0 | 57.0 | 53.04 | 53.6 | 230975.0 |
| 2001-07-03 | ACO-DELISTED | Stock | 5.61 | 5.95 | 5.55 | 5.8 | 18500.0 |
| 2001-07-03 | ACPW-DELISTED | Stock | 80.57 | 81.68 | 79.27 | 80.83 | 31375.0 |
| 2001-07-03 | ACS-DELISTED | Stock | 36.2 | 36.2 | 35.1 | 35.48 | 224800.0 |
| 2001-07-03 | ACTA-DELISTED | Stock | 41.2 | 41.4 | 39.6 | 40.4 | 20900.0 |
| 2001-07-03 | ACTT-DELISTED | Stock | 6.5 | 6.58 | 6.45 | 6.45 | 1500.0 |
| 2001-07-03 | ACTU-DELISTED | Stock | 8.16 | 8.16 | 7.5 | 7.68 | 276600.0 |
| 2001-07-03 | ACXM-DELISTED | Stock | 12.43 | 12.48 | 11.95 | 12.03 | 1189400.0 |
| 2001-07-03 | ACY-DELISTED | Stock | 5.0 | 5.1 | 5.0 | 5.1 | 2400.0 |
| 2001-07-03 | AD | Stock | 38.1333 | 38.6 | 37.9 | 38.5333 | 120150.0 |
| 2001-07-03 | ADAT-DELISTED | Stock | 83.34 | 84.24 | 82.98 | 84.24 | 735.0 |
| 2001-07-03 | ADBE | Stock | 23.05 | 23.075 | 22.5 | 22.65 | 5517200.0 |
| 2001-07-03 | ADC | Stock | 18.82 | 18.82 | 18.75 | 18.79 | 1300.0 |
| 2001-07-03 | ADEP-DELISTED | Stock | 48.5 | 49.5 | 47.25 | 47.55 | 13800.0 |
> showing 50 of 2,868 rows — these rows as CSV