PREVIEW / stock_daily / 2002-08-20
file: by_date/stock_daily/2002/2002-08-20.parquet size: 107 KB rows: 3,165 symbols: 1,962
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-20 | AAPL | Stock | 0.2852 | 0.2873 | 0.2773 | 0.2841 | 186625600.0 |
| 2002-08-20 | MSFT | Stock | 25.69 | 25.85 | 25.375 | 25.52 | 70317600.0 |
| 2002-08-20 | NVDA | Stock | 0.1062 | 0.1083 | 0.0994 | 0.1007 | 1429488000.0 |
| 2002-08-20 | AMZN | Stock | 0.769 | 0.7995 | 0.7655 | 0.799 | 154026000.0 |
| 2002-08-20 | CL | Stock | 27.325 | 27.375 | 26.925 | 27.15 | 2958800.0 |
| 2002-08-20 | A | Stock | 11.6237 | 12.4464 | 11.2661 | 11.588 | 10734263.0 |
| 2002-08-20 | AABA-DELISTED | Stock | 6.58500003814697 | 6.73000001907349 | 6.44999980926514 | 6.54500007629395 | 16508200.0 |
| 2002-08-20 | AAI-DELISTED | Stock | 4.0 | 4.0 | 3.75 | 3.77 | 181900.0 |
| 2002-08-20 | AAIC-DELISTED | Stock | 218.0 | 220.6 | 211.0 | 218.8 | 114700.0 |
| 2002-08-20 | AAME | Stock | 2.11 | 2.2 | 2.1 | 2.1 | 1600.0 |
| 2002-08-20 | AAON | Stock | 2.2505 | 2.2848 | 2.1873 | 2.2782 | 527766.0 |
| 2002-08-20 | AAP | Stock | 17.8167 | 17.98 | 17.7367 | 17.7667 | 1119300.0 |
| 2002-08-20 | AAXN-DELISTED | Stock | 0.590833306312561 | 0.591666638851166 | 0.564999997615814 | 0.579166650772095 | 68400.0 |
| 2002-08-20 | ABAX-DELISTED | Stock | 3.01 | 3.15 | 2.98 | 3.15 | 25000.0 |
| 2002-08-20 | ABB-DELISTED | Stock | 4.0 | 4.1 | 3.85 | 4.05 | 88200.0 |
| 2002-08-20 | ABC-DELISTED | Stock | 17.3 | 17.35 | 17.0 | 17.26 | 2732800.0 |
| 2002-08-20 | ABCB | Stock | 11.4042 | 11.4285 | 11.1449 | 11.1449 | 11844.0 |
| 2002-08-20 | ABCO-DELISTED | Stock | 15.837 | 15.867 | 15.528 | 15.708 | 39465.0 |
| 2002-08-20 | ABCW-DELISTED | Stock | 21.39 | 21.53 | 20.9 | 21.24 | 17330.0 |
| 2002-08-20 | ABE-DELISTED | Stock | 6.33 | 6.33 | 6.3 | 6.31 | 6000.0 |
| 2002-08-20 | ABFS-DELISTED | Stock | 22.4 | 22.71 | 22.07 | 22.15 | 126000.0 |
| 2002-08-20 | ABG | Stock | 11.4 | 11.8 | 11.39 | 11.65 | 58000.0 |
| 2002-08-20 | ABK-DELISTED | Stock | 59.25 | 59.25 | 57.61 | 57.84 | 1149000.0 |
| 2002-08-20 | ABM | Stock | 17.2 | 17.3 | 16.65 | 17.3 | 151200.0 |
| 2002-08-20 | ABMD-DELISTED | Stock | 5.595 | 5.78 | 5.5 | 5.63 | 16900.0 |
| 2002-08-20 | ABP-DELISTED | Stock | 0.5 | 0.54 | 0.5 | 0.51 | 202000.0 |
| 2002-08-20 | ABT | Stock | 17.9515 | 17.9515 | 17.3949 | 17.552 | 7599005.0 |
| 2002-08-20 | ABTL-DELISTED | Stock | 12.25 | 12.5 | 11.65 | 12.3 | 5800.0 |
| 2002-08-20 | ABV-DELISTED | Stock | 14.35 | 14.4 | 14.15 | 14.24 | 380600.0 |
| 2002-08-20 | ABX-DELISTED | Stock | 15.17 | 15.3 | 14.9 | 14.94 | 3201900.0 |
| 2002-08-20 | ACAP-DELISTED | Stock | 18.01 | 18.01 | 17.25 | 17.45 | 43600.0 |
| 2002-08-20 | ACAS-DELISTED | Stock | 23.17 | 23.2 | 22.55 | 22.73 | 487139.0 |
| 2002-08-20 | ACAT-DELISTED | Stock | 15.83 | 16.2 | 15.3966 | 15.67 | 121366.0 |
| 2002-08-20 | ACCL-DELISTED | Stock | 5.24982023239136 | 5.6263599395752 | 5.24982023239136 | 5.6263599395752 | 63900.0 |
| 2002-08-20 | ACE-DELISTED | Stock | 33.3 | 33.45 | 32.5 | 32.97 | 798500.0 |
| 2002-08-20 | ACF-DELISTED | Stock | 14.4 | 14.5 | 13.97 | 14.0 | 1945400.0 |
| 2002-08-20 | ACG-DELISTED | Stock | 8.05 | 8.08 | 8.04 | 8.06 | 354900.0 |
| 2002-08-20 | ACGL | Stock | 3.1 | 3.1222 | 3.0567 | 3.1211 | 1064700.0 |
| 2002-08-20 | ACGN-DELISTED | Stock | 963.3288 | 963.3288 | 759.3288 | 759.3288 | 54700.0 |
| 2002-08-20 | ACH | Stock | 9.6867 | 9.6867 | 9.4667 | 9.6667 | 64950.0 |
| 2002-08-20 | ACH-DELISTED | Stock | 3.8075 | 3.8375 | 3.8075 | 3.825 | 10800.0 |
| 2002-08-20 | ACLS | Stock | 33.2 | 33.24 | 31.96 | 32.16 | 97175.0 |
| 2002-08-20 | ACO-DELISTED | Stock | 5.89 | 5.95 | 5.7 | 5.7 | 3600.0 |
| 2002-08-20 | ACPW-DELISTED | Stock | 11.674 | 11.724 | 11.076 | 11.126 | 16294.0 |
| 2002-08-20 | ACS-DELISTED | Stock | 49.41 | 49.41 | 48.02 | 48.15 | 1124200.0 |
| 2002-08-20 | ACTA-DELISTED | Stock | 4.0 | 4.2 | 3.6 | 3.8 | 34400.0 |
| 2002-08-20 | ACTT-DELISTED | Stock | 1.75 | 1.85 | 1.64 | 1.7 | 39800.0 |
| 2002-08-20 | ACTU-DELISTED | Stock | 2.1 | 2.5 | 2.06 | 2.1 | 884225.0 |
| 2002-08-20 | ACXM-DELISTED | Stock | 17.17 | 17.371 | 17.07 | 17.2 | 522126.0 |
| 2002-08-20 | ACY-DELISTED | Stock | 3.82 | 3.96 | 3.82 | 3.96 | 1400.0 |
> showing 50 of 3,165 rows — these rows as CSV