PREVIEW / stock_daily / 2002-08-19
file: by_date/stock_daily/2002/2002-08-19.parquet size: 106 KB rows: 3,150 symbols: 1,945
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-19 | AAPL | Stock | 0.2818 | 0.2902 | 0.2807 | 0.2854 | 216557600.0 |
| 2002-08-19 | MSFT | Stock | 25.02 | 26.025 | 24.925 | 26.0 | 79848200.0 |
| 2002-08-19 | NVDA | Stock | 0.0929 | 0.1121 | 0.0927 | 0.1054 | 2243928000.0 |
| 2002-08-19 | AMZN | Stock | 0.742 | 0.776 | 0.7335 | 0.775 | 85542000.0 |
| 2002-08-19 | CL | Stock | 26.975 | 27.46 | 26.825 | 27.45 | 2857200.0 |
| 2002-08-19 | A | Stock | 11.3448 | 12.6252 | 11.3019 | 12.475 | 4195398.0 |
| 2002-08-19 | AABA-DELISTED | Stock | 6.02500009536743 | 6.77500009536743 | 6.01999998092651 | 6.7350001335144 | 25111800.0 |
| 2002-08-19 | AAI-DELISTED | Stock | 3.84 | 3.94 | 3.74 | 3.9 | 213600.0 |
| 2002-08-19 | AAIC-DELISTED | Stock | 219.0 | 219.0 | 214.0 | 217.8 | 160500.0 |
| 2002-08-19 | AAME | Stock | 2.2 | 2.2 | 1.92 | 2.1 | 1100.0 |
| 2002-08-19 | AAON | Stock | 2.1728 | 2.2387 | 2.1728 | 2.2387 | 268819.0 |
| 2002-08-19 | AAP | Stock | 17.25 | 18.1333 | 17.24 | 17.85 | 2096100.0 |
| 2002-08-19 | AAXN-DELISTED | Stock | 0.574999988079071 | 0.591666638851166 | 0.564166665077209 | 0.591666638851166 | 96000.0 |
| 2002-08-19 | ABAX-DELISTED | Stock | 3.08 | 3.48 | 2.91 | 3.0 | 92200.0 |
| 2002-08-19 | ABB-DELISTED | Stock | 3.95 | 4.19 | 3.89 | 4.05 | 42800.0 |
| 2002-08-19 | ABC-DELISTED | Stock | 17.0 | 17.31 | 17.0 | 17.28 | 2272000.0 |
| 2002-08-19 | ABCB | Stock | 11.4934 | 11.4934 | 11.3475 | 11.3475 | 20234.0 |
| 2002-08-19 | ABCO-DELISTED | Stock | 16.05 | 16.05 | 15.84 | 15.91 | 60889.0 |
| 2002-08-19 | ABCW-DELISTED | Stock | 21.04 | 21.5 | 21.02 | 21.11 | 37200.0 |
| 2002-08-19 | ABE-DELISTED | Stock | 6.35 | 6.43 | 6.28 | 6.38 | 5100.0 |
| 2002-08-19 | ABFS-DELISTED | Stock | 21.99 | 23.07 | 21.88 | 22.4 | 191499.0 |
| 2002-08-19 | ABG | Stock | 10.3 | 11.35 | 10.3 | 11.33 | 78900.0 |
| 2002-08-19 | ABK-DELISTED | Stock | 58.7 | 59.5 | 58.29 | 59.41 | 599500.0 |
| 2002-08-19 | ABM | Stock | 16.8 | 17.39 | 16.65 | 17.26 | 92700.0 |
| 2002-08-19 | ABMD-DELISTED | Stock | 5.81 | 6.06 | 5.63 | 5.78 | 45297.0 |
| 2002-08-19 | ABP-DELISTED | Stock | 0.5 | 0.54 | 0.5 | 0.54 | 41200.0 |
| 2002-08-19 | ABT | Stock | 17.9336 | 18.1311 | 17.9111 | 17.956 | 6647793.0 |
| 2002-08-19 | ABTL-DELISTED | Stock | 12.25 | 12.7 | 11.65 | 12.0 | 17100.0 |
| 2002-08-19 | ABV-DELISTED | Stock | 14.08 | 14.6 | 14.08 | 14.25 | 711300.0 |
| 2002-08-19 | ABVA-DELISTED | Stock | 9.25 | 9.25 | 9.25 | 9.25 | 500.0 |
| 2002-08-19 | ABX-DELISTED | Stock | 15.6 | 15.6 | 14.85 | 15.03 | 3070100.0 |
| 2002-08-19 | ACAP-DELISTED | Stock | 18.5 | 18.6 | 18.08 | 18.5 | 5300.0 |
| 2002-08-19 | ACAS-DELISTED | Stock | 23.05 | 23.4 | 22.52 | 22.99 | 874128.0 |
| 2002-08-19 | ACAT-DELISTED | Stock | 15.11 | 16.12 | 15.1 | 16.01 | 36744.0 |
| 2002-08-19 | ACCL-DELISTED | Stock | 5.42999982833862 | 5.49599981307983 | 4.98199987411499 | 5.30100011825562 | 113100.0 |
| 2002-08-19 | ACE-DELISTED | Stock | 32.85 | 33.45 | 32.62 | 33.31 | 903200.0 |
| 2002-08-19 | ACF-DELISTED | Stock | 13.63 | 14.38 | 13.37 | 14.16 | 3241100.0 |
| 2002-08-19 | ACG-DELISTED | Stock | 8.01 | 8.08 | 8.01 | 8.04 | 478100.0 |
| 2002-08-19 | ACGL | Stock | 3.0556 | 3.0667 | 3.0444 | 3.0667 | 621000.0 |
| 2002-08-19 | ACGN-DELISTED | Stock | 918.0 | 963.3288 | 918.0 | 963.3288 | 2000.0 |
| 2002-08-19 | ACH | Stock | 9.6267 | 9.74 | 9.5667 | 9.7 | 154800.0 |
| 2002-08-19 | ACH-DELISTED | Stock | 3.75 | 3.815 | 3.75 | 3.815 | 40800.0 |
| 2002-08-19 | ACLS | Stock | 32.48 | 34.0 | 32.12 | 33.2 | 95775.0 |
| 2002-08-19 | ACO-DELISTED | Stock | 5.95 | 5.98 | 5.86 | 5.95 | 11000.0 |
| 2002-08-19 | ACPW-DELISTED | Stock | 11.474 | 12.141 | 11.469 | 11.676 | 8399.0 |
| 2002-08-19 | ACS-DELISTED | Stock | 48.85 | 49.49 | 48.52 | 49.41 | 748900.0 |
| 2002-08-19 | ACTA-DELISTED | Stock | 4.2 | 4.2 | 3.8 | 4.0 | 44100.0 |
| 2002-08-19 | ACTT-DELISTED | Stock | 1.56 | 2.17 | 1.51 | 1.8 | 70300.0 |
| 2002-08-19 | ACTU-DELISTED | Stock | 1.96 | 2.15 | 1.96 | 2.15 | 190672.0 |
| 2002-08-19 | ACXM-DELISTED | Stock | 17.2 | 17.37 | 17.08 | 17.26 | 467459.0 |
> showing 50 of 3,150 rows — these rows as CSV