PREVIEW / stock_daily / 2004-07-21
file: by_date/stock_daily/2004/2004-07-21.parquet size: 127 KB rows: 3,778 symbols: 2,362
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-21 | AAPL | Stock | 0.5789 | 0.5841 | 0.5596 | 0.5646 | 301257600.0 |
| 2004-07-21 | MSFT | Stock | 29.89 | 29.89 | 28.81 | 28.86 | 201518000.0 |
| 2004-07-21 | NVDA | Stock | 0.1325 | 0.1327 | 0.1222 | 0.1226 | 613416000.0 |
| 2004-07-21 | AMZN | Stock | 2.366 | 2.38 | 2.226 | 2.238 | 186730000.0 |
| 2004-07-21 | CL | Stock | 27.65 | 27.96 | 27.125 | 27.5 | 12577600.0 |
| 2004-07-21 | A | Stock | 18.5265 | 18.9199 | 17.4893 | 17.525 | 5453878.0 |
| 2004-07-21 | AABA-DELISTED | Stock | 30.1100006103516 | 30.1499996185303 | 28.1000003814697 | 28.1299991607666 | 19493300.0 |
| 2004-07-21 | AACC-DELISTED | Stock | 17.29 | 17.29 | 16.43 | 16.5 | 28527.0 |
| 2004-07-21 | AAI-DELISTED | Stock | 12.8 | 12.97 | 11.86 | 11.9 | 1205300.0 |
| 2004-07-21 | AAIC-DELISTED | Stock | 352.0 | 357.0 | 337.0 | 339.6 | 1491200.0 |
| 2004-07-21 | AAME | Stock | 2.98 | 2.98 | 2.76 | 2.87 | 11600.0 |
| 2004-07-21 | AAON | Stock | 2.3875 | 2.4955 | 2.377 | 2.3809 | 236925.0 |
| 2004-07-21 | AAP | Stock | 24.9333 | 25.2533 | 24.6467 | 24.8133 | 2116050.0 |
| 2004-07-21 | AAV-DELISTED | Stock | 14.75 | 14.8 | 14.57 | 14.75 | 28200.0 |
| 2004-07-21 | AAXN-DELISTED | Stock | 15.8900003433228 | 16.5849990844727 | 15.4449996948242 | 15.6850004196167 | 21737400.0 |
| 2004-07-21 | ABAX-DELISTED | Stock | 15.55 | 15.55 | 14.37 | 14.49 | 189327.0 |
| 2004-07-21 | ABB-DELISTED | Stock | 5.28 | 5.32 | 5.17 | 5.17 | 248600.0 |
| 2004-07-21 | ABC-DELISTED | Stock | 13.6 | 13.6 | 13.14 | 13.14 | 2735600.0 |
| 2004-07-21 | ABCB | Stock | 15.0111 | 15.3353 | 14.7031 | 14.7031 | 47746.0 |
| 2004-07-21 | ABCO-DELISTED | Stock | 15.572 | 15.707 | 15.493 | 15.513 | 219774.0 |
| 2004-07-21 | ABCW-DELISTED | Stock | 26.29 | 26.73 | 25.71 | 25.96 | 57890.0 |
| 2004-07-21 | ABE-DELISTED | Stock | 7.84 | 7.84 | 7.67 | 7.68 | 7300.0 |
| 2004-07-21 | ABFS-DELISTED | Stock | 34.35 | 34.97 | 34.01 | 34.32 | 570600.0 |
| 2004-07-21 | ABG | Stock | 12.59 | 12.87 | 12.59 | 12.85 | 182800.0 |
| 2004-07-21 | ABK-DELISTED | Stock | 70.51 | 72.0 | 70.51 | 71.01 | 884200.0 |
| 2004-07-21 | ABM | Stock | 18.6 | 18.63 | 18.16 | 18.16 | 97900.0 |
| 2004-07-21 | ABMD-DELISTED | Stock | 10.71 | 10.79 | 10.08 | 10.1 | 40394.0 |
| 2004-07-21 | ABP-DELISTED | Stock | 1.32 | 1.37 | 1.29 | 1.34 | 54100.0 |
| 2004-07-21 | ABR | Stock | 19.45 | 19.45 | 18.77 | 18.82 | 38400.0 |
| 2004-07-21 | ABT | Stock | 18.9329 | 19.168 | 18.5922 | 18.597 | 5810338.0 |
| 2004-07-21 | ABTL-DELISTED | Stock | 38.0 | 38.0 | 33.25 | 34.5 | 221600.0 |
| 2004-07-21 | ABV-DELISTED | Stock | 21.66 | 21.66 | 20.91 | 21.16 | 611700.0 |
| 2004-07-21 | ABVA-DELISTED | Stock | 15.16 | 15.3 | 15.16 | 15.3 | 300.0 |
| 2004-07-21 | ABVT-DELISTED | Stock | 29.0 | 29.0 | 29.0 | 29.0 | 100.0 |
| 2004-07-21 | ABX-DELISTED | Stock | 20.05 | 20.21 | 19.74 | 19.76 | 1449832.0 |
| 2004-07-21 | ACAD | Stock | 6.02 | 6.3 | 6.0 | 6.01 | 19600.0 |
| 2004-07-21 | ACAP-DELISTED | Stock | 24.59 | 24.94 | 24.0 | 24.55 | 36896.0 |
| 2004-07-21 | ACAS-DELISTED | Stock | 29.52 | 29.71 | 29.11 | 29.12 | 763292.0 |
| 2004-07-21 | ACAT-DELISTED | Stock | 27.94 | 27.94 | 26.92 | 26.93 | 83794.0 |
| 2004-07-21 | ACCL-DELISTED | Stock | 7.74 | 7.9 | 6.95 | 6.95 | 197615.0 |
| 2004-07-21 | ACE-DELISTED | Stock | 40.5 | 40.63 | 39.5 | 39.55 | 1882800.0 |
| 2004-07-21 | ACF-DELISTED | Stock | 20.25 | 20.74 | 19.14 | 19.27 | 1706700.0 |
| 2004-07-21 | ACG-DELISTED | Stock | 8.12 | 8.14 | 8.1 | 8.12 | 371800.0 |
| 2004-07-21 | ACGL | Stock | 4.2611 | 4.3056 | 4.2122 | 4.2211 | 1890900.0 |
| 2004-07-21 | ACGN-DELISTED | Stock | 634.6712 | 634.6712 | 589.3288 | 623.3288 | 118500.0 |
| 2004-07-21 | ACH | Stock | 17.0533 | 17.08 | 16.0 | 16.0267 | 309600.0 |
| 2004-07-21 | ACH-DELISTED | Stock | 13.63 | 13.645 | 13.143 | 13.153 | 824836.0 |
| 2004-07-21 | ACLS | Stock | 39.96 | 39.96 | 36.04 | 36.04 | 359150.0 |
| 2004-07-21 | ACO-DELISTED | Stock | 18.91 | 19.0 | 18.0 | 18.0 | 130000.0 |
| 2004-07-21 | ACPW-DELISTED | Stock | 14.55 | 15.35 | 13.75 | 14.5 | 24305.0 |
> showing 50 of 3,778 rows — these rows as CSV