PREVIEW / stock_daily / 2002-08-01
file: by_date/stock_daily/2002/2002-08-01.parquet size: 106 KB rows: 3,133 symbols: 1,945
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-08-01 | AAPL | Stock | 0.2698 | 0.2754 | 0.263 | 0.2643 | 228956000.0 |
| 2002-08-01 | MSFT | Stock | 23.79 | 24.045 | 22.75 | 22.875 | 92002800.0 |
| 2002-08-01 | NVDA | Stock | 0.093 | 0.093 | 0.0833 | 0.0834 | 1725708000.0 |
| 2002-08-01 | AMZN | Stock | 0.7155 | 0.725 | 0.6995 | 0.708 | 121336000.0 |
| 2002-08-01 | CL | Stock | 25.65 | 26.495 | 25.55 | 26.21 | 6087200.0 |
| 2002-08-01 | A | Stock | 13.2475 | 13.505 | 12.5894 | 12.7039 | 3884343.0 |
| 2002-08-01 | AABA-DELISTED | Stock | 6.53000020980835 | 6.53499984741211 | 6.05499982833862 | 6.07999992370605 | 16597800.0 |
| 2002-08-01 | AAI-DELISTED | Stock | 3.85 | 3.95 | 3.65 | 3.75 | 218400.0 |
| 2002-08-01 | AAIC-DELISTED | Stock | 211.0 | 213.0 | 198.0 | 200.0 | 181400.0 |
| 2002-08-01 | AAME | Stock | 2.05 | 2.2 | 1.91 | 1.91 | 2800.0 |
| 2002-08-01 | AAON | Stock | 2.2255 | 2.2281 | 2.1136 | 2.2044 | 107831.0 |
| 2002-08-01 | AAP | Stock | 16.67 | 16.67 | 15.8333 | 16.2 | 1403700.0 |
| 2002-08-01 | AAXN-DELISTED | Stock | 0.411666661500931 | 0.415833324193954 | 0.396666675806046 | 0.41499999165535 | 393600.0 |
| 2002-08-01 | ABAX-DELISTED | Stock | 3.6 | 3.63 | 3.5 | 3.63 | 6700.0 |
| 2002-08-01 | ABB-DELISTED | Stock | 5.02 | 5.1 | 4.95 | 5.04 | 68800.0 |
| 2002-08-01 | ABC-DELISTED | Stock | 16.8 | 16.86 | 16.25 | 16.31 | 4173600.0 |
| 2002-08-01 | ABCB | Stock | 11.5502 | 11.8662 | 11.0962 | 11.8662 | 3331.0 |
| 2002-08-01 | ABCO-DELISTED | Stock | 16.56 | 16.7 | 16.31 | 16.5 | 148825.0 |
| 2002-08-01 | ABCW-DELISTED | Stock | 22.05 | 22.07 | 21.81 | 21.91 | 57250.0 |
| 2002-08-01 | ABE-DELISTED | Stock | 6.37 | 6.37 | 6.15 | 6.25 | 10900.0 |
| 2002-08-01 | ABFS-DELISTED | Stock | 21.749 | 21.749 | 20.11 | 20.249 | 69401.0 |
| 2002-08-01 | ABG | Stock | 11.41 | 11.47 | 11.0 | 11.3 | 107000.0 |
| 2002-08-01 | ABK-DELISTED | Stock | 62.9 | 63.5 | 61.73 | 62.33 | 543300.0 |
| 2002-08-01 | ABM | Stock | 16.25 | 16.59 | 16.18 | 16.36 | 117500.0 |
| 2002-08-01 | ABMD-DELISTED | Stock | 6.63 | 6.86 | 6.08 | 6.299 | 22199.0 |
| 2002-08-01 | ABP-DELISTED | Stock | 0.55 | 0.55 | 0.5 | 0.52 | 38500.0 |
| 2002-08-01 | ABT | Stock | 18.5172 | 18.5845 | 17.6373 | 17.9156 | 11984160.0 |
| 2002-08-01 | ABTL-DELISTED | Stock | 10.85 | 10.85 | 10.1 | 10.5 | 3700.0 |
| 2002-08-01 | ABV-DELISTED | Stock | 12.28 | 13.5 | 12.05 | 13.27 | 666800.0 |
| 2002-08-01 | ABX-DELISTED | Stock | 14.55 | 15.53 | 14.55 | 15.51 | 3010502.0 |
| 2002-08-01 | ACAP-DELISTED | Stock | 15.99 | 16.1 | 15.94 | 16.1 | 102400.0 |
| 2002-08-01 | ACAS-DELISTED | Stock | 25.5 | 26.0 | 25.07 | 25.31 | 577630.0 |
| 2002-08-01 | ACAT-DELISTED | Stock | 14.59 | 14.99 | 13.9 | 14.43 | 33559.0 |
| 2002-08-01 | ACCL-DELISTED | Stock | 4.96016979217529 | 5.27082014083862 | 4.69877004623413 | 5.27082014083862 | 108700.0 |
| 2002-08-01 | ACE-DELISTED | Stock | 31.47 | 32.05 | 31.32 | 31.69 | 1788800.0 |
| 2002-08-01 | ACF-DELISTED | Stock | 19.54 | 19.55 | 18.1 | 18.76 | 2195500.0 |
| 2002-08-01 | ACG-DELISTED | Stock | 7.81 | 7.88 | 7.81 | 7.86 | 436700.0 |
| 2002-08-01 | ACGL | Stock | 2.9833 | 3.0378 | 2.9389 | 3.01 | 294300.0 |
| 2002-08-01 | ACH | Stock | 9.8667 | 10.4067 | 9.8467 | 10.0 | 173700.0 |
| 2002-08-01 | ACH-DELISTED | Stock | 3.9293 | 3.9742 | 3.9293 | 3.9642 | 50410.0 |
| 2002-08-01 | ACLS | Stock | 32.0 | 32.76 | 31.2 | 31.76 | 192150.0 |
| 2002-08-01 | ACO-DELISTED | Stock | 5.2 | 5.2 | 5.06 | 5.18 | 2000.0 |
| 2002-08-01 | ACPW-DELISTED | Stock | 11.478 | 11.522 | 11.128 | 11.522 | 11496.0 |
| 2002-08-01 | ACS-DELISTED | Stock | 46.98 | 46.98 | 44.99 | 45.26 | 1638700.0 |
| 2002-08-01 | ACTA-DELISTED | Stock | 4.8 | 4.8 | 4.2 | 4.2 | 18600.0 |
| 2002-08-01 | ACTT-DELISTED | Stock | 2.04 | 2.1 | 1.9 | 2.1 | 380100.0 |
| 2002-08-01 | ACTU-DELISTED | Stock | 2.0 | 2.14 | 1.95 | 2.0 | 473424.0 |
| 2002-08-01 | ACXM-DELISTED | Stock | 15.839 | 16.34 | 15.634 | 15.99 | 768728.0 |
| 2002-08-01 | AD | Stock | 17.4667 | 17.48 | 16.8 | 16.8867 | 113550.0 |
| 2002-08-01 | ADAT-DELISTED | Stock | 67.5 | 67.5 | 63.36 | 65.88 | 13147.0 |
> showing 50 of 3,133 rows — these rows as CSV