PREVIEW / stock_daily / 2005-01-28
file: by_date/stock_daily/2005/2005-01-28.parquet size: 133 KB rows: 3,957 symbols: 2,472
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-28 | AAPL | Stock | 1.2968 | 1.3211 | 1.2936 | 1.3211 | 801612000.0 |
| 2005-01-28 | MSFT | Stock | 26.54 | 26.65 | 25.96 | 26.18 | 110466500.0 |
| 2005-01-28 | NVDA | Stock | 0.1917 | 0.1924 | 0.1865 | 0.1907 | 671052000.0 |
| 2005-01-28 | AMZN | Stock | 2.1045 | 2.15 | 2.0765 | 2.111 | 123048000.0 |
| 2005-01-28 | CL | Stock | 26.155 | 26.29 | 25.18 | 25.83 | 14362000.0 |
| 2005-01-28 | A | Stock | 15.6652 | 15.7725 | 15.3863 | 15.4578 | 2934122.0 |
| 2005-01-28 | AABA-DELISTED | Stock | 34.9000015258789 | 35.2400016784668 | 34.1199989318848 | 34.6199989318848 | 17853700.0 |
| 2005-01-28 | AACC-DELISTED | Stock | 20.38 | 20.5 | 20.15 | 20.26 | 9224.0 |
| 2005-01-28 | AAI-DELISTED | Stock | 8.14 | 8.25 | 8.01 | 8.18 | 1588800.0 |
| 2005-01-28 | AAIC-DELISTED | Stock | 389.4 | 392.6 | 385.0 | 389.0 | 839700.0 |
| 2005-01-28 | AAME | Stock | 3.03 | 3.03 | 3.02 | 3.02 | 400.0 |
| 2005-01-28 | AAON | Stock | 1.8449 | 1.891 | 1.8449 | 1.891 | 113906.0 |
| 2005-01-28 | AAP | Stock | 28.5533 | 28.6 | 28.2067 | 28.3667 | 743550.0 |
| 2005-01-28 | AAV-DELISTED | Stock | 17.59 | 17.65 | 17.5 | 17.59 | 30300.0 |
| 2005-01-28 | AAXN-DELISTED | Stock | 18.1100006103516 | 18.3400001525879 | 16.9400005340576 | 17.1800003051758 | 8156700.0 |
| 2005-01-28 | ABAX-DELISTED | Stock | 13.0 | 13.24 | 12.95 | 13.15 | 80047.0 |
| 2005-01-28 | ABB-DELISTED | Stock | 5.52 | 5.57 | 5.5 | 5.55 | 635900.0 |
| 2005-01-28 | ABBC-DELISTED | Stock | 13.01 | 13.12 | 13.01 | 13.12 | 3250.0 |
| 2005-01-28 | ABC-DELISTED | Stock | 14.54 | 14.7 | 14.51 | 14.58 | 5836000.0 |
| 2005-01-28 | ABCB | Stock | 15.8054 | 16.2512 | 15.8054 | 16.162 | 18383.0 |
| 2005-01-28 | ABCO-DELISTED | Stock | 17.905 | 17.905 | 17.58 | 17.79 | 65357.0 |
| 2005-01-28 | ABCW-DELISTED | Stock | 27.1 | 27.1 | 26.5 | 26.51 | 32280.0 |
| 2005-01-28 | ABE-DELISTED | Stock | 9.6 | 9.64 | 9.35 | 9.57 | 18500.0 |
| 2005-01-28 | ABFS-DELISTED | Stock | 40.2 | 40.25 | 38.63 | 39.19 | 669294.0 |
| 2005-01-28 | ABG | Stock | 16.9 | 17.0 | 16.75 | 16.92 | 62500.0 |
| 2005-01-28 | ABK-DELISTED | Stock | 76.35 | 76.35 | 75.24 | 75.61 | 664500.0 |
| 2005-01-28 | ABM | Stock | 18.35 | 18.5 | 18.1 | 18.11 | 102300.0 |
| 2005-01-28 | ABMD-DELISTED | Stock | 11.83 | 11.9 | 11.27 | 11.47 | 107526.0 |
| 2005-01-28 | ABP-DELISTED | Stock | 2.27 | 2.29 | 2.08 | 2.15 | 58300.0 |
| 2005-01-28 | ABR | Stock | 23.78 | 23.95 | 23.64 | 23.95 | 33100.0 |
| 2005-01-28 | ABT | Stock | 21.7829 | 21.8501 | 21.5382 | 21.7205 | 8599208.0 |
| 2005-01-28 | ABTL-DELISTED | Stock | 27.7 | 28.4 | 26.55 | 27.0 | 47400.0 |
| 2005-01-28 | ABV-DELISTED | Stock | 25.1 | 25.19 | 25.0 | 25.1 | 388000.0 |
| 2005-01-28 | ABVA-DELISTED | Stock | 15.9 | 15.9 | 15.6 | 15.6 | 720.0 |
| 2005-01-28 | ABVT-DELISTED | Stock | 30.0 | 30.0 | 30.0 | 30.0 | 200.0 |
| 2005-01-28 | ABX-DELISTED | Stock | 22.3 | 22.31 | 21.99 | 22.18 | 867500.0 |
| 2005-01-28 | ACAD | Stock | 7.0 | 7.09 | 6.9 | 6.96 | 12000.0 |
| 2005-01-28 | ACAP-DELISTED | Stock | 35.02 | 35.46 | 35.0 | 35.18 | 19397.0 |
| 2005-01-28 | ACAS-DELISTED | Stock | 33.91 | 33.95 | 33.15 | 33.34 | 627400.0 |
| 2005-01-28 | ACAT-DELISTED | Stock | 25.19 | 25.23 | 24.88 | 25.0 | 50102.0 |
| 2005-01-28 | ACC-DELISTED | Stock | 19.75 | 20.1 | 19.75 | 20.03 | 94200.0 |
| 2005-01-28 | ACCL-DELISTED | Stock | 5.63 | 5.63 | 5.22 | 5.3 | 177446.0 |
| 2005-01-28 | ACE-DELISTED | Stock | 42.76 | 42.85 | 41.93 | 42.13 | 970500.0 |
| 2005-01-28 | ACF-DELISTED | Stock | 23.81 | 24.0 | 23.39 | 23.81 | 1054900.0 |
| 2005-01-28 | ACFC-DELISTED | Stock | 65.51 | 65.97 | 64.69 | 65.31 | 1994.0 |
| 2005-01-28 | ACG-DELISTED | Stock | 8.25 | 8.25 | 8.23 | 8.25 | 470400.0 |
| 2005-01-28 | ACGL | Stock | 4.1 | 4.1044 | 4.0622 | 4.0789 | 930600.0 |
| 2005-01-28 | ACGN-DELISTED | Stock | 725.3288 | 725.3288 | 657.3288 | 680.0 | 298600.0 |
| 2005-01-28 | ACH | Stock | 18.8933 | 19.06 | 18.46 | 18.4667 | 313650.0 |
| 2005-01-28 | ACH-DELISTED | Stock | 13.476 | 13.503 | 13.433 | 13.438 | 78000.0 |
> showing 50 of 3,957 rows — these rows as CSV