PREVIEW / stock_daily / 2004-08-04
file: by_date/stock_daily/2004/2004-08-04.parquet size: 126 KB rows: 3,784 symbols: 2,361
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-08-04 | AAPL | Stock | 0.557 | 0.5736 | 0.5566 | 0.5677 | 276488800.0 |
| 2004-08-04 | MSFT | Stock | 28.01 | 28.2 | 27.99 | 28.06 | 46217900.0 |
| 2004-08-04 | NVDA | Stock | 0.1221 | 0.1259 | 0.1219 | 0.1247 | 507816000.0 |
| 2004-08-04 | AMZN | Stock | 1.841 | 1.873 | 1.82 | 1.856 | 195312000.0 |
| 2004-08-04 | CL | Stock | 26.485 | 26.5 | 26.265 | 26.41 | 3450600.0 |
| 2004-08-04 | A | Stock | 16.5522 | 16.5951 | 16.0587 | 16.4163 | 3509260.0 |
| 2004-08-04 | AABA-DELISTED | Stock | 27.9799995422363 | 28.2299995422363 | 27.5799999237061 | 27.9099998474121 | 30154500.0 |
| 2004-08-04 | AACC-DELISTED | Stock | 16.67 | 16.67 | 16.39 | 16.4 | 66430.0 |
| 2004-08-04 | AAI-DELISTED | Stock | 10.63 | 10.77 | 10.04 | 10.56 | 1993600.0 |
| 2004-08-04 | AAIC-DELISTED | Stock | 318.0 | 323.8 | 300.4 | 322.0 | 3819500.0 |
| 2004-08-04 | AAME | Stock | 2.96 | 3.04 | 2.96 | 3.04 | 5100.0 |
| 2004-08-04 | AAON | Stock | 2.2453 | 2.3453 | 2.1768 | 2.1781 | 232369.0 |
| 2004-08-04 | AAP | Stock | 24.3067 | 24.3133 | 23.7933 | 23.8667 | 1098450.0 |
| 2004-08-04 | AAV-DELISTED | Stock | 14.8 | 14.85 | 14.7 | 14.8 | 18700.0 |
| 2004-08-04 | AAXN-DELISTED | Stock | 14.3450002670288 | 14.5249996185303 | 13.8649997711182 | 14.3699998855591 | 8401400.0 |
| 2004-08-04 | ABAX-DELISTED | Stock | 14.32 | 14.54 | 14.1 | 14.52 | 58736.0 |
| 2004-08-04 | ABB-DELISTED | Stock | 5.44 | 5.5 | 5.42 | 5.46 | 234600.0 |
| 2004-08-04 | ABC-DELISTED | Stock | 13.3 | 13.63 | 13.28 | 13.57 | 4938000.0 |
| 2004-08-04 | ABCB | Stock | 14.1196 | 14.1844 | 13.8845 | 14.0222 | 26156.0 |
| 2004-08-04 | ABCO-DELISTED | Stock | 15.702 | 15.807 | 15.523 | 15.578 | 119060.0 |
| 2004-08-04 | ABCW-DELISTED | Stock | 25.22 | 25.54 | 25.07 | 25.5 | 46600.0 |
| 2004-08-04 | ABE-DELISTED | Stock | 7.8 | 7.81 | 7.61 | 7.65 | 6500.0 |
| 2004-08-04 | ABFS-DELISTED | Stock | 35.45 | 35.75 | 35.0 | 35.75 | 356469.0 |
| 2004-08-04 | ABG | Stock | 13.3 | 14.1 | 13.05 | 13.92 | 137900.0 |
| 2004-08-04 | ABK-DELISTED | Stock | 71.72 | 71.99 | 71.07 | 71.58 | 299700.0 |
| 2004-08-04 | ABM | Stock | 17.8 | 17.96 | 17.52 | 17.85 | 99400.0 |
| 2004-08-04 | ABMD-DELISTED | Stock | 10.52 | 10.68 | 10.5 | 10.55 | 69190.0 |
| 2004-08-04 | ABP-DELISTED | Stock | 1.26 | 1.3 | 1.25 | 1.3 | 83600.0 |
| 2004-08-04 | ABR | Stock | 19.23 | 19.37 | 19.0 | 19.05 | 266200.0 |
| 2004-08-04 | ABT | Stock | 18.5827 | 18.8178 | 18.4963 | 18.7746 | 4921426.0 |
| 2004-08-04 | ABTL-DELISTED | Stock | 33.65 | 34.45 | 32.5 | 32.85 | 36600.0 |
| 2004-08-04 | ABV-DELISTED | Stock | 20.2 | 20.56 | 20.1 | 20.3 | 131900.0 |
| 2004-08-04 | ABVA-DELISTED | Stock | 14.86 | 15.0 | 14.86 | 14.91 | 1650.0 |
| 2004-08-04 | ABVT-DELISTED | Stock | 28.05 | 28.05 | 28.0 | 28.0 | 3600.0 |
| 2004-08-04 | ABX-DELISTED | Stock | 19.05 | 19.23 | 18.85 | 19.0 | 1295400.0 |
| 2004-08-04 | ACAD | Stock | 5.96 | 6.02 | 5.75 | 5.85 | 17600.0 |
| 2004-08-04 | ACAP-DELISTED | Stock | 27.9 | 28.4 | 27.51 | 28.25 | 68553.0 |
| 2004-08-04 | ACAS-DELISTED | Stock | 29.83 | 30.26 | 29.33 | 30.14 | 1529601.0 |
| 2004-08-04 | ACAT-DELISTED | Stock | 26.95 | 27.95 | 26.94 | 27.63 | 55188.0 |
| 2004-08-04 | ACCL-DELISTED | Stock | 7.04 | 7.22 | 6.82 | 6.95 | 104314.0 |
| 2004-08-04 | ACE-DELISTED | Stock | 39.25 | 39.9 | 38.85 | 39.6 | 855500.0 |
| 2004-08-04 | ACF-DELISTED | Stock | 18.59 | 18.84 | 18.33 | 18.72 | 706400.0 |
| 2004-08-04 | ACG-DELISTED | Stock | 8.24 | 8.25 | 8.17 | 8.18 | 419100.0 |
| 2004-08-04 | ACGL | Stock | 4.2622 | 4.2889 | 4.2244 | 4.2711 | 1008000.0 |
| 2004-08-04 | ACGN-DELISTED | Stock | 521.3288 | 544.0 | 498.6712 | 510.0 | 97100.0 |
| 2004-08-04 | ACH | Stock | 16.8 | 17.3933 | 16.5067 | 17.2 | 255750.0 |
| 2004-08-04 | ACH-DELISTED | Stock | 11.6 | 11.682 | 11.325 | 11.6 | 601600.0 |
| 2004-08-04 | ACLS | Stock | 35.12 | 36.52 | 34.6 | 36.08 | 175975.0 |
| 2004-08-04 | ACO-DELISTED | Stock | 19.84 | 20.0 | 19.81 | 19.85 | 152900.0 |
| 2004-08-04 | ACPW-DELISTED | Stock | 15.55 | 15.55 | 15.0 | 15.3 | 10032.0 |
> showing 50 of 3,784 rows — these rows as CSV