PREVIEW / stock_daily / 2005-01-03
file: by_date/stock_daily/2005/2005-01-03.parquet size: 134 KB rows: 3,964 symbols: 2,483
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-03 | AAPL | Stock | 1.1568 | 1.1627 | 1.1179 | 1.1302 | 691992000.0 |
| 2005-01-03 | MSFT | Stock | 26.8 | 26.95 | 26.65 | 26.74 | 65002900.0 |
| 2005-01-03 | NVDA | Stock | 0.2032 | 0.206 | 0.1957 | 0.1965 | 1066716000.0 |
| 2005-01-03 | AMZN | Stock | 2.2475 | 2.272 | 2.2105 | 2.226 | 208930000.0 |
| 2005-01-03 | CL | Stock | 25.455 | 25.575 | 24.985 | 25.01 | 5383200.0 |
| 2005-01-03 | A | Stock | 17.2389 | 17.2961 | 16.8097 | 17.0815 | 3378826.0 |
| 2005-01-03 | AABA-DELISTED | Stock | 38.3600006103516 | 38.9000015258789 | 37.6500015258789 | 38.1800003051758 | 25482800.0 |
| 2005-01-03 | AACC-DELISTED | Stock | 21.53 | 21.65 | 21.3 | 21.35 | 51282.0 |
| 2005-01-03 | AAI-DELISTED | Stock | 10.82 | 11.02 | 10.6 | 10.61 | 1198500.0 |
| 2005-01-03 | AAIC-DELISTED | Stock | 387.8 | 391.4 | 381.4 | 382.8 | 1135200.0 |
| 2005-01-03 | AAME | Stock | 3.07 | 3.07 | 3.01 | 3.07 | 8000.0 |
| 2005-01-03 | AAON | Stock | 2.1728 | 2.2374 | 1.949 | 1.9766 | 737353.0 |
| 2005-01-03 | AAP | Stock | 29.3333 | 29.4933 | 29.0333 | 29.0333 | 1549500.0 |
| 2005-01-03 | AAXN-DELISTED | Stock | 32.3499984741211 | 32.4900016784668 | 28.8799991607666 | 29.9799995422363 | 13510300.0 |
| 2005-01-03 | ABAX-DELISTED | Stock | 14.98 | 14.98 | 14.05 | 14.05 | 120450.0 |
| 2005-01-03 | ABB-DELISTED | Stock | 5.72 | 5.75 | 5.63 | 5.66 | 247600.0 |
| 2005-01-03 | ABBC-DELISTED | Stock | 13.21 | 13.346 | 12.91 | 13.0 | 154761.0 |
| 2005-01-03 | ABC-DELISTED | Stock | 14.67 | 14.7 | 14.5 | 14.54 | 6764800.0 |
| 2005-01-03 | ABCB | Stock | 17.4589 | 17.4589 | 16.5916 | 16.6241 | 11844.0 |
| 2005-01-03 | ABCO-DELISTED | Stock | 18.845 | 18.87 | 18.505 | 18.625 | 214920.0 |
| 2005-01-03 | ABCW-DELISTED | Stock | 29.24 | 29.43 | 28.75 | 28.75 | 48840.0 |
| 2005-01-03 | ABE-DELISTED | Stock | 9.97 | 10.08 | 9.97 | 10.04 | 41600.0 |
| 2005-01-03 | ABFS-DELISTED | Stock | 45.52 | 45.74 | 44.67 | 44.9 | 196764.0 |
| 2005-01-03 | ABG | Stock | 13.8 | 13.98 | 13.74 | 13.87 | 32700.0 |
| 2005-01-03 | ABK-DELISTED | Stock | 82.33 | 82.82 | 81.75 | 82.37 | 451900.0 |
| 2005-01-03 | ABM | Stock | 19.69 | 19.9 | 18.81 | 18.92 | 223500.0 |
| 2005-01-03 | ABMD-DELISTED | Stock | 15.87 | 15.97 | 14.97 | 15.01 | 212963.0 |
| 2005-01-03 | ABP-DELISTED | Stock | 2.32 | 2.35 | 2.2 | 2.24 | 90300.0 |
| 2005-01-03 | ABR | Stock | 24.54 | 24.6 | 24.26 | 24.35 | 67900.0 |
| 2005-01-03 | ABT | Stock | 22.3107 | 22.4642 | 22.2291 | 22.3923 | 7165902.0 |
| 2005-01-03 | ABTL-DELISTED | Stock | 30.75 | 31.0 | 30.0 | 30.4 | 147900.0 |
| 2005-01-03 | ABV-DELISTED | Stock | 28.33 | 28.81 | 28.33 | 28.63 | 203100.0 |
| 2005-01-03 | ABVA-DELISTED | Stock | 15.5 | 15.51 | 15.2 | 15.25 | 7783.0 |
| 2005-01-03 | ABVT-DELISTED | Stock | 33.0 | 33.0 | 33.0 | 33.0 | 123600.0 |
| 2005-01-03 | ABX-DELISTED | Stock | 23.97 | 23.97 | 23.5 | 23.55 | 2008000.0 |
| 2005-01-03 | ACAD | Stock | 6.82 | 6.82 | 6.39 | 6.39 | 8600.0 |
| 2005-01-03 | ACAP-DELISTED | Stock | 35.64 | 36.04 | 34.98 | 35.68 | 66154.0 |
| 2005-01-03 | ACAS-DELISTED | Stock | 33.48 | 33.63 | 32.97 | 32.97 | 472321.0 |
| 2005-01-03 | ACAT-DELISTED | Stock | 26.89 | 26.89 | 25.54 | 25.54 | 84664.0 |
| 2005-01-03 | ACC-DELISTED | Stock | 22.6 | 22.75 | 22.41 | 22.53 | 205000.0 |
| 2005-01-03 | ACCL-DELISTED | Stock | 7.83 | 7.93 | 7.25 | 7.29 | 227503.0 |
| 2005-01-03 | ACE-DELISTED | Stock | 42.95 | 42.95 | 42.22 | 42.33 | 860500.0 |
| 2005-01-03 | ACF-DELISTED | Stock | 23.55 | 24.3 | 23.5 | 24.06 | 1250400.0 |
| 2005-01-03 | ACFC-DELISTED | Stock | 70.61 | 71.43 | 68.88 | 69.9 | 3800.0 |
| 2005-01-03 | ACG-DELISTED | Stock | 8.15 | 8.18 | 8.15 | 8.18 | 529100.0 |
| 2005-01-03 | ACGL | Stock | 4.2778 | 4.2889 | 4.2222 | 4.2333 | 1130400.0 |
| 2005-01-03 | ACGN-DELISTED | Stock | 566.6712 | 566.6712 | 532.6712 | 566.6712 | 141100.0 |
| 2005-01-03 | ACH | Stock | 18.8467 | 19.1133 | 18.5267 | 18.8267 | 409950.0 |
| 2005-01-03 | ACH-DELISTED | Stock | 14.767 | 14.767 | 14.58 | 14.638 | 356571.0 |
| 2005-01-03 | ACLS | Stock | 32.6 | 32.6 | 31.16 | 31.56 | 191950.0 |
> showing 50 of 3,964 rows — these rows as CSV