PREVIEW / stock_daily / 2001-09-24
file: by_date/stock_daily/2001/2001-09-24.parquet size: 100 KB rows: 3,025 symbols: 1,886
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-09-24 | AAPL | Stock | 0.2877 | 0.3007 | 0.2848 | 0.2938 | 294537600.0 |
| 2001-09-24 | MSFT | Stock | 25.325 | 26.225 | 24.935 | 26.005 | 85580200.0 |
| 2001-09-24 | NVDA | Stock | 0.2426 | 0.2537 | 0.2318 | 0.25 | 1507500000.0 |
| 2001-09-24 | AMZN | Stock | 0.385 | 0.3915 | 0.367 | 0.373 | 102054000.0 |
| 2001-09-24 | CL | Stock | 26.625 | 27.36 | 26.625 | 27.265 | 3235800.0 |
| 2001-09-24 | A | Stock | 14.6638 | 15.515 | 14.4492 | 15.0215 | 2779643.0 |
| 2001-09-24 | AABA-DELISTED | Stock | 4.54500007629395 | 4.73000001907349 | 4.40999984741211 | 4.625 | 15538800.0 |
| 2001-09-24 | AAI-DELISTED | Stock | 3.3 | 3.48 | 3.14 | 3.14 | 1061200.0 |
| 2001-09-24 | AAIC-DELISTED | Stock | 105.2 | 108.0 | 92.0 | 92.2 | 70800.0 |
| 2001-09-24 | AAME | Stock | 1.2 | 1.27 | 0.75 | 1.27 | 10200.0 |
| 2001-09-24 | AAON | Stock | 1.5855 | 1.7119 | 1.5855 | 1.6914 | 527955.0 |
| 2001-09-24 | AAXN-DELISTED | Stock | 0.587499976158142 | 0.641666650772095 | 0.587499976158142 | 0.633333325386047 | 262800.0 |
| 2001-09-24 | ABAX-DELISTED | Stock | 3.75 | 4.0 | 3.55 | 3.8 | 17100.0 |
| 2001-09-24 | ABB-DELISTED | Stock | 6.67 | 7.4 | 6.62 | 7.15 | 40500.0 |
| 2001-09-24 | ABC-DELISTED | Stock | 16.5 | 16.7 | 16.4 | 16.51 | 4699200.0 |
| 2001-09-24 | ABCW-DELISTED | Stock | 16.15 | 16.94 | 16.15 | 16.65 | 156900.0 |
| 2001-09-24 | ABE-DELISTED | Stock | 6.0 | 6.25 | 6.0 | 6.15 | 44100.0 |
| 2001-09-24 | ABFS-DELISTED | Stock | 19.32 | 21.6 | 19.32 | 20.15 | 134100.0 |
| 2001-09-24 | ABK-DELISTED | Stock | 47.25 | 49.8 | 47.25 | 49.15 | 704700.0 |
| 2001-09-24 | ABM | Stock | 12.725 | 13.175 | 12.725 | 13.0 | 256000.0 |
| 2001-09-24 | ABMD-DELISTED | Stock | 13.0 | 13.97 | 12.8 | 13.29 | 115200.0 |
| 2001-09-24 | ABP-DELISTED | Stock | 2.09 | 2.09 | 1.8 | 1.93 | 138400.0 |
| 2001-09-24 | ABT | Stock | 21.4799 | 21.5248 | 20.8066 | 21.2106 | 8397845.0 |
| 2001-09-24 | ABTL-DELISTED | Stock | 4.2 | 4.75 | 3.9 | 3.9 | 17800.0 |
| 2001-09-24 | ABV-DELISTED | Stock | 15.38 | 15.55 | 14.9 | 15.24 | 323000.0 |
| 2001-09-24 | ABX-DELISTED | Stock | 16.8 | 16.85 | 16.46 | 16.69 | 1793700.0 |
| 2001-09-24 | ACAP-DELISTED | Stock | 18.86 | 19.76 | 18.86 | 19.76 | 17700.0 |
| 2001-09-24 | ACAS-DELISTED | Stock | 26.12 | 26.8 | 26.02 | 26.33 | 108200.0 |
| 2001-09-24 | ACAT-DELISTED | Stock | 13.55 | 13.99 | 13.15 | 13.55 | 119300.0 |
| 2001-09-24 | ACCL-DELISTED | Stock | 8.10933971405029 | 8.64517974853516 | 8.10933971405029 | 8.64517974853516 | 336000.0 |
| 2001-09-24 | ACE-DELISTED | Stock | 22.25 | 24.6 | 21.65 | 23.8 | 3421900.0 |
| 2001-09-24 | ACF-DELISTED | Stock | 30.0 | 30.85 | 29.7 | 29.87 | 1410800.0 |
| 2001-09-24 | ACG-DELISTED | Stock | 8.25 | 8.49 | 8.15 | 8.42 | 360200.0 |
| 2001-09-24 | ACGL | Stock | 1.8078 | 1.8889 | 1.7944 | 1.8056 | 387900.0 |
| 2001-09-24 | ACGN-DELISTED | Stock | 1156.0 | 1156.0 | 918.0 | 1133.3288 | 7500.0 |
| 2001-09-24 | ACH | Stock | 11.6667 | 11.96 | 11.6667 | 11.9 | 77550.0 |
| 2001-09-24 | ACLS | Stock | 37.6 | 39.84 | 37.4 | 39.0 | 163775.0 |
| 2001-09-24 | ACO-DELISTED | Stock | 5.7 | 5.7 | 5.6 | 5.7 | 1800.0 |
| 2001-09-24 | ACPW-DELISTED | Stock | 24.95 | 27.25 | 24.15 | 26.0 | 109300.0 |
| 2001-09-24 | ACS-DELISTED | Stock | 42.5 | 42.55 | 41.655 | 41.695 | 651100.0 |
| 2001-09-24 | ACTA-DELISTED | Stock | 9.6 | 10.6 | 9.4 | 10.0 | 76700.0 |
| 2001-09-24 | ACTT-DELISTED | Stock | 7.3 | 8.36 | 7.05 | 8.2 | 264100.0 |
| 2001-09-24 | ACTU-DELISTED | Stock | 4.15 | 4.46 | 4.05 | 4.3 | 545100.0 |
| 2001-09-24 | ACXM-DELISTED | Stock | 8.4 | 8.88 | 8.17 | 8.79 | 1115643.0 |
| 2001-09-24 | ACY-DELISTED | Stock | 5.87 | 5.87 | 5.6 | 5.65 | 2500.0 |
| 2001-09-24 | AD | Stock | 32.3333 | 33.3 | 32.3333 | 32.92 | 171150.0 |
| 2001-09-24 | ADAT-DELISTED | Stock | 57.6 | 71.1 | 53.1 | 71.1 | 2294.0 |
| 2001-09-24 | ADBE | Stock | 13.0 | 13.0 | 12.31 | 12.645 | 13773600.0 |
| 2001-09-24 | ADC | Stock | 17.45 | 17.88 | 17.4 | 17.8 | 12600.0 |
| 2001-09-24 | ADEP-DELISTED | Stock | 20.05 | 23.0 | 20.0 | 20.75 | 9500.0 |
> showing 50 of 3,025 rows — these rows as CSV