PREVIEW / stock_daily / 2005-12-23
file: by_date/stock_daily/2005/2005-12-23.parquet size: 143 KB rows: 4,296 symbols: 2,719
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-12-23 | AAPL | Stock | 2.6489 | 2.6521 | 2.6179 | 2.6196 | 229857600.0 |
| 2005-12-23 | MSFT | Stock | 26.52 | 26.67 | 26.44 | 26.64 | 30689200.0 |
| 2005-12-23 | NVDA | Stock | 0.3112 | 0.3132 | 0.3092 | 0.3128 | 214536000.0 |
| 2005-12-23 | AMZN | Stock | 2.4545 | 2.4695 | 2.436 | 2.461 | 64130000.0 |
| 2005-12-23 | CL | Stock | 27.8 | 27.825 | 27.605 | 27.75 | 1376400.0 |
| 2005-12-23 | A | Stock | 25.0358 | 25.1431 | 24.8927 | 24.9642 | 1786364.0 |
| 2005-12-23 | AABA-DELISTED | Stock | 41.0900001525879 | 41.0999984741211 | 40.4500007629395 | 40.6300010681152 | 5070200.0 |
| 2005-12-23 | AACC-DELISTED | Stock | 22.43 | 22.5 | 22.37 | 22.47 | 54214.0 |
| 2005-12-23 | AACQ-DELISTED | Stock | 5.205 | 5.21 | 5.205 | 5.21 | 10500.0 |
| 2005-12-23 | AACQW-DELISTED | Stock | 0.51 | 0.53 | 0.5024 | 0.5024 | 74000.0 |
| 2005-12-23 | AAI-DELISTED | Stock | 15.16 | 15.53 | 15.11 | 15.32 | 1033700.0 |
| 2005-12-23 | AAIC-DELISTED | Stock | 208.0 | 216.6 | 206.72 | 216.4 | 2022600.0 |
| 2005-12-23 | AAME | Stock | 2.67 | 2.67 | 2.65 | 2.65 | 300.0 |
| 2005-12-23 | AAON | Stock | 2.3704 | 2.3888 | 2.3625 | 2.3625 | 47841.0 |
| 2005-12-23 | AAP | Stock | 42.92 | 43.44 | 42.92 | 43.14 | 213600.0 |
| 2005-12-23 | AATI-DELISTED | Stock | 14.55 | 14.55 | 14.14 | 14.27 | 24729.0 |
| 2005-12-23 | AAU-DELISTED | Stock | 1.79 | 2.15 | 1.79 | 2.0 | 130400.0 |
| 2005-12-23 | AAUAF-DELISTED | Stock | 1.79 | 2.15 | 1.79 | 2.0 | 130400.0 |
| 2005-12-23 | AAV-DELISTED | Stock | 19.64 | 19.68 | 19.58 | 19.64 | 102800.0 |
| 2005-12-23 | AAWW-DELISTED | Stock | 43.5 | 44.0 | 43.5 | 44.0 | 5500.0 |
| 2005-12-23 | AAXN-DELISTED | Stock | 7.69999980926514 | 7.75 | 7.51999998092651 | 7.65000009536743 | 3310300.0 |
| 2005-12-23 | ABAX-DELISTED | Stock | 16.91 | 17.0 | 16.75 | 16.87 | 77425.0 |
| 2005-12-23 | ABB-DELISTED | Stock | 9.34 | 9.4 | 9.27 | 9.3 | 945800.0 |
| 2005-12-23 | ABBC-DELISTED | Stock | 12.6 | 13.18 | 12.6 | 13.1 | 30487.0 |
| 2005-12-23 | ABC-DELISTED | Stock | 20.45 | 20.6 | 20.36 | 20.45 | 1738400.0 |
| 2005-12-23 | ABCB | Stock | 19.9683 | 19.9683 | 19.6862 | 19.91 | 2983.0 |
| 2005-12-23 | ABCO-DELISTED | Stock | 24.42 | 24.62 | 24.27 | 24.33 | 55433.0 |
| 2005-12-23 | ABCW-DELISTED | Stock | 31.07 | 31.07 | 30.7 | 30.81 | 94890.0 |
| 2005-12-23 | ABD-DELISTED | Stock | 23.5 | 23.79 | 23.45 | 23.61 | 160000.0 |
| 2005-12-23 | ABE-DELISTED | Stock | 11.9 | 11.9501 | 11.8 | 11.92 | 5800.0 |
| 2005-12-23 | ABFS-DELISTED | Stock | 44.82 | 45.69 | 44.62 | 45.49 | 223806.0 |
| 2005-12-23 | ABG | Stock | 17.25 | 17.5 | 17.23 | 17.35 | 13100.0 |
| 2005-12-23 | ABK-DELISTED | Stock | 78.1 | 78.77 | 78.05 | 78.6 | 211100.0 |
| 2005-12-23 | ABM | Stock | 19.91 | 20.09 | 19.8 | 19.94 | 252200.0 |
| 2005-12-23 | ABMD-DELISTED | Stock | 9.36 | 9.44 | 9.35 | 9.39 | 32765.0 |
| 2005-12-23 | ABP-DELISTED | Stock | 6.0 | 6.0 | 5.85 | 5.9 | 328900.0 |
| 2005-12-23 | ABR | Stock | 26.2 | 26.5 | 26.15 | 26.5 | 28500.0 |
| 2005-12-23 | ABT | Stock | 19.3263 | 19.6718 | 19.3263 | 19.6046 | 5674865.0 |
| 2005-12-23 | ABTL-DELISTED | Stock | 24.95 | 24.95 | 24.2 | 24.75 | 35903.0 |
| 2005-12-23 | ABV-DELISTED | Stock | 37.75 | 37.97 | 37.63 | 37.94 | 186300.0 |
| 2005-12-23 | ABVA-DELISTED | Stock | 16.7 | 16.7 | 16.05 | 16.1 | 6100.0 |
| 2005-12-23 | ABVT-DELISTED | Stock | 27.1 | 27.1 | 27.0 | 27.1 | 1500.0 |
| 2005-12-23 | ABX-DELISTED | Stock | 27.17 | 27.49 | 27.08 | 27.19 | 4301882.0 |
| 2005-12-23 | ACAD | Stock | 10.03 | 10.03 | 9.88 | 9.9 | 19900.0 |
| 2005-12-23 | ACAP-DELISTED | Stock | 46.5 | 47.2 | 46.32 | 47.06 | 38624.0 |
| 2005-12-23 | ACAS-DELISTED | Stock | 36.71 | 37.0 | 36.71 | 36.9 | 494809.0 |
| 2005-12-23 | ACAT-DELISTED | Stock | 20.27 | 20.27 | 20.05 | 20.07 | 24338.0 |
| 2005-12-23 | ACC-DELISTED | Stock | 24.9 | 25.04 | 24.84 | 25.0 | 15300.0 |
| 2005-12-23 | ACCL-DELISTED | Stock | 7.85 | 7.85 | 7.38 | 7.56 | 69459.0 |
| 2005-12-23 | ACCO | Stock | 23.5 | 23.79 | 23.45 | 23.61 | 160000.0 |
> showing 50 of 4,296 rows — these rows as CSV