PREVIEW / stock_daily / 2002-10-14
file: by_date/stock_daily/2002/2002-10-14.parquet size: 105 KB rows: 3,152 symbols: 1,941
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-10-14 | AAPL | Stock | 0.2598 | 0.2675 | 0.2579 | 0.2638 | 194404000.0 |
| 2002-10-14 | MSFT | Stock | 24.125 | 24.665 | 23.92 | 24.645 | 76216200.0 |
| 2002-10-14 | NVDA | Stock | 0.0712 | 0.0734 | 0.0697 | 0.0712 | 611484000.0 |
| 2002-10-14 | AMZN | Stock | 0.909 | 0.9615 | 0.9085 | 0.96 | 197448000.0 |
| 2002-10-14 | CL | Stock | 27.95 | 28.5 | 27.95 | 28.5 | 4484000.0 |
| 2002-10-14 | A | Stock | 7.6538 | 7.9971 | 7.5107 | 7.8755 | 3241822.0 |
| 2002-10-14 | AABA-DELISTED | Stock | 6.44500017166138 | 7.34999990463257 | 6.44000005722046 | 7.13000011444092 | 65224200.0 |
| 2002-10-14 | AAI-DELISTED | Stock | 3.0 | 3.0 | 2.83 | 2.91 | 76600.0 |
| 2002-10-14 | AAIC-DELISTED | Stock | 187.0 | 196.0 | 186.0 | 195.8 | 45200.0 |
| 2002-10-14 | AAME | Stock | 1.74 | 1.75 | 1.74 | 1.75 | 500.0 |
| 2002-10-14 | AAON | Stock | 2.1333 | 2.1702 | 2.1333 | 2.1333 | 40247.0 |
| 2002-10-14 | AAP | Stock | 18.1 | 19.13 | 17.9667 | 18.7167 | 2241000.0 |
| 2002-10-14 | AAXN-DELISTED | Stock | 0.295833319425583 | 0.295833319425583 | 0.279166668653488 | 0.281666666269302 | 50400.0 |
| 2002-10-14 | ABAX-DELISTED | Stock | 3.5 | 3.75 | 3.5 | 3.75 | 15900.0 |
| 2002-10-14 | ABB-DELISTED | Stock | 2.75 | 2.94 | 2.75 | 2.94 | 43900.0 |
| 2002-10-14 | ABC-DELISTED | Stock | 18.34 | 18.75 | 18.31 | 18.73 | 2716000.0 |
| 2002-10-14 | ABCB | Stock | 10.5613 | 10.5613 | 10.537 | 10.537 | 5552.0 |
| 2002-10-14 | ABCO-DELISTED | Stock | 13.875 | 14.061 | 13.79 | 13.88 | 23909.0 |
| 2002-10-14 | ABCW-DELISTED | Stock | 19.75 | 20.15 | 19.5 | 19.63 | 22600.0 |
| 2002-10-14 | ABE-DELISTED | Stock | 5.55 | 5.57 | 5.52 | 5.57 | 4300.0 |
| 2002-10-14 | ABFS-DELISTED | Stock | 29.47 | 29.88 | 29.15 | 29.5 | 368757.0 |
| 2002-10-14 | ABG | Stock | 8.3 | 8.38 | 8.23 | 8.35 | 24600.0 |
| 2002-10-14 | ABK-DELISTED | Stock | 56.25 | 57.79 | 56.05 | 57.54 | 512700.0 |
| 2002-10-14 | ABM | Stock | 13.5 | 13.91 | 13.47 | 13.8 | 41900.0 |
| 2002-10-14 | ABMD-DELISTED | Stock | 3.11 | 3.11 | 2.86 | 3.05 | 287450.0 |
| 2002-10-14 | ABP-DELISTED | Stock | 0.72 | 0.75 | 0.69 | 0.69 | 28000.0 |
| 2002-10-14 | ABT | Stock | 19.0783 | 19.4599 | 19.0334 | 19.4284 | 10938495.0 |
| 2002-10-14 | ABTL-DELISTED | Stock | 10.4 | 11.25 | 10.4 | 11.0 | 3700.0 |
| 2002-10-14 | ABV-DELISTED | Stock | 11.43 | 11.6 | 11.05 | 11.25 | 191700.0 |
| 2002-10-14 | ABX-DELISTED | Stock | 14.56 | 14.64 | 14.21 | 14.54 | 1511400.0 |
| 2002-10-14 | ACAP-DELISTED | Stock | 15.7 | 16.05 | 15.6 | 15.83 | 26700.0 |
| 2002-10-14 | ACAS-DELISTED | Stock | 18.41 | 19.24 | 18.14 | 18.7 | 495360.0 |
| 2002-10-14 | ACAT-DELISTED | Stock | 13.01 | 13.71 | 13.01 | 13.71 | 8800.0 |
| 2002-10-14 | ACCL-DELISTED | Stock | 6.08255004882813 | 6.82113981246948 | 6.08255004882813 | 6.82113981246948 | 95800.0 |
| 2002-10-14 | ACE-DELISTED | Stock | 31.85 | 31.85 | 29.95 | 30.49 | 1974900.0 |
| 2002-10-14 | ACF-DELISTED | Stock | 6.85 | 7.04 | 6.68 | 6.77 | 1495000.0 |
| 2002-10-14 | ACG-DELISTED | Stock | 7.98 | 8.04 | 7.96 | 7.96 | 453600.0 |
| 2002-10-14 | ACGL | Stock | 2.9278 | 2.9933 | 2.9278 | 2.9556 | 332100.0 |
| 2002-10-14 | ACGN-DELISTED | Stock | 929.3288 | 929.3288 | 906.6712 | 906.6712 | 8500.0 |
| 2002-10-14 | ACH | Stock | 9.6 | 9.6 | 9.3267 | 9.4133 | 191400.0 |
| 2002-10-14 | ACH-DELISTED | Stock | 2.4468 | 2.4842 | 2.4468 | 2.4667 | 138990.0 |
| 2002-10-14 | ACLS | Stock | 15.96 | 16.52 | 15.4 | 16.52 | 165125.0 |
| 2002-10-14 | ACO-DELISTED | Stock | 5.3 | 5.4 | 5.2 | 5.4 | 9000.0 |
| 2002-10-14 | ACPW-DELISTED | Stock | 9.75 | 11.15 | 9.7 | 10.2 | 17800.0 |
| 2002-10-14 | ACS-DELISTED | Stock | 40.5 | 40.99 | 39.75 | 40.32 | 1275600.0 |
| 2002-10-14 | ACTA-DELISTED | Stock | 3.8 | 3.8 | 3.2 | 3.4 | 14900.0 |
| 2002-10-14 | ACTT-DELISTED | Stock | 1.4 | 1.4 | 1.07 | 1.18 | 61000.0 |
| 2002-10-14 | ACTU-DELISTED | Stock | 0.93 | 0.97 | 0.86 | 0.94 | 36400.0 |
| 2002-10-14 | ACXM-DELISTED | Stock | 15.21 | 15.93 | 15.11 | 15.5 | 668570.0 |
| 2002-10-14 | AD | Stock | 18.4933 | 18.4933 | 17.9133 | 18.1267 | 115650.0 |
> showing 50 of 3,152 rows — these rows as CSV