PREVIEW / stock_daily / 2005-10-10
file: by_date/stock_daily/2005/2005-10-10.parquet size: 139 KB rows: 4,145 symbols: 2,593
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-10 | AAPL | Stock | 1.8486 | 1.8539 | 1.7957 | 1.7989 | 507505600.0 |
| 2005-10-10 | MSFT | Stock | 24.67 | 24.68 | 24.35 | 24.46 | 48880900.0 |
| 2005-10-10 | NVDA | Stock | 0.2769 | 0.2774 | 0.2684 | 0.2685 | 459216000.0 |
| 2005-10-10 | AMZN | Stock | 2.191 | 2.219 | 2.179 | 2.188 | 73606000.0 |
| 2005-10-10 | CL | Stock | 26.25 | 26.395 | 26.11 | 26.13 | 2982600.0 |
| 2005-10-10 | A | Stock | 22.7468 | 22.8541 | 22.3963 | 22.4249 | 3127326.0 |
| 2005-10-10 | AABA-DELISTED | Stock | 34.2000007629395 | 34.9000015258789 | 34.1199989318848 | 34.5299987792969 | 15227800.0 |
| 2005-10-10 | AACC-DELISTED | Stock | 29.8 | 29.8 | 29.121 | 29.4 | 63398.0 |
| 2005-10-10 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 2700.0 |
| 2005-10-10 | AACQU-DELISTED | Stock | 6.16 | 6.16 | 6.14 | 6.14 | 10000.0 |
| 2005-10-10 | AACQW-DELISTED | Stock | 0.54 | 0.55 | 0.53 | 0.54 | 90000.0 |
| 2005-10-10 | AAI-DELISTED | Stock | 13.71 | 13.91 | 13.15 | 13.27 | 1745500.0 |
| 2005-10-10 | AAIC-DELISTED | Stock | 190.0 | 194.0 | 178.6 | 182.0 | 3699900.0 |
| 2005-10-10 | AAME | Stock | 2.7 | 2.82 | 2.69 | 2.77 | 11700.0 |
| 2005-10-10 | AAON | Stock | 2.3335 | 2.3335 | 2.265 | 2.2663 | 97200.0 |
| 2005-10-10 | AAP | Stock | 38.76 | 38.97 | 38.36 | 38.74 | 424600.0 |
| 2005-10-10 | AATI-DELISTED | Stock | 11.67 | 11.67 | 11.27 | 11.29 | 86779.0 |
| 2005-10-10 | AAXN-DELISTED | Stock | 5.3899998664856 | 5.98000001907349 | 5.36999988555908 | 5.90000009536743 | 4081700.0 |
| 2005-10-10 | ABAX-DELISTED | Stock | 13.77 | 13.9 | 13.26 | 13.49 | 174645.0 |
| 2005-10-10 | ABB-DELISTED | Stock | 7.43 | 7.43 | 7.36 | 7.37 | 335400.0 |
| 2005-10-10 | ABBC-DELISTED | Stock | 12.5 | 12.51 | 12.43 | 12.51 | 24500.0 |
| 2005-10-10 | ABC-DELISTED | Stock | 19.04 | 19.07 | 18.73 | 18.77 | 2194000.0 |
| 2005-10-10 | ABCB | Stock | 17.9939 | 17.9939 | 17.42 | 17.5075 | 17067.0 |
| 2005-10-10 | ABCO-DELISTED | Stock | 24.56 | 24.69 | 24.18 | 24.35 | 134988.0 |
| 2005-10-10 | ABCW-DELISTED | Stock | 29.08 | 29.25 | 28.98 | 29.19 | 52280.0 |
| 2005-10-10 | ABD-DELISTED | Stock | 27.6 | 27.6 | 27.0 | 27.05 | 169700.0 |
| 2005-10-10 | ABE-DELISTED | Stock | 11.1 | 11.1 | 10.99 | 10.99 | 30000.0 |
| 2005-10-10 | ABFS-DELISTED | Stock | 33.72 | 33.94 | 33.18 | 33.44 | 69821.0 |
| 2005-10-10 | ABG | Stock | 16.83 | 17.01 | 16.54 | 16.71 | 76600.0 |
| 2005-10-10 | ABK-DELISTED | Stock | 69.67 | 70.24 | 69.1 | 69.22 | 382600.0 |
| 2005-10-10 | ABM | Stock | 20.12 | 20.24 | 19.74 | 20.23 | 148100.0 |
| 2005-10-10 | ABMD-DELISTED | Stock | 9.6 | 9.6 | 9.45 | 9.48 | 35889.0 |
| 2005-10-10 | ABP-DELISTED | Stock | 7.05 | 7.2 | 6.5 | 6.65 | 1301900.0 |
| 2005-10-10 | ABR | Stock | 29.09 | 29.35 | 28.63 | 28.79 | 268100.0 |
| 2005-10-10 | ABT | Stock | 20.4587 | 20.5306 | 20.2332 | 20.238 | 6849729.0 |
| 2005-10-10 | ABTL-DELISTED | Stock | 24.05 | 24.25 | 23.7 | 23.95 | 32172.0 |
| 2005-10-10 | ABV-DELISTED | Stock | 36.79 | 37.25 | 36.55 | 36.61 | 289100.0 |
| 2005-10-10 | ABX-DELISTED | Stock | 28.6 | 28.79 | 28.16 | 28.45 | 1469000.0 |
| 2005-10-10 | ACAD | Stock | 10.79 | 11.0 | 10.78 | 10.8 | 16300.0 |
| 2005-10-10 | ACAP-DELISTED | Stock | 45.5 | 46.66 | 44.63 | 46.33 | 114910.0 |
| 2005-10-10 | ACAS-DELISTED | Stock | 36.5 | 36.5 | 35.73 | 35.98 | 586643.0 |
| 2005-10-10 | ACAT-DELISTED | Stock | 19.54 | 19.54 | 18.85 | 19.07 | 56867.0 |
| 2005-10-10 | ACC-DELISTED | Stock | 23.25 | 23.25 | 23.02 | 23.06 | 58600.0 |
| 2005-10-10 | ACCL-DELISTED | Stock | 6.49 | 6.6 | 6.45 | 6.48 | 62893.0 |
| 2005-10-10 | ACCO | Stock | 27.6 | 27.6 | 27.01 | 27.05 | 169700.0 |
| 2005-10-10 | ACE-DELISTED | Stock | 47.25 | 48.28 | 46.93 | 47.55 | 1925800.0 |
| 2005-10-10 | ACF-DELISTED | Stock | 22.54 | 22.73 | 21.64 | 22.0 | 2414200.0 |
| 2005-10-10 | ACFC-DELISTED | Stock | 70.92 | 70.92 | 70.41 | 70.46 | 558.0 |
| 2005-10-10 | ACG-DELISTED | Stock | 8.25 | 8.29 | 8.24 | 8.25 | 229100.0 |
| 2005-10-10 | ACGL | Stock | 5.2822 | 5.3156 | 5.2178 | 5.2367 | 1684800.0 |
> showing 50 of 4,145 rows — these rows as CSV