PREVIEW / stock_daily / 2002-08-07
file: by_date/stock_daily/2002/2002-08-07.parquet size: 106 KB rows: 3,149 symbols: 1,947
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-08-07 | AAPL | Stock | 0.2695 | 0.2743 | 0.2563 | 0.2684 | 333474400.0 |
| 2002-08-07 | MSFT | Stock | 23.5 | 23.65 | 22.58 | 23.545 | 86349400.0 |
| 2002-08-07 | NVDA | Stock | 0.0787 | 0.0795 | 0.0708 | 0.0737 | 892980000.0 |
| 2002-08-07 | AMZN | Stock | 0.6965 | 0.697 | 0.6425 | 0.68 | 111114000.0 |
| 2002-08-07 | CL | Stock | 25.83 | 26.25 | 25.76 | 26.25 | 4765600.0 |
| 2002-08-07 | A | Stock | 12.1459 | 12.2175 | 11.4092 | 12.0672 | 2245328.0 |
| 2002-08-07 | AABA-DELISTED | Stock | 6.00500011444092 | 6.09499979019165 | 5.375 | 5.71500015258789 | 16859000.0 |
| 2002-08-07 | AAI-DELISTED | Stock | 3.64 | 3.7 | 3.51 | 3.7 | 69100.0 |
| 2002-08-07 | AAIC-DELISTED | Stock | 199.8 | 200.2 | 189.0 | 196.0 | 58100.0 |
| 2002-08-07 | AAME | Stock | 2.09 | 2.09 | 1.9 | 2.09 | 1000.0 |
| 2002-08-07 | AAON | Stock | 2.2255 | 2.2255 | 2.1386 | 2.186 | 202753.0 |
| 2002-08-07 | AAP | Stock | 15.1167 | 15.3833 | 15.0 | 15.3167 | 1200900.0 |
| 2002-08-07 | AAXN-DELISTED | Stock | 0.483333319425583 | 0.483333319425583 | 0.470833331346512 | 0.474999994039536 | 195600.0 |
| 2002-08-07 | ABAX-DELISTED | Stock | 3.31 | 3.41 | 3.1999 | 3.365 | 14600.0 |
| 2002-08-07 | ABB-DELISTED | Stock | 4.65 | 4.65 | 4.33 | 4.52 | 43800.0 |
| 2002-08-07 | ABC-DELISTED | Stock | 16.0 | 16.3 | 15.88 | 16.27 | 3306800.0 |
| 2002-08-07 | ABCB | Stock | 11.9068 | 11.9068 | 11.7446 | 11.8662 | 6662.0 |
| 2002-08-07 | ABCO-DELISTED | Stock | 16.275 | 16.479 | 15.803 | 16.305 | 22423.0 |
| 2002-08-07 | ABCW-DELISTED | Stock | 21.71 | 21.71 | 20.96 | 21.42 | 16670.0 |
| 2002-08-07 | ABE-DELISTED | Stock | 6.16 | 6.4 | 6.12 | 6.24 | 12500.0 |
| 2002-08-07 | ABFS-DELISTED | Stock | 19.87 | 20.41 | 19.3 | 20.359 | 105400.0 |
| 2002-08-07 | ABG | Stock | 10.45 | 10.66 | 10.35 | 10.4 | 27800.0 |
| 2002-08-07 | ABK-DELISTED | Stock | 58.7 | 58.88 | 57.06 | 58.87 | 861500.0 |
| 2002-08-07 | ABM | Stock | 16.25 | 16.35 | 15.89 | 16.1 | 88700.0 |
| 2002-08-07 | ABMD-DELISTED | Stock | 5.75 | 6.21 | 5.75 | 5.94 | 23892.0 |
| 2002-08-07 | ABP-DELISTED | Stock | 0.5 | 0.5 | 0.42 | 0.42 | 57300.0 |
| 2002-08-07 | ABT | Stock | 17.0897 | 17.956 | 17.0897 | 17.8932 | 9215397.0 |
| 2002-08-07 | ABTL-DELISTED | Stock | 11.25 | 11.75 | 10.25 | 11.0 | 7100.0 |
| 2002-08-07 | ABV-DELISTED | Stock | 13.39 | 13.59 | 12.83 | 13.51 | 451800.0 |
| 2002-08-07 | ABVA-DELISTED | Stock | 8.49 | 8.65 | 8.4 | 8.65 | 3000.0 |
| 2002-08-07 | ABX-DELISTED | Stock | 15.57 | 15.57 | 15.14 | 15.27 | 3113995.0 |
| 2002-08-07 | ACAP-DELISTED | Stock | 16.0 | 16.03 | 15.81 | 15.91 | 37500.0 |
| 2002-08-07 | ACAS-DELISTED | Stock | 24.6 | 25.03 | 24.31 | 24.5 | 353486.0 |
| 2002-08-07 | ACAT-DELISTED | Stock | 15.0 | 15.75 | 14.81 | 15.249 | 87200.0 |
| 2002-08-07 | ACCL-DELISTED | Stock | 4.49673986434937 | 4.86604022979736 | 4.49673986434937 | 4.86604022979736 | 122100.0 |
| 2002-08-07 | ACE-DELISTED | Stock | 30.65 | 30.83 | 29.0 | 29.5 | 1412600.0 |
| 2002-08-07 | ACF-DELISTED | Stock | 16.04 | 16.04 | 11.5 | 11.98 | 12830100.0 |
| 2002-08-07 | ACG-DELISTED | Stock | 7.88 | 7.89 | 7.8 | 7.83 | 606400.0 |
| 2002-08-07 | ACGL | Stock | 2.9811 | 3.1056 | 2.9167 | 3.0033 | 371700.0 |
| 2002-08-07 | ACGN-DELISTED | Stock | 918.0 | 1054.0 | 906.6712 | 963.3288 | 18900.0 |
| 2002-08-07 | ACH | Stock | 9.8333 | 9.9533 | 9.7333 | 9.9333 | 161250.0 |
| 2002-08-07 | ACH-DELISTED | Stock | 3.588 | 3.588 | 3.563 | 3.563 | 5600.0 |
| 2002-08-07 | ACLS | Stock | 31.56 | 32.72 | 29.92 | 31.44 | 136025.0 |
| 2002-08-07 | ACO-DELISTED | Stock | 5.65 | 5.7 | 5.35 | 5.44 | 11600.0 |
| 2002-08-07 | ACPW-DELISTED | Stock | 11.406 | 11.649 | 10.806 | 11.5 | 11436.0 |
| 2002-08-07 | ACS-DELISTED | Stock | 45.39 | 46.3 | 44.79 | 46.25 | 1652400.0 |
| 2002-08-07 | ACTA-DELISTED | Stock | 4.4 | 4.8 | 4.4 | 4.6 | 30200.0 |
| 2002-08-07 | ACTT-DELISTED | Stock | 2.11 | 2.17 | 1.4 | 1.5 | 65600.0 |
| 2002-08-07 | ACTU-DELISTED | Stock | 1.88 | 1.99 | 1.75 | 1.75 | 338900.0 |
| 2002-08-07 | ACXM-DELISTED | Stock | 15.92 | 16.4 | 15.78 | 16.33 | 953128.0 |
> showing 50 of 3,149 rows — these rows as CSV