PREVIEW / stock_daily / 2003-08-20
file: by_date/stock_daily/2003/2003-08-20.parquet size: 117 KB rows: 3,430 symbols: 2,113
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 |
|---|---|---|---|---|---|---|---|
| 2003-08-20 | AAPL | Stock | 0.3604 | 0.3798 | 0.3596 | 0.3752 | 273212800.0 |
| 2003-08-20 | MSFT | Stock | 26.3 | 26.53 | 26.0 | 26.45 | 56739300.0 |
| 2003-08-20 | NVDA | Stock | 0.1471 | 0.1498 | 0.1438 | 0.1471 | 870348000.0 |
| 2003-08-20 | AMZN | Stock | 2.153 | 2.197 | 2.1505 | 2.188 | 134494000.0 |
| 2003-08-20 | CL | Stock | 27.22 | 27.35 | 27.08 | 27.24 | 2400400.0 |
| 2003-08-20 | A | Stock | 17.1102 | 17.5465 | 17.0529 | 17.4392 | 4400345.0 |
| 2003-08-20 | AABA-DELISTED | Stock | 15.7449998855591 | 16.1700000762939 | 15.7399997711182 | 15.9949998855591 | 15894200.0 |
| 2003-08-20 | AAI-DELISTED | Stock | 14.25 | 14.25 | 13.6 | 13.65 | 2303100.0 |
| 2003-08-20 | AAIC-DELISTED | Stock | 335.0 | 335.0 | 323.0 | 330.8 | 974600.0 |
| 2003-08-20 | AAME | Stock | 2.4 | 2.64 | 2.27 | 2.45 | 56000.0 |
| 2003-08-20 | AAON | Stock | 2.423 | 2.4362 | 2.423 | 2.4362 | 42525.0 |
| 2003-08-20 | AAP | Stock | 23.8333 | 24.11 | 23.75 | 24.0 | 2921700.0 |
| 2003-08-20 | AAXN-DELISTED | Stock | 1.93499994277954 | 2.05916666984558 | 1.89583337306976 | 1.99916660785675 | 1333200.0 |
| 2003-08-20 | ABAX-DELISTED | Stock | 8.6 | 8.92 | 8.25 | 8.87 | 158800.0 |
| 2003-08-20 | ABB-DELISTED | Stock | 5.55 | 5.55 | 5.15 | 5.17 | 846000.0 |
| 2003-08-20 | ABC-DELISTED | Stock | 15.23 | 15.23 | 14.99 | 15.0 | 3150800.0 |
| 2003-08-20 | ABCB | Stock | 13.3739 | 13.3739 | 13.1712 | 13.2927 | 26896.0 |
| 2003-08-20 | ABCO-DELISTED | Stock | 21.6 | 21.95 | 21.4 | 21.72 | 186024.0 |
| 2003-08-20 | ABCW-DELISTED | Stock | 25.13 | 25.33 | 25.05 | 25.22 | 22800.0 |
| 2003-08-20 | ABE-DELISTED | Stock | 6.32 | 6.33 | 6.28 | 6.31 | 13700.0 |
| 2003-08-20 | ABFS-DELISTED | Stock | 28.0 | 28.29 | 27.75 | 28.0 | 83925.0 |
| 2003-08-20 | ABG | Stock | 17.25 | 17.5 | 17.1 | 17.12 | 19700.0 |
| 2003-08-20 | ABK-DELISTED | Stock | 65.75 | 66.7 | 65.6 | 66.36 | 231400.0 |
| 2003-08-20 | ABM | Stock | 15.87 | 16.3 | 15.78 | 16.25 | 156200.0 |
| 2003-08-20 | ABMD-DELISTED | Stock | 5.34 | 5.42 | 5.25 | 5.25 | 15420.0 |
| 2003-08-20 | ABP-DELISTED | Stock | 1.0 | 1.0 | 0.98 | 1.0 | 62900.0 |
| 2003-08-20 | ABT | Stock | 17.5969 | 17.6777 | 17.359 | 17.5071 | 10547317.0 |
| 2003-08-20 | ABTL-DELISTED | Stock | 34.05 | 37.85 | 33.75 | 37.7 | 223300.0 |
| 2003-08-20 | ABV-DELISTED | Stock | 19.7 | 19.72 | 19.37 | 19.67 | 731300.0 |
| 2003-08-20 | ABVA-DELISTED | Stock | 20.0 | 20.0 | 19.6 | 19.6 | 800.0 |
| 2003-08-20 | ABX-DELISTED | Stock | 19.0 | 20.0 | 19.0 | 19.75 | 4858200.0 |
| 2003-08-20 | ACAP-DELISTED | Stock | 28.29 | 28.47 | 28.03 | 28.32 | 46992.0 |
| 2003-08-20 | ACAS-DELISTED | Stock | 23.56 | 24.6 | 23.5 | 24.33 | 1047116.0 |
| 2003-08-20 | ACAT-DELISTED | Stock | 21.85 | 22.12 | 21.72 | 22.03 | 25059.0 |
| 2003-08-20 | ACCL-DELISTED | Stock | 7.94352006912231 | 8.05937957763672 | 7.94352006912231 | 8.05937957763672 | 93000.0 |
| 2003-08-20 | ACE-DELISTED | Stock | 32.84 | 33.63 | 32.72 | 33.62 | 1420191.0 |
| 2003-08-20 | ACF-DELISTED | Stock | 8.05 | 8.25 | 7.8 | 8.16 | 1350500.0 |
| 2003-08-20 | ACG-DELISTED | Stock | 8.2 | 8.24 | 8.15 | 8.18 | 364600.0 |
| 2003-08-20 | ACGL | Stock | 3.9056 | 3.9322 | 3.8789 | 3.8856 | 546300.0 |
| 2003-08-20 | ACGN-DELISTED | Stock | 1042.6712 | 1065.3288 | 1008.6712 | 1020.0 | 49400.0 |
| 2003-08-20 | ACH | Stock | 15.9467 | 15.9933 | 15.6533 | 15.8267 | 205800.0 |
| 2003-08-20 | ACH-DELISTED | Stock | 7.5 | 7.587 | 7.5 | 7.537 | 36801.0 |
| 2003-08-20 | ACLS | Stock | 33.12 | 34.0 | 31.92 | 33.96 | 195675.0 |
| 2003-08-20 | ACO-DELISTED | Stock | 10.75 | 11.5 | 10.7 | 11.01 | 240000.0 |
| 2003-08-20 | ACPW-DELISTED | Stock | 10.25 | 10.4 | 9.2 | 9.85 | 51063.0 |
| 2003-08-20 | ACS-DELISTED | Stock | 46.05 | 47.15 | 45.66 | 46.7 | 1333700.0 |
| 2003-08-20 | ACTA-DELISTED | Stock | 8.8 | 9.0 | 8.4 | 8.4 | 239100.0 |
| 2003-08-20 | ACTG | Stock | 1.76 | 1.81 | 1.66 | 1.72 | 117500.0 |
| 2003-08-20 | ACTI-DELISTED | Stock | 8.21 | 8.85 | 8.21 | 8.85 | 394991.0 |
| 2003-08-20 | ACTT-DELISTED | Stock | 2.35 | 2.35 | 2.29 | 2.3 | 70903.0 |
> showing 50 of 3,430 rows — these rows as CSV