PREVIEW / stock_daily / 2002-09-30
file: by_date/stock_daily/2002/2002-09-30.parquet size: 109 KB rows: 3,213 symbols: 1,991
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-09-30 | AAPL | Stock | 0.2571 | 0.2602 | 0.2525 | 0.2589 | 237697600.0 |
| 2002-09-30 | MSFT | Stock | 22.435 | 22.52 | 21.555 | 21.87 | 115577000.0 |
| 2002-09-30 | NVDA | Stock | 0.0711 | 0.0744 | 0.0696 | 0.0713 | 584124000.0 |
| 2002-09-30 | AMZN | Stock | 0.832 | 0.8425 | 0.7925 | 0.7965 | 184798000.0 |
| 2002-09-30 | CL | Stock | 27.1 | 27.375 | 26.865 | 26.975 | 6348000.0 |
| 2002-09-30 | A | Stock | 9.1917 | 9.6209 | 8.834 | 9.3419 | 3721057.0 |
| 2002-09-30 | AABA-DELISTED | Stock | 5.19000005722046 | 5.19000005722046 | 4.76999998092651 | 4.78499984741211 | 21264200.0 |
| 2002-09-30 | AAI-DELISTED | Stock | 2.69 | 3.15 | 2.65 | 3.1 | 191300.0 |
| 2002-09-30 | AAIC-DELISTED | Stock | 203.0 | 206.6 | 199.0 | 202.6 | 52000.0 |
| 2002-09-30 | AAME | Stock | 1.71 | 2.19 | 1.71 | 1.76 | 8800.0 |
| 2002-09-30 | AAON | Stock | 2.1478 | 2.2795 | 2.1465 | 2.2281 | 73659.0 |
| 2002-09-30 | AAP | Stock | 17.97 | 17.9967 | 17.4 | 17.58 | 1425600.0 |
| 2002-09-30 | AAXN-DELISTED | Stock | 0.451666653156281 | 0.451666653156281 | 0.400000005960464 | 0.428333342075348 | 312000.0 |
| 2002-09-30 | ABAX-DELISTED | Stock | 3.21 | 3.39 | 3.17 | 3.3 | 15900.0 |
| 2002-09-30 | ABB-DELISTED | Stock | 3.25 | 3.4 | 3.15 | 3.4 | 28500.0 |
| 2002-09-30 | ABC-DELISTED | Stock | 17.69 | 17.98 | 17.44 | 17.86 | 4984400.0 |
| 2002-09-30 | ABCB | Stock | 10.4721 | 10.4721 | 10.2857 | 10.391 | 3456.0 |
| 2002-09-30 | ABCO-DELISTED | Stock | 14.73 | 14.925 | 14.505 | 14.805 | 30605.0 |
| 2002-09-30 | ABCW-DELISTED | Stock | 20.03 | 20.49 | 19.9 | 20.2 | 104700.0 |
| 2002-09-30 | ABE-DELISTED | Stock | 5.52 | 5.52 | 5.45 | 5.51 | 20000.0 |
| 2002-09-30 | ABFS-DELISTED | Stock | 28.69 | 28.79 | 28.25 | 28.7 | 284724.0 |
| 2002-09-30 | ABG | Stock | 9.05 | 9.12 | 8.73 | 8.75 | 45200.0 |
| 2002-09-30 | ABK-DELISTED | Stock | 53.09 | 54.21 | 52.16 | 53.89 | 1105200.0 |
| 2002-09-30 | ABM | Stock | 13.95 | 14.26 | 13.59 | 14.1 | 79800.0 |
| 2002-09-30 | ABMD-DELISTED | Stock | 3.65 | 3.93 | 3.25 | 3.54 | 69590.0 |
| 2002-09-30 | ABP-DELISTED | Stock | 0.75 | 0.8 | 0.71 | 0.75 | 64000.0 |
| 2002-09-30 | ABT | Stock | 18.1087 | 18.3376 | 17.4398 | 18.1356 | 11759612.0 |
| 2002-09-30 | ABTL-DELISTED | Stock | 12.9 | 13.25 | 11.15 | 11.95 | 22600.0 |
| 2002-09-30 | ABV-DELISTED | Stock | 11.2 | 11.27 | 10.82 | 11.0 | 659900.0 |
| 2002-09-30 | ABVA-DELISTED | Stock | 10.1 | 10.1 | 10.0 | 10.0 | 1200.0 |
| 2002-09-30 | ABX-DELISTED | Stock | 15.3 | 15.99 | 15.17 | 15.52 | 4638800.0 |
| 2002-09-30 | ACAP-DELISTED | Stock | 16.8 | 16.8 | 16.1 | 16.68 | 8941.0 |
| 2002-09-30 | ACAS-DELISTED | Stock | 18.07 | 18.9 | 18.06 | 18.8 | 818137.0 |
| 2002-09-30 | ACAT-DELISTED | Stock | 13.94 | 14.34 | 13.71 | 13.96 | 82531.0 |
| 2002-09-30 | ACCL-DELISTED | Stock | 5.81463003158569 | 6.49528980255127 | 5.81463003158569 | 6.49528980255127 | 71700.0 |
| 2002-09-30 | ACE-DELISTED | Stock | 29.35 | 30.15 | 28.25 | 29.6 | 1782600.0 |
| 2002-09-30 | ACF-DELISTED | Stock | 8.2 | 8.29 | 7.6 | 8.04 | 4980200.0 |
| 2002-09-30 | ACG-DELISTED | Stock | 8.22 | 8.3 | 8.2 | 8.28 | 463200.0 |
| 2002-09-30 | ACGL | Stock | 3.1056 | 3.1222 | 3.0 | 3.1 | 756000.0 |
| 2002-09-30 | ACGN-DELISTED | Stock | 793.3288 | 940.6712 | 793.3288 | 940.6712 | 700.0 |
| 2002-09-30 | ACH | Stock | 9.5867 | 9.7467 | 9.34 | 9.5267 | 188850.0 |
| 2002-09-30 | ACH-DELISTED | Stock | 2.4775 | 2.4925 | 2.475 | 2.475 | 17200.0 |
| 2002-09-30 | ACLS | Stock | 18.32 | 20.16 | 18.2 | 19.52 | 248400.0 |
| 2002-09-30 | ACO-DELISTED | Stock | 5.9 | 5.9 | 5.8 | 5.85 | 52200.0 |
| 2002-09-30 | ACPW-DELISTED | Stock | 6.6 | 6.9 | 6.25 | 6.7 | 23607.0 |
| 2002-09-30 | ACS-DELISTED | Stock | 42.61 | 43.25 | 40.87 | 42.55 | 1662800.0 |
| 2002-09-30 | ACTA-DELISTED | Stock | 4.0 | 4.6 | 3.6 | 3.8 | 184200.0 |
| 2002-09-30 | ACTT-DELISTED | Stock | 1.44 | 1.53 | 1.36 | 1.41 | 7700.0 |
| 2002-09-30 | ACTU-DELISTED | Stock | 0.93 | 0.97 | 0.85 | 0.9 | 342004.0 |
| 2002-09-30 | ACXM-DELISTED | Stock | 14.16 | 14.72 | 13.67 | 14.18 | 911921.0 |
> showing 50 of 3,213 rows — these rows as CSV