PREVIEW / stock_daily / 2001-09-05
file: by_date/stock_daily/2001/2001-09-05.parquet size: 102 KB rows: 2,983 symbols: 1,855
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-05 | AAPL | Stock | 0.3257 | 0.3384 | 0.3236 | 0.3313 | 360057600.0 |
| 2001-09-05 | MSFT | Stock | 28.09 | 29.195 | 27.695 | 28.87 | 89470600.0 |
| 2001-09-05 | NVDA | Stock | 0.3281 | 0.3379 | 0.3148 | 0.3354 | 2395584000.0 |
| 2001-09-05 | AMZN | Stock | 0.433 | 0.434 | 0.3425 | 0.3825 | 421468000.0 |
| 2001-09-05 | CL | Stock | 27.4 | 28.1 | 27.005 | 27.865 | 6285400.0 |
| 2001-09-05 | A | Stock | 18.133 | 18.4406 | 17.3534 | 17.5966 | 4119067.0 |
| 2001-09-05 | AABA-DELISTED | Stock | 5.84499979019165 | 5.84499979019165 | 5.22499990463257 | 5.32000017166138 | 24114600.0 |
| 2001-09-05 | AAI-DELISTED | Stock | 6.52 | 6.63 | 6.05 | 6.22 | 343400.0 |
| 2001-09-05 | AAIC-DELISTED | Stock | 133.0 | 136.0 | 128.0 | 132.0 | 59100.0 |
| 2001-09-05 | AAON | Stock | 1.7974 | 1.8202 | 1.7974 | 1.8144 | 432274.0 |
| 2001-09-05 | AAXN-DELISTED | Stock | 0.758333325386047 | 0.762499988079071 | 0.737500011920929 | 0.753333330154419 | 350400.0 |
| 2001-09-05 | ABAX-DELISTED | Stock | 4.75 | 4.8 | 4.7 | 4.74 | 14600.0 |
| 2001-09-05 | ABB-DELISTED | Stock | 9.98 | 10.0 | 9.81 | 9.96 | 3100.0 |
| 2001-09-05 | ABC-DELISTED | Stock | 16.34 | 16.6 | 16.17 | 16.37 | 7131200.0 |
| 2001-09-05 | ABCB | Stock | 10.5856 | 10.5856 | 10.5856 | 10.5856 | 370.0 |
| 2001-09-05 | ABCW-DELISTED | Stock | 18.41 | 18.49 | 17.94 | 17.94 | 164300.0 |
| 2001-09-05 | ABE-DELISTED | Stock | 7.07 | 7.07 | 7.03 | 7.04 | 19400.0 |
| 2001-09-05 | ABFS-DELISTED | Stock | 26.95 | 26.95 | 24.79 | 25.23 | 159800.0 |
| 2001-09-05 | ABK-DELISTED | Stock | 59.0 | 59.01 | 58.12 | 58.25 | 704000.0 |
| 2001-09-05 | ABM | Stock | 17.375 | 17.4 | 17.05 | 17.155 | 91600.0 |
| 2001-09-05 | ABMD-DELISTED | Stock | 18.39 | 18.6 | 17.48 | 17.6 | 51700.0 |
| 2001-09-05 | ABP-DELISTED | Stock | 2.26 | 2.36 | 2.04 | 2.05 | 79800.0 |
| 2001-09-05 | ABT | Stock | 22.6022 | 23.289 | 22.5258 | 23.1768 | 8058572.0 |
| 2001-09-05 | ABTL-DELISTED | Stock | 4.85 | 5.0 | 4.75 | 4.95 | 22600.0 |
| 2001-09-05 | ABV-DELISTED | Stock | 19.01 | 19.34 | 18.98 | 19.3 | 145900.0 |
| 2001-09-05 | ABX-DELISTED | Stock | 15.51 | 15.86 | 15.51 | 15.83 | 1858621.0 |
| 2001-09-05 | ACAP-DELISTED | Stock | 22.15 | 22.45 | 21.61 | 22.3 | 174300.0 |
| 2001-09-05 | ACAS-DELISTED | Stock | 29.24 | 29.5 | 28.46 | 29.47 | 208000.0 |
| 2001-09-05 | ACAT-DELISTED | Stock | 15.0 | 15.62 | 15.0 | 15.45 | 105800.0 |
| 2001-09-05 | ACCL-DELISTED | Stock | 11.9499998092651 | 12.1579999923706 | 11.7159996032715 | 12.1579999923706 | 188400.0 |
| 2001-09-05 | ACE-DELISTED | Stock | 33.52 | 34.2 | 33.21 | 33.95 | 875500.0 |
| 2001-09-05 | ACF-DELISTED | Stock | 45.35 | 45.5 | 43.2 | 44.56 | 1939600.0 |
| 2001-09-05 | ACG-DELISTED | Stock | 8.83 | 8.86 | 8.76 | 8.81 | 246300.0 |
| 2001-09-05 | ACGL | Stock | 1.9722 | 2.0267 | 1.9711 | 2.0267 | 155700.0 |
| 2001-09-05 | ACGN-DELISTED | Stock | 1246.6712 | 1360.0 | 1133.3288 | 1258.0 | 16300.0 |
| 2001-09-05 | ACH | Stock | 13.4 | 13.6667 | 13.0 | 13.6667 | 548100.0 |
| 2001-09-05 | ACLS | Stock | 55.64 | 57.0 | 53.2 | 56.04 | 229150.0 |
| 2001-09-05 | ACO-DELISTED | Stock | 5.86 | 5.86 | 5.55 | 5.77 | 9100.0 |
| 2001-09-05 | ACPW-DELISTED | Stock | 30.25 | 31.75 | 28.75 | 30.05 | 47380.0 |
| 2001-09-05 | ACS-DELISTED | Stock | 41.205 | 41.205 | 40.235 | 40.405 | 481400.0 |
| 2001-09-05 | ACTA-DELISTED | Stock | 14.6 | 14.6 | 12.0 | 13.0 | 60000.0 |
| 2001-09-05 | ACTT-DELISTED | Stock | 6.17 | 6.17 | 5.0 | 5.3 | 15200.0 |
| 2001-09-05 | ACTU-DELISTED | Stock | 6.84 | 7.0 | 6.5 | 6.51 | 469500.0 |
| 2001-09-05 | ACXM-DELISTED | Stock | 13.25 | 13.29 | 12.76 | 12.9 | 306800.0 |
| 2001-09-05 | ACY-DELISTED | Stock | 5.77 | 5.77 | 5.7 | 5.7 | 200.0 |
| 2001-09-05 | AD | Stock | 32.5 | 33.2667 | 32.0 | 32.6333 | 488700.0 |
| 2001-09-05 | ADAT-DELISTED | Stock | 69.3 | 70.2 | 63.0 | 68.4 | 1809.0 |
| 2001-09-05 | ADBE | Stock | 16.095 | 16.675 | 15.5 | 16.1 | 7284400.0 |
| 2001-09-05 | ADC | Stock | 18.7 | 18.95 | 18.61 | 18.93 | 7800.0 |
| 2001-09-05 | ADEP-DELISTED | Stock | 26.8 | 27.75 | 24.55 | 25.95 | 158800.0 |
> showing 50 of 2,983 rows — these rows as CSV