PREVIEW / stock_daily / 2002-10-18
file: by_date/stock_daily/2002/2002-10-18.parquet size: 107 KB rows: 3,172 symbols: 1,955
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-18 | AAPL | Stock | 0.25 | 0.2563 | 0.2488 | 0.2561 | 288299200.0 |
| 2002-10-18 | MSFT | Stock | 26.3 | 26.6 | 25.57 | 26.575 | 152817200.0 |
| 2002-10-18 | NVDA | Stock | 0.0772 | 0.0792 | 0.0742 | 0.0783 | 498372000.0 |
| 2002-10-18 | AMZN | Stock | 0.924 | 0.9645 | 0.918 | 0.952 | 131366000.0 |
| 2002-10-18 | CL | Stock | 27.5 | 28.625 | 27.5 | 28.34 | 4469800.0 |
| 2002-10-18 | A | Stock | 8.6266 | 8.7124 | 8.083 | 8.6552 | 4631854.0 |
| 2002-10-18 | AABA-DELISTED | Stock | 7.20499992370605 | 7.52500009536743 | 7.14499998092651 | 7.5149998664856 | 30130400.0 |
| 2002-10-18 | AAI-DELISTED | Stock | 3.19 | 3.19 | 3.05 | 3.17 | 108200.0 |
| 2002-10-18 | AAIC-DELISTED | Stock | 201.6 | 202.8 | 198.8 | 199.6 | 21800.0 |
| 2002-10-18 | AAME | Stock | 1.62 | 2.35 | 1.62 | 2.19 | 4800.0 |
| 2002-10-18 | AAON | Stock | 2.2808 | 2.3427 | 2.1742 | 2.3045 | 546750.0 |
| 2002-10-18 | AAP | Stock | 17.3333 | 17.8167 | 17.14 | 17.8 | 3003000.0 |
| 2002-10-18 | AAXN-DELISTED | Stock | 0.294166654348373 | 0.294999986886978 | 0.275000005960464 | 0.283333331346512 | 235200.0 |
| 2002-10-18 | ABAX-DELISTED | Stock | 4.35 | 4.45 | 4.1 | 4.12 | 18120.0 |
| 2002-10-18 | ABB-DELISTED | Stock | 3.4 | 3.57 | 3.38 | 3.51 | 26100.0 |
| 2002-10-18 | ABC-DELISTED | Stock | 17.76 | 17.92 | 17.49 | 17.7 | 5619200.0 |
| 2002-10-18 | ABCB | Stock | 10.7639 | 10.7639 | 10.5775 | 10.5775 | 28130.0 |
| 2002-10-18 | ABCO-DELISTED | Stock | 15.605 | 16.72 | 15.605 | 16.27 | 166600.0 |
| 2002-10-18 | ABCW-DELISTED | Stock | 20.4 | 20.5 | 20.04 | 20.44 | 15900.0 |
| 2002-10-18 | ABE-DELISTED | Stock | 5.7 | 5.74 | 5.6 | 5.68 | 16300.0 |
| 2002-10-18 | ABFS-DELISTED | Stock | 29.55 | 30.378 | 29.43 | 30.3 | 300788.0 |
| 2002-10-18 | ABG | Stock | 9.5 | 9.5 | 9.1 | 9.15 | 67200.0 |
| 2002-10-18 | ABK-DELISTED | Stock | 64.09 | 64.46 | 62.69 | 63.18 | 687500.0 |
| 2002-10-18 | ABM | Stock | 14.5 | 14.5 | 14.1 | 14.3 | 64000.0 |
| 2002-10-18 | ABMD-DELISTED | Stock | 3.499 | 3.61 | 3.44 | 3.52 | 27200.0 |
| 2002-10-18 | ABP-DELISTED | Stock | 0.66 | 0.67 | 0.64 | 0.65 | 22100.0 |
| 2002-10-18 | ABT | Stock | 19.7067 | 19.9267 | 19.5541 | 19.7516 | 8075057.0 |
| 2002-10-18 | ABTL-DELISTED | Stock | 11.35 | 12.0 | 11.0 | 11.5 | 5700.0 |
| 2002-10-18 | ABV-DELISTED | Stock | 11.6 | 11.9 | 11.45 | 11.61 | 242400.0 |
| 2002-10-18 | ABVA-DELISTED | Stock | 9.8 | 9.8 | 9.7 | 9.7 | 3500.0 |
| 2002-10-18 | ABX-DELISTED | Stock | 14.45 | 14.6 | 14.21 | 14.29 | 2117800.0 |
| 2002-10-18 | ACAP-DELISTED | Stock | 15.99 | 16.0 | 15.86 | 15.86 | 15100.0 |
| 2002-10-18 | ACAS-DELISTED | Stock | 20.44 | 20.6 | 19.82 | 20.29 | 437976.0 |
| 2002-10-18 | ACAT-DELISTED | Stock | 14.3 | 14.88 | 14.11 | 14.53 | 22100.0 |
| 2002-10-18 | ACCL-DELISTED | Stock | 6.87182998657227 | 7.21940994262695 | 6.87182998657227 | 7.21940994262695 | 88800.0 |
| 2002-10-18 | ACE-DELISTED | Stock | 33.95 | 35.2 | 33.8 | 34.76 | 2587400.0 |
| 2002-10-18 | ACF-DELISTED | Stock | 6.61 | 6.98 | 6.57 | 6.85 | 1874000.0 |
| 2002-10-18 | ACG-DELISTED | Stock | 7.86 | 7.9 | 7.83 | 7.87 | 465900.0 |
| 2002-10-18 | ACGL | Stock | 2.9667 | 2.98 | 2.9222 | 2.9711 | 1586700.0 |
| 2002-10-18 | ACGN-DELISTED | Stock | 929.3288 | 974.6712 | 918.0 | 963.3288 | 35600.0 |
| 2002-10-18 | ACH | Stock | 9.6333 | 9.6333 | 9.2933 | 9.5 | 211500.0 |
| 2002-10-18 | ACH-DELISTED | Stock | 3.0245 | 3.037 | 3.0245 | 3.037 | 10002.0 |
| 2002-10-18 | ACLS | Stock | 18.56 | 19.28 | 17.64 | 19.0 | 121750.0 |
| 2002-10-18 | ACO-DELISTED | Stock | 5.4 | 5.44 | 4.9 | 4.99 | 19500.0 |
| 2002-10-18 | ACPW-DELISTED | Stock | 10.0 | 10.5 | 9.9 | 10.3 | 21061.0 |
| 2002-10-18 | ACS-DELISTED | Stock | 43.0 | 43.8 | 42.1 | 43.67 | 1350900.0 |
| 2002-10-18 | ACTA-DELISTED | Stock | 4.2 | 4.8 | 4.0 | 4.2 | 59800.0 |
| 2002-10-18 | ACTT-DELISTED | Stock | 1.19 | 1.28 | 1.11 | 1.19 | 21600.0 |
| 2002-10-18 | ACTU-DELISTED | Stock | 1.0 | 1.04 | 0.99 | 1.04 | 87840.0 |
| 2002-10-18 | ACXM-DELISTED | Stock | 13.85 | 14.13 | 13.5 | 13.82 | 1731414.0 |
> showing 50 of 3,172 rows — these rows as CSV