PREVIEW / stock_daily / 2002-11-06
file: by_date/stock_daily/2002/2002-11-06.parquet size: 109 KB rows: 3,220 symbols: 1,981
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-06 | AAPL | Stock | 0.305 | 0.3093 | 0.2982 | 0.3075 | 216389600.0 |
| 2002-11-06 | MSFT | Stock | 28.495 | 28.55 | 27.765 | 28.515 | 115407000.0 |
| 2002-11-06 | NVDA | Stock | 0.1294 | 0.135 | 0.1243 | 0.1348 | 1646016000.0 |
| 2002-11-06 | AMZN | Stock | 0.9385 | 0.9695 | 0.913 | 0.967 | 159468000.0 |
| 2002-11-06 | CL | Stock | 27.175 | 27.195 | 26.475 | 26.7 | 4871600.0 |
| 2002-11-06 | A | Stock | 10.7439 | 10.9442 | 10.422 | 10.701 | 2202829.0 |
| 2002-11-06 | AABA-DELISTED | Stock | 8.54500007629395 | 8.72000026702881 | 8.3100004196167 | 8.6899995803833 | 50040000.0 |
| 2002-11-06 | AAI-DELISTED | Stock | 4.16 | 4.48 | 4.16 | 4.47 | 474900.0 |
| 2002-11-06 | AAIC-DELISTED | Stock | 199.0 | 199.0 | 193.8 | 194.4 | 20400.0 |
| 2002-11-06 | AAME | Stock | 1.77 | 1.8 | 1.77 | 1.8 | 1200.0 |
| 2002-11-06 | AAON | Stock | 2.6008 | 2.6008 | 2.4309 | 2.589 | 191362.0 |
| 2002-11-06 | AAP | Stock | 17.55 | 17.6333 | 17.3367 | 17.4 | 663600.0 |
| 2002-11-06 | AAXN-DELISTED | Stock | 0.299166679382324 | 0.300000011920929 | 0.28833332657814 | 0.295833319425583 | 152400.0 |
| 2002-11-06 | ABAX-DELISTED | Stock | 4.06 | 4.15 | 4.06 | 4.11 | 2900.0 |
| 2002-11-06 | ABB-DELISTED | Stock | 2.03 | 2.1 | 1.9 | 2.1 | 922600.0 |
| 2002-11-06 | ABC-DELISTED | Stock | 17.28 | 17.84 | 17.28 | 17.82 | 8974063.0 |
| 2002-11-06 | ABCB | Stock | 11.2908 | 11.4609 | 11.0881 | 11.4123 | 12708.0 |
| 2002-11-06 | ABCO-DELISTED | Stock | 16.695 | 16.935 | 16.575 | 16.87 | 94800.0 |
| 2002-11-06 | ABCW-DELISTED | Stock | 21.37 | 21.7 | 20.88 | 21.14 | 22870.0 |
| 2002-11-06 | ABE-DELISTED | Stock | 5.84 | 5.85 | 5.75 | 5.75 | 13400.0 |
| 2002-11-06 | ABFS-DELISTED | Stock | 30.0 | 30.04 | 29.61 | 30.0 | 175092.0 |
| 2002-11-06 | ABG | Stock | 9.0 | 9.48 | 9.0 | 9.47 | 125400.0 |
| 2002-11-06 | ABK-DELISTED | Stock | 60.31 | 60.31 | 58.65 | 60.13 | 1465500.0 |
| 2002-11-06 | ABM | Stock | 14.6 | 14.97 | 14.6 | 14.8 | 128200.0 |
| 2002-11-06 | ABMD-DELISTED | Stock | 3.74 | 3.83 | 3.5 | 3.819 | 69000.0 |
| 2002-11-06 | ABP-DELISTED | Stock | 0.69 | 0.72 | 0.6 | 0.62 | 114000.0 |
| 2002-11-06 | ABT | Stock | 19.7516 | 20.6046 | 19.7516 | 20.4474 | 15386025.0 |
| 2002-11-06 | ABTL-DELISTED | Stock | 11.75 | 12.0 | 11.6 | 11.65 | 24500.0 |
| 2002-11-06 | ABV-DELISTED | Stock | 14.35 | 14.35 | 13.73 | 14.01 | 130900.0 |
| 2002-11-06 | ABX-DELISTED | Stock | 16.0 | 16.42 | 15.79 | 16.37 | 2243100.0 |
| 2002-11-06 | ACAP-DELISTED | Stock | 15.4 | 16.01 | 15.4 | 15.76 | 91000.0 |
| 2002-11-06 | ACAS-DELISTED | Stock | 20.43 | 21.25 | 19.5 | 20.55 | 951441.0 |
| 2002-11-06 | ACAT-DELISTED | Stock | 15.64 | 16.2 | 15.1 | 15.94 | 37000.0 |
| 2002-11-06 | ACCL-DELISTED | Stock | 7.16147994995117 | 7.58869981765747 | 7.16147994995117 | 7.58869981765747 | 34400.0 |
| 2002-11-06 | ACE-DELISTED | Stock | 31.65 | 31.84 | 30.2 | 31.84 | 2877531.0 |
| 2002-11-06 | ACF-DELISTED | Stock | 8.2 | 8.38 | 7.98 | 8.27 | 2229500.0 |
| 2002-11-06 | ACG-DELISTED | Stock | 8.0 | 8.06 | 8.0 | 8.04 | 309600.0 |
| 2002-11-06 | ACGL | Stock | 3.0744 | 3.13 | 3.0744 | 3.1078 | 805500.0 |
| 2002-11-06 | ACGN-DELISTED | Stock | 1144.6712 | 1303.3288 | 1088.0 | 1303.3288 | 103400.0 |
| 2002-11-06 | ACH | Stock | 10.0 | 10.4 | 9.9267 | 10.4 | 378150.0 |
| 2002-11-06 | ACH-DELISTED | Stock | 2.9925 | 3.0 | 2.9925 | 3.0 | 7200.0 |
| 2002-11-06 | ACLS | Stock | 25.36 | 27.88 | 24.92 | 27.52 | 227975.0 |
| 2002-11-06 | ACO-DELISTED | Stock | 5.83 | 6.0 | 5.83 | 5.96 | 8500.0 |
| 2002-11-06 | ACPW-DELISTED | Stock | 10.1 | 10.25 | 9.5 | 10.2 | 9600.0 |
| 2002-11-06 | ACS-DELISTED | Stock | 48.65 | 50.0 | 48.15 | 49.7 | 1375000.0 |
| 2002-11-06 | ACTA-DELISTED | Stock | 7.6 | 8.0 | 7.2 | 7.6 | 77700.0 |
| 2002-11-06 | ACTT-DELISTED | Stock | 1.37 | 1.57 | 1.33 | 1.55 | 112155.0 |
| 2002-11-06 | ACTU-DELISTED | Stock | 2.25 | 2.48 | 2.16 | 2.4 | 451287.0 |
| 2002-11-06 | ACXM-DELISTED | Stock | 14.55 | 14.56 | 13.7 | 14.36 | 1511012.0 |
| 2002-11-06 | ACY-DELISTED | Stock | 3.77 | 3.77 | 3.75 | 3.75 | 400.0 |
> showing 50 of 3,220 rows — these rows as CSV