PREVIEW / stock_daily / 2001-11-16
file: by_date/stock_daily/2001/2001-11-16.parquet size: 102 KB rows: 3,018 symbols: 1,877
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-16 | AAPL | Stock | 0.3441 | 0.3445 | 0.3286 | 0.3388 | 230664000.0 |
| 2001-11-16 | MSFT | Stock | 33.18 | 33.305 | 32.475 | 32.875 | 59249000.0 |
| 2001-11-16 | NVDA | Stock | 0.4417 | 0.4463 | 0.4315 | 0.4374 | 496128000.0 |
| 2001-11-16 | AMZN | Stock | 0.4605 | 0.4675 | 0.4375 | 0.4475 | 261240000.0 |
| 2001-11-16 | CL | Stock | 29.075 | 29.45 | 29.0 | 29.275 | 2829200.0 |
| 2001-11-16 | A | Stock | 17.0959 | 17.3462 | 16.166 | 17.2604 | 11550556.0 |
| 2001-11-16 | AABA-DELISTED | Stock | 7.63500022888184 | 8.0 | 7.52500009536743 | 7.7350001335144 | 31970800.0 |
| 2001-11-16 | AAI-DELISTED | Stock | 5.65 | 5.95 | 5.65 | 5.73 | 552000.0 |
| 2001-11-16 | AAIC-DELISTED | Stock | 102.6 | 102.8 | 98.2 | 100.0 | 5100.0 |
| 2001-11-16 | AAME | Stock | 2.5 | 2.5 | 2.25 | 2.45 | 6000.0 |
| 2001-11-16 | AAON | Stock | 1.7154 | 1.7997 | 1.7032 | 1.7558 | 161747.0 |
| 2001-11-16 | AAXN-DELISTED | Stock | 1.1525000333786 | 1.26166665554047 | 1.12916672229767 | 1.18416666984558 | 10719600.0 |
| 2001-11-16 | ABAX-DELISTED | Stock | 4.18 | 4.32 | 4.17 | 4.25 | 13700.0 |
| 2001-11-16 | ABB-DELISTED | Stock | 10.8 | 11.09 | 10.75 | 11.0 | 38700.0 |
| 2001-11-16 | ABC-DELISTED | Stock | 14.0 | 14.44 | 13.94 | 14.22 | 8314400.0 |
| 2001-11-16 | ABCB | Stock | 10.537 | 10.6423 | 10.537 | 10.6423 | 14188.0 |
| 2001-11-16 | ABCO-DELISTED | Stock | 11.712 | 11.898 | 11.592 | 11.788 | 541493.0 |
| 2001-11-16 | ABCW-DELISTED | Stock | 17.52 | 17.7 | 17.43 | 17.68 | 39800.0 |
| 2001-11-16 | ABE-DELISTED | Stock | 6.9 | 7.05 | 6.9 | 6.99 | 24300.0 |
| 2001-11-16 | ABFS-DELISTED | Stock | 26.75 | 27.0 | 25.89 | 25.98 | 270200.0 |
| 2001-11-16 | ABK-DELISTED | Stock | 52.25 | 52.8 | 51.94 | 52.25 | 398100.0 |
| 2001-11-16 | ABM | Stock | 14.425 | 14.6 | 14.325 | 14.4 | 196200.0 |
| 2001-11-16 | ABMD-DELISTED | Stock | 17.95 | 18.64 | 17.81 | 17.9996 | 219700.0 |
| 2001-11-16 | ABP-DELISTED | Stock | 1.35 | 1.36 | 1.28 | 1.3 | 136500.0 |
| 2001-11-16 | ABT | Stock | 23.8142 | 23.8277 | 23.1453 | 23.3563 | 7549996.0 |
| 2001-11-16 | ABTL-DELISTED | Stock | 6.8 | 7.65 | 6.8 | 7.4 | 10500.0 |
| 2001-11-16 | ABV-DELISTED | Stock | 19.15 | 19.56 | 19.14 | 19.5 | 316700.0 |
| 2001-11-16 | ABX-DELISTED | Stock | 14.68 | 14.7 | 14.09 | 14.4 | 2774625.0 |
| 2001-11-16 | ACAP-DELISTED | Stock | 16.49 | 18.23 | 16.49 | 18.09 | 190100.0 |
| 2001-11-16 | ACAS-DELISTED | Stock | 28.05 | 28.15 | 27.73 | 27.91 | 109400.0 |
| 2001-11-16 | ACAT-DELISTED | Stock | 15.28 | 15.8 | 15.09 | 15.65 | 13500.0 |
| 2001-11-16 | ACCL-DELISTED | Stock | 10.152099609375 | 10.2607002258301 | 10.0651998519897 | 10.2607002258301 | 99800.0 |
| 2001-11-16 | ACE-DELISTED | Stock | 36.4 | 37.25 | 36.3 | 37.25 | 1727600.0 |
| 2001-11-16 | ACF-DELISTED | Stock | 23.6 | 23.7 | 22.58 | 22.94 | 2808300.0 |
| 2001-11-16 | ACG-DELISTED | Stock | 8.25 | 8.25 | 8.1 | 8.14 | 702700.0 |
| 2001-11-16 | ACGL | Stock | 2.6056 | 2.6456 | 2.6056 | 2.6444 | 128700.0 |
| 2001-11-16 | ACGN-DELISTED | Stock | 1246.6712 | 1246.6712 | 1167.3288 | 1246.6712 | 51600.0 |
| 2001-11-16 | ACH | Stock | 12.2667 | 12.2667 | 12.0867 | 12.0867 | 133350.0 |
| 2001-11-16 | ACLS | Stock | 54.08 | 55.4 | 53.24 | 54.68 | 74125.0 |
| 2001-11-16 | ACO-DELISTED | Stock | 5.8 | 5.85 | 5.7 | 5.71 | 8700.0 |
| 2001-11-16 | ACPW-DELISTED | Stock | 32.25 | 34.65 | 31.75 | 32.55 | 35480.0 |
| 2001-11-16 | ACS-DELISTED | Stock | 48.0 | 48.0 | 47.05 | 47.435 | 568200.0 |
| 2001-11-16 | ACTA-DELISTED | Stock | 24.8 | 26.2 | 24.8 | 25.2 | 67100.0 |
| 2001-11-16 | ACTT-DELISTED | Stock | 10.06 | 10.1 | 9.14 | 9.5 | 199300.0 |
| 2001-11-16 | ACTU-DELISTED | Stock | 6.29 | 6.36 | 5.96 | 6.12 | 149900.0 |
| 2001-11-16 | ACXM-DELISTED | Stock | 12.48 | 12.78 | 12.35 | 12.54 | 2235200.0 |
| 2001-11-16 | AD | Stock | 30.1333 | 30.1333 | 29.08 | 29.6667 | 189750.0 |
| 2001-11-16 | ADAT-DELISTED | Stock | 77.22 | 77.22 | 70.74 | 75.42 | 1061.0 |
| 2001-11-16 | ADBE | Stock | 16.18 | 16.375 | 15.75 | 15.95 | 4456000.0 |
| 2001-11-16 | ADC | Stock | 19.12 | 19.25 | 19.1 | 19.24 | 3900.0 |
> showing 50 of 3,018 rows — these rows as CSV