PREVIEW / stock_daily / 2005-07-11
file: by_date/stock_daily/2005/2005-07-11.parquet size: 138 KB rows: 4,141 symbols: 2,598
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-07-11 | AAPL | Stock | 1.3704 | 1.3804 | 1.3493 | 1.3607 | 388788400.0 |
| 2005-07-11 | MSFT | Stock | 25.15 | 25.38 | 25.11 | 25.29 | 61525400.0 |
| 2005-07-11 | NVDA | Stock | 0.2366 | 0.2404 | 0.2356 | 0.238 | 399492000.0 |
| 2005-07-11 | AMZN | Stock | 1.736 | 1.784 | 1.73 | 1.7795 | 103320000.0 |
| 2005-07-11 | CL | Stock | 25.3 | 25.385 | 25.085 | 25.21 | 3156800.0 |
| 2005-07-11 | A | Stock | 17.8827 | 18.7196 | 17.8827 | 18.3619 | 9869321.0 |
| 2005-07-11 | AABA-DELISTED | Stock | 34.9000015258789 | 35.810001373291 | 34.7799987792969 | 35.7599983215332 | 20233000.0 |
| 2005-07-11 | AACC-DELISTED | Stock | 25.41 | 25.79 | 25.214 | 25.52 | 117060.0 |
| 2005-07-11 | AACQ-DELISTED | Stock | 4.95 | 4.95 | 4.9 | 4.9 | 2400.0 |
| 2005-07-11 | AACQU-DELISTED | Stock | 6.0 | 6.0 | 5.96 | 5.96 | 1500.0 |
| 2005-07-11 | AACQW-DELISTED | Stock | 0.54 | 0.54 | 0.53 | 0.53 | 5000.0 |
| 2005-07-11 | AAI-DELISTED | Stock | 9.45 | 9.75 | 9.42 | 9.72 | 812000.0 |
| 2005-07-11 | AAIC-DELISTED | Stock | 302.0 | 305.6 | 301.8 | 305.0 | 881100.0 |
| 2005-07-11 | AAME | Stock | 3.02 | 3.02 | 3.0 | 3.0 | 3000.0 |
| 2005-07-11 | AAON | Stock | 2.5021 | 2.5389 | 2.4731 | 2.5389 | 135928.0 |
| 2005-07-11 | AAP | Stock | 42.9 | 43.08 | 42.5667 | 42.62 | 628800.0 |
| 2005-07-11 | AAV-DELISTED | Stock | 14.51 | 14.59 | 14.43 | 14.51 | 56200.0 |
| 2005-07-11 | AAXN-DELISTED | Stock | 10.1499996185303 | 10.2200002670288 | 10.0 | 10.0600004196167 | 1864200.0 |
| 2005-07-11 | ABAX-DELISTED | Stock | 11.1 | 11.39 | 11.09 | 11.33 | 141312.0 |
| 2005-07-11 | ABB-DELISTED | Stock | 6.48 | 6.57 | 6.48 | 6.55 | 663000.0 |
| 2005-07-11 | ABBC-DELISTED | Stock | 11.97 | 12.12 | 11.74 | 12.01 | 4445.0 |
| 2005-07-11 | ABC-DELISTED | Stock | 17.75 | 17.79 | 17.5 | 17.65 | 2433600.0 |
| 2005-07-11 | ABCB | Stock | 18.3343 | 19.4529 | 18.13 | 19.4042 | 15833.0 |
| 2005-07-11 | ABCO-DELISTED | Stock | 24.09 | 24.5 | 23.76 | 24.5 | 175016.0 |
| 2005-07-11 | ABCW-DELISTED | Stock | 31.05 | 31.46 | 30.9 | 31.37 | 85151.0 |
| 2005-07-11 | ABE-DELISTED | Stock | 10.06 | 10.18 | 10.04 | 10.09 | 14600.0 |
| 2005-07-11 | ABFS-DELISTED | Stock | 35.24 | 35.64 | 34.88 | 35.15 | 639067.0 |
| 2005-07-11 | ABG | Stock | 16.14 | 16.61 | 16.14 | 16.55 | 117500.0 |
| 2005-07-11 | ABK-DELISTED | Stock | 69.6 | 71.25 | 69.28 | 70.94 | 707600.0 |
| 2005-07-11 | ABM | Stock | 19.84 | 20.27 | 19.78 | 19.95 | 205700.0 |
| 2005-07-11 | ABMD-DELISTED | Stock | 9.38 | 9.9 | 9.22 | 9.79 | 107027.0 |
| 2005-07-11 | ABP-DELISTED | Stock | 3.01 | 3.08 | 3.0 | 3.06 | 304700.0 |
| 2005-07-11 | ABR | Stock | 30.39 | 30.4 | 29.61 | 29.63 | 126900.0 |
| 2005-07-11 | ABT | Stock | 23.7981 | 23.87 | 23.7261 | 23.8221 | 8614423.0 |
| 2005-07-11 | ABTL-DELISTED | Stock | 23.2 | 23.81 | 22.75 | 23.2 | 62564.0 |
| 2005-07-11 | ABV-DELISTED | Stock | 31.35 | 31.5 | 31.27 | 31.4 | 309000.0 |
| 2005-07-11 | ABVA-DELISTED | Stock | 15.62 | 16.02 | 15.62 | 16.02 | 350.0 |
| 2005-07-11 | ABX-DELISTED | Stock | 24.6 | 25.08 | 24.6 | 24.9 | 1234500.0 |
| 2005-07-11 | ACAD | Stock | 9.0 | 9.08 | 8.57 | 9.07 | 28000.0 |
| 2005-07-11 | ACAP-DELISTED | Stock | 38.4 | 38.47 | 37.61 | 37.89 | 36996.0 |
| 2005-07-11 | ACAS-DELISTED | Stock | 36.65 | 37.0 | 36.6 | 36.84 | 705723.0 |
| 2005-07-11 | ACAT-DELISTED | Stock | 20.36 | 20.46 | 19.91 | 20.45 | 144979.0 |
| 2005-07-11 | ACC-DELISTED | Stock | 23.7 | 23.86 | 23.45 | 23.85 | 100493.0 |
| 2005-07-11 | ACCL-DELISTED | Stock | 5.25 | 5.46 | 5.22 | 5.37 | 157534.0 |
| 2005-07-11 | ACE-DELISTED | Stock | 45.09 | 45.69 | 44.87 | 45.55 | 1194600.0 |
| 2005-07-11 | ACF-DELISTED | Stock | 26.47 | 26.74 | 26.23 | 26.36 | 1263300.0 |
| 2005-07-11 | ACFC-DELISTED | Stock | 62.45 | 62.91 | 62.45 | 62.91 | 745.0 |
| 2005-07-11 | ACG-DELISTED | Stock | 8.29 | 8.29 | 8.24 | 8.24 | 398600.0 |
| 2005-07-11 | ACGL | Stock | 4.9267 | 5.0433 | 4.9267 | 5.04 | 583200.0 |
| 2005-07-11 | ACGN-DELISTED | Stock | 623.3288 | 657.3288 | 600.6712 | 634.6712 | 52900.0 |
> showing 50 of 4,141 rows — these rows as CSV