PREVIEW / stock_daily / 2002-07-22
file: by_date/stock_daily/2002/2002-07-22.parquet size: 107 KB rows: 3,169 symbols: 1,968
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-22 | AAPL | Stock | 0.2634 | 0.2713 | 0.2609 | 0.2664 | 430897600.0 |
| 2002-07-22 | MSFT | Stock | 24.475 | 24.995 | 22.95 | 23.755 | 180069800.0 |
| 2002-07-22 | NVDA | Stock | 0.1504 | 0.1547 | 0.1379 | 0.1441 | 1290744000.0 |
| 2002-07-22 | AMZN | Stock | 0.7575 | 0.7825 | 0.75 | 0.775 | 186658000.0 |
| 2002-07-22 | CL | Stock | 22.4 | 23.28 | 22.275 | 22.655 | 5810400.0 |
| 2002-07-22 | A | Stock | 14.628 | 14.9499 | 14.0916 | 14.299 | 4534553.0 |
| 2002-07-22 | AABA-DELISTED | Stock | 6.57999992370605 | 6.9850001335144 | 6.42000007629395 | 6.65999984741211 | 26279400.0 |
| 2002-07-22 | AAI-DELISTED | Stock | 3.62 | 3.7 | 3.43 | 3.65 | 268300.0 |
| 2002-07-22 | AAIC-DELISTED | Stock | 185.0 | 192.0 | 185.0 | 185.0 | 113700.0 |
| 2002-07-22 | AAME | Stock | 2.1 | 2.31 | 2.0 | 2.31 | 6000.0 |
| 2002-07-22 | AAON | Stock | 2.0148 | 2.1663 | 2.0016 | 2.1663 | 386522.0 |
| 2002-07-22 | AAP | Stock | 15.3333 | 15.5667 | 13.8 | 14.5 | 1582200.0 |
| 2002-07-22 | AAXN-DELISTED | Stock | 0.675000011920929 | 0.699999988079071 | 0.636666655540466 | 0.690833330154419 | 672000.0 |
| 2002-07-22 | ABAX-DELISTED | Stock | 3.82 | 3.82 | 2.9 | 3.5 | 37400.0 |
| 2002-07-22 | ABB-DELISTED | Stock | 8.1 | 8.1 | 7.55 | 7.65 | 92900.0 |
| 2002-07-22 | ABC-DELISTED | Stock | 15.34 | 15.65 | 14.25 | 14.42 | 8335200.0 |
| 2002-07-22 | ABCB | Stock | 11.307 | 11.307 | 10.3343 | 10.5532 | 35656.0 |
| 2002-07-22 | ABCO-DELISTED | Stock | 13.874 | 13.99 | 13.495 | 13.495 | 103281.0 |
| 2002-07-22 | ABCW-DELISTED | Stock | 18.95 | 20.0 | 18.76 | 19.99 | 45800.0 |
| 2002-07-22 | ABE-DELISTED | Stock | 6.43 | 6.43 | 6.3 | 6.3 | 41300.0 |
| 2002-07-22 | ABFS-DELISTED | Stock | 21.18 | 21.25 | 19.88 | 20.51 | 145000.0 |
| 2002-07-22 | ABG | Stock | 11.48 | 11.85 | 11.05 | 11.5 | 78100.0 |
| 2002-07-22 | ABK-DELISTED | Stock | 55.5 | 55.99 | 52.66 | 53.78 | 946100.0 |
| 2002-07-22 | ABM | Stock | 15.82 | 16.27 | 15.26 | 15.75 | 181000.0 |
| 2002-07-22 | ABMD-DELISTED | Stock | 6.28 | 6.4 | 6.03 | 6.31 | 32707.0 |
| 2002-07-22 | ABP-DELISTED | Stock | 0.59 | 0.6 | 0.55 | 0.59 | 159300.0 |
| 2002-07-22 | ABT | Stock | 14.4277 | 14.7688 | 14.1853 | 14.3648 | 13382687.0 |
| 2002-07-22 | ABTL-DELISTED | Stock | 11.95 | 12.2 | 11.75 | 12.15 | 2600.0 |
| 2002-07-22 | ABV-DELISTED | Stock | 15.15 | 15.57 | 14.75 | 14.75 | 432300.0 |
| 2002-07-22 | ABVA-DELISTED | Stock | 8.07 | 8.07 | 8.02 | 8.02 | 2200.0 |
| 2002-07-22 | ABX-DELISTED | Stock | 17.15 | 17.25 | 15.87 | 16.0 | 8574500.0 |
| 2002-07-22 | ACAP-DELISTED | Stock | 16.61 | 16.7 | 16.19 | 16.37 | 24900.0 |
| 2002-07-22 | ACAS-DELISTED | Stock | 25.52 | 25.74 | 22.1 | 23.61 | 952070.0 |
| 2002-07-22 | ACAT-DELISTED | Stock | 15.45 | 16.07 | 15.23 | 15.4 | 67473.0 |
| 2002-07-22 | ACCL-DELISTED | Stock | 5.15000009536743 | 5.39499998092651 | 4.81500005722046 | 5.01100015640259 | 254700.0 |
| 2002-07-22 | ACE-DELISTED | Stock | 25.5 | 25.8 | 24.45 | 24.75 | 2587400.0 |
| 2002-07-22 | ACF-DELISTED | Stock | 16.91 | 17.13 | 15.5 | 15.79 | 1683800.0 |
| 2002-07-22 | ACG-DELISTED | Stock | 8.0 | 8.04 | 7.93 | 7.95 | 843700.0 |
| 2002-07-22 | ACGL | Stock | 2.6667 | 2.7767 | 2.6167 | 2.7111 | 469800.0 |
| 2002-07-22 | ACGN-DELISTED | Stock | 1144.6712 | 1156.0 | 963.3288 | 1020.0 | 75200.0 |
| 2002-07-22 | ACH | Stock | 9.7 | 10.0267 | 9.24 | 9.3933 | 418950.0 |
| 2002-07-22 | ACH-DELISTED | Stock | 4.2005 | 4.2755 | 4.2005 | 4.213 | 101990.0 |
| 2002-07-22 | ACLS | Stock | 39.24 | 39.96 | 36.4 | 36.44 | 261000.0 |
| 2002-07-22 | ACO-DELISTED | Stock | 4.8 | 4.83 | 4.55 | 4.75 | 1009600.0 |
| 2002-07-22 | ACPW-DELISTED | Stock | 9.725 | 10.473 | 8.478 | 9.825 | 85166.0 |
| 2002-07-22 | ACS-DELISTED | Stock | 41.25 | 41.25 | 37.5 | 39.0 | 1663000.0 |
| 2002-07-22 | ACTA-DELISTED | Stock | 5.2 | 5.4 | 4.8 | 5.2 | 15000.0 |
| 2002-07-22 | ACTT-DELISTED | Stock | 2.61 | 2.94 | 2.4 | 2.63 | 17500.0 |
| 2002-07-22 | ACTU-DELISTED | Stock | 2.2 | 2.24 | 2.0 | 2.08 | 697600.0 |
| 2002-07-22 | ACXM-DELISTED | Stock | 13.35 | 14.01 | 12.94 | 13.285 | 1083505.0 |
> showing 50 of 3,169 rows — these rows as CSV