PREVIEW / stock_daily / 2002-11-14
file: by_date/stock_daily/2002/2002-11-14.parquet size: 109 KB rows: 3,250 symbols: 2,008
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-14 | AAPL | Stock | 0.2839 | 0.293 | 0.2818 | 0.2911 | 141713600.0 |
| 2002-11-14 | MSFT | Stock | 27.995 | 28.5 | 27.935 | 28.495 | 78337000.0 |
| 2002-11-14 | NVDA | Stock | 0.1046 | 0.1066 | 0.1014 | 0.1046 | 1138728000.0 |
| 2002-11-14 | AMZN | Stock | 1.0495 | 1.0745 | 1.0475 | 1.0605 | 263546000.0 |
| 2002-11-14 | CL | Stock | 26.375 | 26.465 | 26.03 | 26.465 | 4537800.0 |
| 2002-11-14 | A | Stock | 9.5851 | 10.0215 | 9.4421 | 10.0 | 2348360.0 |
| 2002-11-14 | AABA-DELISTED | Stock | 7.98000001907349 | 8.375 | 7.92500019073486 | 8.35000038146973 | 21356200.0 |
| 2002-11-14 | AAI-DELISTED | Stock | 4.01 | 4.2 | 3.99 | 4.11 | 145500.0 |
| 2002-11-14 | AAIC-DELISTED | Stock | 184.6 | 190.0 | 181.4 | 190.0 | 128500.0 |
| 2002-11-14 | AAME | Stock | 1.6 | 1.62 | 1.6 | 1.62 | 9400.0 |
| 2002-11-14 | AAON | Stock | 2.4336 | 2.4375 | 2.4086 | 2.4362 | 140484.0 |
| 2002-11-14 | AAP | Stock | 17.5833 | 17.9767 | 17.5 | 17.8833 | 1450200.0 |
| 2002-11-14 | AAXN-DELISTED | Stock | 0.355833321809769 | 0.360833346843719 | 0.349999994039536 | 0.351666659116745 | 279600.0 |
| 2002-11-14 | ABAX-DELISTED | Stock | 4.07 | 4.07 | 3.95 | 3.951 | 15700.0 |
| 2002-11-14 | ABB-DELISTED | Stock | 2.12 | 2.19 | 2.1 | 2.17 | 190400.0 |
| 2002-11-14 | ABC-DELISTED | Stock | 16.67 | 16.75 | 15.71 | 15.9 | 11576400.0 |
| 2002-11-14 | ABCB | Stock | 11.0638 | 11.3475 | 10.699 | 11.3151 | 18136.0 |
| 2002-11-14 | ABCO-DELISTED | Stock | 14.9 | 15.65 | 14.885 | 15.54 | 535208.0 |
| 2002-11-14 | ABCW-DELISTED | Stock | 20.76 | 20.86 | 20.4 | 20.85 | 15290.0 |
| 2002-11-14 | ABE-DELISTED | Stock | 5.62 | 5.75 | 5.62 | 5.75 | 9600.0 |
| 2002-11-14 | ABFS-DELISTED | Stock | 29.98 | 30.35 | 29.75 | 30.29 | 230100.0 |
| 2002-11-14 | ABG | Stock | 8.8 | 8.86 | 8.4 | 8.45 | 29000.0 |
| 2002-11-14 | ABK-DELISTED | Stock | 56.87 | 57.4 | 55.73 | 55.98 | 1784900.0 |
| 2002-11-14 | ABM | Stock | 13.85 | 14.24 | 13.85 | 14.19 | 89900.0 |
| 2002-11-14 | ABMD-DELISTED | Stock | 3.78 | 4.0 | 3.611 | 3.89 | 81619.0 |
| 2002-11-14 | ABP-DELISTED | Stock | 0.6 | 0.65 | 0.55 | 0.56 | 110000.0 |
| 2002-11-14 | ABT | Stock | 19.5272 | 19.7741 | 19.3566 | 19.7337 | 6933156.0 |
| 2002-11-14 | ABTL-DELISTED | Stock | 12.0 | 14.15 | 11.6 | 13.75 | 50400.0 |
| 2002-11-14 | ABV-DELISTED | Stock | 14.13 | 14.53 | 14.0 | 14.44 | 177600.0 |
| 2002-11-14 | ABVA-DELISTED | Stock | 10.4 | 10.4 | 10.4 | 10.4 | 1500.0 |
| 2002-11-14 | ABX-DELISTED | Stock | 15.42 | 15.62 | 15.33 | 15.47 | 1616397.0 |
| 2002-11-14 | ACAP-DELISTED | Stock | 16.01 | 16.3 | 15.98 | 16.25 | 12600.0 |
| 2002-11-14 | ACAS-DELISTED | Stock | 18.39 | 18.95 | 18.16 | 18.75 | 2424874.0 |
| 2002-11-14 | ACAT-DELISTED | Stock | 16.2 | 16.22 | 16.03 | 16.22 | 33488.0 |
| 2002-11-14 | ACCL-DELISTED | Stock | 6.80666017532349 | 7.20491981506348 | 6.80666017532349 | 7.20491981506348 | 37400.0 |
| 2002-11-14 | ACE-DELISTED | Stock | 31.0 | 31.36 | 30.45 | 31.24 | 1596900.0 |
| 2002-11-14 | ACF-DELISTED | Stock | 7.85 | 7.9 | 7.15 | 7.35 | 3073300.0 |
| 2002-11-14 | ACG-DELISTED | Stock | 8.14 | 8.14 | 8.06 | 8.06 | 478400.0 |
| 2002-11-14 | ACGL | Stock | 3.2167 | 3.2756 | 3.2 | 3.25 | 851400.0 |
| 2002-11-14 | ACGN-DELISTED | Stock | 1246.6712 | 1394.0 | 1224.0 | 1360.0 | 63400.0 |
| 2002-11-14 | ACH | Stock | 10.3 | 10.68 | 10.3 | 10.6667 | 154650.0 |
| 2002-11-14 | ACH-DELISTED | Stock | 2.9053 | 2.9053 | 2.87 | 2.875 | 11105.0 |
| 2002-11-14 | ACLS | Stock | 23.08 | 26.64 | 23.08 | 26.44 | 127800.0 |
| 2002-11-14 | ACO-DELISTED | Stock | 5.95 | 5.98 | 5.7 | 5.94 | 26800.0 |
| 2002-11-14 | ACPW-DELISTED | Stock | 9.5 | 10.0 | 8.95 | 9.65 | 20440.0 |
| 2002-11-14 | ACS-DELISTED | Stock | 47.15 | 48.97 | 39.95 | 42.25 | 3497100.0 |
| 2002-11-14 | ACTA-DELISTED | Stock | 10.0 | 10.4 | 9.6 | 10.0 | 157600.0 |
| 2002-11-14 | ACTT-DELISTED | Stock | 1.4 | 1.559 | 1.25 | 1.37 | 136400.0 |
| 2002-11-14 | ACTU-DELISTED | Stock | 1.95 | 2.12 | 1.91 | 2.1 | 136220.0 |
| 2002-11-14 | ACXM-DELISTED | Stock | 13.32 | 13.77 | 13.32 | 13.57 | 1099770.0 |
> showing 50 of 3,250 rows — these rows as CSV