PREVIEW / stock_daily / 2002-06-24
file: by_date/stock_daily/2002/2002-06-24.parquet size: 108 KB rows: 3,164 symbols: 1,967
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-06-24 | AAPL | Stock | 0.2995 | 0.3166 | 0.2982 | 0.3084 | 431933600.0 |
| 2002-06-24 | MSFT | Stock | 26.045 | 27.32 | 25.925 | 27.08 | 104523200.0 |
| 2002-06-24 | NVDA | Stock | 0.184 | 0.1982 | 0.1783 | 0.1923 | 1379592000.0 |
| 2002-06-24 | AMZN | Stock | 0.8715 | 0.889 | 0.847 | 0.8755 | 119136000.0 |
| 2002-06-24 | CL | Stock | 25.125 | 25.4 | 24.035 | 24.825 | 8228800.0 |
| 2002-06-24 | A | Stock | 17.1674 | 17.6967 | 16.8312 | 17.2818 | 4355469.0 |
| 2002-06-24 | AABA-DELISTED | Stock | 7.69500017166138 | 7.69999980926514 | 7.2649998664856 | 7.53999996185303 | 19801800.0 |
| 2002-06-24 | AAI-DELISTED | Stock | 5.7 | 5.7 | 5.5 | 5.66 | 603700.0 |
| 2002-06-24 | AAIC-DELISTED | Stock | 228.4 | 233.4 | 224.0 | 226.0 | 73800.0 |
| 2002-06-24 | AAME | Stock | 2.22 | 2.39 | 2.16 | 2.39 | 2000.0 |
| 2002-06-24 | AAON | Stock | 2.8155 | 2.8155 | 2.3862 | 2.4757 | 397912.0 |
| 2002-06-24 | AAP | Stock | 20.3167 | 20.4333 | 19.6167 | 19.9667 | 778800.0 |
| 2002-06-24 | AAXN-DELISTED | Stock | 1.10083329677582 | 1.10166668891907 | 1.01666665077209 | 1.07666671276093 | 758400.0 |
| 2002-06-24 | ABAX-DELISTED | Stock | 4.75 | 4.85 | 4.75 | 4.83 | 10200.0 |
| 2002-06-24 | ABB-DELISTED | Stock | 8.25 | 8.35 | 8.25 | 8.3 | 4900.0 |
| 2002-06-24 | ABC-DELISTED | Stock | 19.69 | 19.86 | 19.34 | 19.44 | 3621200.0 |
| 2002-06-24 | ABCB | Stock | 11.85 | 12.0364 | 11.85 | 11.9959 | 28377.0 |
| 2002-06-24 | ABCO-DELISTED | Stock | 18.43 | 18.43 | 17.505 | 17.61 | 183600.0 |
| 2002-06-24 | ABCW-DELISTED | Stock | 23.39 | 23.4 | 22.36 | 23.0 | 42700.0 |
| 2002-06-24 | ABE-DELISTED | Stock | 6.65 | 6.7 | 6.63 | 6.66 | 19700.0 |
| 2002-06-24 | ABFS-DELISTED | Stock | 25.45 | 25.5 | 24.75 | 24.99 | 119800.0 |
| 2002-06-24 | ABG | Stock | 13.92 | 13.99 | 13.0 | 13.85 | 105200.0 |
| 2002-06-24 | ABK-DELISTED | Stock | 69.4 | 69.75 | 68.29 | 68.59 | 571900.0 |
| 2002-06-24 | ABM | Stock | 16.2 | 16.94 | 16.2 | 16.93 | 212100.0 |
| 2002-06-24 | ABMD-DELISTED | Stock | 6.5 | 7.18 | 6.38 | 6.8 | 92100.0 |
| 2002-06-24 | ABP-DELISTED | Stock | 0.6 | 0.6 | 0.52 | 0.58 | 87700.0 |
| 2002-06-24 | ABT | Stock | 16.2727 | 16.8652 | 16.0527 | 16.7081 | 15146105.0 |
| 2002-06-24 | ABTL-DELISTED | Stock | 13.2 | 13.5 | 12.55 | 12.55 | 14800.0 |
| 2002-06-24 | ABV-DELISTED | Stock | 14.3 | 15.26 | 14.25 | 15.2 | 774300.0 |
| 2002-06-24 | ABVA-DELISTED | Stock | 7.85 | 7.85 | 7.85 | 7.85 | 500.0 |
| 2002-06-24 | ABX-DELISTED | Stock | 20.88 | 21.17 | 20.33 | 20.47 | 3752800.0 |
| 2002-06-24 | ACAP-DELISTED | Stock | 17.5 | 18.2 | 17.48 | 18.2 | 18900.0 |
| 2002-06-24 | ACAS-DELISTED | Stock | 26.2 | 27.4 | 25.55 | 27.08 | 541200.0 |
| 2002-06-24 | ACAT-DELISTED | Stock | 16.11 | 17.2 | 16.1 | 17.12 | 140300.0 |
| 2002-06-24 | ACCL-DELISTED | Stock | 5.88704013824463 | 6.06083011627197 | 5.83634996414185 | 6.06083011627197 | 129800.0 |
| 2002-06-24 | ACE-DELISTED | Stock | 33.05 | 33.31 | 32.7 | 32.89 | 1252500.0 |
| 2002-06-24 | ACF-DELISTED | Stock | 26.1 | 27.9 | 24.7 | 26.8 | 1536800.0 |
| 2002-06-24 | ACG-DELISTED | Stock | 8.18 | 8.19 | 8.0 | 8.09 | 995200.0 |
| 2002-06-24 | ACGL | Stock | 3.3133 | 3.3133 | 3.1533 | 3.1778 | 1268100.0 |
| 2002-06-24 | ACGN-DELISTED | Stock | 1405.3288 | 1416.6712 | 1394.0 | 1416.6712 | 9300.0 |
| 2002-06-24 | ACH | Stock | 12.6 | 13.2 | 12.5667 | 12.9333 | 208050.0 |
| 2002-06-24 | ACH-DELISTED | Stock | 4.4905 | 4.4905 | 4.4605 | 4.4605 | 10792.0 |
| 2002-06-24 | ACLS | Stock | 41.04 | 43.36 | 40.04 | 43.36 | 244050.0 |
| 2002-06-24 | ACO-DELISTED | Stock | 5.98 | 6.04 | 5.85 | 5.85 | 20000.0 |
| 2002-06-24 | ACPW-DELISTED | Stock | 17.75 | 18.1 | 16.5 | 17.15 | 16500.0 |
| 2002-06-24 | ACS-DELISTED | Stock | 51.37 | 51.37 | 49.45 | 49.89 | 2196800.0 |
| 2002-06-24 | ACTA-DELISTED | Stock | 6.4 | 7.0 | 6.0 | 6.8 | 27600.0 |
| 2002-06-24 | ACTT-DELISTED | Stock | 3.2 | 3.2 | 2.931 | 3.0 | 50800.0 |
| 2002-06-24 | ACTU-DELISTED | Stock | 4.9 | 5.12 | 4.67 | 5.06 | 223200.0 |
| 2002-06-24 | ACXM-DELISTED | Stock | 17.0 | 17.06 | 16.65 | 16.98 | 717600.0 |
> showing 50 of 3,164 rows — these rows as CSV