PREVIEW / stock_daily / 2001-11-28
file: by_date/stock_daily/2001/2001-11-28.parquet size: 104 KB rows: 3,051 symbols: 1,902
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-28 | AAPL | Stock | 0.3723 | 0.3788 | 0.3645 | 0.3666 | 250611200.0 |
| 2001-11-28 | MSFT | Stock | 31.585 | 32.06 | 31.365 | 31.4 | 54536600.0 |
| 2001-11-28 | NVDA | Stock | 0.445 | 0.4524 | 0.427 | 0.428 | 740844000.0 |
| 2001-11-28 | AMZN | Stock | 0.562 | 0.62 | 0.559 | 0.5795 | 970324000.0 |
| 2001-11-28 | CL | Stock | 28.895 | 29.235 | 28.725 | 28.975 | 2011600.0 |
| 2001-11-28 | A | Stock | 18.9557 | 19.4921 | 18.7768 | 19.2775 | 5990290.0 |
| 2001-11-28 | AABA-DELISTED | Stock | 8.52000045776367 | 8.72500038146973 | 8.05000019073486 | 8.10499954223633 | 25570400.0 |
| 2001-11-28 | AAI-DELISTED | Stock | 6.05 | 6.14 | 5.87 | 5.87 | 213900.0 |
| 2001-11-28 | AAIC-DELISTED | Stock | 96.0 | 97.0 | 96.0 | 96.0 | 33800.0 |
| 2001-11-28 | AAME | Stock | 2.1 | 2.1 | 2.1 | 2.1 | 1000.0 |
| 2001-11-28 | AAON | Stock | 1.9314 | 1.9314 | 1.7997 | 1.848 | 249455.0 |
| 2001-11-28 | AAXN-DELISTED | Stock | 1.01916670799255 | 1.01999998092651 | 0.983333349227905 | 1.0 | 698400.0 |
| 2001-11-28 | ABAX-DELISTED | Stock | 4.12 | 4.15 | 4.03 | 4.0807 | 55500.0 |
| 2001-11-28 | ABB-DELISTED | Stock | 10.87 | 11.0 | 10.53 | 10.95 | 33500.0 |
| 2001-11-28 | ABC-DELISTED | Stock | 14.11 | 14.47 | 14.1 | 14.26 | 5411200.0 |
| 2001-11-28 | ABCB | Stock | 10.7477 | 10.9422 | 10.7396 | 10.7964 | 15052.0 |
| 2001-11-28 | ABCO-DELISTED | Stock | 13.3 | 13.645 | 13.3 | 13.45 | 230600.0 |
| 2001-11-28 | ABCW-DELISTED | Stock | 17.39 | 17.39 | 17.19 | 17.2 | 31000.0 |
| 2001-11-28 | ABE-DELISTED | Stock | 6.9 | 6.9 | 6.81 | 6.81 | 11900.0 |
| 2001-11-28 | ABFS-DELISTED | Stock | 26.6 | 26.6 | 25.0 | 25.0 | 58400.0 |
| 2001-11-28 | ABK-DELISTED | Stock | 55.31 | 55.54 | 53.62 | 54.03 | 644000.0 |
| 2001-11-28 | ABM | Stock | 14.625 | 14.63 | 14.5 | 14.5 | 75200.0 |
| 2001-11-28 | ABMD-DELISTED | Stock | 19.9 | 19.9 | 17.46 | 19.2 | 278000.0 |
| 2001-11-28 | ABP-DELISTED | Stock | 1.05 | 1.29 | 1.01 | 1.21 | 117800.0 |
| 2001-11-28 | ABT | Stock | 24.1419 | 24.4651 | 24.1284 | 24.281 | 5369782.0 |
| 2001-11-28 | ABTL-DELISTED | Stock | 6.95 | 7.15 | 6.95 | 7.05 | 3600.0 |
| 2001-11-28 | ABV-DELISTED | Stock | 20.55 | 20.61 | 19.15 | 19.5 | 493800.0 |
| 2001-11-28 | ABX-DELISTED | Stock | 14.88 | 15.1 | 14.79 | 14.83 | 2440381.0 |
| 2001-11-28 | ACAP-DELISTED | Stock | 19.13 | 20.05 | 19.13 | 20.0 | 53300.0 |
| 2001-11-28 | ACAS-DELISTED | Stock | 28.1 | 28.35 | 27.7 | 27.7 | 194500.0 |
| 2001-11-28 | ACAT-DELISTED | Stock | 16.75 | 17.0668 | 16.56 | 16.85 | 21400.0 |
| 2001-11-28 | ACCL-DELISTED | Stock | 10.5500001907349 | 10.746000289917 | 10.4630002975464 | 10.5 | 57200.0 |
| 2001-11-28 | ACE-DELISTED | Stock | 38.54 | 38.54 | 37.5 | 37.65 | 388905.0 |
| 2001-11-28 | ACF-DELISTED | Stock | 24.3 | 24.38 | 22.6 | 22.76 | 1429200.0 |
| 2001-11-28 | ACG-DELISTED | Stock | 8.08 | 8.09 | 8.01 | 8.02 | 493500.0 |
| 2001-11-28 | ACGL | Stock | 2.6133 | 2.6444 | 2.5778 | 2.6444 | 43200.0 |
| 2001-11-28 | ACGN-DELISTED | Stock | 1518.6712 | 1609.3288 | 1473.3288 | 1609.3288 | 85700.0 |
| 2001-11-28 | ACH | Stock | 12.0667 | 12.0667 | 11.92 | 11.98 | 134100.0 |
| 2001-11-28 | ACLS | Stock | 55.44 | 56.0 | 52.52 | 52.84 | 56525.0 |
| 2001-11-28 | ACO-DELISTED | Stock | 5.65 | 5.88 | 5.65 | 5.68 | 38600.0 |
| 2001-11-28 | ACPW-DELISTED | Stock | 29.7 | 29.8 | 28.15 | 28.65 | 19340.0 |
| 2001-11-28 | ACS-DELISTED | Stock | 47.95 | 47.955 | 46.7 | 47.25 | 456400.0 |
| 2001-11-28 | ACTA-DELISTED | Stock | 24.2 | 24.2 | 21.2 | 21.4 | 105600.0 |
| 2001-11-28 | ACTT-DELISTED | Stock | 10.52 | 10.93 | 10.05 | 10.16 | 45300.0 |
| 2001-11-28 | ACTU-DELISTED | Stock | 5.38 | 5.64 | 5.25 | 5.25 | 283200.0 |
| 2001-11-28 | ACXM-DELISTED | Stock | 13.35 | 13.4 | 12.65 | 12.7 | 1042900.0 |
| 2001-11-28 | ACY-DELISTED | Stock | 5.05 | 5.05 | 4.96 | 5.0 | 4100.0 |
| 2001-11-28 | AD | Stock | 29.3667 | 29.5 | 29.1667 | 29.3267 | 192000.0 |
| 2001-11-28 | ADAT-DELISTED | Stock | 67.5 | 71.1 | 66.6 | 71.1 | 2065.0 |
| 2001-11-28 | ADBE | Stock | 16.905 | 16.91 | 16.01 | 16.03 | 6677800.0 |
> showing 50 of 3,051 rows — these rows as CSV