PREVIEW / stock_daily / 2001-11-12
file: by_date/stock_daily/2001/2001-11-12.parquet size: 101 KB rows: 2,985 symbols: 1,851
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-11-12 | AAPL | Stock | 0.3332 | 0.3423 | 0.3207 | 0.3348 | 201499200.0 |
| 2001-11-12 | MSFT | Stock | 32.35 | 33.22 | 31.825 | 32.895 | 57752800.0 |
| 2001-11-12 | NVDA | Stock | 0.4417 | 0.4666 | 0.4282 | 0.4552 | 1458636000.0 |
| 2001-11-12 | AMZN | Stock | 0.358 | 0.362 | 0.34 | 0.3525 | 76546000.0 |
| 2001-11-12 | CL | Stock | 28.7 | 28.7 | 28.125 | 28.4 | 3210600.0 |
| 2001-11-12 | A | Stock | 17.4249 | 17.7396 | 16.8884 | 17.6252 | 2104829.0 |
| 2001-11-12 | AABA-DELISTED | Stock | 6.77500009536743 | 6.88500022888184 | 6.42000007629395 | 6.84999990463257 | 15510000.0 |
| 2001-11-12 | AAI-DELISTED | Stock | 5.24 | 5.24 | 4.6 | 5.07 | 1214000.0 |
| 2001-11-12 | AAIC-DELISTED | Stock | 101.0 | 101.4 | 99.0 | 100.0 | 20700.0 |
| 2001-11-12 | AAME | Stock | 2.14 | 2.55 | 2.05 | 2.4 | 5600.0 |
| 2001-11-12 | AAON | Stock | 1.5715 | 1.668 | 1.5153 | 1.6531 | 146939.0 |
| 2001-11-12 | AAXN-DELISTED | Stock | 0.931666672229767 | 0.987500011920929 | 0.930833339691162 | 0.945833325386047 | 1074000.0 |
| 2001-11-12 | ABAX-DELISTED | Stock | 4.3 | 4.36 | 4.2 | 4.32 | 7900.0 |
| 2001-11-12 | ABB-DELISTED | Stock | 9.3 | 9.38 | 9.15 | 9.38 | 39100.0 |
| 2001-11-12 | ABC-DELISTED | Stock | 13.94 | 14.35 | 13.62 | 14.2 | 6208800.0 |
| 2001-11-12 | ABCB | Stock | 10.1803 | 10.2127 | 10.1803 | 10.2127 | 617.0 |
| 2001-11-12 | ABCW-DELISTED | Stock | 15.77 | 17.33 | 15.75 | 17.26 | 132800.0 |
| 2001-11-12 | ABE-DELISTED | Stock | 6.85 | 6.88 | 6.83 | 6.88 | 16400.0 |
| 2001-11-12 | ABFS-DELISTED | Stock | 25.55 | 25.9 | 25.28 | 25.55 | 169800.0 |
| 2001-11-12 | ABK-DELISTED | Stock | 50.81 | 51.01 | 49.7 | 50.96 | 339200.0 |
| 2001-11-12 | ABM | Stock | 14.52 | 14.52 | 14.2 | 14.275 | 81200.0 |
| 2001-11-12 | ABMD-DELISTED | Stock | 22.1 | 22.35 | 21.13 | 22.17 | 103800.0 |
| 2001-11-12 | ABP-DELISTED | Stock | 1.47 | 1.54 | 1.45 | 1.45 | 32200.0 |
| 2001-11-12 | ABT | Stock | 23.7693 | 24.1688 | 23.5673 | 24.0656 | 4324563.0 |
| 2001-11-12 | ABTL-DELISTED | Stock | 8.0 | 8.0 | 6.75 | 7.6 | 74900.0 |
| 2001-11-12 | ABV-DELISTED | Stock | 18.47 | 18.8 | 17.81 | 18.7 | 186300.0 |
| 2001-11-12 | ABX-DELISTED | Stock | 15.97 | 16.12 | 15.7 | 15.72 | 1784818.0 |
| 2001-11-12 | ACAP-DELISTED | Stock | 15.92 | 16.5 | 14.7 | 15.7 | 238500.0 |
| 2001-11-12 | ACAS-DELISTED | Stock | 27.47 | 27.85 | 26.95 | 27.21 | 136300.0 |
| 2001-11-12 | ACAT-DELISTED | Stock | 15.31 | 15.85 | 15.16 | 15.68 | 15800.0 |
| 2001-11-12 | ACCL-DELISTED | Stock | 9.65999984741211 | 9.92000007629395 | 9.65200042724609 | 9.77600002288818 | 154800.0 |
| 2001-11-12 | ACE-DELISTED | Stock | 36.5 | 37.39 | 35.24 | 36.9 | 2123000.0 |
| 2001-11-12 | ACF-DELISTED | Stock | 19.37 | 20.3 | 18.89 | 19.78 | 2614700.0 |
| 2001-11-12 | ACG-DELISTED | Stock | 8.89 | 8.94 | 8.75 | 8.85 | 417300.0 |
| 2001-11-12 | ACGL | Stock | 2.5556 | 2.6422 | 2.5556 | 2.6111 | 72900.0 |
| 2001-11-12 | ACGN-DELISTED | Stock | 1190.0 | 1190.0 | 1133.3288 | 1190.0 | 11000.0 |
| 2001-11-12 | ACH | Stock | 12.5 | 12.5 | 11.96 | 12.3133 | 97200.0 |
| 2001-11-12 | ACLS | Stock | 52.56 | 52.56 | 46.44 | 50.2 | 164250.0 |
| 2001-11-12 | ACO-DELISTED | Stock | 5.79 | 6.04 | 5.73 | 5.8 | 20400.0 |
| 2001-11-12 | ACPW-DELISTED | Stock | 28.25 | 29.1 | 26.8 | 27.15 | 44140.0 |
| 2001-11-12 | ACS-DELISTED | Stock | 44.05 | 44.9 | 43.7 | 44.885 | 436200.0 |
| 2001-11-12 | ACTA-DELISTED | Stock | 21.6 | 22.4 | 18.0 | 20.8 | 189400.0 |
| 2001-11-12 | ACTT-DELISTED | Stock | 10.5 | 11.22 | 10.04 | 10.79 | 132200.0 |
| 2001-11-12 | ACTU-DELISTED | Stock | 5.75 | 5.85 | 5.0 | 5.57 | 495800.0 |
| 2001-11-12 | ACXM-DELISTED | Stock | 12.28 | 12.85 | 12.02 | 12.66 | 229900.0 |
| 2001-11-12 | ACY-DELISTED | Stock | 5.3 | 5.3 | 5.2 | 5.2 | 800.0 |
| 2001-11-12 | AD | Stock | 29.2667 | 29.4333 | 29.0 | 29.42 | 138000.0 |
| 2001-11-12 | ADAT-DELISTED | Stock | 76.5 | 78.84 | 74.7 | 74.7 | 1975.0 |
| 2001-11-12 | ADBE | Stock | 14.375 | 14.69 | 13.275 | 14.5 | 5878400.0 |
| 2001-11-12 | ADC | Stock | 19.48 | 19.48 | 19.15 | 19.23 | 2000.0 |
> showing 50 of 2,985 rows — these rows as CSV