PREVIEW / stock_daily / 2004-07-29
file: by_date/stock_daily/2004/2004-07-29.parquet size: 126 KB rows: 3,772 symbols: 2,352
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-29 | AAPL | Stock | 0.5798 | 0.5861 | 0.5738 | 0.5829 | 222157600.0 |
| 2004-07-29 | MSFT | Stock | 28.78 | 28.8 | 28.25 | 28.48 | 60148400.0 |
| 2004-07-29 | NVDA | Stock | 0.1209 | 0.1302 | 0.1203 | 0.1271 | 747360000.0 |
| 2004-07-29 | AMZN | Stock | 1.9155 | 1.948 | 1.901 | 1.929 | 164000000.0 |
| 2004-07-29 | CL | Stock | 26.8 | 26.81 | 26.505 | 26.645 | 3037000.0 |
| 2004-07-29 | A | Stock | 16.4878 | 16.9456 | 16.4878 | 16.8455 | 5296183.0 |
| 2004-07-29 | AABA-DELISTED | Stock | 30.5599994659424 | 30.7999992370605 | 30.0 | 30.4899997711182 | 18747300.0 |
| 2004-07-29 | AACC-DELISTED | Stock | 16.12 | 17.09 | 16.12 | 16.96 | 115786.0 |
| 2004-07-29 | AAI-DELISTED | Stock | 11.04 | 11.38 | 11.0 | 11.16 | 1407900.0 |
| 2004-07-29 | AAIC-DELISTED | Stock | 319.6 | 324.2 | 318.0 | 320.6 | 1603700.0 |
| 2004-07-29 | AAME | Stock | 2.83 | 2.95 | 2.83 | 2.87 | 2400.0 |
| 2004-07-29 | AAON | Stock | 2.3111 | 2.3796 | 2.3019 | 2.3585 | 228572.0 |
| 2004-07-29 | AAP | Stock | 24.1333 | 24.76 | 24.1333 | 24.7267 | 1093350.0 |
| 2004-07-29 | AAV-DELISTED | Stock | 14.72 | 14.75 | 14.61 | 14.72 | 15300.0 |
| 2004-07-29 | AAXN-DELISTED | Stock | 16.6800003051758 | 17.0 | 15.125 | 15.7200002670288 | 22897800.0 |
| 2004-07-29 | ABAX-DELISTED | Stock | 14.74 | 14.882 | 14.42 | 14.7 | 131013.0 |
| 2004-07-29 | ABB-DELISTED | Stock | 5.22 | 5.28 | 5.18 | 5.23 | 247000.0 |
| 2004-07-29 | ABC-DELISTED | Stock | 13.22 | 13.52 | 13.13 | 13.5 | 3685200.0 |
| 2004-07-29 | ABCB | Stock | 14.152 | 14.4924 | 14.1439 | 14.4681 | 16533.0 |
| 2004-07-29 | ABCO-DELISTED | Stock | 15.264 | 15.411 | 15.181 | 15.381 | 333189.0 |
| 2004-07-29 | ABCW-DELISTED | Stock | 25.72 | 25.8 | 25.44 | 25.8 | 29030.0 |
| 2004-07-29 | ABE-DELISTED | Stock | 7.56 | 7.65 | 7.55 | 7.63 | 5100.0 |
| 2004-07-29 | ABFS-DELISTED | Stock | 34.28 | 35.39 | 34.28 | 35.28 | 380202.0 |
| 2004-07-29 | ABG | Stock | 14.11 | 14.12 | 13.19 | 13.75 | 121700.0 |
| 2004-07-29 | ABK-DELISTED | Stock | 70.56 | 71.35 | 70.47 | 71.08 | 545300.0 |
| 2004-07-29 | ABM | Stock | 18.1 | 18.22 | 17.69 | 18.17 | 72200.0 |
| 2004-07-29 | ABMD-DELISTED | Stock | 9.39 | 10.13 | 9.35 | 9.91 | 63077.0 |
| 2004-07-29 | ABP-DELISTED | Stock | 1.3 | 1.33 | 1.21 | 1.29 | 67100.0 |
| 2004-07-29 | ABR | Stock | 18.6 | 19.35 | 18.6 | 19.35 | 153200.0 |
| 2004-07-29 | ABT | Stock | 18.7362 | 18.9041 | 18.5922 | 18.7842 | 4733847.0 |
| 2004-07-29 | ABTL-DELISTED | Stock | 33.75 | 35.1 | 32.9 | 34.15 | 88900.0 |
| 2004-07-29 | ABV-DELISTED | Stock | 20.52 | 20.6 | 20.35 | 20.36 | 246700.0 |
| 2004-07-29 | ABVA-DELISTED | Stock | 15.31 | 15.31 | 15.31 | 15.31 | 388.0 |
| 2004-07-29 | ABVT-DELISTED | Stock | 29.0 | 30.99 | 22.25 | 30.99 | 2200.0 |
| 2004-07-29 | ABX-DELISTED | Stock | 18.45 | 19.03 | 18.44 | 18.86 | 1324700.0 |
| 2004-07-29 | ACAD | Stock | 6.08 | 6.3 | 5.98 | 6.29 | 10200.0 |
| 2004-07-29 | ACAP-DELISTED | Stock | 24.13 | 24.3 | 23.61 | 23.9 | 24163.0 |
| 2004-07-29 | ACAS-DELISTED | Stock | 28.8 | 29.11 | 28.77 | 28.82 | 312730.0 |
| 2004-07-29 | ACAT-DELISTED | Stock | 27.01 | 27.96 | 26.97 | 27.66 | 216028.0 |
| 2004-07-29 | ACCL-DELISTED | Stock | 7.15 | 7.45 | 6.94 | 7.44 | 102634.0 |
| 2004-07-29 | ACE-DELISTED | Stock | 39.99 | 40.3 | 39.87 | 40.01 | 712000.0 |
| 2004-07-29 | ACF-DELISTED | Stock | 19.05 | 19.4 | 18.8 | 19.29 | 560200.0 |
| 2004-07-29 | ACG-DELISTED | Stock | 8.18 | 8.22 | 8.15 | 8.21 | 379400.0 |
| 2004-07-29 | ACGL | Stock | 4.1311 | 4.1889 | 4.1133 | 4.1511 | 5622300.0 |
| 2004-07-29 | ACGN-DELISTED | Stock | 555.3288 | 555.3288 | 510.0 | 521.3288 | 75600.0 |
| 2004-07-29 | ACH | Stock | 17.3333 | 17.7 | 17.1667 | 17.6933 | 214350.0 |
| 2004-07-29 | ACH-DELISTED | Stock | 13.13 | 13.35 | 13.0 | 13.29 | 425200.0 |
| 2004-07-29 | ACLS | Stock | 38.44 | 38.56 | 35.4 | 35.84 | 666900.0 |
| 2004-07-29 | ACO-DELISTED | Stock | 18.94 | 19.3 | 18.9 | 19.27 | 225000.0 |
| 2004-07-29 | ACPW-DELISTED | Stock | 15.0 | 15.5 | 14.4 | 15.5 | 48535.0 |
> showing 50 of 3,772 rows — these rows as CSV