PREVIEW / stock_daily / 2002-10-22
file: by_date/stock_daily/2002/2002-10-22.parquet size: 107 KB rows: 3,195 symbols: 1,974
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-22 | AAPL | Stock | 0.2584 | 0.2657 | 0.2546 | 0.2625 | 218148000.0 |
| 2002-10-22 | MSFT | Stock | 25.715 | 25.965 | 25.515 | 25.835 | 87159000.0 |
| 2002-10-22 | NVDA | Stock | 0.0815 | 0.0933 | 0.0814 | 0.0882 | 1272168000.0 |
| 2002-10-22 | AMZN | Stock | 0.9505 | 0.9955 | 0.945 | 0.969 | 172914000.0 |
| 2002-10-22 | CL | Stock | 28.63 | 28.65 | 28.1 | 28.31 | 4771000.0 |
| 2002-10-22 | A | Stock | 8.598 | 8.8698 | 8.5479 | 8.7983 | 3464244.0 |
| 2002-10-22 | AABA-DELISTED | Stock | 7.25500011444092 | 7.45499992370605 | 7.15500020980835 | 7.42500019073486 | 29231800.0 |
| 2002-10-22 | AAI-DELISTED | Stock | 3.38 | 3.47 | 3.21 | 3.44 | 122300.0 |
| 2002-10-22 | AAIC-DELISTED | Stock | 210.0 | 211.6 | 204.6 | 206.4 | 83800.0 |
| 2002-10-22 | AAME | Stock | 2.03 | 2.15 | 1.71 | 2.0 | 13400.0 |
| 2002-10-22 | AAON | Stock | 2.3374 | 2.3638 | 2.3045 | 2.3519 | 100237.0 |
| 2002-10-22 | AAP | Stock | 18.0 | 18.3 | 17.7667 | 18.0 | 1067700.0 |
| 2002-10-22 | AAXN-DELISTED | Stock | 0.283333331346512 | 0.314999997615814 | 0.279166668653488 | 0.285833328962326 | 2742000.0 |
| 2002-10-22 | ABAX-DELISTED | Stock | 4.02 | 4.051 | 3.74 | 3.91 | 19700.0 |
| 2002-10-22 | ABB-DELISTED | Stock | 1.65 | 1.65 | 1.39 | 1.52 | 1083000.0 |
| 2002-10-22 | ABC-DELISTED | Stock | 18.2 | 18.7 | 18.11 | 18.7 | 5882596.0 |
| 2002-10-22 | ABCB | Stock | 10.537 | 10.537 | 10.4235 | 10.5046 | 6169.0 |
| 2002-10-22 | ABCO-DELISTED | Stock | 16.745 | 17.09 | 16.325 | 16.645 | 265800.0 |
| 2002-10-22 | ABCW-DELISTED | Stock | 20.45 | 20.53 | 20.06 | 20.07 | 14100.0 |
| 2002-10-22 | ABE-DELISTED | Stock | 5.78 | 5.78 | 5.55 | 5.71 | 19400.0 |
| 2002-10-22 | ABFS-DELISTED | Stock | 31.25 | 31.57 | 29.5 | 30.88 | 390564.0 |
| 2002-10-22 | ABG | Stock | 8.8 | 8.9 | 8.59 | 8.59 | 18000.0 |
| 2002-10-22 | ABK-DELISTED | Stock | 63.7 | 64.05 | 63.13 | 63.48 | 798900.0 |
| 2002-10-22 | ABM | Stock | 14.25 | 14.3 | 13.99 | 14.08 | 56900.0 |
| 2002-10-22 | ABMD-DELISTED | Stock | 3.4 | 3.74 | 3.4 | 3.57 | 36000.0 |
| 2002-10-22 | ABP-DELISTED | Stock | 0.73 | 0.75 | 0.68 | 0.7 | 20800.0 |
| 2002-10-22 | ABT | Stock | 19.2803 | 19.406 | 19.0738 | 19.213 | 7674968.0 |
| 2002-10-22 | ABTL-DELISTED | Stock | 11.85 | 12.0 | 11.4 | 11.75 | 24700.0 |
| 2002-10-22 | ABV-DELISTED | Stock | 11.28 | 11.41 | 11.05 | 11.37 | 408400.0 |
| 2002-10-22 | ABVA-DELISTED | Stock | 9.7 | 9.7 | 9.7 | 9.7 | 100.0 |
| 2002-10-22 | ABX-DELISTED | Stock | 14.55 | 14.93 | 14.4 | 14.92 | 2972654.0 |
| 2002-10-22 | ACAP-DELISTED | Stock | 15.41 | 15.54 | 15.34 | 15.37 | 5400.0 |
| 2002-10-22 | ACAS-DELISTED | Stock | 20.29 | 20.31 | 19.48 | 19.48 | 601652.0 |
| 2002-10-22 | ACAT-DELISTED | Stock | 14.45 | 14.65 | 14.241 | 14.55 | 189300.0 |
| 2002-10-22 | ACCL-DELISTED | Stock | 7.16871976852417 | 7.26284980773926 | 6.82113981246948 | 7.26284980773926 | 56400.0 |
| 2002-10-22 | ACE-DELISTED | Stock | 36.25 | 36.3 | 35.3 | 35.48 | 1902200.0 |
| 2002-10-22 | ACF-DELISTED | Stock | 7.0 | 7.38 | 6.75 | 7.07 | 1374500.0 |
| 2002-10-22 | ACG-DELISTED | Stock | 7.88 | 7.92 | 7.84 | 7.89 | 471200.0 |
| 2002-10-22 | ACGL | Stock | 2.9778 | 3.0522 | 2.9778 | 3.0344 | 600300.0 |
| 2002-10-22 | ACGN-DELISTED | Stock | 963.3288 | 986.0 | 906.6712 | 986.0 | 27200.0 |
| 2002-10-22 | ACH | Stock | 9.6 | 9.8667 | 9.5467 | 9.6333 | 123750.0 |
| 2002-10-22 | ACH-DELISTED | Stock | 2.918 | 2.918 | 2.888 | 2.888 | 6399.0 |
| 2002-10-22 | ACLS | Stock | 19.52 | 19.6 | 17.76 | 18.6 | 187000.0 |
| 2002-10-22 | ACO-DELISTED | Stock | 5.4 | 5.4 | 5.01 | 5.15 | 48400.0 |
| 2002-10-22 | ACPW-DELISTED | Stock | 9.25 | 10.45 | 9.2 | 10.45 | 12460.0 |
| 2002-10-22 | ACS-DELISTED | Stock | 45.0 | 48.1 | 43.64 | 44.0 | 3590000.0 |
| 2002-10-22 | ACTA-DELISTED | Stock | 4.4 | 4.6 | 4.4 | 4.6 | 23100.0 |
| 2002-10-22 | ACTT-DELISTED | Stock | 1.16 | 1.3 | 1.1 | 1.25 | 84900.0 |
| 2002-10-22 | ACTU-DELISTED | Stock | 1.06 | 1.06 | 0.95 | 1.01 | 40789.0 |
| 2002-10-22 | ACXM-DELISTED | Stock | 14.05 | 14.43 | 13.92 | 14.4 | 1041468.0 |
> showing 50 of 3,195 rows — these rows as CSV