PREVIEW / stock_daily / 2002-03-19
file: by_date/stock_daily/2002/2002-03-19.parquet size: 106 KB rows: 3,091 symbols: 1,919
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-03-19 | AAPL | Stock | 0.4409 | 0.4518 | 0.4339 | 0.4438 | 242345600.0 |
| 2002-03-19 | MSFT | Stock | 31.09 | 31.5 | 30.75 | 31.115 | 36376400.0 |
| 2002-03-19 | NVDA | Stock | 0.4429 | 0.4437 | 0.4278 | 0.4304 | 846072000.0 |
| 2002-03-19 | AMZN | Stock | 0.7575 | 0.77 | 0.728 | 0.733 | 97874000.0 |
| 2002-03-19 | CL | Stock | 28.25 | 28.825 | 28.25 | 28.44 | 5880200.0 |
| 2002-03-19 | A | Stock | 26.5093 | 26.7454 | 25.9084 | 26.1803 | 3069868.0 |
| 2002-03-19 | AABA-DELISTED | Stock | 9.58500003814697 | 9.72500038146973 | 9.49499988555908 | 9.54500007629395 | 10785200.0 |
| 2002-03-19 | AAI-DELISTED | Stock | 6.51 | 6.52 | 6.4 | 6.46 | 137500.0 |
| 2002-03-19 | AAIC-DELISTED | Stock | 139.4 | 142.6 | 138.4 | 140.8 | 151300.0 |
| 2002-03-19 | AAME | Stock | 2.07 | 2.42 | 2.07 | 2.25 | 900.0 |
| 2002-03-19 | AAON | Stock | 2.1816 | 2.1816 | 2.1377 | 2.1684 | 240342.0 |
| 2002-03-19 | AAP | Stock | 14.7167 | 15.0333 | 14.6667 | 15.0 | 929400.0 |
| 2002-03-19 | AAXN-DELISTED | Stock | 1.55083334445953 | 1.55833327770233 | 1.50166666507721 | 1.5091667175293 | 1100400.0 |
| 2002-03-19 | ABAX-DELISTED | Stock | 6.31 | 6.44 | 6.28 | 6.3986 | 12300.0 |
| 2002-03-19 | ABB-DELISTED | Stock | 8.6 | 8.65 | 8.45 | 8.65 | 20600.0 |
| 2002-03-19 | ABC-DELISTED | Stock | 17.39 | 17.48 | 17.29 | 17.41 | 2520800.0 |
| 2002-03-19 | ABCB | Stock | 10.8612 | 11.3475 | 10.7477 | 10.7477 | 5182.0 |
| 2002-03-19 | ABCO-DELISTED | Stock | 14.89 | 14.99 | 14.76 | 14.83 | 74200.0 |
| 2002-03-19 | ABCW-DELISTED | Stock | 21.18 | 21.18 | 21.04 | 21.09 | 47700.0 |
| 2002-03-19 | ABE-DELISTED | Stock | 7.34 | 7.4 | 7.33 | 7.35 | 18900.0 |
| 2002-03-19 | ABFS-DELISTED | Stock | 28.95 | 28.95 | 25.6 | 26.5 | 779700.0 |
| 2002-03-19 | ABK-DELISTED | Stock | 59.3 | 59.4 | 58.13 | 58.63 | 641500.0 |
| 2002-03-19 | ABM | Stock | 16.95 | 17.325 | 16.95 | 17.325 | 176800.0 |
| 2002-03-19 | ABMD-DELISTED | Stock | 10.3 | 11.72 | 10.3 | 11.43 | 187600.0 |
| 2002-03-19 | ABP-DELISTED | Stock | 1.5 | 1.75 | 1.41 | 1.67 | 1113600.0 |
| 2002-03-19 | ABT | Stock | 24.3753 | 24.3753 | 23.8411 | 23.9623 | 8538188.0 |
| 2002-03-19 | ABTL-DELISTED | Stock | 15.15 | 16.5 | 14.8 | 16.1 | 119300.0 |
| 2002-03-19 | ABV-DELISTED | Stock | 19.7 | 20.15 | 19.7 | 20.05 | 325400.0 |
| 2002-03-19 | ABX-DELISTED | Stock | 18.15 | 18.24 | 17.8 | 17.96 | 2097300.0 |
| 2002-03-19 | ACAP-DELISTED | Stock | 17.91 | 18.2 | 17.91 | 18.05 | 50200.0 |
| 2002-03-19 | ACAS-DELISTED | Stock | 30.35 | 31.12 | 30.25 | 31.0 | 289600.0 |
| 2002-03-19 | ACAT-DELISTED | Stock | 18.55 | 18.7 | 17.0 | 17.82 | 138200.0 |
| 2002-03-19 | ACCL-DELISTED | Stock | 9.63070011138916 | 9.77552032470703 | 9.63070011138916 | 9.77552032470703 | 113100.0 |
| 2002-03-19 | ACE-DELISTED | Stock | 42.14 | 42.2 | 41.0 | 41.1 | 2138000.0 |
| 2002-03-19 | ACF-DELISTED | Stock | 37.99 | 39.07 | 37.8 | 38.9 | 1523600.0 |
| 2002-03-19 | ACG-DELISTED | Stock | 7.73 | 7.75 | 7.7 | 7.73 | 901500.0 |
| 2002-03-19 | ACGL | Stock | 2.9778 | 2.9778 | 2.9333 | 2.9344 | 404100.0 |
| 2002-03-19 | ACGN-DELISTED | Stock | 1734.0 | 1734.0 | 1609.3288 | 1609.3288 | 8000.0 |
| 2002-03-19 | ACH | Stock | 13.2333 | 13.5333 | 13.0667 | 13.32 | 917250.0 |
| 2002-03-19 | ACH-DELISTED | Stock | 5.387 | 5.412 | 5.367 | 5.367 | 92407.0 |
| 2002-03-19 | ACLS | Stock | 54.16 | 54.48 | 52.72 | 52.72 | 91500.0 |
| 2002-03-19 | ACO-DELISTED | Stock | 6.6 | 6.6 | 6.03 | 6.04 | 74000.0 |
| 2002-03-19 | ACPW-DELISTED | Stock | 23.23 | 23.97 | 21.58 | 23.42 | 46354.0 |
| 2002-03-19 | ACS-DELISTED | Stock | 56.75 | 56.76 | 55.52 | 56.0 | 1434600.0 |
| 2002-03-19 | ACTA-DELISTED | Stock | 17.4 | 18.0 | 16.4 | 16.8 | 34000.0 |
| 2002-03-19 | ACTT-DELISTED | Stock | 5.1 | 5.218 | 5.0 | 5.0 | 51500.0 |
| 2002-03-19 | ACTU-DELISTED | Stock | 6.56 | 6.77 | 6.37 | 6.65 | 366500.0 |
| 2002-03-19 | ACXM-DELISTED | Stock | 16.62 | 17.27 | 16.62 | 17.08 | 596700.0 |
| 2002-03-19 | ACY-DELISTED | Stock | 4.65 | 4.65 | 4.65 | 4.65 | 100.0 |
| 2002-03-19 | AD | Stock | 26.4 | 26.5 | 25.9533 | 26.1 | 106350.0 |
> showing 50 of 3,091 rows — these rows as CSV