PREVIEW / stock_daily / 2005-06-16
file: by_date/stock_daily/2005/2005-06-16.parquet size: 137 KB rows: 4,099 symbols: 2,566
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-06-16 | AAPL | Stock | 1.3282 | 1.36 | 1.315 | 1.3564 | 547674400.0 |
| 2005-06-16 | MSFT | Stock | 25.22 | 25.23 | 24.95 | 25.04 | 65918800.0 |
| 2005-06-16 | NVDA | Stock | 0.2235 | 0.2262 | 0.2202 | 0.2247 | 489240000.0 |
| 2005-06-16 | AMZN | Stock | 1.76 | 1.7905 | 1.758 | 1.779 | 84110000.0 |
| 2005-06-16 | CL | Stock | 24.725 | 24.755 | 24.44 | 24.45 | 4148800.0 |
| 2005-06-16 | A | Stock | 17.7039 | 17.7325 | 17.5536 | 17.5751 | 1531229.0 |
| 2005-06-16 | AABA-DELISTED | Stock | 36.4599990844727 | 36.7400016784668 | 36.2200012207031 | 36.4000015258789 | 12228700.0 |
| 2005-06-16 | AACC-DELISTED | Stock | 25.64 | 25.66 | 25.306 | 25.5 | 54382.0 |
| 2005-06-16 | AACQ-DELISTED | Stock | 4.95 | 4.95 | 4.95 | 4.95 | 500.0 |
| 2005-06-16 | AACQU-DELISTED | Stock | 6.05 | 6.15 | 6.05 | 6.15 | 3000.0 |
| 2005-06-16 | AAI-DELISTED | Stock | 9.86 | 9.9 | 9.79 | 9.84 | 501500.0 |
| 2005-06-16 | AAIC-DELISTED | Stock | 274.0 | 280.4 | 273.4 | 275.0 | 977400.0 |
| 2005-06-16 | AAME | Stock | 3.02 | 3.02 | 3.01 | 3.01 | 1000.0 |
| 2005-06-16 | AAON | Stock | 2.3967 | 2.402 | 2.373 | 2.398 | 173897.0 |
| 2005-06-16 | AAP | Stock | 41.7267 | 41.96 | 41.6867 | 41.8733 | 954750.0 |
| 2005-06-16 | AAV-DELISTED | Stock | 14.99 | 15.0 | 14.6 | 14.99 | 56400.0 |
| 2005-06-16 | AAXN-DELISTED | Stock | 10.8699998855591 | 10.9700002670288 | 10.6700000762939 | 10.8299999237061 | 2504100.0 |
| 2005-06-16 | ABAX-DELISTED | Stock | 11.29 | 11.32 | 11.11 | 11.28 | 45458.0 |
| 2005-06-16 | ABB-DELISTED | Stock | 6.82 | 6.95 | 6.78 | 6.94 | 3429900.0 |
| 2005-06-16 | ABBC-DELISTED | Stock | 11.39 | 11.39 | 11.12 | 11.37 | 18019.0 |
| 2005-06-16 | ABC-DELISTED | Stock | 16.8 | 17.08 | 16.78 | 17.01 | 3410400.0 |
| 2005-06-16 | ABCB | Stock | 16.9435 | 17.6049 | 16.9435 | 17.6049 | 17889.0 |
| 2005-06-16 | ABCO-DELISTED | Stock | 23.32 | 23.92 | 23.0 | 23.85 | 432591.0 |
| 2005-06-16 | ABCW-DELISTED | Stock | 29.13 | 29.69 | 29.12 | 29.69 | 128210.0 |
| 2005-06-16 | ABE-DELISTED | Stock | 10.0 | 10.04 | 9.91 | 9.91 | 6600.0 |
| 2005-06-16 | ABFS-DELISTED | Stock | 30.97 | 31.21 | 30.91 | 31.18 | 453842.0 |
| 2005-06-16 | ABG | Stock | 15.01 | 15.69 | 14.93 | 15.57 | 70500.0 |
| 2005-06-16 | ABK-DELISTED | Stock | 71.8 | 71.93 | 71.21 | 71.32 | 221900.0 |
| 2005-06-16 | ABM | Stock | 18.83 | 19.4 | 18.8 | 19.4 | 159000.0 |
| 2005-06-16 | ABMD-DELISTED | Stock | 9.25 | 9.49 | 9.18 | 9.3 | 75752.0 |
| 2005-06-16 | ABP-DELISTED | Stock | 2.65 | 2.65 | 2.6 | 2.63 | 130000.0 |
| 2005-06-16 | ABR | Stock | 28.25 | 28.25 | 27.95 | 28.03 | 132200.0 |
| 2005-06-16 | ABT | Stock | 23.5198 | 23.6302 | 23.4382 | 23.5486 | 4151730.0 |
| 2005-06-16 | ABTL-DELISTED | Stock | 25.0 | 25.6 | 24.5 | 25.15 | 60484.0 |
| 2005-06-16 | ABV-DELISTED | Stock | 30.4 | 31.3 | 30.38 | 31.25 | 1062400.0 |
| 2005-06-16 | ABVA-DELISTED | Stock | 14.87 | 14.87 | 14.87 | 14.87 | 100.0 |
| 2005-06-16 | ABX-DELISTED | Stock | 24.2 | 24.63 | 24.14 | 24.53 | 2737300.0 |
| 2005-06-16 | ACAD | Stock | 9.0 | 9.51 | 8.95 | 9.32 | 74500.0 |
| 2005-06-16 | ACAP-DELISTED | Stock | 35.7 | 35.98 | 35.55 | 35.7 | 151131.0 |
| 2005-06-16 | ACAS-DELISTED | Stock | 34.95 | 35.08 | 34.71 | 34.95 | 377066.0 |
| 2005-06-16 | ACAT-DELISTED | Stock | 23.16 | 23.71 | 23.03 | 23.21 | 66380.0 |
| 2005-06-16 | ACC-DELISTED | Stock | 22.0 | 22.45 | 21.91 | 22.15 | 65300.0 |
| 2005-06-16 | ACCL-DELISTED | Stock | 5.17 | 5.19 | 5.08 | 5.13 | 166057.0 |
| 2005-06-16 | ACE-DELISTED | Stock | 45.5 | 45.94 | 45.37 | 45.87 | 599827.0 |
| 2005-06-16 | ACF-DELISTED | Stock | 24.74 | 24.95 | 24.71 | 24.89 | 783200.0 |
| 2005-06-16 | ACFC-DELISTED | Stock | 62.3 | 62.4 | 61.79 | 61.84 | 990.0 |
| 2005-06-16 | ACG-DELISTED | Stock | 8.22 | 8.24 | 8.2 | 8.23 | 325400.0 |
| 2005-06-16 | ACGL | Stock | 4.8133 | 4.8689 | 4.8133 | 4.8411 | 1003500.0 |
| 2005-06-16 | ACGN-DELISTED | Stock | 702.6712 | 702.6712 | 657.3288 | 680.0 | 114900.0 |
| 2005-06-16 | ACH | Stock | 21.24 | 21.5 | 21.12 | 21.5 | 90150.0 |
> showing 50 of 4,099 rows — these rows as CSV