PREVIEW / stock_daily / 2005-01-14
file: by_date/stock_daily/2005/2005-01-14.parquet size: 133 KB rows: 3,965 symbols: 2,487
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-14 | AAPL | Stock | 1.2545 | 1.2807 | 1.2355 | 1.2536 | 1770742400.0 |
| 2005-01-14 | MSFT | Stock | 26.4 | 26.45 | 26.04 | 26.12 | 92180800.0 |
| 2005-01-14 | NVDA | Stock | 0.182 | 0.1824 | 0.1775 | 0.1792 | 573912000.0 |
| 2005-01-14 | AMZN | Stock | 2.145 | 2.233 | 2.118 | 2.2275 | 250660000.0 |
| 2005-01-14 | CL | Stock | 24.95 | 25.05 | 24.76 | 25.04 | 3377800.0 |
| 2005-01-14 | A | Stock | 15.5579 | 15.8369 | 15.5508 | 15.7725 | 2851640.0 |
| 2005-01-14 | AABA-DELISTED | Stock | 35.8600006103516 | 36.7000007629395 | 35.8300018310547 | 36.7000007629395 | 27697700.0 |
| 2005-01-14 | AACC-DELISTED | Stock | 21.21 | 21.75 | 21.21 | 21.65 | 17467.0 |
| 2005-01-14 | AAI-DELISTED | Stock | 8.4 | 8.63 | 8.37 | 8.6 | 2086800.0 |
| 2005-01-14 | AAIC-DELISTED | Stock | 396.2 | 399.4 | 392.4 | 399.4 | 819500.0 |
| 2005-01-14 | AAME | Stock | 3.16 | 3.18 | 3.16 | 3.17 | 5000.0 |
| 2005-01-14 | AAON | Stock | 1.9147 | 1.924 | 1.8963 | 1.9134 | 47841.0 |
| 2005-01-14 | AAP | Stock | 28.92 | 29.0067 | 28.8067 | 28.9733 | 375150.0 |
| 2005-01-14 | AAV-DELISTED | Stock | 17.96 | 18.07 | 17.76 | 17.96 | 28800.0 |
| 2005-01-14 | AAXN-DELISTED | Stock | 21.7099990844727 | 21.7199993133545 | 19.1700000762939 | 19.6399993896484 | 35435700.0 |
| 2005-01-14 | ABAX-DELISTED | Stock | 12.2 | 12.57 | 12.2 | 12.56 | 142585.0 |
| 2005-01-14 | ABB-DELISTED | Stock | 5.83 | 5.92 | 5.83 | 5.88 | 829100.0 |
| 2005-01-14 | ABBC-DELISTED | Stock | 13.0 | 13.0 | 12.86 | 12.9 | 37013.0 |
| 2005-01-14 | ABC-DELISTED | Stock | 14.34 | 14.4 | 14.2 | 14.32 | 3596400.0 |
| 2005-01-14 | ABCB | Stock | 15.2381 | 15.465 | 14.9625 | 15.4407 | 5058.0 |
| 2005-01-14 | ABCO-DELISTED | Stock | 18.62 | 18.835 | 18.555 | 18.785 | 178014.0 |
| 2005-01-14 | ABCW-DELISTED | Stock | 27.97 | 27.97 | 27.64 | 27.78 | 48800.0 |
| 2005-01-14 | ABE-DELISTED | Stock | 9.5 | 9.62 | 9.5 | 9.58 | 19300.0 |
| 2005-01-14 | ABFS-DELISTED | Stock | 39.12 | 40.59 | 39.1 | 40.59 | 399535.0 |
| 2005-01-14 | ABG | Stock | 14.65 | 14.89 | 14.6 | 14.89 | 40100.0 |
| 2005-01-14 | ABK-DELISTED | Stock | 80.0 | 80.24 | 79.68 | 79.87 | 378800.0 |
| 2005-01-14 | ABM | Stock | 18.27 | 18.33 | 18.0 | 18.24 | 245900.0 |
| 2005-01-14 | ABMD-DELISTED | Stock | 12.27 | 12.44 | 11.69 | 12.05 | 376069.0 |
| 2005-01-14 | ABP-DELISTED | Stock | 2.45 | 2.46 | 2.4 | 2.44 | 54100.0 |
| 2005-01-14 | ABR | Stock | 24.1 | 24.22 | 23.89 | 23.96 | 69000.0 |
| 2005-01-14 | ABT | Stock | 21.9508 | 22.2915 | 21.8549 | 22.1908 | 9098374.0 |
| 2005-01-14 | ABTL-DELISTED | Stock | 28.7 | 28.75 | 27.25 | 28.5 | 87500.0 |
| 2005-01-14 | ABV-DELISTED | Stock | 27.05 | 27.65 | 26.8 | 27.6 | 162800.0 |
| 2005-01-14 | ABX-DELISTED | Stock | 21.91 | 22.21 | 21.84 | 22.14 | 1564245.0 |
| 2005-01-14 | ACAD | Stock | 7.11 | 7.11 | 7.06 | 7.06 | 11400.0 |
| 2005-01-14 | ACAP-DELISTED | Stock | 34.4 | 35.01 | 34.07 | 34.66 | 31736.0 |
| 2005-01-14 | ACAS-DELISTED | Stock | 32.52 | 32.68 | 32.3 | 32.52 | 393265.0 |
| 2005-01-14 | ACAT-DELISTED | Stock | 24.74 | 24.95 | 24.59 | 24.8 | 40746.0 |
| 2005-01-14 | ACC-DELISTED | Stock | 21.25 | 21.6 | 21.15 | 21.5 | 92900.0 |
| 2005-01-14 | ACCL-DELISTED | Stock | 6.09 | 6.14 | 5.78 | 5.91 | 130625.0 |
| 2005-01-14 | ACE-DELISTED | Stock | 42.4 | 43.0 | 42.31 | 42.5 | 1194100.0 |
| 2005-01-14 | ACF-DELISTED | Stock | 23.91 | 24.53 | 23.91 | 24.4 | 843700.0 |
| 2005-01-14 | ACFC-DELISTED | Stock | 63.93 | 65.82 | 63.93 | 64.8 | 2134.0 |
| 2005-01-14 | ACG-DELISTED | Stock | 8.16 | 8.17 | 8.11 | 8.11 | 534400.0 |
| 2005-01-14 | ACGL | Stock | 4.1589 | 4.1633 | 4.1156 | 4.14 | 977400.0 |
| 2005-01-14 | ACGN-DELISTED | Stock | 544.0 | 555.3288 | 532.6712 | 544.0 | 137800.0 |
| 2005-01-14 | ACH | Stock | 18.1 | 18.32 | 18.04 | 18.2733 | 147750.0 |
| 2005-01-14 | ACH-DELISTED | Stock | 13.165 | 13.497 | 13.14 | 13.462 | 612409.0 |
| 2005-01-14 | ACLS | Stock | 28.04 | 29.32 | 28.04 | 29.16 | 180900.0 |
| 2005-01-14 | ACO-DELISTED | Stock | 19.87 | 20.22 | 19.85 | 20.18 | 165700.0 |
> showing 50 of 3,965 rows — these rows as CSV