PREVIEW / stock_daily / 2002-01-18
file: by_date/stock_daily/2002/2002-01-18.parquet size: 104 KB rows: 3,038 symbols: 1,885
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-01-18 | AAPL | Stock | 0.3929 | 0.4036 | 0.3921 | 0.3959 | 338811200.0 |
| 2002-01-18 | MSFT | Stock | 33.55 | 33.925 | 32.71 | 33.05 | 107140400.0 |
| 2002-01-18 | NVDA | Stock | 0.5212 | 0.5354 | 0.5208 | 0.5317 | 803676000.0 |
| 2002-01-18 | AMZN | Stock | 0.48 | 0.5275 | 0.4695 | 0.508 | 229870000.0 |
| 2002-01-18 | CL | Stock | 28.45 | 28.65 | 28.35 | 28.575 | 1947600.0 |
| 2002-01-18 | A | Stock | 20.6152 | 20.7225 | 20.2003 | 20.372 | 2725261.0 |
| 2002-01-18 | AABA-DELISTED | Stock | 9.82999992370605 | 9.98999977111816 | 9.47500038146973 | 9.60000038146973 | 35842800.0 |
| 2002-01-18 | AAI-DELISTED | Stock | 6.7 | 6.93 | 6.61 | 6.85 | 221000.0 |
| 2002-01-18 | AAIC-DELISTED | Stock | 119.6 | 120.0 | 114.4 | 115.2 | 40500.0 |
| 2002-01-18 | AAME | Stock | 2.41 | 2.44 | 2.41 | 2.42 | 9000.0 |
| 2002-01-18 | AAON | Stock | 1.7997 | 1.7997 | 1.7558 | 1.7558 | 20503.0 |
| 2002-01-18 | AAP | Stock | 15.7 | 16.0 | 15.5667 | 15.7667 | 70500.0 |
| 2002-01-18 | AAXN-DELISTED | Stock | 1.43416666984558 | 1.43416666984558 | 1.40499997138977 | 1.40916669368744 | 500400.0 |
| 2002-01-18 | ABAX-DELISTED | Stock | 5.61 | 5.7 | 5.6 | 5.69 | 14400.0 |
| 2002-01-18 | ABB-DELISTED | Stock | 10.08 | 10.1 | 9.9 | 9.9 | 15900.0 |
| 2002-01-18 | ABC-DELISTED | Stock | 14.28 | 14.68 | 14.2 | 14.21 | 4298800.0 |
| 2002-01-18 | ABCB | Stock | 11.1043 | 11.1043 | 11.0638 | 11.0638 | 10980.0 |
| 2002-01-18 | ABCO-DELISTED | Stock | 14.225 | 14.56 | 14.175 | 14.49 | 148200.0 |
| 2002-01-18 | ABCW-DELISTED | Stock | 17.34 | 17.45 | 17.04 | 17.05 | 13800.0 |
| 2002-01-18 | ABE-DELISTED | Stock | 7.07 | 7.17 | 7.02 | 7.02 | 25800.0 |
| 2002-01-18 | ABFS-DELISTED | Stock | 28.44 | 28.87 | 27.75 | 27.96 | 96100.0 |
| 2002-01-18 | ABK-DELISTED | Stock | 58.4 | 59.8 | 58.3 | 58.94 | 350900.0 |
| 2002-01-18 | ABM | Stock | 14.75 | 14.805 | 14.325 | 14.355 | 121200.0 |
| 2002-01-18 | ABMD-DELISTED | Stock | 14.47 | 15.0 | 13.5 | 13.65 | 98200.0 |
| 2002-01-18 | ABP-DELISTED | Stock | 1.33 | 1.33 | 1.25 | 1.29 | 39000.0 |
| 2002-01-18 | ABT | Stock | 25.7041 | 25.9195 | 25.6233 | 25.7714 | 11701692.0 |
| 2002-01-18 | ABTL-DELISTED | Stock | 14.95 | 16.0 | 14.4 | 15.25 | 63900.0 |
| 2002-01-18 | ABV-DELISTED | Stock | 20.28 | 20.44 | 20.0 | 20.3 | 430500.0 |
| 2002-01-18 | ABVA-DELISTED | Stock | 8.0 | 8.5 | 8.0 | 8.5 | 13100.0 |
| 2002-01-18 | ABX-DELISTED | Stock | 17.03 | 17.03 | 16.73 | 16.8 | 2174600.0 |
| 2002-01-18 | ACAP-DELISTED | Stock | 20.03 | 20.03 | 19.44 | 19.45 | 14600.0 |
| 2002-01-18 | ACAS-DELISTED | Stock | 28.15 | 28.25 | 27.47 | 27.59 | 414000.0 |
| 2002-01-18 | ACAT-DELISTED | Stock | 16.3 | 16.66 | 16.3 | 16.5 | 38200.0 |
| 2002-01-18 | ACCL-DELISTED | Stock | 10.0724000930786 | 11.0065002441406 | 9.92035007476807 | 11.0065002441406 | 1677100.0 |
| 2002-01-18 | ACE-DELISTED | Stock | 35.3 | 35.94 | 35.14 | 35.86 | 2319100.0 |
| 2002-01-18 | ACF-DELISTED | Stock | 20.91 | 21.6 | 20.15 | 21.5 | 3025300.0 |
| 2002-01-18 | ACG-DELISTED | Stock | 7.65 | 7.67 | 7.62 | 7.65 | 723500.0 |
| 2002-01-18 | ACGL | Stock | 2.8567 | 2.8756 | 2.8111 | 2.8111 | 36900.0 |
| 2002-01-18 | ACGN-DELISTED | Stock | 1983.3288 | 1994.6712 | 1926.6712 | 1989.0 | 52900.0 |
| 2002-01-18 | ACH | Stock | 12.7333 | 12.9 | 12.5667 | 12.8 | 120450.0 |
| 2002-01-18 | ACH-DELISTED | Stock | 4.7125 | 4.7125 | 4.6 | 4.675 | 63200.0 |
| 2002-01-18 | ACLS | Stock | 52.64 | 53.2 | 51.68 | 52.64 | 292650.0 |
| 2002-01-18 | ACO-DELISTED | Stock | 7.23 | 7.23 | 7.0 | 7.0 | 16100.0 |
| 2002-01-18 | ACPW-DELISTED | Stock | 30.0 | 30.05 | 27.6 | 27.6 | 54592.0 |
| 2002-01-18 | ACS-DELISTED | Stock | 53.935 | 54.15 | 53.5 | 54.04 | 484900.0 |
| 2002-01-18 | ACTA-DELISTED | Stock | 24.4 | 24.4 | 23.0 | 23.6 | 48200.0 |
| 2002-01-18 | ACTT-DELISTED | Stock | 7.705 | 7.75 | 7.41 | 7.6 | 55600.0 |
| 2002-01-18 | ACTU-DELISTED | Stock | 6.15 | 6.7 | 6.0 | 6.47 | 2028400.0 |
| 2002-01-18 | ACXM-DELISTED | Stock | 17.37 | 17.47 | 16.75 | 17.1 | 694200.0 |
| 2002-01-18 | ACY-DELISTED | Stock | 4.7 | 4.8 | 4.7 | 4.7 | 800.0 |
> showing 50 of 3,038 rows — these rows as CSV