PREVIEW / stock_daily / 2001-08-20
file: by_date/stock_daily/2001/2001-08-20.parquet size: 101 KB rows: 2,967 symbols: 1,837
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-20 | AAPL | Stock | 0.3239 | 0.3255 | 0.318 | 0.3236 | 252302400.0 |
| 2001-08-20 | MSFT | Stock | 30.83 | 31.375 | 30.55 | 31.35 | 48371200.0 |
| 2001-08-20 | NVDA | Stock | 0.3468 | 0.3504 | 0.336 | 0.3466 | 1183320000.0 |
| 2001-08-20 | AMZN | Stock | 0.5095 | 0.5205 | 0.4975 | 0.52 | 72280000.0 |
| 2001-08-20 | CL | Stock | 27.515 | 27.825 | 27.45 | 27.725 | 1941400.0 |
| 2001-08-20 | A | Stock | 18.6695 | 18.8555 | 18.0901 | 18.6624 | 2238058.0 |
| 2001-08-20 | AABA-DELISTED | Stock | 7.01999998092651 | 7.3899998664856 | 6.875 | 7.23000001907349 | 9762600.0 |
| 2001-08-20 | AAI-DELISTED | Stock | 7.8 | 7.95 | 7.68 | 7.7 | 311700.0 |
| 2001-08-20 | AAIC-DELISTED | Stock | 127.0 | 132.0 | 126.0 | 130.0 | 23300.0 |
| 2001-08-20 | AAME | Stock | 1.5 | 1.5 | 1.35 | 1.35 | 1600.0 |
| 2001-08-20 | AAON | Stock | 1.7705 | 1.7705 | 1.7119 | 1.7623 | 107641.0 |
| 2001-08-20 | AAXN-DELISTED | Stock | 0.670833349227905 | 0.679166674613953 | 0.612500011920929 | 0.629166662693024 | 378000.0 |
| 2001-08-20 | ABAX-DELISTED | Stock | 5.13 | 5.26 | 5.13 | 5.25 | 14600.0 |
| 2001-08-20 | ABB-DELISTED | Stock | 10.93 | 11.15 | 10.79 | 11.13 | 31000.0 |
| 2001-08-20 | ABC-DELISTED | Stock | 14.625 | 14.7950000762939 | 14.5500001907349 | 14.7124996185303 | 3220400.0 |
| 2001-08-20 | ABCB | Stock | 10.4721 | 10.618 | 10.4721 | 10.5532 | 93765.0 |
| 2001-08-20 | ABCW-DELISTED | Stock | 17.41 | 17.55 | 17.24 | 17.52 | 26100.0 |
| 2001-08-20 | ABE-DELISTED | Stock | 7.3 | 7.35 | 7.26 | 7.26 | 9100.0 |
| 2001-08-20 | ABFS-DELISTED | Stock | 26.0 | 26.42 | 25.79 | 26.3 | 245300.0 |
| 2001-08-20 | ABK-DELISTED | Stock | 59.35 | 60.44 | 59.25 | 60.42 | 356500.0 |
| 2001-08-20 | ABM | Stock | 18.1 | 18.3 | 18.085 | 18.235 | 64200.0 |
| 2001-08-20 | ABMD-DELISTED | Stock | 16.68 | 18.31 | 16.66 | 18.1 | 202200.0 |
| 2001-08-20 | ABP-DELISTED | Stock | 3.37 | 3.39 | 3.23 | 3.23 | 5800.0 |
| 2001-08-20 | ABT | Stock | 23.4551 | 23.9264 | 23.4326 | 23.7873 | 6001102.0 |
| 2001-08-20 | ABTL-DELISTED | Stock | 4.35 | 4.35 | 3.9 | 3.95 | 8400.0 |
| 2001-08-20 | ABV-DELISTED | Stock | 19.8 | 20.0 | 19.65 | 19.79 | 124300.0 |
| 2001-08-20 | ABX-DELISTED | Stock | 16.55 | 16.64 | 16.4 | 16.55 | 1800600.0 |
| 2001-08-20 | ACAP-DELISTED | Stock | 22.3 | 22.38 | 22.0 | 22.18 | 50600.0 |
| 2001-08-20 | ACAS-DELISTED | Stock | 27.69 | 28.29 | 27.68 | 28.28 | 219300.0 |
| 2001-08-20 | ACAT-DELISTED | Stock | 16.0 | 16.1 | 15.97 | 16.0 | 71400.0 |
| 2001-08-20 | ACCL-DELISTED | Stock | 12.5634002685547 | 12.8899002075195 | 12.5634002685547 | 12.8899002075195 | 331700.0 |
| 2001-08-20 | ACE-DELISTED | Stock | 35.6 | 35.6 | 35.1 | 35.3 | 1090700.0 |
| 2001-08-20 | ACF-DELISTED | Stock | 52.0 | 53.35 | 51.11 | 52.45 | 2419600.0 |
| 2001-08-20 | ACG-DELISTED | Stock | 8.75 | 8.78 | 8.67 | 8.78 | 239000.0 |
| 2001-08-20 | ACGL | Stock | 1.9078 | 1.9556 | 1.9078 | 1.9556 | 17100.0 |
| 2001-08-20 | ACGN-DELISTED | Stock | 1042.6712 | 1144.6712 | 1008.6712 | 1008.6712 | 69700.0 |
| 2001-08-20 | ACH | Stock | 12.3333 | 12.6667 | 12.3333 | 12.5267 | 96600.0 |
| 2001-08-20 | ACLS | Stock | 53.56 | 54.44 | 52.48 | 53.88 | 63925.0 |
| 2001-08-20 | ACO-DELISTED | Stock | 6.35 | 6.5 | 6.32 | 6.49 | 23100.0 |
| 2001-08-20 | ACPW-DELISTED | Stock | 30.1 | 32.3 | 29.95 | 31.8 | 143180.0 |
| 2001-08-20 | ACS-DELISTED | Stock | 40.17 | 40.575 | 39.95 | 40.45 | 368200.0 |
| 2001-08-20 | ACTA-DELISTED | Stock | 16.8 | 18.2 | 16.2 | 17.4 | 70800.0 |
| 2001-08-20 | ACTT-DELISTED | Stock | 6.19 | 6.19 | 5.95 | 6.04 | 3900.0 |
| 2001-08-20 | ACTU-DELISTED | Stock | 7.29 | 7.43 | 6.94 | 7.01 | 274400.0 |
| 2001-08-20 | ACXM-DELISTED | Stock | 12.96 | 13.0 | 12.75 | 12.86 | 246100.0 |
| 2001-08-20 | ACY-DELISTED | Stock | 5.9 | 5.9 | 5.85 | 5.9 | 1500.0 |
| 2001-08-20 | AD | Stock | 37.54 | 37.7 | 36.3333 | 36.6667 | 188850.0 |
| 2001-08-20 | ADAT-DELISTED | Stock | 77.4 | 77.4 | 71.1 | 74.7 | 1030.0 |
| 2001-08-20 | ADBE | Stock | 16.29 | 17.455 | 16.0 | 17.115 | 5000800.0 |
| 2001-08-20 | ADC | Stock | 20.35 | 20.38 | 20.18 | 20.2 | 4400.0 |
> showing 50 of 2,967 rows — these rows as CSV