PREVIEW / stock_daily / 2002-05-17
file: by_date/stock_daily/2002/2002-05-17.parquet size: 107 KB rows: 3,104 symbols: 1,924
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-05-17 | AAPL | Stock | 0.4552 | 0.4604 | 0.4395 | 0.4466 | 236493600.0 |
| 2002-05-17 | MSFT | Stock | 28.105 | 28.2 | 27.635 | 28.015 | 54646200.0 |
| 2002-05-17 | NVDA | Stock | 0.325 | 0.3273 | 0.3169 | 0.3264 | 934404000.0 |
| 2002-05-17 | AMZN | Stock | 0.9985 | 1.0 | 0.9405 | 0.958 | 128938000.0 |
| 2002-05-17 | CL | Stock | 27.75 | 27.85 | 27.29 | 27.52 | 3671400.0 |
| 2002-05-17 | A | Stock | 21.2446 | 21.4878 | 20.3863 | 21.4664 | 5153727.0 |
| 2002-05-17 | AABA-DELISTED | Stock | 9.09500026702881 | 9.22500038146973 | 8.83500003814697 | 9.0 | 12264200.0 |
| 2002-05-17 | AAI-DELISTED | Stock | 6.01 | 6.19 | 5.92 | 6.05 | 254600.0 |
| 2002-05-17 | AAIC-DELISTED | Stock | 197.6 | 201.8 | 190.2 | 191.2 | 83500.0 |
| 2002-05-17 | AAME | Stock | 2.35 | 2.5 | 2.23 | 2.5 | 1600.0 |
| 2002-05-17 | AAON | Stock | 2.8023 | 2.8137 | 2.7567 | 2.7567 | 243759.0 |
| 2002-05-17 | AAP | Stock | 20.4667 | 20.5 | 20.3 | 20.3633 | 226800.0 |
| 2002-05-17 | AAXN-DELISTED | Stock | 1.25 | 1.28333330154419 | 1.22000002861023 | 1.2591667175293 | 332400.0 |
| 2002-05-17 | ABAX-DELISTED | Stock | 5.5307 | 5.6689 | 5.51 | 5.6689 | 2900.0 |
| 2002-05-17 | ABB-DELISTED | Stock | 9.6 | 9.63 | 9.52 | 9.52 | 5100.0 |
| 2002-05-17 | ABC-DELISTED | Stock | 19.1 | 19.43 | 18.98 | 19.4 | 4287200.0 |
| 2002-05-17 | ABCB | Stock | 11.5664 | 11.7608 | 11.5664 | 11.5907 | 94382.0 |
| 2002-05-17 | ABCO-DELISTED | Stock | 18.585 | 18.87 | 18.585 | 18.625 | 53200.0 |
| 2002-05-17 | ABCW-DELISTED | Stock | 22.78 | 23.1 | 22.0 | 22.07 | 17100.0 |
| 2002-05-17 | ABE-DELISTED | Stock | 7.55 | 7.6 | 7.5 | 7.56 | 6700.0 |
| 2002-05-17 | ABFS-DELISTED | Stock | 25.0 | 25.32 | 24.65 | 24.99 | 179000.0 |
| 2002-05-17 | ABG | Stock | 20.99 | 20.99 | 19.8 | 20.02 | 89100.0 |
| 2002-05-17 | ABK-DELISTED | Stock | 65.94 | 66.8 | 65.94 | 66.73 | 576100.0 |
| 2002-05-17 | ABM | Stock | 18.6 | 18.8 | 18.55 | 18.74 | 88900.0 |
| 2002-05-17 | ABMD-DELISTED | Stock | 7.15 | 7.45 | 6.5 | 6.85 | 123600.0 |
| 2002-05-17 | ABP-DELISTED | Stock | 0.95 | 0.97 | 0.88 | 0.9 | 39300.0 |
| 2002-05-17 | ABT | Stock | 20.2454 | 21.5383 | 20.2454 | 21.3677 | 21649768.0 |
| 2002-05-17 | ABTL-DELISTED | Stock | 18.75 | 18.75 | 17.5 | 18.65 | 7800.0 |
| 2002-05-17 | ABV-DELISTED | Stock | 19.6 | 19.6 | 19.11 | 19.22 | 253800.0 |
| 2002-05-17 | ABVA-DELISTED | Stock | 7.95 | 8.0 | 7.9 | 8.0 | 6100.0 |
| 2002-05-17 | ABX-DELISTED | Stock | 21.02 | 21.92 | 21.02 | 21.92 | 2932000.0 |
| 2002-05-17 | ACAP-DELISTED | Stock | 16.6 | 16.67 | 16.56 | 16.57 | 68500.0 |
| 2002-05-17 | ACAS-DELISTED | Stock | 30.32 | 30.68 | 30.25 | 30.5 | 244800.0 |
| 2002-05-17 | ACAT-DELISTED | Stock | 19.19 | 19.6 | 19.05 | 19.4 | 38100.0 |
| 2002-05-17 | ACCL-DELISTED | Stock | 7.92903995513916 | 8.34105968475342 | 7.92903995513916 | 8.34105968475342 | 195100.0 |
| 2002-05-17 | ACE-DELISTED | Stock | 33.39 | 33.45 | 32.38 | 33.36 | 3929200.0 |
| 2002-05-17 | ACF-DELISTED | Stock | 39.02 | 39.25 | 38.0 | 38.03 | 883900.0 |
| 2002-05-17 | ACG-DELISTED | Stock | 7.92 | 7.92 | 7.72 | 7.76 | 1265900.0 |
| 2002-05-17 | ACGL | Stock | 3.4111 | 3.4211 | 3.3889 | 3.3889 | 889200.0 |
| 2002-05-17 | ACGN-DELISTED | Stock | 1382.6712 | 1428.0 | 1360.0 | 1428.0 | 28100.0 |
| 2002-05-17 | ACH | Stock | 13.0333 | 13.1867 | 13.0 | 13.0667 | 138300.0 |
| 2002-05-17 | ACH-DELISTED | Stock | 4.938 | 5.0255 | 4.938 | 4.988 | 47998.0 |
| 2002-05-17 | ACLS | Stock | 60.72 | 61.0 | 57.6 | 59.12 | 187550.0 |
| 2002-05-17 | ACO-DELISTED | Stock | 6.1 | 6.2 | 6.0 | 6.0 | 23600.0 |
| 2002-05-17 | ACPW-DELISTED | Stock | 20.6 | 21.79 | 20.25 | 21.35 | 18232.0 |
| 2002-05-17 | ACS-DELISTED | Stock | 54.0 | 55.24 | 53.84 | 55.02 | 1288900.0 |
| 2002-05-17 | ACTA-DELISTED | Stock | 6.6 | 7.2 | 6.4 | 6.4 | 51000.0 |
| 2002-05-17 | ACTT-DELISTED | Stock | 4.05 | 4.1 | 3.85 | 4.0 | 90100.0 |
| 2002-05-17 | ACTU-DELISTED | Stock | 5.54 | 6.0 | 5.5 | 5.96 | 209300.0 |
| 2002-05-17 | ACXM-DELISTED | Stock | 16.805 | 17.305 | 16.545 | 17.305 | 882256.0 |
> showing 50 of 3,104 rows — these rows as CSV