PREVIEW / stock_daily / 2001-06-18
file: by_date/stock_daily/2001/2001-06-18.parquet size: 101 KB rows: 2,928 symbols: 1,819
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-06-18 | AAPL | Stock | 0.3645 | 0.3723 | 0.3571 | 0.363 | 345912000.0 |
| 2001-06-18 | MSFT | Stock | 33.975 | 33.98 | 33.005 | 33.44 | 56846800.0 |
| 2001-06-18 | NVDA | Stock | 0.395 | 0.4015 | 0.376 | 0.3804 | 856656000.0 |
| 2001-06-18 | AMZN | Stock | 0.6225 | 0.635 | 0.5835 | 0.5915 | 114342000.0 |
| 2001-06-18 | CL | Stock | 28.95 | 29.1 | 28.7 | 28.955 | 2543000.0 |
| 2001-06-18 | A | Stock | 21.6738 | 22.2246 | 20.9442 | 21.4592 | 2492634.0 |
| 2001-06-18 | AABA-DELISTED | Stock | 8.25500011444092 | 8.31999969482422 | 7.6399998664856 | 7.65500020980835 | 11646000.0 |
| 2001-06-18 | AAI-DELISTED | Stock | 11.97 | 12.0 | 11.88 | 11.95 | 221300.0 |
| 2001-06-18 | AAIC-DELISTED | Stock | 114.0 | 115.0 | 113.0 | 113.0 | 15500.0 |
| 2001-06-18 | AAON | Stock | 1.4105 | 1.4105 | 1.3461 | 1.3549 | 234077.0 |
| 2001-06-18 | ABAX-DELISTED | Stock | 5.78 | 5.78 | 5.68 | 5.7 | 36900.0 |
| 2001-06-18 | ABB-DELISTED | Stock | 16.0 | 16.27 | 16.0 | 16.1 | 22600.0 |
| 2001-06-18 | ABC-DELISTED | Stock | 14.8000001907349 | 14.8999996185303 | 14.6899995803833 | 14.7700004577637 | 2494000.0 |
| 2001-06-18 | ABCB | Stock | 9.3212 | 9.3212 | 9.1996 | 9.2806 | 16779.0 |
| 2001-06-18 | ABCW-DELISTED | Stock | 14.49 | 14.49 | 14.04 | 14.09 | 72510.0 |
| 2001-06-18 | ABE-DELISTED | Stock | 8.14 | 8.14 | 8.0 | 8.1 | 15600.0 |
| 2001-06-18 | ABFS-DELISTED | Stock | 21.52 | 21.69 | 19.44 | 19.95 | 231600.0 |
| 2001-06-18 | ABK-DELISTED | Stock | 55.86 | 56.5 | 55.35 | 56.06 | 302400.0 |
| 2001-06-18 | ABM | Stock | 18.435 | 18.45 | 18.0 | 18.3 | 140400.0 |
| 2001-06-18 | ABMD-DELISTED | Stock | 22.7 | 25.6 | 22.7 | 23.19 | 173500.0 |
| 2001-06-18 | ABP-DELISTED | Stock | 4.01 | 4.03 | 3.9 | 3.91 | 68200.0 |
| 2001-06-18 | ABT | Stock | 22.6695 | 23.0466 | 22.6695 | 22.9388 | 9641549.0 |
| 2001-06-18 | ABTL-DELISTED | Stock | 7.4 | 7.4 | 7.0 | 7.05 | 6300.0 |
| 2001-06-18 | ABV-DELISTED | Stock | 19.85 | 19.85 | 19.0 | 19.27 | 717900.0 |
| 2001-06-18 | ABX-DELISTED | Stock | 16.97 | 17.26 | 16.58 | 16.76 | 1755100.0 |
| 2001-06-18 | ACAP-DELISTED | Stock | 19.0 | 19.23 | 18.76 | 19.2 | 41600.0 |
| 2001-06-18 | ACAS-DELISTED | Stock | 25.82 | 25.93 | 25.22 | 25.38 | 66491.0 |
| 2001-06-18 | ACAT-DELISTED | Stock | 14.82 | 14.82 | 14.75 | 14.79 | 16600.0 |
| 2001-06-18 | ACCL-DELISTED | Stock | 17.0799999237061 | 17.5240001678467 | 16.9080009460449 | 16.9080009460449 | 355900.0 |
| 2001-06-18 | ACE-DELISTED | Stock | 38.1 | 38.34 | 37.05 | 37.6 | 879800.0 |
| 2001-06-18 | ACF-DELISTED | Stock | 47.15 | 48.66 | 47.15 | 47.73 | 759600.0 |
| 2001-06-18 | ACG-DELISTED | Stock | 8.73 | 8.75 | 8.63 | 8.67 | 359900.0 |
| 2001-06-18 | ACGL | Stock | 1.7778 | 1.8556 | 1.7611 | 1.7833 | 78300.0 |
| 2001-06-18 | ACGN-DELISTED | Stock | 1246.6712 | 1348.6712 | 1246.6712 | 1292.0 | 34100.0 |
| 2001-06-18 | ACH | Stock | 13.2 | 13.6533 | 12.9333 | 13.1133 | 189900.0 |
| 2001-06-18 | ACLS | Stock | 58.96 | 60.56 | 56.52 | 58.4 | 213225.0 |
| 2001-06-18 | ACO-DELISTED | Stock | 6.08 | 6.09 | 6.05 | 6.08 | 22600.0 |
| 2001-06-18 | ACPW-DELISTED | Stock | 103.4 | 104.54 | 93.02 | 95.1 | 93999.0 |
| 2001-06-18 | ACS-DELISTED | Stock | 37.5 | 37.5 | 37.005 | 37.485 | 323800.0 |
| 2001-06-18 | ACTA-DELISTED | Stock | 38.6 | 39.2 | 31.2 | 32.8 | 65300.0 |
| 2001-06-18 | ACTT-DELISTED | Stock | 6.74 | 6.85 | 6.74 | 6.74 | 3800.0 |
| 2001-06-18 | ACTU-DELISTED | Stock | 8.34 | 9.05 | 7.89 | 8.04 | 398200.0 |
| 2001-06-18 | ACXM-DELISTED | Stock | 16.3 | 16.31 | 15.34 | 15.57 | 530000.0 |
| 2001-06-18 | ACY-DELISTED | Stock | 5.15 | 5.15 | 5.0 | 5.0 | 2400.0 |
| 2001-06-18 | AD | Stock | 37.7667 | 37.9933 | 37.0 | 37.0 | 96600.0 |
| 2001-06-18 | ADAT-DELISTED | Stock | 78.3 | 80.28 | 77.94 | 78.3 | 3629.0 |
| 2001-06-18 | ADBE | Stock | 19.63 | 20.365 | 19.38 | 20.27 | 7543000.0 |
| 2001-06-18 | ADC | Stock | 19.3 | 19.44 | 19.15 | 19.2 | 3600.0 |
| 2001-06-18 | ADEP-DELISTED | Stock | 41.75 | 43.25 | 41.25 | 41.35 | 22900.0 |
| 2001-06-18 | ADGF-DELISTED | Stock | 0.89 | 0.9 | 0.84 | 0.88 | 20000.0 |
> showing 50 of 2,928 rows — these rows as CSV