PREVIEW / stock_daily / 2002-03-14
file: by_date/stock_daily/2002/2002-03-14.parquet size: 106 KB rows: 3,084 symbols: 1,917
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-14 | AAPL | Stock | 0.4339 | 0.4393 | 0.4263 | 0.4363 | 217296800.0 |
| 2002-03-14 | MSFT | Stock | 31.07 | 31.12 | 30.525 | 30.61 | 51819600.0 |
| 2002-03-14 | NVDA | Stock | 0.4433 | 0.4433 | 0.421 | 0.4219 | 1139460000.0 |
| 2002-03-14 | AMZN | Stock | 0.7495 | 0.775 | 0.714 | 0.724 | 303386000.0 |
| 2002-03-14 | CL | Stock | 27.4 | 27.455 | 27.25 | 27.275 | 2544200.0 |
| 2002-03-14 | A | Stock | 25.5365 | 25.7153 | 25.3219 | 25.5079 | 3553856.0 |
| 2002-03-14 | AABA-DELISTED | Stock | 9.52000045776367 | 9.69499969482422 | 9.44999980926514 | 9.61499977111816 | 11820400.0 |
| 2002-03-14 | AAI-DELISTED | Stock | 6.55 | 6.6 | 6.39 | 6.57 | 174300.0 |
| 2002-03-14 | AAIC-DELISTED | Stock | 136.6 | 136.6 | 130.0 | 130.0 | 233300.0 |
| 2002-03-14 | AAME | Stock | 2.42 | 2.42 | 2.07 | 2.07 | 23000.0 |
| 2002-03-14 | AAON | Stock | 2.1605 | 2.2053 | 2.1605 | 2.1904 | 75178.0 |
| 2002-03-14 | AAP | Stock | 14.0 | 14.4 | 13.9667 | 14.3667 | 2705400.0 |
| 2002-03-14 | AAXN-DELISTED | Stock | 1.36416661739349 | 1.36416661739349 | 1.34583330154419 | 1.34666669368744 | 441600.0 |
| 2002-03-14 | ABAX-DELISTED | Stock | 6.65 | 6.69 | 6.46 | 6.48 | 32600.0 |
| 2002-03-14 | ABB-DELISTED | Stock | 8.46 | 8.65 | 8.45 | 8.6 | 7000.0 |
| 2002-03-14 | ABC-DELISTED | Stock | 17.28 | 17.45 | 17.1 | 17.42 | 4657600.0 |
| 2002-03-14 | ABCB | Stock | 10.9179 | 10.9422 | 10.7801 | 10.7801 | 6045.0 |
| 2002-03-14 | ABCO-DELISTED | Stock | 14.245 | 14.455 | 14.03 | 14.23 | 29800.0 |
| 2002-03-14 | ABCW-DELISTED | Stock | 21.04 | 21.15 | 20.66 | 21.0 | 79700.0 |
| 2002-03-14 | ABE-DELISTED | Stock | 7.36 | 7.46 | 7.34 | 7.44 | 6200.0 |
| 2002-03-14 | ABFS-DELISTED | Stock | 28.8 | 29.74 | 28.8 | 29.35 | 146400.0 |
| 2002-03-14 | ABK-DELISTED | Stock | 59.1 | 60.4 | 59.06 | 60.09 | 520700.0 |
| 2002-03-14 | ABM | Stock | 16.435 | 16.535 | 16.38 | 16.425 | 301800.0 |
| 2002-03-14 | ABMD-DELISTED | Stock | 10.1 | 10.1 | 9.86 | 9.93 | 37100.0 |
| 2002-03-14 | ABP-DELISTED | Stock | 1.2 | 1.2 | 1.14 | 1.15 | 113400.0 |
| 2002-03-14 | ABT | Stock | 24.914 | 24.9589 | 24.4427 | 24.6177 | 8755608.0 |
| 2002-03-14 | ABTL-DELISTED | Stock | 15.35 | 15.5 | 14.85 | 15.2 | 16900.0 |
| 2002-03-14 | ABV-DELISTED | Stock | 19.21 | 19.27 | 18.89 | 19.02 | 306500.0 |
| 2002-03-14 | ABVA-DELISTED | Stock | 8.25 | 8.25 | 8.25 | 8.25 | 100.0 |
| 2002-03-14 | ABX-DELISTED | Stock | 17.4 | 17.62 | 17.22 | 17.53 | 2070800.0 |
| 2002-03-14 | ACAP-DELISTED | Stock | 17.95 | 18.1 | 17.5 | 17.93 | 62900.0 |
| 2002-03-14 | ACAS-DELISTED | Stock | 30.35 | 30.48 | 29.16 | 29.66 | 284100.0 |
| 2002-03-14 | ACAT-DELISTED | Stock | 17.925 | 18.32 | 17.85 | 18.05 | 127500.0 |
| 2002-03-14 | ACCL-DELISTED | Stock | 9.59000015258789 | 9.87600040435791 | 9.44999980926514 | 9.49300003051758 | 604300.0 |
| 2002-03-14 | ACE-DELISTED | Stock | 42.2 | 43.69 | 42.05 | 43.49 | 1892600.0 |
| 2002-03-14 | ACF-DELISTED | Stock | 37.83 | 37.83 | 35.7 | 36.19 | 3362200.0 |
| 2002-03-14 | ACG-DELISTED | Stock | 7.73 | 7.73 | 7.68 | 7.71 | 860200.0 |
| 2002-03-14 | ACGL | Stock | 3.0333 | 3.0489 | 3.0256 | 3.0256 | 11700.0 |
| 2002-03-14 | ACGN-DELISTED | Stock | 1586.6712 | 1722.6712 | 1530.0 | 1700.0 | 110600.0 |
| 2002-03-14 | ACH | Stock | 12.7933 | 13.3333 | 12.78 | 13.2067 | 389400.0 |
| 2002-03-14 | ACH-DELISTED | Stock | 5.5745 | 5.5745 | 5.4995 | 5.512 | 55203.0 |
| 2002-03-14 | ACLS | Stock | 51.6 | 54.36 | 51.0 | 53.2 | 111125.0 |
| 2002-03-14 | ACO-DELISTED | Stock | 6.82 | 6.99 | 6.82 | 6.98 | 16100.0 |
| 2002-03-14 | ACPW-DELISTED | Stock | 21.05 | 23.0 | 20.5 | 22.8 | 89420.0 |
| 2002-03-14 | ACS-DELISTED | Stock | 52.9 | 54.5 | 52.25 | 52.58 | 1613700.0 |
| 2002-03-14 | ACTA-DELISTED | Stock | 18.2 | 18.6 | 17.0 | 17.2 | 26000.0 |
| 2002-03-14 | ACTT-DELISTED | Stock | 5.015 | 5.334 | 5.0 | 5.16 | 7300.0 |
| 2002-03-14 | ACTU-DELISTED | Stock | 6.99 | 7.1 | 6.82 | 6.96 | 419100.0 |
| 2002-03-14 | ACXM-DELISTED | Stock | 16.49 | 16.8 | 15.86 | 16.46 | 809200.0 |
| 2002-03-14 | ACY-DELISTED | Stock | 4.71 | 4.71 | 4.66 | 4.66 | 1600.0 |
> showing 50 of 3,084 rows — these rows as CSV