PREVIEW / stock_daily / 2002-08-09
file: by_date/stock_daily/2002/2002-08-09.parquet size: 106 KB rows: 3,116 symbols: 1,922
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-09 | AAPL | Stock | 0.2723 | 0.2723 | 0.2634 | 0.2679 | 205716000.0 |
| 2002-08-09 | MSFT | Stock | 24.075 | 24.575 | 23.83 | 24.06 | 69049400.0 |
| 2002-08-09 | NVDA | Stock | 0.0764 | 0.0792 | 0.0751 | 0.0767 | 581304000.0 |
| 2002-08-09 | AMZN | Stock | 0.6805 | 0.7375 | 0.68 | 0.713 | 95558000.0 |
| 2002-08-09 | CL | Stock | 27.025 | 27.1 | 26.605 | 27.035 | 3806800.0 |
| 2002-08-09 | A | Stock | 11.8956 | 12.1888 | 11.7167 | 11.9599 | 2253995.0 |
| 2002-08-09 | AABA-DELISTED | Stock | 5.875 | 6.09499979019165 | 5.81500005722046 | 5.98000001907349 | 9686400.0 |
| 2002-08-09 | AAI-DELISTED | Stock | 3.98 | 3.98 | 3.71 | 3.82 | 144600.0 |
| 2002-08-09 | AAIC-DELISTED | Stock | 200.0 | 200.0 | 191.6 | 199.0 | 83400.0 |
| 2002-08-09 | AAME | Stock | 1.8 | 1.98 | 1.8 | 1.98 | 3000.0 |
| 2002-08-09 | AAON | Stock | 2.1412 | 2.2387 | 2.1412 | 2.2347 | 133650.0 |
| 2002-08-09 | AAP | Stock | 15.75 | 16.3833 | 15.6333 | 16.2667 | 1509600.0 |
| 2002-08-09 | AAXN-DELISTED | Stock | 0.541666686534882 | 0.576666653156281 | 0.524999976158142 | 0.576666653156281 | 466800.0 |
| 2002-08-09 | ABAX-DELISTED | Stock | 3.09 | 3.25 | 3.05 | 3.24 | 30090.0 |
| 2002-08-09 | ABB-DELISTED | Stock | 4.73 | 4.89 | 4.62 | 4.8 | 29400.0 |
| 2002-08-09 | ABC-DELISTED | Stock | 16.97 | 17.4 | 16.66 | 17.28 | 3344000.0 |
| 2002-08-09 | ABCB | Stock | 11.6717 | 11.7041 | 10.9908 | 11.4123 | 7156.0 |
| 2002-08-09 | ABCO-DELISTED | Stock | 17.041 | 17.046 | 16.305 | 16.7 | 44705.0 |
| 2002-08-09 | ABCW-DELISTED | Stock | 21.09 | 21.64 | 21.01 | 21.1 | 36800.0 |
| 2002-08-09 | ABE-DELISTED | Stock | 6.26 | 6.4 | 6.26 | 6.37 | 6900.0 |
| 2002-08-09 | ABFS-DELISTED | Stock | 20.45 | 21.18 | 20.26 | 21.0 | 94749.0 |
| 2002-08-09 | ABG | Stock | 10.15 | 10.2 | 9.91 | 10.0 | 28100.0 |
| 2002-08-09 | ABK-DELISTED | Stock | 61.45 | 62.56 | 61.02 | 62.25 | 574300.0 |
| 2002-08-09 | ABM | Stock | 16.45 | 16.85 | 16.33 | 16.5 | 64900.0 |
| 2002-08-09 | ABMD-DELISTED | Stock | 5.86 | 6.2 | 5.8 | 5.83 | 38000.0 |
| 2002-08-09 | ABP-DELISTED | Stock | 0.47 | 0.5 | 0.36 | 0.5 | 45900.0 |
| 2002-08-09 | ABT | Stock | 18.2927 | 18.2927 | 17.8977 | 18.1042 | 7943402.0 |
| 2002-08-09 | ABTL-DELISTED | Stock | 11.5 | 12.15 | 10.0 | 12.0 | 45300.0 |
| 2002-08-09 | ABV-DELISTED | Stock | 14.6 | 14.67 | 14.35 | 14.67 | 688400.0 |
| 2002-08-09 | ABVA-DELISTED | Stock | 8.65 | 9.1 | 8.65 | 8.8 | 50100.0 |
| 2002-08-09 | ABX-DELISTED | Stock | 15.48 | 16.25 | 15.44 | 16.06 | 3291700.0 |
| 2002-08-09 | ACAP-DELISTED | Stock | 16.0 | 16.79 | 15.96 | 16.74 | 486900.0 |
| 2002-08-09 | ACAS-DELISTED | Stock | 25.59 | 25.93 | 25.05 | 25.51 | 338800.0 |
| 2002-08-09 | ACAT-DELISTED | Stock | 15.7 | 15.76 | 15.0961 | 15.7 | 15862.0 |
| 2002-08-09 | ACCL-DELISTED | Stock | 4.63000011444092 | 4.64900016784668 | 4.58400011062622 | 4.59100008010864 | 156700.0 |
| 2002-08-09 | ACE-DELISTED | Stock | 31.76 | 32.6 | 30.95 | 31.73 | 1181344.0 |
| 2002-08-09 | ACF-DELISTED | Stock | 11.6 | 12.48 | 10.7 | 11.87 | 4466100.0 |
| 2002-08-09 | ACG-DELISTED | Stock | 7.9 | 8.0 | 7.9 | 7.96 | 406300.0 |
| 2002-08-09 | ACGL | Stock | 2.9278 | 3.0189 | 2.9278 | 3.0156 | 36000.0 |
| 2002-08-09 | ACGN-DELISTED | Stock | 929.3288 | 952.0 | 906.6712 | 952.0 | 19000.0 |
| 2002-08-09 | ACH | Stock | 9.9333 | 9.9333 | 9.7667 | 9.8267 | 96750.0 |
| 2002-08-09 | ACH-DELISTED | Stock | 3.5753 | 3.6123 | 3.5753 | 3.6 | 49074.0 |
| 2002-08-09 | ACLS | Stock | 31.6 | 32.28 | 30.8 | 31.6 | 109250.0 |
| 2002-08-09 | ACO-DELISTED | Stock | 5.5 | 5.5 | 5.3 | 5.31 | 4000.0 |
| 2002-08-09 | ACPW-DELISTED | Stock | 11.2 | 11.805 | 11.099 | 11.25 | 33281.0 |
| 2002-08-09 | ACS-DELISTED | Stock | 47.9 | 48.2 | 46.85 | 47.3 | 1377600.0 |
| 2002-08-09 | ACTA-DELISTED | Stock | 4.8 | 4.8 | 4.4 | 4.6 | 11500.0 |
| 2002-08-09 | ACTT-DELISTED | Stock | 1.7287 | 1.75 | 1.43 | 1.43 | 31800.0 |
| 2002-08-09 | ACTU-DELISTED | Stock | 1.92 | 1.96 | 1.71 | 1.74 | 143206.0 |
| 2002-08-09 | ACXM-DELISTED | Stock | 16.53 | 16.53 | 16.255 | 16.34 | 288058.0 |
> showing 50 of 3,116 rows — these rows as CSV