PREVIEW / stock_daily / 2002-11-27
file: by_date/stock_daily/2002/2002-11-27.parquet size: 110 KB rows: 3,260 symbols: 2,014
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-27 | AAPL | Stock | 0.2786 | 0.2832 | 0.2759 | 0.2807 | 286798400.0 |
| 2002-11-27 | MSFT | Stock | 28.8 | 29.305 | 28.7 | 29.04 | 55191800.0 |
| 2002-11-27 | NVDA | Stock | 0.1377 | 0.1447 | 0.1359 | 0.1423 | 1088556000.0 |
| 2002-11-27 | AMZN | Stock | 1.186 | 1.212 | 1.1855 | 1.204 | 113320000.0 |
| 2002-11-27 | CL | Stock | 25.575 | 26.25 | 25.475 | 25.95 | 3061800.0 |
| 2002-11-27 | A | Stock | 13.5551 | 14.02 | 13.4907 | 14.0057 | 2473062.0 |
| 2002-11-27 | AABA-DELISTED | Stock | 9.16499996185303 | 9.29500007629395 | 9.08500003814697 | 9.19499969482422 | 12832400.0 |
| 2002-11-27 | AAI-DELISTED | Stock | 3.85 | 3.99 | 3.77 | 3.9 | 175700.0 |
| 2002-11-27 | AAIC-DELISTED | Stock | 180.0 | 185.0 | 179.8 | 183.6 | 223800.0 |
| 2002-11-27 | AAME | Stock | 1.55 | 1.6 | 1.55 | 1.6 | 1100.0 |
| 2002-11-27 | AAON | Stock | 2.6166 | 2.6469 | 2.6021 | 2.6469 | 63787.0 |
| 2002-11-27 | AAP | Stock | 16.7 | 17.3033 | 16.51 | 17.3033 | 1476600.0 |
| 2002-11-27 | AAXN-DELISTED | Stock | 0.329166680574417 | 0.333333343267441 | 0.321666657924652 | 0.329166680574417 | 217200.0 |
| 2002-11-27 | ABAX-DELISTED | Stock | 4.13 | 4.239 | 4.1 | 4.18 | 12200.0 |
| 2002-11-27 | ABB-DELISTED | Stock | 3.05 | 3.19 | 3.05 | 3.13 | 165900.0 |
| 2002-11-27 | ABC-DELISTED | Stock | 14.72 | 14.79 | 14.32 | 14.62 | 6315600.0 |
| 2002-11-27 | ABCB | Stock | 10.4154 | 10.7396 | 10.4154 | 10.7396 | 8266.0 |
| 2002-11-27 | ABCO-DELISTED | Stock | 15.555 | 15.625 | 15.475 | 15.57 | 45200.0 |
| 2002-11-27 | ABCW-DELISTED | Stock | 20.43 | 20.7 | 20.3 | 20.54 | 25170.0 |
| 2002-11-27 | ABE-DELISTED | Stock | 6.0 | 6.19 | 6.0 | 6.18 | 15300.0 |
| 2002-11-27 | ABFS-DELISTED | Stock | 28.55 | 29.75 | 28.45 | 29.48 | 201217.0 |
| 2002-11-27 | ABG | Stock | 8.95 | 9.5 | 8.95 | 9.32 | 33400.0 |
| 2002-11-27 | ABK-DELISTED | Stock | 60.05 | 61.71 | 59.88 | 61.53 | 503400.0 |
| 2002-11-27 | ABM | Stock | 15.15 | 15.36 | 14.84 | 15.34 | 119200.0 |
| 2002-11-27 | ABMD-DELISTED | Stock | 5.15 | 5.15 | 5.0 | 5.11 | 25800.0 |
| 2002-11-27 | ABP-DELISTED | Stock | 0.73 | 0.83 | 0.71 | 0.79 | 130400.0 |
| 2002-11-27 | ABT | Stock | 19.4643 | 19.8639 | 19.3656 | 19.5721 | 5320996.0 |
| 2002-11-27 | ABTL-DELISTED | Stock | 14.95 | 15.25 | 14.25 | 15.25 | 22300.0 |
| 2002-11-27 | ABV-DELISTED | Stock | 15.03 | 15.2 | 14.9 | 15.0 | 154600.0 |
| 2002-11-27 | ABX-DELISTED | Stock | 14.5 | 14.63 | 14.03 | 14.57 | 3518869.0 |
| 2002-11-27 | ACAP-DELISTED | Stock | 18.49 | 18.49 | 18.23 | 18.47 | 60200.0 |
| 2002-11-27 | ACAS-DELISTED | Stock | 21.06 | 21.31 | 20.46 | 21.23 | 741831.0 |
| 2002-11-27 | ACAT-DELISTED | Stock | 16.05 | 16.2 | 15.96 | 16.15 | 38683.0 |
| 2002-11-27 | ACCL-DELISTED | Stock | 7.48999977111816 | 7.49499988555908 | 7.20499992370605 | 7.24100017547607 | 106100.0 |
| 2002-11-27 | ACE-DELISTED | Stock | 32.73 | 33.51 | 32.62 | 33.4 | 594000.0 |
| 2002-11-27 | ACF-DELISTED | Stock | 8.52 | 8.8 | 8.3 | 8.48 | 2193600.0 |
| 2002-11-27 | ACG-DELISTED | Stock | 8.2 | 8.2 | 8.15 | 8.16 | 364100.0 |
| 2002-11-27 | ACGL | Stock | 3.3122 | 3.3333 | 3.3111 | 3.3222 | 662400.0 |
| 2002-11-27 | ACGN-DELISTED | Stock | 1122.0 | 1122.0 | 1065.3288 | 1122.0 | 7000.0 |
| 2002-11-27 | ACH | Stock | 10.6733 | 10.9267 | 10.6667 | 10.9267 | 114300.0 |
| 2002-11-27 | ACH-DELISTED | Stock | 3.03 | 3.03 | 3.025 | 3.025 | 5191.0 |
| 2002-11-27 | ACLS | Stock | 32.4 | 34.64 | 32.2 | 34.64 | 284500.0 |
| 2002-11-27 | ACO-DELISTED | Stock | 5.8 | 6.0 | 5.8 | 6.0 | 30300.0 |
| 2002-11-27 | ACPW-DELISTED | Stock | 9.75 | 10.2 | 9.75 | 10.1 | 16979.0 |
| 2002-11-27 | ACS-DELISTED | Stock | 49.03 | 50.44 | 49.03 | 50.02 | 971300.0 |
| 2002-11-27 | ACTA-DELISTED | Stock | 13.8 | 13.8 | 12.0 | 13.0 | 246400.0 |
| 2002-11-27 | ACTT-DELISTED | Stock | 1.39 | 1.4 | 1.3 | 1.357 | 68600.0 |
| 2002-11-27 | ACTU-DELISTED | Stock | 2.45 | 2.55 | 2.39 | 2.54 | 135266.0 |
| 2002-11-27 | ACXM-DELISTED | Stock | 15.04 | 15.5 | 15.04 | 15.46 | 622227.0 |
| 2002-11-27 | AD | Stock | 19.4333 | 20.1333 | 19.4 | 20.1333 | 80850.0 |
> showing 50 of 3,260 rows — these rows as CSV