PREVIEW / stock_daily / 2001-07-20
file: by_date/stock_daily/2001/2001-07-20.parquet size: 101 KB rows: 2,942 symbols: 1,824
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-07-20 | AAPL | Stock | 0.3518 | 0.3582 | 0.348 | 0.3568 | 444584000.0 |
| 2001-07-20 | MSFT | Stock | 34.015 | 34.7 | 33.97 | 34.59 | 124203600.0 |
| 2001-07-20 | NVDA | Stock | 0.3133 | 0.3204 | 0.3021 | 0.312 | 742464000.0 |
| 2001-07-20 | AMZN | Stock | 0.8265 | 0.8625 | 0.8225 | 0.849 | 74714000.0 |
| 2001-07-20 | CL | Stock | 27.7 | 28.075 | 27.7 | 27.905 | 2849800.0 |
| 2001-07-20 | A | Stock | 20.5365 | 21.0157 | 19.9571 | 20.6724 | 2055619.0 |
| 2001-07-20 | AABA-DELISTED | Stock | 8.64000034332275 | 9.02499961853027 | 8.63500022888184 | 8.97000026702881 | 17394400.0 |
| 2001-07-20 | AAI-DELISTED | Stock | 9.0 | 9.1 | 8.95 | 9.0 | 339400.0 |
| 2001-07-20 | AAIC-DELISTED | Stock | 137.0 | 138.0 | 136.6 | 136.8 | 7000.0 |
| 2001-07-20 | AAME | Stock | 1.5 | 1.55 | 1.5 | 1.55 | 29200.0 |
| 2001-07-20 | AAON | Stock | 1.6973 | 1.7324 | 1.6938 | 1.7318 | 967064.0 |
| 2001-07-20 | AAXN-DELISTED | Stock | 0.479166656732559 | 0.479166656732559 | 0.466666668653488 | 0.466666668653488 | 42000.0 |
| 2001-07-20 | ABAX-DELISTED | Stock | 5.4 | 5.4 | 5.3 | 5.3 | 13200.0 |
| 2001-07-20 | ABB-DELISTED | Stock | 13.99 | 13.99 | 13.78 | 13.78 | 11900.0 |
| 2001-07-20 | ABC-DELISTED | Stock | 14.3625001907349 | 14.4650001525879 | 14.2624998092651 | 14.4650001525879 | 1523600.0 |
| 2001-07-20 | ABCB | Stock | 9.8561 | 9.8561 | 9.8561 | 9.8561 | 987.0 |
| 2001-07-20 | ABCW-DELISTED | Stock | 15.64 | 15.7 | 15.58 | 15.69 | 251400.0 |
| 2001-07-20 | ABE-DELISTED | Stock | 7.7 | 7.7 | 7.63 | 7.63 | 11400.0 |
| 2001-07-20 | ABFS-DELISTED | Stock | 27.25 | 28.01 | 27.05 | 27.34 | 397400.0 |
| 2001-07-20 | ABK-DELISTED | Stock | 57.95 | 58.2 | 56.41 | 57.1 | 481700.0 |
| 2001-07-20 | ABM | Stock | 18.75 | 19.0 | 18.7 | 19.0 | 60400.0 |
| 2001-07-20 | ABMD-DELISTED | Stock | 19.53 | 20.1 | 19.08 | 20.0 | 72300.0 |
| 2001-07-20 | ABP-DELISTED | Stock | 3.47 | 3.47 | 3.09 | 3.32 | 76700.0 |
| 2001-07-20 | ABT | Stock | 23.3114 | 23.5628 | 23.1184 | 23.4685 | 6718410.0 |
| 2001-07-20 | ABTL-DELISTED | Stock | 5.5 | 5.75 | 5.4 | 5.55 | 4900.0 |
| 2001-07-20 | ABV-DELISTED | Stock | 20.3 | 20.7 | 20.3 | 20.62 | 239000.0 |
| 2001-07-20 | ABX-DELISTED | Stock | 15.64 | 15.65 | 15.55 | 15.6 | 1901800.0 |
| 2001-07-20 | ACAP-DELISTED | Stock | 19.17 | 19.25 | 19.0 | 19.08 | 61100.0 |
| 2001-07-20 | ACAS-DELISTED | Stock | 27.45 | 27.7 | 27.05 | 27.49 | 156700.0 |
| 2001-07-20 | ACAT-DELISTED | Stock | 14.62 | 14.73 | 14.55 | 14.58 | 17500.0 |
| 2001-07-20 | ACCL-DELISTED | Stock | 12.1731004714966 | 12.4540004730225 | 12.1731004714966 | 12.4540004730225 | 37700.0 |
| 2001-07-20 | ACE-DELISTED | Stock | 33.95 | 34.15 | 33.6 | 33.76 | 1690900.0 |
| 2001-07-20 | ACF-DELISTED | Stock | 58.3 | 58.95 | 58.0 | 58.94 | 936200.0 |
| 2001-07-20 | ACG-DELISTED | Stock | 8.72 | 8.75 | 8.62 | 8.67 | 247800.0 |
| 2001-07-20 | ACGL | Stock | 1.8944 | 1.99 | 1.8944 | 1.99 | 9900.0 |
| 2001-07-20 | ACGN-DELISTED | Stock | 1190.0 | 1190.0 | 929.3288 | 997.3288 | 134300.0 |
| 2001-07-20 | ACH | Stock | 12.3333 | 12.9667 | 12.1667 | 12.9067 | 163350.0 |
| 2001-07-20 | ACLS | Stock | 55.68 | 57.24 | 52.44 | 55.44 | 93775.0 |
| 2001-07-20 | ACO-DELISTED | Stock | 5.88 | 5.94 | 5.8 | 5.94 | 41000.0 |
| 2001-07-20 | ACPW-DELISTED | Stock | 47.45 | 47.8 | 38.45 | 39.75 | 985960.0 |
| 2001-07-20 | ACS-DELISTED | Stock | 40.405 | 41.56 | 40.125 | 40.275 | 1432300.0 |
| 2001-07-20 | ACTA-DELISTED | Stock | 30.0 | 32.4 | 29.0 | 32.0 | 35800.0 |
| 2001-07-20 | ACTT-DELISTED | Stock | 6.05 | 6.05 | 5.69 | 5.69 | 10800.0 |
| 2001-07-20 | ACTU-DELISTED | Stock | 8.46 | 9.31 | 8.45 | 9.08 | 537200.0 |
| 2001-07-20 | ACXM-DELISTED | Stock | 10.87 | 11.49 | 10.58 | 10.87 | 558500.0 |
| 2001-07-20 | ACY-DELISTED | Stock | 4.95 | 5.0 | 4.93 | 5.0 | 3800.0 |
| 2001-07-20 | AD | Stock | 38.1667 | 38.4467 | 37.8 | 37.8667 | 76500.0 |
| 2001-07-20 | ADAT-DELISTED | Stock | 90.54 | 91.44 | 89.1 | 91.44 | 1990.0 |
| 2001-07-20 | ADBE | Stock | 20.575 | 21.12 | 20.145 | 20.345 | 4848000.0 |
| 2001-07-20 | ADC | Stock | 19.31 | 19.55 | 19.31 | 19.55 | 8000.0 |
> showing 50 of 2,942 rows — these rows as CSV