PREVIEW / stock_daily / 2001-11-14
file: by_date/stock_daily/2001/2001-11-14.parquet size: 103 KB rows: 3,034 symbols: 1,895
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-14 | AAPL | Stock | 0.3498 | 0.3554 | 0.342 | 0.3502 | 221149600.0 |
| 2001-11-14 | MSFT | Stock | 34.115 | 34.17 | 32.895 | 32.975 | 88625600.0 |
| 2001-11-14 | NVDA | Stock | 0.4548 | 0.4592 | 0.4267 | 0.4389 | 1150224000.0 |
| 2001-11-14 | AMZN | Stock | 0.3815 | 0.4745 | 0.38 | 0.4745 | 590596000.0 |
| 2001-11-14 | CL | Stock | 28.93 | 28.97 | 28.675 | 28.865 | 2517800.0 |
| 2001-11-14 | A | Stock | 17.9614 | 18.3834 | 17.8898 | 18.1044 | 2448038.0 |
| 2001-11-14 | AABA-DELISTED | Stock | 7.28499984741211 | 7.69000005722046 | 7.21000003814697 | 7.60500001907349 | 29540000.0 |
| 2001-11-14 | AAI-DELISTED | Stock | 5.32 | 5.44 | 5.3 | 5.44 | 798000.0 |
| 2001-11-14 | AAIC-DELISTED | Stock | 101.0 | 102.6 | 100.0 | 102.6 | 14400.0 |
| 2001-11-14 | AAME | Stock | 2.28 | 3.1 | 2.25 | 2.63 | 16800.0 |
| 2001-11-14 | AAON | Stock | 1.755 | 1.7585 | 1.6268 | 1.7541 | 116184.0 |
| 2001-11-14 | AAXN-DELISTED | Stock | 0.933333337306976 | 0.933333337306976 | 0.875833332538605 | 0.899999976158142 | 394800.0 |
| 2001-11-14 | ABAX-DELISTED | Stock | 4.25 | 4.5 | 4.25 | 4.45 | 20900.0 |
| 2001-11-14 | ABB-DELISTED | Stock | 10.1 | 10.3 | 9.92 | 10.3 | 32300.0 |
| 2001-11-14 | ABC-DELISTED | Stock | 14.19 | 14.28 | 13.75 | 13.78 | 6832400.0 |
| 2001-11-14 | ABCB | Stock | 10.4965 | 10.4965 | 10.4965 | 10.4965 | 617.0 |
| 2001-11-14 | ABCO-DELISTED | Stock | 12.01 | 12.595 | 11.825 | 11.975 | 1807400.0 |
| 2001-11-14 | ABCW-DELISTED | Stock | 16.85 | 17.49 | 16.85 | 17.49 | 33200.0 |
| 2001-11-14 | ABE-DELISTED | Stock | 6.96 | 6.96 | 6.88 | 6.9 | 26900.0 |
| 2001-11-14 | ABFS-DELISTED | Stock | 25.85 | 26.72 | 25.8 | 26.63 | 192900.0 |
| 2001-11-14 | ABK-DELISTED | Stock | 51.85 | 53.3 | 51.75 | 51.96 | 410000.0 |
| 2001-11-14 | ABM | Stock | 14.67 | 14.74 | 14.4 | 14.4 | 129200.0 |
| 2001-11-14 | ABMD-DELISTED | Stock | 19.64 | 20.05 | 18.0 | 19.14 | 639900.0 |
| 2001-11-14 | ABP-DELISTED | Stock | 1.5 | 1.5 | 1.36 | 1.4 | 393000.0 |
| 2001-11-14 | ABT | Stock | 23.7379 | 23.7873 | 23.3518 | 23.4236 | 8309630.0 |
| 2001-11-14 | ABTL-DELISTED | Stock | 7.6 | 7.65 | 7.15 | 7.6 | 16700.0 |
| 2001-11-14 | ABV-DELISTED | Stock | 19.11 | 19.12 | 18.68 | 18.8 | 308500.0 |
| 2001-11-14 | ABX-DELISTED | Stock | 15.39 | 15.65 | 15.14 | 15.15 | 2097818.0 |
| 2001-11-14 | ACAP-DELISTED | Stock | 16.56 | 16.9 | 16.0 | 16.68 | 1030400.0 |
| 2001-11-14 | ACAS-DELISTED | Stock | 28.0 | 28.25 | 27.84 | 27.95 | 156500.0 |
| 2001-11-14 | ACAT-DELISTED | Stock | 15.67 | 15.99 | 15.15 | 15.76 | 14200.0 |
| 2001-11-14 | ACCL-DELISTED | Stock | 9.86242008209229 | 10.5357999801636 | 9.86242008209229 | 10.5357999801636 | 464400.0 |
| 2001-11-14 | ACE-DELISTED | Stock | 36.97 | 37.2 | 36.2 | 36.47 | 1068700.0 |
| 2001-11-14 | ACF-DELISTED | Stock | 25.75 | 25.85 | 24.75 | 25.3 | 4500900.0 |
| 2001-11-14 | ACG-DELISTED | Stock | 8.84 | 8.84 | 8.65 | 8.65 | 479900.0 |
| 2001-11-14 | ACGL | Stock | 2.5644 | 2.6056 | 2.5489 | 2.5556 | 358200.0 |
| 2001-11-14 | ACGN-DELISTED | Stock | 1190.0 | 1190.0 | 1110.6712 | 1167.3288 | 42200.0 |
| 2001-11-14 | ACH | Stock | 12.26 | 12.2867 | 12.0 | 12.2667 | 60600.0 |
| 2001-11-14 | ACLS | Stock | 55.04 | 55.4 | 51.8 | 53.52 | 78475.0 |
| 2001-11-14 | ACO-DELISTED | Stock | 5.9 | 6.38 | 5.9 | 6.0 | 82100.0 |
| 2001-11-14 | ACPW-DELISTED | Stock | 30.05 | 33.25 | 30.0 | 32.5 | 55100.0 |
| 2001-11-14 | ACS-DELISTED | Stock | 45.645 | 47.01 | 45.475 | 46.785 | 696400.0 |
| 2001-11-14 | ACTA-DELISTED | Stock | 25.0 | 27.6 | 24.2 | 25.4 | 187900.0 |
| 2001-11-14 | ACTT-DELISTED | Stock | 11.13 | 11.26 | 10.77 | 10.77 | 167300.0 |
| 2001-11-14 | ACTU-DELISTED | Stock | 5.98 | 6.35 | 5.92 | 6.2 | 384600.0 |
| 2001-11-14 | ACXM-DELISTED | Stock | 13.17 | 13.3 | 12.71 | 13.02 | 244800.0 |
| 2001-11-14 | ACY-DELISTED | Stock | 5.2 | 5.2 | 5.2 | 5.2 | 200.0 |
| 2001-11-14 | AD | Stock | 29.6867 | 30.1667 | 29.6333 | 30.1667 | 121200.0 |
| 2001-11-14 | ADAT-DELISTED | Stock | 74.52 | 75.6 | 70.2 | 72.9 | 1403.0 |
| 2001-11-14 | ADBE | Stock | 15.585 | 15.9 | 15.125 | 15.67 | 5430400.0 |
> showing 50 of 3,034 rows — these rows as CSV