PREVIEW / stock_daily / 2001-12-20
file: by_date/stock_daily/2001/2001-12-20.parquet size: 105 KB rows: 3,065 symbols: 1,907
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-12-20 | AAPL | Stock | 0.3821 | 0.3834 | 0.3682 | 0.3691 | 220864000.0 |
| 2001-12-20 | MSFT | Stock | 34.575 | 34.625 | 33.31 | 33.38 | 78585000.0 |
| 2001-12-20 | NVDA | Stock | 0.5392 | 0.5489 | 0.5139 | 0.5158 | 951228000.0 |
| 2001-12-20 | AMZN | Stock | 0.5285 | 0.5415 | 0.507 | 0.5075 | 157024000.0 |
| 2001-12-20 | CL | Stock | 29.0 | 29.29 | 28.95 | 29.095 | 3269400.0 |
| 2001-12-20 | A | Stock | 20.1359 | 20.2146 | 19.6137 | 19.814 | 3982203.0 |
| 2001-12-20 | AABA-DELISTED | Stock | 8.80000019073486 | 9.09500026702881 | 8.07499980926514 | 8.10999965667725 | 20588400.0 |
| 2001-12-20 | AAI-DELISTED | Stock | 6.16 | 6.24 | 5.85 | 5.95 | 398200.0 |
| 2001-12-20 | AAIC-DELISTED | Stock | 107.0 | 109.4 | 105.0 | 105.2 | 64700.0 |
| 2001-12-20 | AAME | Stock | 2.1 | 2.25 | 2.0 | 2.13 | 17000.0 |
| 2001-12-20 | AAON | Stock | 1.848 | 1.8717 | 1.8261 | 1.8673 | 166303.0 |
| 2001-12-20 | AAP | Stock | 13.7333 | 14.23 | 13.7333 | 14.1 | 97200.0 |
| 2001-12-20 | AAXN-DELISTED | Stock | 1.02250003814697 | 1.02250003814697 | 1.00583338737488 | 1.00833332538605 | 141600.0 |
| 2001-12-20 | ABAX-DELISTED | Stock | 5.54 | 5.75 | 5.35 | 5.3998 | 46100.0 |
| 2001-12-20 | ABB-DELISTED | Stock | 9.3 | 9.4 | 9.3 | 9.4 | 10700.0 |
| 2001-12-20 | ABC-DELISTED | Stock | 15.1 | 15.47 | 15.05 | 15.42 | 6264000.0 |
| 2001-12-20 | ABCB | Stock | 10.699 | 11.1449 | 10.699 | 10.9746 | 12708.0 |
| 2001-12-20 | ABCO-DELISTED | Stock | 13.32 | 13.525 | 13.135 | 13.24 | 120800.0 |
| 2001-12-20 | ABCW-DELISTED | Stock | 17.98 | 17.98 | 17.69 | 17.7 | 62600.0 |
| 2001-12-20 | ABE-DELISTED | Stock | 6.88 | 6.91 | 6.88 | 6.88 | 27200.0 |
| 2001-12-20 | ABFS-DELISTED | Stock | 27.75 | 29.1 | 27.75 | 28.75 | 470000.0 |
| 2001-12-20 | ABK-DELISTED | Stock | 57.5 | 57.86 | 56.8 | 57.2 | 547200.0 |
| 2001-12-20 | ABM | Stock | 15.5 | 15.55 | 15.39 | 15.45 | 192200.0 |
| 2001-12-20 | ABMD-DELISTED | Stock | 15.98 | 16.035 | 14.19 | 15.3 | 243600.0 |
| 2001-12-20 | ABP-DELISTED | Stock | 1.22 | 1.23 | 1.13 | 1.22 | 81400.0 |
| 2001-12-20 | ABT | Stock | 24.8018 | 25.1115 | 24.7165 | 24.9589 | 8449081.0 |
| 2001-12-20 | ABTL-DELISTED | Stock | 9.8 | 9.8 | 8.45 | 9.35 | 30000.0 |
| 2001-12-20 | ABV-DELISTED | Stock | 20.45 | 20.48 | 20.01 | 20.39 | 372400.0 |
| 2001-12-20 | ABX-DELISTED | Stock | 16.05 | 16.48 | 16.02 | 16.44 | 1936300.0 |
| 2001-12-20 | ACAP-DELISTED | Stock | 21.6 | 21.79 | 21.35 | 21.58 | 29000.0 |
| 2001-12-20 | ACAS-DELISTED | Stock | 27.72 | 27.9991 | 27.5799 | 27.7 | 877682.0 |
| 2001-12-20 | ACAT-DELISTED | Stock | 16.54 | 16.54 | 16.15 | 16.15 | 30800.0 |
| 2001-12-20 | ACCL-DELISTED | Stock | 10.1599998474121 | 10.1669998168945 | 9.73900032043457 | 9.76799964904785 | 228400.0 |
| 2001-12-20 | ACE-DELISTED | Stock | 38.25 | 38.58 | 38.25 | 38.5 | 1348900.0 |
| 2001-12-20 | ACF-DELISTED | Stock | 30.7 | 32.25 | 29.52 | 29.55 | 2631900.0 |
| 2001-12-20 | ACG-DELISTED | Stock | 7.45 | 7.52 | 7.42 | 7.48 | 1259500.0 |
| 2001-12-20 | ACGL | Stock | 2.6333 | 2.6944 | 2.6333 | 2.6944 | 377100.0 |
| 2001-12-20 | ACGN-DELISTED | Stock | 1802.0 | 2028.6712 | 1802.0 | 2028.6712 | 10300.0 |
| 2001-12-20 | ACH | Stock | 12.3333 | 12.48 | 12.1333 | 12.1333 | 168150.0 |
| 2001-12-20 | ACH-DELISTED | Stock | 4.375 | 4.375 | 4.3125 | 4.325 | 157200.0 |
| 2001-12-20 | ACLS | Stock | 55.16 | 55.6 | 53.12 | 54.68 | 235600.0 |
| 2001-12-20 | ACO-DELISTED | Stock | 6.55 | 6.57 | 6.45 | 6.45 | 14800.0 |
| 2001-12-20 | ACPW-DELISTED | Stock | 25.4 | 27.5 | 25.4 | 27.4 | 51040.0 |
| 2001-12-20 | ACS-DELISTED | Stock | 51.25 | 51.5 | 50.815 | 51.0 | 658100.0 |
| 2001-12-20 | ACTA-DELISTED | Stock | 23.0 | 25.0 | 22.4 | 22.6 | 120900.0 |
| 2001-12-20 | ACTT-DELISTED | Stock | 8.2 | 8.5 | 7.87 | 8.1 | 31900.0 |
| 2001-12-20 | ACTU-DELISTED | Stock | 4.72 | 5.05 | 4.65 | 4.82 | 1157600.0 |
| 2001-12-20 | ACXM-DELISTED | Stock | 17.84 | 17.84 | 17.21 | 17.65 | 1505700.0 |
| 2001-12-20 | ACY-DELISTED | Stock | 4.95 | 4.95 | 4.95 | 4.95 | 100.0 |
| 2001-12-20 | AD | Stock | 29.9733 | 29.9733 | 29.2667 | 29.2867 | 138450.0 |
> showing 50 of 3,065 rows — these rows as CSV