PREVIEW / stock_daily / 2001-11-20
file: by_date/stock_daily/2001/2001-11-20.parquet size: 104 KB rows: 3,034 symbols: 1,891
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-20 | AAPL | Stock | 0.3539 | 0.3607 | 0.3482 | 0.3488 | 276584000.0 |
| 2001-11-20 | MSFT | Stock | 33.225 | 33.9 | 32.515 | 32.7 | 65921800.0 |
| 2001-11-20 | NVDA | Stock | 0.4299 | 0.4374 | 0.4111 | 0.4158 | 937884000.0 |
| 2001-11-20 | AMZN | Stock | 0.4535 | 0.465 | 0.43 | 0.43 | 149040000.0 |
| 2001-11-20 | CL | Stock | 29.05 | 29.45 | 29.05 | 29.335 | 2300600.0 |
| 2001-11-20 | A | Stock | 17.3462 | 17.3534 | 16.8813 | 17.01 | 13580172.0 |
| 2001-11-20 | AABA-DELISTED | Stock | 7.94000005722046 | 8.0 | 7.44000005722046 | 7.44500017166138 | 26776200.0 |
| 2001-11-20 | AAI-DELISTED | Stock | 6.04 | 6.04 | 5.7 | 5.78 | 414900.0 |
| 2001-11-20 | AAIC-DELISTED | Stock | 101.6 | 102.0 | 98.6 | 98.6 | 37200.0 |
| 2001-11-20 | AAME | Stock | 2.39 | 2.39 | 2.25 | 2.25 | 2800.0 |
| 2001-11-20 | AAON | Stock | 1.8875 | 1.8875 | 1.7427 | 1.8041 | 123019.0 |
| 2001-11-20 | AAXN-DELISTED | Stock | 1.16250002384186 | 1.16666662693024 | 1.12583339214325 | 1.15750002861023 | 729600.0 |
| 2001-11-20 | ABAX-DELISTED | Stock | 4.2 | 4.3 | 4.2 | 4.2 | 5800.0 |
| 2001-11-20 | ABB-DELISTED | Stock | 10.7 | 10.97 | 10.22 | 10.97 | 118200.0 |
| 2001-11-20 | ABC-DELISTED | Stock | 14.54 | 14.9 | 14.4 | 14.56 | 4450800.0 |
| 2001-11-20 | ABCO-DELISTED | Stock | 12.04 | 12.125 | 11.975 | 12.1 | 683600.0 |
| 2001-11-20 | ABCW-DELISTED | Stock | 17.76 | 18.14 | 17.7 | 18.14 | 185000.0 |
| 2001-11-20 | ABE-DELISTED | Stock | 6.99 | 7.03 | 6.96 | 7.02 | 38600.0 |
| 2001-11-20 | ABFS-DELISTED | Stock | 25.66 | 25.66 | 25.0 | 25.0 | 88500.0 |
| 2001-11-20 | ABK-DELISTED | Stock | 53.86 | 54.75 | 53.55 | 54.5 | 702500.0 |
| 2001-11-20 | ABM | Stock | 14.2 | 14.31 | 14.075 | 14.25 | 87000.0 |
| 2001-11-20 | ABMD-DELISTED | Stock | 19.11 | 19.6 | 18.05 | 18.42 | 200700.0 |
| 2001-11-20 | ABP-DELISTED | Stock | 1.2 | 1.27 | 1.11 | 1.18 | 247200.0 |
| 2001-11-20 | ABT | Stock | 23.4775 | 23.8456 | 23.4775 | 23.7648 | 5953653.0 |
| 2001-11-20 | ABTL-DELISTED | Stock | 7.25 | 7.5 | 7.0 | 7.0 | 3700.0 |
| 2001-11-20 | ABV-DELISTED | Stock | 19.85 | 19.85 | 19.3 | 19.3 | 375000.0 |
| 2001-11-20 | ABX-DELISTED | Stock | 14.17 | 14.54 | 14.1 | 14.5 | 2611353.0 |
| 2001-11-20 | ACAP-DELISTED | Stock | 18.3 | 18.4 | 18.06 | 18.25 | 235400.0 |
| 2001-11-20 | ACAS-DELISTED | Stock | 27.98 | 29.03 | 27.8 | 27.98 | 238248.0 |
| 2001-11-20 | ACAT-DELISTED | Stock | 16.16 | 16.25 | 15.86 | 16.04 | 14600.0 |
| 2001-11-20 | ACCL-DELISTED | Stock | 10.1599998474121 | 10.289999961853 | 10.0649995803833 | 10.210000038147 | 259600.0 |
| 2001-11-20 | ACE-DELISTED | Stock | 38.9 | 38.9 | 38.0 | 38.22 | 2293700.0 |
| 2001-11-20 | ACF-DELISTED | Stock | 24.45 | 24.46 | 23.35 | 23.93 | 2080400.0 |
| 2001-11-20 | ACG-DELISTED | Stock | 8.23 | 8.24 | 8.13 | 8.16 | 358400.0 |
| 2001-11-20 | ACGL | Stock | 2.6444 | 2.6444 | 2.5878 | 2.5878 | 79200.0 |
| 2001-11-20 | ACGN-DELISTED | Stock | 1224.0 | 1292.0 | 1190.0 | 1246.6712 | 284400.0 |
| 2001-11-20 | ACH | Stock | 11.9533 | 12.18 | 11.8333 | 12.1333 | 184200.0 |
| 2001-11-20 | ACLS | Stock | 54.44 | 54.92 | 51.56 | 52.4 | 100000.0 |
| 2001-11-20 | ACO-DELISTED | Stock | 5.9 | 5.97 | 5.9 | 5.9 | 23900.0 |
| 2001-11-20 | ACPW-DELISTED | Stock | 32.75 | 33.0 | 30.3 | 30.35 | 25320.0 |
| 2001-11-20 | ACS-DELISTED | Stock | 47.95 | 48.075 | 46.75 | 47.435 | 488200.0 |
| 2001-11-20 | ACTA-DELISTED | Stock | 28.8 | 30.4 | 27.0 | 27.2 | 244300.0 |
| 2001-11-20 | ACTT-DELISTED | Stock | 10.0 | 10.45 | 9.85 | 10.4 | 92400.0 |
| 2001-11-20 | ACTU-DELISTED | Stock | 6.2 | 6.25 | 5.15 | 5.62 | 456600.0 |
| 2001-11-20 | ACXM-DELISTED | Stock | 12.47 | 12.53 | 12.0 | 12.05 | 4427800.0 |
| 2001-11-20 | ACY-DELISTED | Stock | 5.1 | 5.1 | 5.0 | 5.08 | 4700.0 |
| 2001-11-20 | AD | Stock | 30.1667 | 30.1667 | 29.8 | 29.9133 | 135600.0 |
| 2001-11-20 | ADAT-DELISTED | Stock | 73.08 | 73.8 | 68.4 | 69.48 | 1503.0 |
| 2001-11-20 | ADBE | Stock | 16.77 | 17.125 | 16.095 | 16.1 | 8401000.0 |
| 2001-11-20 | ADC | Stock | 19.24 | 19.28 | 19.01 | 19.26 | 2800.0 |
> showing 50 of 3,034 rows — these rows as CSV