PREVIEW / stock_daily / 2002-08-21
file: by_date/stock_daily/2002/2002-08-21.parquet size: 107 KB rows: 3,153 symbols: 1,953
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-21 | AAPL | Stock | 0.2859 | 0.29 | 0.2759 | 0.2879 | 202428800.0 |
| 2002-08-21 | MSFT | Stock | 25.78 | 26.19 | 25.575 | 26.14 | 81203400.0 |
| 2002-08-21 | NVDA | Stock | 0.1053 | 0.1074 | 0.1004 | 0.1061 | 1194876000.0 |
| 2002-08-21 | AMZN | Stock | 0.7975 | 0.7985 | 0.76 | 0.769 | 145684000.0 |
| 2002-08-21 | CL | Stock | 27.2 | 27.445 | 27.14 | 27.355 | 2184800.0 |
| 2002-08-21 | A | Stock | 11.6953 | 12.3391 | 11.4878 | 12.196 | 3668911.0 |
| 2002-08-21 | AABA-DELISTED | Stock | 6.67500019073486 | 6.73999977111816 | 6.34999990463257 | 6.44999980926514 | 20940400.0 |
| 2002-08-21 | AAI-DELISTED | Stock | 3.81 | 3.89 | 3.7 | 3.85 | 272900.0 |
| 2002-08-21 | AAIC-DELISTED | Stock | 219.0 | 219.8 | 211.6 | 215.2 | 123500.0 |
| 2002-08-21 | AAME | Stock | 1.94 | 2.26 | 1.93 | 1.93 | 1400.0 |
| 2002-08-21 | AAON | Stock | 2.29 | 2.3453 | 2.1926 | 2.3032 | 226294.0 |
| 2002-08-21 | AAP | Stock | 17.9167 | 18.1167 | 17.75 | 18.0667 | 738300.0 |
| 2002-08-21 | AAXN-DELISTED | Stock | 0.589999973773956 | 0.589999973773956 | 0.550833344459534 | 0.566666662693024 | 241200.0 |
| 2002-08-21 | ABAX-DELISTED | Stock | 3.19 | 3.85 | 3.1 | 3.3 | 28900.0 |
| 2002-08-21 | ABB-DELISTED | Stock | 4.65 | 4.9 | 4.47 | 4.9 | 77100.0 |
| 2002-08-21 | ABC-DELISTED | Stock | 17.4 | 17.68 | 17.3 | 17.62 | 2780400.0 |
| 2002-08-21 | ABCB | Stock | 11.4042 | 11.4528 | 11.1854 | 11.4528 | 19617.0 |
| 2002-08-21 | ABCO-DELISTED | Stock | 15.705 | 16.1 | 15.68 | 16.1 | 30600.0 |
| 2002-08-21 | ABCW-DELISTED | Stock | 21.33 | 21.44 | 20.96 | 21.17 | 31830.0 |
| 2002-08-21 | ABE-DELISTED | Stock | 6.33 | 6.43 | 6.33 | 6.33 | 8300.0 |
| 2002-08-21 | ABFS-DELISTED | Stock | 22.28 | 22.85 | 22.27 | 22.85 | 139900.0 |
| 2002-08-21 | ABG | Stock | 11.75 | 11.95 | 11.0 | 11.45 | 143700.0 |
| 2002-08-21 | ABK-DELISTED | Stock | 58.35 | 59.24 | 58.0 | 58.65 | 568600.0 |
| 2002-08-21 | ABM | Stock | 16.9 | 17.5 | 16.9 | 17.5 | 83200.0 |
| 2002-08-21 | ABMD-DELISTED | Stock | 5.73 | 5.85 | 5.13 | 5.13 | 37499.0 |
| 2002-08-21 | ABP-DELISTED | Stock | 0.5 | 0.84 | 0.48 | 0.7 | 380500.0 |
| 2002-08-21 | ABT | Stock | 17.543 | 18.1984 | 17.5386 | 18.1536 | 6111817.0 |
| 2002-08-21 | ABTL-DELISTED | Stock | 12.25 | 12.7 | 11.0 | 12.55 | 73900.0 |
| 2002-08-21 | ABV-DELISTED | Stock | 14.25 | 14.55 | 14.08 | 14.1 | 170200.0 |
| 2002-08-21 | ABX-DELISTED | Stock | 14.9 | 14.91 | 14.5 | 14.67 | 3182700.0 |
| 2002-08-21 | ACAP-DELISTED | Stock | 17.74 | 17.84 | 17.45 | 17.84 | 17500.0 |
| 2002-08-21 | ACAS-DELISTED | Stock | 22.9 | 23.34 | 22.8 | 22.9 | 602835.0 |
| 2002-08-21 | ACAT-DELISTED | Stock | 15.75 | 15.86 | 15.09 | 15.599 | 33222.0 |
| 2002-08-21 | ACCL-DELISTED | Stock | 5.59999990463257 | 5.8439998626709 | 5.39499998092651 | 5.80000019073486 | 140000.0 |
| 2002-08-21 | ACE-DELISTED | Stock | 33.15 | 33.59 | 32.24 | 32.74 | 1848100.0 |
| 2002-08-21 | ACF-DELISTED | Stock | 14.2 | 14.55 | 13.83 | 14.51 | 1080600.0 |
| 2002-08-21 | ACG-DELISTED | Stock | 8.06 | 8.1 | 8.05 | 8.08 | 374000.0 |
| 2002-08-21 | ACGL | Stock | 3.1211 | 3.1211 | 3.0633 | 3.1111 | 125100.0 |
| 2002-08-21 | ACGN-DELISTED | Stock | 850.0 | 906.6712 | 770.6712 | 850.0 | 24200.0 |
| 2002-08-21 | ACH | Stock | 9.6 | 9.7667 | 9.5533 | 9.6667 | 105600.0 |
| 2002-08-21 | ACH-DELISTED | Stock | 3.8125 | 3.8125 | 3.75 | 3.775 | 178800.0 |
| 2002-08-21 | ACLS | Stock | 32.12 | 35.8 | 32.0 | 35.8 | 102675.0 |
| 2002-08-21 | ACO-DELISTED | Stock | 5.74 | 5.9 | 5.5 | 5.9 | 21000.0 |
| 2002-08-21 | ACPW-DELISTED | Stock | 11.25 | 12.5 | 11.0 | 12.4 | 23840.0 |
| 2002-08-21 | ACS-DELISTED | Stock | 48.3 | 49.3 | 48.2 | 49.24 | 948500.0 |
| 2002-08-21 | ACTA-DELISTED | Stock | 3.8 | 4.6 | 3.8 | 4.4 | 64700.0 |
| 2002-08-21 | ACTT-DELISTED | Stock | 1.8 | 1.8 | 1.3997 | 1.3997 | 50600.0 |
| 2002-08-21 | ACTU-DELISTED | Stock | 2.15 | 2.15 | 1.97 | 2.05 | 302078.0 |
| 2002-08-21 | ACXM-DELISTED | Stock | 17.17 | 17.46 | 17.08 | 17.44 | 358201.0 |
| 2002-08-21 | AD | Stock | 20.8333 | 20.9333 | 20.5667 | 20.8 | 170550.0 |
> showing 50 of 3,153 rows — these rows as CSV