PREVIEW / stock_daily / 2002-08-23
file: by_date/stock_daily/2002/2002-08-23.parquet size: 107 KB rows: 3,147 symbols: 1,937
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-08-23 | AAPL | Stock | 0.2839 | 0.2845 | 0.2759 | 0.2809 | 163245600.0 |
| 2002-08-23 | MSFT | Stock | 26.33 | 26.425 | 25.92 | 26.11 | 57929200.0 |
| 2002-08-23 | NVDA | Stock | 0.0996 | 0.1002 | 0.0952 | 0.0957 | 919932000.0 |
| 2002-08-23 | AMZN | Stock | 0.78 | 0.786 | 0.7475 | 0.7585 | 100776000.0 |
| 2002-08-23 | CL | Stock | 27.32 | 27.375 | 26.8 | 26.885 | 2979400.0 |
| 2002-08-23 | A | Stock | 12.0601 | 12.0672 | 11.4592 | 11.4592 | 2544500.0 |
| 2002-08-23 | AABA-DELISTED | Stock | 6.375 | 6.38500022888184 | 5.90000009536743 | 6.01000022888184 | 17538200.0 |
| 2002-08-23 | AAI-DELISTED | Stock | 3.99 | 3.99 | 3.68 | 3.68 | 227100.0 |
| 2002-08-23 | AAIC-DELISTED | Stock | 211.2 | 216.0 | 206.0 | 216.0 | 180900.0 |
| 2002-08-23 | AAME | Stock | 2.0 | 2.35 | 2.0 | 2.32 | 9900.0 |
| 2002-08-23 | AAON | Stock | 2.3704 | 2.3783 | 2.3309 | 2.344 | 148078.0 |
| 2002-08-23 | AAP | Stock | 18.0667 | 18.1667 | 17.96 | 18.1633 | 330000.0 |
| 2002-08-23 | AAXN-DELISTED | Stock | 0.579999983310699 | 0.579999983310699 | 0.555833339691162 | 0.574166655540466 | 124800.0 |
| 2002-08-23 | ABAX-DELISTED | Stock | 3.2 | 3.34 | 3.2 | 3.2008 | 24000.0 |
| 2002-08-23 | ABB-DELISTED | Stock | 5.3 | 6.2 | 5.2 | 5.9 | 132600.0 |
| 2002-08-23 | ABC-DELISTED | Stock | 18.1 | 18.25 | 17.74 | 17.78 | 1857200.0 |
| 2002-08-23 | ABCB | Stock | 11.4204 | 11.5015 | 11.153 | 11.153 | 51077.0 |
| 2002-08-23 | ABCO-DELISTED | Stock | 16.008 | 16.137 | 15.877 | 16.007 | 113618.0 |
| 2002-08-23 | ABCW-DELISTED | Stock | 21.25 | 21.35 | 20.59 | 21.04 | 71600.0 |
| 2002-08-23 | ABE-DELISTED | Stock | 6.3 | 6.34 | 6.29 | 6.3 | 10400.0 |
| 2002-08-23 | ABFS-DELISTED | Stock | 22.75 | 23.0 | 22.61 | 22.71 | 115500.0 |
| 2002-08-23 | ABG | Stock | 11.23 | 11.25 | 10.8 | 10.8 | 37000.0 |
| 2002-08-23 | ABK-DELISTED | Stock | 60.67 | 60.68 | 59.1 | 59.39 | 441000.0 |
| 2002-08-23 | ABM | Stock | 17.35 | 17.69 | 17.0 | 17.0 | 63300.0 |
| 2002-08-23 | ABMD-DELISTED | Stock | 5.05 | 5.37 | 4.28 | 5.08 | 208850.0 |
| 2002-08-23 | ABP-DELISTED | Stock | 0.9 | 1.1 | 0.89 | 0.98 | 677700.0 |
| 2002-08-23 | ABT | Stock | 18.6294 | 18.7461 | 18.1491 | 18.194 | 5787692.0 |
| 2002-08-23 | ABTL-DELISTED | Stock | 11.75 | 12.4 | 10.75 | 12.0 | 29500.0 |
| 2002-08-23 | ABV-DELISTED | Stock | 13.35 | 13.92 | 13.35 | 13.69 | 484500.0 |
| 2002-08-23 | ABVA-DELISTED | Stock | 9.0 | 9.2 | 9.0 | 9.2 | 1500.0 |
| 2002-08-23 | ABX-DELISTED | Stock | 15.12 | 15.42 | 14.75 | 14.85 | 2340207.0 |
| 2002-08-23 | ACAP-DELISTED | Stock | 17.76 | 17.84 | 17.3 | 17.57 | 14900.0 |
| 2002-08-23 | ACAS-DELISTED | Stock | 22.85 | 23.5 | 22.56 | 23.18 | 655095.0 |
| 2002-08-23 | ACAT-DELISTED | Stock | 15.71 | 15.72 | 14.7 | 15.1 | 85462.0 |
| 2002-08-23 | ACCL-DELISTED | Stock | 5.8600001335144 | 5.86499977111816 | 5.56099987030029 | 5.57600021362305 | 113000.0 |
| 2002-08-23 | ACE-DELISTED | Stock | 33.98 | 33.98 | 33.0 | 33.17 | 849143.0 |
| 2002-08-23 | ACF-DELISTED | Stock | 17.3 | 17.55 | 16.16 | 16.35 | 1921100.0 |
| 2002-08-23 | ACG-DELISTED | Stock | 8.09 | 8.12 | 8.08 | 8.11 | 339200.0 |
| 2002-08-23 | ACGL | Stock | 3.0833 | 3.1222 | 3.08 | 3.1122 | 1297800.0 |
| 2002-08-23 | ACGN-DELISTED | Stock | 850.0 | 906.6712 | 850.0 | 906.6712 | 22500.0 |
| 2002-08-23 | ACH | Stock | 9.9333 | 10.0333 | 9.8467 | 9.8667 | 194550.0 |
| 2002-08-23 | ACH-DELISTED | Stock | 3.77 | 3.795 | 3.77 | 3.795 | 32800.0 |
| 2002-08-23 | ACLS | Stock | 34.48 | 34.48 | 31.44 | 31.64 | 204225.0 |
| 2002-08-23 | ACO-DELISTED | Stock | 5.88 | 5.88 | 5.65 | 5.65 | 7700.0 |
| 2002-08-23 | ACPW-DELISTED | Stock | 11.355 | 11.456 | 10.749 | 10.85 | 10247.0 |
| 2002-08-23 | ACS-DELISTED | Stock | 48.9 | 49.29 | 47.8 | 47.84 | 984200.0 |
| 2002-08-23 | ACTA-DELISTED | Stock | 7.8 | 8.4 | 6.2 | 6.6 | 270300.0 |
| 2002-08-23 | ACTT-DELISTED | Stock | 3.28 | 3.45 | 2.41 | 2.68 | 339400.0 |
| 2002-08-23 | ACTU-DELISTED | Stock | 2.06 | 2.1 | 1.95 | 1.96 | 74100.0 |
| 2002-08-23 | ACXM-DELISTED | Stock | 17.7 | 17.78 | 17.47 | 17.49 | 282700.0 |
> showing 50 of 3,147 rows — these rows as CSV