PREVIEW / stock_daily / 2001-08-08
file: by_date/stock_daily/2001/2001-08-08.parquet size: 102 KB rows: 2,973 symbols: 1,850
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-08-08 | AAPL | Stock | 0.3439 | 0.3518 | 0.3311 | 0.3375 | 276169600.0 |
| 2001-08-08 | MSFT | Stock | 33.255 | 33.62 | 32.245 | 32.43 | 54996400.0 |
| 2001-08-08 | NVDA | Stock | 0.3655 | 0.375 | 0.3578 | 0.3594 | 1125696000.0 |
| 2001-08-08 | AMZN | Stock | 0.5755 | 0.5775 | 0.5515 | 0.5555 | 67468000.0 |
| 2001-08-08 | CL | Stock | 26.45 | 26.855 | 26.28 | 26.495 | 3010200.0 |
| 2001-08-08 | A | Stock | 21.2446 | 21.8884 | 20.6867 | 20.7082 | 3093774.0 |
| 2001-08-08 | AABA-DELISTED | Stock | 8.61499977111816 | 8.75 | 8.22000026702881 | 8.27499961853027 | 10008800.0 |
| 2001-08-08 | AAI-DELISTED | Stock | 8.75 | 8.89 | 8.55 | 8.6 | 376200.0 |
| 2001-08-08 | AAIC-DELISTED | Stock | 134.0 | 134.0 | 126.0 | 128.0 | 32600.0 |
| 2001-08-08 | AAME | Stock | 1.5 | 1.5 | 1.5 | 1.5 | 300.0 |
| 2001-08-08 | AAON | Stock | 1.771 | 1.8173 | 1.7558 | 1.7705 | 743238.0 |
| 2001-08-08 | AAXN-DELISTED | Stock | 0.537500023841858 | 0.5625 | 0.534166693687439 | 0.551666676998138 | 696000.0 |
| 2001-08-08 | ABAX-DELISTED | Stock | 5.13 | 5.18 | 5.12 | 5.17 | 3100.0 |
| 2001-08-08 | ABB-DELISTED | Stock | 11.2 | 11.5 | 11.2 | 11.4 | 20200.0 |
| 2001-08-08 | ABC-DELISTED | Stock | 13.9499998092651 | 14.0150003433228 | 13.8249998092651 | 13.8649997711182 | 2318800.0 |
| 2001-08-08 | ABCB | Stock | 10.5775 | 10.5775 | 10.5775 | 10.5775 | 1234.0 |
| 2001-08-08 | ABCW-DELISTED | Stock | 16.72 | 16.97 | 16.64 | 16.8 | 76400.0 |
| 2001-08-08 | ABE-DELISTED | Stock | 7.61 | 7.64 | 7.53 | 7.53 | 15200.0 |
| 2001-08-08 | ABFS-DELISTED | Stock | 25.91 | 26.1 | 24.45 | 24.66 | 235300.0 |
| 2001-08-08 | ABK-DELISTED | Stock | 57.95 | 57.99 | 57.31 | 57.45 | 205400.0 |
| 2001-08-08 | ABM | Stock | 18.025 | 18.3 | 18.025 | 18.15 | 54600.0 |
| 2001-08-08 | ABMD-DELISTED | Stock | 19.0 | 19.2 | 18.25 | 18.4 | 68300.0 |
| 2001-08-08 | ABP-DELISTED | Stock | 3.26 | 3.26 | 3.11 | 3.13 | 56800.0 |
| 2001-08-08 | ABT | Stock | 23.6077 | 23.6795 | 23.1768 | 23.2845 | 3650695.0 |
| 2001-08-08 | ABTL-DELISTED | Stock | 4.85 | 4.9 | 4.35 | 4.6 | 24100.0 |
| 2001-08-08 | ABV-DELISTED | Stock | 20.65 | 21.0 | 20.6 | 20.87 | 301700.0 |
| 2001-08-08 | ABX-DELISTED | Stock | 14.68 | 15.32 | 14.62 | 15.25 | 2370500.0 |
| 2001-08-08 | ACAP-DELISTED | Stock | 21.05 | 21.05 | 20.34 | 20.53 | 48700.0 |
| 2001-08-08 | ACAS-DELISTED | Stock | 27.4 | 27.5 | 26.51 | 26.9 | 207800.0 |
| 2001-08-08 | ACAT-DELISTED | Stock | 15.24 | 15.75 | 15.24 | 15.25 | 48400.0 |
| 2001-08-08 | ACCL-DELISTED | Stock | 12.2375001907349 | 12.3823003768921 | 12.0058002471924 | 12.3823003768921 | 388600.0 |
| 2001-08-08 | ACE-DELISTED | Stock | 35.95 | 36.0 | 35.2 | 35.51 | 1095400.0 |
| 2001-08-08 | ACF-DELISTED | Stock | 61.55 | 62.35 | 59.91 | 60.1 | 1948500.0 |
| 2001-08-08 | ACG-DELISTED | Stock | 8.77 | 8.8 | 8.76 | 8.79 | 223800.0 |
| 2001-08-08 | ACGN-DELISTED | Stock | 1156.0 | 1156.0 | 929.3288 | 929.3288 | 11100.0 |
| 2001-08-08 | ACH | Stock | 11.9667 | 12.1733 | 11.8667 | 12.02 | 55200.0 |
| 2001-08-08 | ACLS | Stock | 54.84 | 56.56 | 51.4 | 51.92 | 263250.0 |
| 2001-08-08 | ACO-DELISTED | Stock | 6.2 | 6.21 | 6.15 | 6.15 | 19500.0 |
| 2001-08-08 | ACPW-DELISTED | Stock | 39.0 | 40.7 | 38.25 | 39.15 | 46340.0 |
| 2001-08-08 | ACS-DELISTED | Stock | 39.275 | 39.375 | 38.7 | 39.2 | 446700.0 |
| 2001-08-08 | ACTA-DELISTED | Stock | 28.6 | 28.8 | 26.6 | 27.2 | 42400.0 |
| 2001-08-08 | ACTT-DELISTED | Stock | 5.45 | 5.45 | 5.24 | 5.25 | 10500.0 |
| 2001-08-08 | ACTU-DELISTED | Stock | 9.0 | 9.29 | 9.0 | 9.07 | 144100.0 |
| 2001-08-08 | ACXM-DELISTED | Stock | 10.82 | 11.46 | 10.71 | 11.16 | 1621400.0 |
| 2001-08-08 | ACY-DELISTED | Stock | 5.49 | 5.65 | 5.49 | 5.65 | 2200.0 |
| 2001-08-08 | AD | Stock | 38.9333 | 40.0667 | 38.2667 | 38.2667 | 256500.0 |
| 2001-08-08 | ADAT-DELISTED | Stock | 87.3 | 88.92 | 81.0 | 84.6 | 766.0 |
| 2001-08-08 | ADBE | Stock | 17.125 | 17.87 | 16.85 | 17.03 | 8426000.0 |
| 2001-08-08 | ADC | Stock | 19.46 | 19.56 | 19.45 | 19.56 | 1100.0 |
| 2001-08-08 | ADEP-DELISTED | Stock | 37.5 | 39.7 | 35.0 | 36.7 | 9900.0 |
> showing 50 of 2,973 rows — these rows as CSV