PREVIEW / stock_daily / 2002-07-01
file: by_date/stock_daily/2002/2002-07-01.parquet size: 107 KB rows: 3,137 symbols: 1,944
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-07-01 | AAPL | Stock | 0.3163 | 0.3193 | 0.3045 | 0.3046 | 222689600.0 |
| 2002-07-01 | MSFT | Stock | 27.06 | 27.195 | 26.29 | 26.33 | 66473800.0 |
| 2002-07-01 | NVDA | Stock | 0.1425 | 0.1467 | 0.1398 | 0.1428 | 1164372000.0 |
| 2002-07-01 | AMZN | Stock | 0.8085 | 0.8085 | 0.676 | 0.6775 | 270730000.0 |
| 2002-07-01 | CL | Stock | 25.125 | 25.975 | 25.1 | 25.84 | 4940400.0 |
| 2002-07-01 | A | Stock | 16.774 | 17.103 | 16.3233 | 16.5451 | 2621250.0 |
| 2002-07-01 | AABA-DELISTED | Stock | 7.38000011444092 | 7.42999982833862 | 6.77500009536743 | 6.81500005722046 | 15985000.0 |
| 2002-07-01 | AAI-DELISTED | Stock | 5.36 | 5.5 | 5.32 | 5.41 | 310100.0 |
| 2002-07-01 | AAIC-DELISTED | Stock | 254.6 | 255.4 | 237.6 | 242.0 | 298800.0 |
| 2002-07-01 | AAME | Stock | 2.4 | 2.46 | 1.91 | 2.35 | 5400.0 |
| 2002-07-01 | AAON | Stock | 2.423 | 2.4494 | 2.3506 | 2.3967 | 475369.0 |
| 2002-07-01 | AAP | Stock | 18.1333 | 18.25 | 17.4 | 17.4667 | 1267500.0 |
| 2002-07-01 | AAXN-DELISTED | Stock | 1.00833332538605 | 1.03750002384186 | 0.925833344459534 | 1.01666665077209 | 642000.0 |
| 2002-07-01 | ABAX-DELISTED | Stock | 4.31 | 4.65 | 4.31 | 4.52 | 7900.0 |
| 2002-07-01 | ABB-DELISTED | Stock | 9.0 | 9.02 | 8.75 | 8.95 | 28500.0 |
| 2002-07-01 | ABC-DELISTED | Stock | 18.8 | 18.84 | 17.6 | 17.95 | 6228800.0 |
| 2002-07-01 | ABCB | Stock | 12.0689 | 12.3526 | 11.5096 | 11.9959 | 31214.0 |
| 2002-07-01 | ABCO-DELISTED | Stock | 17.254 | 17.254 | 15.208 | 16.76 | 384458.0 |
| 2002-07-01 | ABCW-DELISTED | Stock | 24.01 | 24.25 | 23.55 | 24.25 | 168400.0 |
| 2002-07-01 | ABE-DELISTED | Stock | 6.76 | 6.76 | 6.65 | 6.7 | 14500.0 |
| 2002-07-01 | ABFS-DELISTED | Stock | 25.2 | 25.22 | 23.94 | 24.18 | 115000.0 |
| 2002-07-01 | ABG | Stock | 13.6 | 14.0 | 13.3 | 13.48 | 117000.0 |
| 2002-07-01 | ABK-DELISTED | Stock | 67.3 | 68.87 | 67.0 | 67.56 | 669400.0 |
| 2002-07-01 | ABM | Stock | 17.41 | 17.66 | 17.0 | 17.05 | 105800.0 |
| 2002-07-01 | ABMD-DELISTED | Stock | 8.29 | 8.48 | 7.56 | 7.56 | 89800.0 |
| 2002-07-01 | ABP-DELISTED | Stock | 0.73 | 0.73 | 0.6 | 0.65 | 20400.0 |
| 2002-07-01 | ABT | Stock | 17.0941 | 17.3725 | 16.6542 | 16.744 | 10643552.0 |
| 2002-07-01 | ABTL-DELISTED | Stock | 14.5 | 15.0 | 13.95 | 13.95 | 10500.0 |
| 2002-07-01 | ABV-DELISTED | Stock | 16.35 | 16.35 | 15.05 | 15.2 | 558800.0 |
| 2002-07-01 | ABVA-DELISTED | Stock | 8.35 | 8.35 | 8.35 | 8.35 | 300.0 |
| 2002-07-01 | ABX-DELISTED | Stock | 18.9 | 19.24 | 18.78 | 19.19 | 4032300.0 |
| 2002-07-01 | ACAP-DELISTED | Stock | 18.15 | 18.4 | 18.06 | 18.26 | 85700.0 |
| 2002-07-01 | ACAS-DELISTED | Stock | 27.41 | 27.99 | 27.4 | 27.59 | 436600.0 |
| 2002-07-01 | ACAT-DELISTED | Stock | 17.4 | 17.41 | 15.97 | 16.22 | 54000.0 |
| 2002-07-01 | ACCL-DELISTED | Stock | 6.24184989929199 | 6.3359899520874 | 6.12599992752075 | 6.3359899520874 | 154900.0 |
| 2002-07-01 | ACE-DELISTED | Stock | 31.27 | 31.27 | 30.25 | 30.3 | 1932157.0 |
| 2002-07-01 | ACF-DELISTED | Stock | 27.6 | 28.34 | 26.01 | 26.1 | 2152700.0 |
| 2002-07-01 | ACG-DELISTED | Stock | 7.96 | 8.0 | 7.92 | 7.93 | 852200.0 |
| 2002-07-01 | ACGL | Stock | 3.1267 | 3.2033 | 3.1111 | 3.1444 | 414000.0 |
| 2002-07-01 | ACGN-DELISTED | Stock | 1314.6712 | 1394.0 | 1224.0 | 1246.6712 | 78400.0 |
| 2002-07-01 | ACH | Stock | 13.16 | 13.16 | 12.5 | 12.72 | 163200.0 |
| 2002-07-01 | ACH-DELISTED | Stock | 4.775 | 4.775 | 4.7 | 4.7 | 94400.0 |
| 2002-07-01 | ACLS | Stock | 45.6 | 45.6 | 42.32 | 42.32 | 325200.0 |
| 2002-07-01 | ACO-DELISTED | Stock | 6.65 | 6.8 | 6.44 | 6.45 | 66100.0 |
| 2002-07-01 | ACPW-DELISTED | Stock | 18.05 | 19.4 | 17.05 | 17.25 | 33560.0 |
| 2002-07-01 | ACS-DELISTED | Stock | 48.1 | 48.9 | 45.05 | 45.65 | 3108600.0 |
| 2002-07-01 | ACTA-DELISTED | Stock | 5.4 | 5.6 | 4.4 | 4.8 | 53900.0 |
| 2002-07-01 | ACTT-DELISTED | Stock | 2.84 | 2.98 | 2.38 | 2.46 | 69000.0 |
| 2002-07-01 | ACTU-DELISTED | Stock | 4.55 | 4.81 | 4.05 | 4.2 | 218200.0 |
| 2002-07-01 | ACXM-DELISTED | Stock | 17.55 | 17.74 | 16.42 | 16.48 | 612800.0 |
> showing 50 of 3,137 rows — these rows as CSV