PREVIEW / stock_daily / 2002-11-07
file: by_date/stock_daily/2002/2002-11-07.parquet size: 109 KB rows: 3,228 symbols: 1,998
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-07 | AAPL | Stock | 0.3025 | 0.3054 | 0.2823 | 0.2857 | 336179200.0 |
| 2002-11-07 | MSFT | Stock | 28.1 | 28.31 | 27.75 | 28.005 | 73699600.0 |
| 2002-11-07 | NVDA | Stock | 0.1313 | 0.1313 | 0.1205 | 0.1212 | 1660560000.0 |
| 2002-11-07 | AMZN | Stock | 0.9425 | 0.965 | 0.9385 | 0.956 | 128394000.0 |
| 2002-11-07 | CL | Stock | 26.7 | 27.025 | 26.6 | 26.92 | 4684600.0 |
| 2002-11-07 | A | Stock | 10.5436 | 10.5508 | 10.0215 | 10.1645 | 2371288.0 |
| 2002-11-07 | AABA-DELISTED | Stock | 8.07499980926514 | 8.09000015258789 | 7.66499996185303 | 7.80000019073486 | 45190000.0 |
| 2002-11-07 | AAI-DELISTED | Stock | 4.49 | 4.5 | 4.29 | 4.32 | 170200.0 |
| 2002-11-07 | AAIC-DELISTED | Stock | 194.0 | 194.0 | 185.2 | 185.2 | 22300.0 |
| 2002-11-07 | AAON | Stock | 2.5337 | 2.5837 | 2.506 | 2.5402 | 127575.0 |
| 2002-11-07 | AAP | Stock | 17.2833 | 17.45 | 17.2 | 17.35 | 596400.0 |
| 2002-11-07 | AAXN-DELISTED | Stock | 0.300000011920929 | 0.314999997615814 | 0.300000011920929 | 0.308333337306976 | 288000.0 |
| 2002-11-07 | ABAX-DELISTED | Stock | 4.11 | 4.28 | 4.0 | 4.28 | 13100.0 |
| 2002-11-07 | ABB-DELISTED | Stock | 2.04 | 2.1 | 2.01 | 2.05 | 513500.0 |
| 2002-11-07 | ABC-DELISTED | Stock | 17.84 | 18.0 | 17.55 | 17.56 | 6460800.0 |
| 2002-11-07 | ABCB | Stock | 11.1854 | 11.2746 | 11.0638 | 11.2502 | 3948.0 |
| 2002-11-07 | ABCO-DELISTED | Stock | 16.925 | 16.925 | 16.43 | 16.485 | 133026.0 |
| 2002-11-07 | ABCW-DELISTED | Stock | 21.2 | 21.2 | 20.5 | 20.51 | 10100.0 |
| 2002-11-07 | ABE-DELISTED | Stock | 5.67 | 5.67 | 5.6 | 5.6 | 20600.0 |
| 2002-11-07 | ABFS-DELISTED | Stock | 29.8 | 29.98 | 29.3 | 29.65 | 172000.0 |
| 2002-11-07 | ABG | Stock | 9.48 | 9.75 | 9.36 | 9.6 | 138300.0 |
| 2002-11-07 | ABK-DELISTED | Stock | 59.9 | 60.29 | 58.04 | 58.09 | 636200.0 |
| 2002-11-07 | ABM | Stock | 14.55 | 14.8 | 14.35 | 14.42 | 70300.0 |
| 2002-11-07 | ABMD-DELISTED | Stock | 3.83 | 4.03 | 3.59 | 3.84 | 22092.0 |
| 2002-11-07 | ABP-DELISTED | Stock | 0.62 | 0.67 | 0.61 | 0.61 | 21000.0 |
| 2002-11-07 | ABT | Stock | 20.434 | 20.6046 | 20.1601 | 20.4923 | 11499866.0 |
| 2002-11-07 | ABTL-DELISTED | Stock | 11.6 | 11.85 | 11.6 | 11.85 | 23800.0 |
| 2002-11-07 | ABV-DELISTED | Stock | 14.0 | 14.5 | 13.95 | 14.34 | 158100.0 |
| 2002-11-07 | ABX-DELISTED | Stock | 16.59 | 16.78 | 16.16 | 16.46 | 2749567.0 |
| 2002-11-07 | ACAP-DELISTED | Stock | 15.6 | 15.85 | 15.26 | 15.64 | 57400.0 |
| 2002-11-07 | ACAS-DELISTED | Stock | 20.46 | 20.56 | 19.9 | 20.09 | 572660.0 |
| 2002-11-07 | ACAT-DELISTED | Stock | 15.59 | 16.04 | 15.33 | 15.9 | 37300.0 |
| 2002-11-07 | ACCL-DELISTED | Stock | 7.48732995986938 | 7.53076982498169 | 7.41491985321045 | 7.53076982498169 | 81800.0 |
| 2002-11-07 | ACE-DELISTED | Stock | 31.8 | 31.83 | 30.66 | 30.92 | 1508500.0 |
| 2002-11-07 | ACF-DELISTED | Stock | 8.17 | 8.17 | 7.6 | 8.01 | 1228300.0 |
| 2002-11-07 | ACG-DELISTED | Stock | 8.04 | 8.19 | 8.04 | 8.16 | 450100.0 |
| 2002-11-07 | ACGL | Stock | 3.0667 | 3.1222 | 3.0167 | 3.11 | 976500.0 |
| 2002-11-07 | ACGN-DELISTED | Stock | 1326.0 | 1416.6712 | 1224.0 | 1246.6712 | 101900.0 |
| 2002-11-07 | ACH | Stock | 10.3667 | 10.3667 | 9.8867 | 10.0333 | 100050.0 |
| 2002-11-07 | ACH-DELISTED | Stock | 2.9525 | 2.955 | 2.925 | 2.925 | 4800.0 |
| 2002-11-07 | ACLS | Stock | 27.48 | 27.52 | 25.16 | 25.28 | 174950.0 |
| 2002-11-07 | ACO-DELISTED | Stock | 5.9 | 5.92 | 5.85 | 5.87 | 5200.0 |
| 2002-11-07 | ACPW-DELISTED | Stock | 10.3 | 10.4 | 8.35 | 9.5 | 22900.0 |
| 2002-11-07 | ACS-DELISTED | Stock | 49.2 | 50.0 | 48.7 | 49.79 | 1520400.0 |
| 2002-11-07 | ACTA-DELISTED | Stock | 8.2 | 11.2 | 8.2 | 10.6 | 530200.0 |
| 2002-11-07 | ACTT-DELISTED | Stock | 1.57 | 1.78 | 1.55 | 1.64 | 165900.0 |
| 2002-11-07 | ACTU-DELISTED | Stock | 2.4 | 2.4 | 2.16 | 2.21 | 393668.0 |
| 2002-11-07 | ACXM-DELISTED | Stock | 14.2 | 14.2 | 13.7 | 13.908 | 1254411.0 |
| 2002-11-07 | ACY-DELISTED | Stock | 3.84 | 3.84 | 3.71 | 3.71 | 600.0 |
| 2002-11-07 | AD | Stock | 18.2 | 18.84 | 18.1 | 18.84 | 185700.0 |
> showing 50 of 3,228 rows — these rows as CSV