PREVIEW / stock_daily / 2005-01-31
file: by_date/stock_daily/2005/2005-01-31.parquet size: 134 KB rows: 4,015 symbols: 2,522
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-31 | AAPL | Stock | 1.3318 | 1.3909 | 1.3305 | 1.3732 | 1681097600.0 |
| 2005-01-31 | MSFT | Stock | 26.35 | 26.52 | 26.16 | 26.28 | 71442100.0 |
| 2005-01-31 | NVDA | Stock | 0.1922 | 0.1946 | 0.1883 | 0.191 | 562968000.0 |
| 2005-01-31 | AMZN | Stock | 2.122 | 2.171 | 2.1215 | 2.161 | 126406000.0 |
| 2005-01-31 | CL | Stock | 26.0 | 26.275 | 25.88 | 26.27 | 7571800.0 |
| 2005-01-31 | A | Stock | 15.6938 | 15.9156 | 15.6652 | 15.8155 | 2656899.0 |
| 2005-01-31 | AABA-DELISTED | Stock | 35.0400009155273 | 35.439998626709 | 34.5299987792969 | 35.2099990844727 | 20712200.0 |
| 2005-01-31 | AACC-DELISTED | Stock | 20.53 | 20.65 | 20.01 | 20.53 | 78423.0 |
| 2005-01-31 | AAI-DELISTED | Stock | 8.89 | 8.89 | 8.45 | 8.54 | 2435700.0 |
| 2005-01-31 | AAIC-DELISTED | Stock | 391.0 | 398.0 | 389.6 | 393.6 | 1183400.0 |
| 2005-01-31 | AAME | Stock | 3.01 | 3.04 | 3.01 | 3.04 | 2300.0 |
| 2005-01-31 | AAON | Stock | 1.891 | 1.9345 | 1.8449 | 1.9068 | 103275.0 |
| 2005-01-31 | AAP | Stock | 28.4867 | 28.7933 | 28.3333 | 28.7333 | 307350.0 |
| 2005-01-31 | AAV-DELISTED | Stock | 17.54 | 17.67 | 17.48 | 17.54 | 50100.0 |
| 2005-01-31 | AAXN-DELISTED | Stock | 18.1900005340576 | 18.1900005340576 | 17.4899997711182 | 17.9799995422363 | 6158700.0 |
| 2005-01-31 | ABAX-DELISTED | Stock | 13.25 | 13.67 | 13.0 | 13.67 | 124270.0 |
| 2005-01-31 | ABB-DELISTED | Stock | 5.52 | 5.58 | 5.5 | 5.51 | 117000.0 |
| 2005-01-31 | ABBC-DELISTED | Stock | 13.12 | 13.12 | 12.85 | 12.901 | 17242.0 |
| 2005-01-31 | ABC-DELISTED | Stock | 14.6 | 14.64 | 14.5 | 14.57 | 3337200.0 |
| 2005-01-31 | ABCB | Stock | 16.2918 | 16.4863 | 15.8621 | 16.4863 | 12585.0 |
| 2005-01-31 | ABCO-DELISTED | Stock | 17.853 | 18.153 | 17.717 | 17.777 | 240989.0 |
| 2005-01-31 | ABCW-DELISTED | Stock | 26.91 | 27.11 | 26.84 | 27.0 | 47920.0 |
| 2005-01-31 | ABE-DELISTED | Stock | 9.6 | 9.66 | 9.56 | 9.66 | 17000.0 |
| 2005-01-31 | ABFS-DELISTED | Stock | 39.52 | 40.98 | 39.31 | 40.17 | 648943.0 |
| 2005-01-31 | ABG | Stock | 16.95 | 17.05 | 16.75 | 16.88 | 77300.0 |
| 2005-01-31 | ABK-DELISTED | Stock | 75.81 | 77.0 | 75.75 | 76.88 | 614300.0 |
| 2005-01-31 | ABM | Stock | 18.11 | 18.4 | 18.09 | 18.3 | 143700.0 |
| 2005-01-31 | ABMD-DELISTED | Stock | 11.84 | 12.24 | 11.31 | 11.88 | 297072.0 |
| 2005-01-31 | ABP-DELISTED | Stock | 2.15 | 2.31 | 2.13 | 2.3 | 120800.0 |
| 2005-01-31 | ABR | Stock | 24.05 | 24.13 | 23.73 | 23.8 | 101100.0 |
| 2005-01-31 | ABT | Stock | 21.7205 | 21.7877 | 21.5238 | 21.6006 | 7407670.0 |
| 2005-01-31 | ABTL-DELISTED | Stock | 27.45 | 27.95 | 27.05 | 27.9 | 75600.0 |
| 2005-01-31 | ABV-DELISTED | Stock | 25.3 | 25.68 | 25.3 | 25.52 | 158400.0 |
| 2005-01-31 | ABVA-DELISTED | Stock | 16.05 | 16.05 | 15.61 | 15.61 | 450.0 |
| 2005-01-31 | ABVT-DELISTED | Stock | 30.0 | 30.0 | 30.0 | 30.0 | 200.0 |
| 2005-01-31 | ABX-DELISTED | Stock | 21.97 | 22.06 | 21.75 | 21.86 | 1318700.0 |
| 2005-01-31 | ACAD | Stock | 7.15 | 7.15 | 7.0 | 7.07 | 15100.0 |
| 2005-01-31 | ACAP-DELISTED | Stock | 35.11 | 35.8 | 35.1 | 35.8 | 39237.0 |
| 2005-01-31 | ACAS-DELISTED | Stock | 33.59 | 34.0 | 33.45 | 34.0 | 544873.0 |
| 2005-01-31 | ACAT-DELISTED | Stock | 25.4 | 25.51 | 25.11 | 25.33 | 57419.0 |
| 2005-01-31 | ACC-DELISTED | Stock | 20.15 | 20.4 | 20.15 | 20.2 | 35900.0 |
| 2005-01-31 | ACCL-DELISTED | Stock | 5.55 | 5.71 | 5.38 | 5.66 | 221564.0 |
| 2005-01-31 | ACE-DELISTED | Stock | 42.5 | 43.44 | 42.41 | 43.4 | 1514700.0 |
| 2005-01-31 | ACF-DELISTED | Stock | 24.15 | 24.9 | 24.06 | 24.59 | 1272800.0 |
| 2005-01-31 | ACFC-DELISTED | Stock | 66.17 | 66.33 | 65.36 | 66.33 | 1475.0 |
| 2005-01-31 | ACG-DELISTED | Stock | 8.26 | 8.29 | 8.25 | 8.29 | 490200.0 |
| 2005-01-31 | ACGL | Stock | 4.11 | 4.1144 | 4.0722 | 4.0811 | 559800.0 |
| 2005-01-31 | ACGN-DELISTED | Stock | 680.0 | 770.6712 | 680.0 | 714.0 | 635800.0 |
| 2005-01-31 | ACH | Stock | 18.9333 | 19.1667 | 18.8 | 19.0333 | 337200.0 |
| 2005-01-31 | ACH-DELISTED | Stock | 13.684 | 13.944 | 13.659 | 13.817 | 257648.0 |
> showing 50 of 4,015 rows — these rows as CSV