PREVIEW / stock_daily / 2002-09-19
file: by_date/stock_daily/2002/2002-09-19.parquet size: 108 KB rows: 3,219 symbols: 1,999
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-19 | AAPL | Stock | 0.2634 | 0.2643 | 0.2586 | 0.2604 | 205945600.0 |
| 2002-09-19 | MSFT | Stock | 23.34 | 23.91 | 23.295 | 23.6 | 77777600.0 |
| 2002-09-19 | NVDA | Stock | 0.0772 | 0.08 | 0.0759 | 0.0763 | 618492000.0 |
| 2002-09-19 | AMZN | Stock | 0.87 | 0.882 | 0.8585 | 0.8605 | 96822000.0 |
| 2002-09-19 | CL | Stock | 27.05 | 27.175 | 26.66 | 26.705 | 3175200.0 |
| 2002-09-19 | A | Stock | 10.4435 | 10.4435 | 10.0143 | 10.0644 | 3454178.0 |
| 2002-09-19 | AABA-DELISTED | Stock | 4.78000020980835 | 4.94999980926514 | 4.75 | 4.75 | 9647400.0 |
| 2002-09-19 | AAI-DELISTED | Stock | 3.2 | 3.22 | 3.1 | 3.11 | 192200.0 |
| 2002-09-19 | AAIC-DELISTED | Stock | 183.4 | 187.0 | 182.4 | 185.2 | 68400.0 |
| 2002-09-19 | AAME | Stock | 1.9 | 1.9 | 1.78 | 1.9 | 2500.0 |
| 2002-09-19 | AAON | Stock | 2.0886 | 2.1004 | 2.0412 | 2.0477 | 123778.0 |
| 2002-09-19 | AAP | Stock | 17.41 | 17.5067 | 17.0867 | 17.2167 | 808200.0 |
| 2002-09-19 | AAXN-DELISTED | Stock | 0.469166666269302 | 0.469166666269302 | 0.420833319425583 | 0.449999988079071 | 328800.0 |
| 2002-09-19 | ABAX-DELISTED | Stock | 3.2114 | 3.24 | 3.1 | 3.18 | 7200.0 |
| 2002-09-19 | ABB-DELISTED | Stock | 3.83 | 3.98 | 3.8 | 3.9 | 37800.0 |
| 2002-09-19 | ABC-DELISTED | Stock | 17.0 | 17.2 | 16.77 | 16.81 | 6546800.0 |
| 2002-09-19 | ABCB | Stock | 10.3829 | 10.6099 | 10.2938 | 10.3181 | 9747.0 |
| 2002-09-19 | ABCO-DELISTED | Stock | 15.454 | 15.454 | 13.634 | 13.796 | 226887.0 |
| 2002-09-19 | ABCW-DELISTED | Stock | 20.3 | 20.41 | 20.2 | 20.2 | 43400.0 |
| 2002-09-19 | ABE-DELISTED | Stock | 5.9 | 5.9 | 5.8 | 5.8 | 1900.0 |
| 2002-09-19 | ABFS-DELISTED | Stock | 27.35 | 27.65 | 26.63 | 27.27 | 194800.0 |
| 2002-09-19 | ABG | Stock | 10.4 | 10.79 | 10.35 | 10.45 | 118600.0 |
| 2002-09-19 | ABK-DELISTED | Stock | 54.0 | 55.0 | 53.63 | 53.75 | 558100.0 |
| 2002-09-19 | ABM | Stock | 13.99 | 14.0 | 13.71 | 13.72 | 99000.0 |
| 2002-09-19 | ABMD-DELISTED | Stock | 4.3 | 4.48 | 4.25 | 4.25 | 29100.0 |
| 2002-09-19 | ABP-DELISTED | Stock | 0.78 | 0.83 | 0.76 | 0.78 | 25200.0 |
| 2002-09-19 | ABT | Stock | 17.772 | 18.1311 | 17.772 | 18.0009 | 9624174.0 |
| 2002-09-19 | ABTL-DELISTED | Stock | 10.0 | 10.2 | 9.55 | 10.0 | 41100.0 |
| 2002-09-19 | ABV-DELISTED | Stock | 12.5 | 12.5 | 11.62 | 11.8 | 447000.0 |
| 2002-09-19 | ABVA-DELISTED | Stock | 10.5 | 10.5 | 10.4 | 10.4 | 2500.0 |
| 2002-09-19 | ABX-DELISTED | Stock | 17.38 | 17.47 | 17.11 | 17.44 | 2891200.0 |
| 2002-09-19 | ACAP-DELISTED | Stock | 17.3 | 17.59 | 17.03 | 17.05 | 42900.0 |
| 2002-09-19 | ACAS-DELISTED | Stock | 18.1 | 18.46 | 17.5 | 18.1 | 1314805.0 |
| 2002-09-19 | ACAT-DELISTED | Stock | 14.54 | 14.72 | 14.1 | 14.1 | 122984.0 |
| 2002-09-19 | ACCL-DELISTED | Stock | 6.17999982833862 | 6.28499984741211 | 5.90199995040894 | 5.95900011062622 | 78700.0 |
| 2002-09-19 | ACE-DELISTED | Stock | 31.95 | 32.3 | 31.58 | 31.6 | 1327700.0 |
| 2002-09-19 | ACF-DELISTED | Stock | 7.0 | 7.5 | 7.0 | 7.15 | 2809100.0 |
| 2002-09-19 | ACG-DELISTED | Stock | 8.18 | 8.22 | 8.17 | 8.17 | 525800.0 |
| 2002-09-19 | ACGL | Stock | 3.0722 | 3.1211 | 3.0722 | 3.0889 | 499500.0 |
| 2002-09-19 | ACGN-DELISTED | Stock | 963.3288 | 963.3288 | 929.3288 | 963.3288 | 11900.0 |
| 2002-09-19 | ACH | Stock | 9.9333 | 10.0333 | 9.8467 | 10.0 | 109200.0 |
| 2002-09-19 | ACH-DELISTED | Stock | 3.125 | 3.125 | 3.075 | 3.075 | 17200.0 |
| 2002-09-19 | ACLS | Stock | 22.2 | 22.2 | 20.32 | 20.36 | 119300.0 |
| 2002-09-19 | ACO-DELISTED | Stock | 5.85 | 6.1 | 5.75 | 5.78 | 46400.0 |
| 2002-09-19 | ACPW-DELISTED | Stock | 6.5 | 6.75 | 6.25 | 6.5 | 38520.0 |
| 2002-09-19 | ACS-DELISTED | Stock | 41.5 | 43.248 | 40.65 | 40.9 | 5404500.0 |
| 2002-09-19 | ACTA-DELISTED | Stock | 4.4 | 4.4 | 4.0 | 4.2 | 52900.0 |
| 2002-09-19 | ACTT-DELISTED | Stock | 1.92 | 2.04 | 1.76 | 1.85 | 14600.0 |
| 2002-09-19 | ACTU-DELISTED | Stock | 1.23 | 1.24 | 0.77 | 0.82 | 1729458.0 |
| 2002-09-19 | ACXM-DELISTED | Stock | 16.99 | 17.75 | 16.44 | 17.01 | 2041663.0 |
> showing 50 of 3,219 rows — these rows as CSV