PREVIEW / stock_daily / 2005-10-31
file: by_date/stock_daily/2005/2005-10-31.parquet size: 142 KB rows: 4,246 symbols: 2,681
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-10-31 | AAPL | Stock | 1.9714 | 2.0707 | 1.9554 | 2.0568 | 940844800.0 |
| 2005-10-31 | MSFT | Stock | 25.61 | 25.8 | 25.5 | 25.7 | 75122100.0 |
| 2005-10-31 | NVDA | Stock | 0.2712 | 0.2815 | 0.2712 | 0.2796 | 432420000.0 |
| 2005-10-31 | AMZN | Stock | 1.9675 | 2.0195 | 1.956 | 1.993 | 135612000.0 |
| 2005-10-31 | CL | Stock | 26.6 | 26.7 | 26.34 | 26.48 | 6649200.0 |
| 2005-10-31 | A | Stock | 22.1745 | 22.99 | 22.1388 | 22.897 | 4258588.0 |
| 2005-10-31 | AABA-DELISTED | Stock | 35.5999984741211 | 37.2700004577637 | 35.5999984741211 | 36.9700012207031 | 24867100.0 |
| 2005-10-31 | AACC-DELISTED | Stock | 26.5 | 26.85 | 25.4 | 26.51 | 431068.0 |
| 2005-10-31 | AACQU-DELISTED | Stock | 6.115 | 6.115 | 6.115 | 6.115 | 2000.0 |
| 2005-10-31 | AACQW-DELISTED | Stock | 0.46 | 0.46 | 0.46 | 0.46 | 2500.0 |
| 2005-10-31 | AAI-DELISTED | Stock | 14.64 | 15.0 | 14.61 | 14.94 | 2584500.0 |
| 2005-10-31 | AAIC-DELISTED | Stock | 170.2 | 180.2 | 170.2 | 177.4 | 2668000.0 |
| 2005-10-31 | AAME | Stock | 3.0 | 3.0 | 2.73 | 2.94 | 3000.0 |
| 2005-10-31 | AAON | Stock | 2.136 | 2.2663 | 2.136 | 2.265 | 106312.0 |
| 2005-10-31 | AAP | Stock | 37.06 | 37.71 | 37.01 | 37.5 | 1226600.0 |
| 2005-10-31 | AATI-DELISTED | Stock | 11.27 | 11.27 | 10.61 | 10.87 | 100997.0 |
| 2005-10-31 | AAV-DELISTED | Stock | 16.6 | 16.62 | 16.39 | 16.6 | 32400.0 |
| 2005-10-31 | AAXN-DELISTED | Stock | 6.17999982833862 | 6.23999977111816 | 6.05999994277954 | 6.15000009536743 | 1634900.0 |
| 2005-10-31 | ABAX-DELISTED | Stock | 16.93 | 17.47 | 16.92 | 17.2 | 214302.0 |
| 2005-10-31 | ABB-DELISTED | Stock | 7.67 | 7.77 | 7.61 | 7.76 | 3639200.0 |
| 2005-10-31 | ABBC-DELISTED | Stock | 12.1 | 12.1 | 12.05 | 12.05 | 300.0 |
| 2005-10-31 | ABC-DELISTED | Stock | 18.86 | 19.25 | 18.86 | 19.05 | 3703600.0 |
| 2005-10-31 | ABCB | Stock | 18.2468 | 18.8985 | 18.1495 | 18.8207 | 17067.0 |
| 2005-10-31 | ABCO-DELISTED | Stock | 23.55 | 24.29 | 23.46 | 24.12 | 186549.0 |
| 2005-10-31 | ABCW-DELISTED | Stock | 31.3 | 31.83 | 30.96 | 31.66 | 60240.0 |
| 2005-10-31 | ABD-DELISTED | Stock | 24.2 | 24.35 | 24.03 | 24.31 | 160400.0 |
| 2005-10-31 | ABE-DELISTED | Stock | 10.9 | 10.9899 | 10.89 | 10.91 | 15200.0 |
| 2005-10-31 | ABFS-DELISTED | Stock | 38.0 | 39.22 | 37.93 | 38.69 | 207230.0 |
| 2005-10-31 | ABG | Stock | 16.65 | 17.1 | 16.65 | 16.9 | 129600.0 |
| 2005-10-31 | ABK-DELISTED | Stock | 69.8 | 71.08 | 69.69 | 70.8 | 703600.0 |
| 2005-10-31 | ABM | Stock | 19.5 | 19.94 | 19.5 | 19.78 | 142300.0 |
| 2005-10-31 | ABMD-DELISTED | Stock | 8.28 | 8.74 | 8.25 | 8.57 | 160791.0 |
| 2005-10-31 | ABP-DELISTED | Stock | 5.8 | 6.0 | 5.7 | 5.89 | 583100.0 |
| 2005-10-31 | ABR | Stock | 26.5 | 26.93 | 26.31 | 26.36 | 95800.0 |
| 2005-10-31 | ABT | Stock | 20.8233 | 20.9193 | 20.4875 | 20.6554 | 9291163.0 |
| 2005-10-31 | ABTL-DELISTED | Stock | 21.75 | 22.71 | 21.75 | 22.05 | 59577.0 |
| 2005-10-31 | ABV-DELISTED | Stock | 35.2 | 35.89 | 35.2 | 35.52 | 356800.0 |
| 2005-10-31 | ABVA-DELISTED | Stock | 16.55 | 17.0 | 16.5 | 16.62 | 9957.0 |
| 2005-10-31 | ABVT-DELISTED | Stock | 25.0 | 28.0 | 25.0 | 28.0 | 600.0 |
| 2005-10-31 | ABX-DELISTED | Stock | 26.29 | 26.3 | 24.8 | 25.25 | 11750700.0 |
| 2005-10-31 | ACAD | Stock | 10.3 | 10.5 | 10.3 | 10.5 | 32000.0 |
| 2005-10-31 | ACAP-DELISTED | Stock | 41.78 | 42.86 | 41.78 | 42.27 | 53701.0 |
| 2005-10-31 | ACAS-DELISTED | Stock | 37.2 | 37.78 | 37.2 | 37.52 | 563515.0 |
| 2005-10-31 | ACAT-DELISTED | Stock | 18.71 | 18.77 | 18.68 | 18.73 | 69171.0 |
| 2005-10-31 | ACC-DELISTED | Stock | 24.2 | 25.09 | 24.2 | 24.66 | 69700.0 |
| 2005-10-31 | ACCL-DELISTED | Stock | 6.48 | 6.63 | 6.36 | 6.56 | 61161.0 |
| 2005-10-31 | ACCO | Stock | 24.2 | 24.35 | 24.03 | 24.31 | 163800.0 |
| 2005-10-31 | ACE-DELISTED | Stock | 51.55 | 52.4 | 51.39 | 52.1 | 1518900.0 |
| 2005-10-31 | ACF-DELISTED | Stock | 22.23 | 22.65 | 22.15 | 22.34 | 1681000.0 |
| 2005-10-31 | ACFC-DELISTED | Stock | 71.12 | 71.38 | 70.76 | 70.76 | 368.0 |
> showing 50 of 4,246 rows — these rows as CSV