PREVIEW / stock_daily / 2001-08-06
file: by_date/stock_daily/2001/2001-08-06.parquet size: 100 KB rows: 2,942 symbols: 1,822
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-08-06 | AAPL | Stock | 0.34 | 0.3511 | 0.3393 | 0.3416 | 99652000.0 |
| 2001-08-06 | MSFT | Stock | 33.265 | 33.56 | 32.84 | 33.065 | 27831600.0 |
| 2001-08-06 | NVDA | Stock | 0.3607 | 0.378 | 0.3568 | 0.3743 | 1292568000.0 |
| 2001-08-06 | AMZN | Stock | 0.609 | 0.61 | 0.5925 | 0.595 | 53236000.0 |
| 2001-08-06 | CL | Stock | 26.55 | 26.65 | 26.14 | 26.44 | 2573800.0 |
| 2001-08-06 | A | Stock | 22.3963 | 22.5179 | 21.824 | 22.0458 | 1707797.0 |
| 2001-08-06 | AABA-DELISTED | Stock | 8.875 | 8.92000007629395 | 8.63000011444092 | 8.69499969482422 | 7260600.0 |
| 2001-08-06 | AAI-DELISTED | Stock | 8.51 | 8.65 | 8.35 | 8.36 | 151800.0 |
| 2001-08-06 | AAIC-DELISTED | Stock | 128.0 | 131.0 | 128.0 | 130.0 | 7500.0 |
| 2001-08-06 | AAME | Stock | 2.3 | 2.31 | 1.55 | 1.7 | 21600.0 |
| 2001-08-06 | AAON | Stock | 1.7705 | 1.8348 | 1.75 | 1.7617 | 430566.0 |
| 2001-08-06 | AAXN-DELISTED | Stock | 0.509166657924652 | 0.516666650772095 | 0.5 | 0.516666650772095 | 76800.0 |
| 2001-08-06 | ABAX-DELISTED | Stock | 5.33 | 5.4 | 5.2 | 5.2 | 18500.0 |
| 2001-08-06 | ABB-DELISTED | Stock | 11.25 | 11.45 | 11.2 | 11.4 | 21600.0 |
| 2001-08-06 | ABC-DELISTED | Stock | 14.2375001907349 | 14.5749998092651 | 14.0349998474121 | 14.2550001144409 | 2010000.0 |
| 2001-08-06 | ABCB | Stock | 10.7396 | 10.7396 | 10.5208 | 10.537 | 19493.0 |
| 2001-08-06 | ABCW-DELISTED | Stock | 16.4 | 16.46 | 16.0 | 16.4 | 24800.0 |
| 2001-08-06 | ABE-DELISTED | Stock | 7.61 | 7.7 | 7.6 | 7.64 | 17500.0 |
| 2001-08-06 | ABFS-DELISTED | Stock | 26.25 | 26.55 | 25.81 | 26.25 | 198600.0 |
| 2001-08-06 | ABK-DELISTED | Stock | 58.28 | 58.4 | 56.88 | 57.09 | 389300.0 |
| 2001-08-06 | ABM | Stock | 18.32 | 18.35 | 17.495 | 17.945 | 153200.0 |
| 2001-08-06 | ABMD-DELISTED | Stock | 19.39 | 19.5 | 18.75 | 18.81 | 75700.0 |
| 2001-08-06 | ABP-DELISTED | Stock | 3.39 | 3.39 | 3.1 | 3.21 | 35800.0 |
| 2001-08-06 | ABT | Stock | 23.5583 | 23.5673 | 23.0511 | 23.2127 | 5601237.0 |
| 2001-08-06 | ABTL-DELISTED | Stock | 4.75 | 4.95 | 4.6 | 4.95 | 22300.0 |
| 2001-08-06 | ABV-DELISTED | Stock | 20.3 | 20.6 | 20.3 | 20.5 | 178900.0 |
| 2001-08-06 | ABX-DELISTED | Stock | 14.6 | 14.87 | 14.49 | 14.84 | 1496770.0 |
| 2001-08-06 | ACAP-DELISTED | Stock | 21.5 | 22.29 | 21.45 | 21.45 | 17800.0 |
| 2001-08-06 | ACAS-DELISTED | Stock | 27.99 | 27.99 | 27.54 | 27.68 | 103100.0 |
| 2001-08-06 | ACAT-DELISTED | Stock | 14.97 | 14.98 | 14.66 | 14.95 | 3100.0 |
| 2001-08-06 | ACCL-DELISTED | Stock | 12.078200340271 | 12.2012996673584 | 12.0268001556396 | 12.2012996673584 | 206700.0 |
| 2001-08-06 | ACE-DELISTED | Stock | 34.5 | 34.99 | 34.05 | 34.86 | 485700.0 |
| 2001-08-06 | ACF-DELISTED | Stock | 63.35 | 63.36 | 59.75 | 60.05 | 907200.0 |
| 2001-08-06 | ACG-DELISTED | Stock | 8.77 | 8.78 | 8.72 | 8.75 | 186400.0 |
| 2001-08-06 | ACGL | Stock | 1.9667 | 1.9667 | 1.9044 | 1.9044 | 27900.0 |
| 2001-08-06 | ACGN-DELISTED | Stock | 1076.6712 | 1088.0 | 963.3288 | 969.0 | 152800.0 |
| 2001-08-06 | ACH | Stock | 12.2667 | 12.4533 | 11.6667 | 11.6667 | 84600.0 |
| 2001-08-06 | ACLS | Stock | 59.88 | 60.16 | 57.84 | 59.52 | 105400.0 |
| 2001-08-06 | ACO-DELISTED | Stock | 6.25 | 6.25 | 6.1 | 6.2 | 61500.0 |
| 2001-08-06 | ACPW-DELISTED | Stock | 43.0 | 43.0 | 38.75 | 39.15 | 66460.0 |
| 2001-08-06 | ACS-DELISTED | Stock | 40.25 | 40.25 | 38.915 | 39.405 | 956800.0 |
| 2001-08-06 | ACTA-DELISTED | Stock | 29.4 | 30.6 | 29.0 | 30.4 | 25500.0 |
| 2001-08-06 | ACTT-DELISTED | Stock | 5.59 | 5.9 | 5.45 | 5.69 | 5800.0 |
| 2001-08-06 | ACTU-DELISTED | Stock | 10.15 | 10.35 | 9.9 | 9.9 | 423200.0 |
| 2001-08-06 | ACXM-DELISTED | Stock | 11.09 | 11.16 | 10.88 | 10.95 | 363000.0 |
| 2001-08-06 | ACY-DELISTED | Stock | 5.3 | 5.44 | 5.3 | 5.44 | 1300.0 |
| 2001-08-06 | AD | Stock | 38.6667 | 38.6667 | 37.7667 | 37.8 | 61950.0 |
| 2001-08-06 | ADAT-DELISTED | Stock | 81.18 | 86.22 | 81.18 | 86.22 | 151.0 |
| 2001-08-06 | ADBE | Stock | 18.77 | 18.925 | 18.265 | 18.38 | 5311000.0 |
| 2001-08-06 | ADC | Stock | 19.28 | 19.66 | 19.26 | 19.66 | 3100.0 |
> showing 50 of 2,942 rows — these rows as CSV