PREVIEW / stock_daily / 2005-09-22
file: by_date/stock_daily/2005/2005-09-22.parquet size: 140 KB rows: 4,195 symbols: 2,642
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-09-22 | AAPL | Stock | 1.8529 | 1.8739 | 1.8329 | 1.8536 | 463727600.0 |
| 2005-09-22 | MSFT | Stock | 25.49 | 25.6 | 25.15 | 25.34 | 71314900.0 |
| 2005-09-22 | NVDA | Stock | 0.2767 | 0.2767 | 0.2637 | 0.2687 | 739152000.0 |
| 2005-09-22 | AMZN | Stock | 2.06 | 2.1135 | 2.025 | 2.104 | 116760000.0 |
| 2005-09-22 | CL | Stock | 25.85 | 26.055 | 25.665 | 25.985 | 4094000.0 |
| 2005-09-22 | A | Stock | 23.9628 | 24.1416 | 23.691 | 24.0916 | 5213561.0 |
| 2005-09-22 | AABA-DELISTED | Stock | 32.0900001525879 | 32.4099998474121 | 31.7600002288818 | 32.0400009155273 | 18259400.0 |
| 2005-09-22 | AACC-DELISTED | Stock | 28.23 | 28.23 | 26.36 | 27.87 | 498190.0 |
| 2005-09-22 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 100.0 |
| 2005-09-22 | AACQW-DELISTED | Stock | 0.61 | 0.61 | 0.61 | 0.61 | 52500.0 |
| 2005-09-22 | AAI-DELISTED | Stock | 9.88 | 10.58 | 9.85 | 10.5 | 1268800.0 |
| 2005-09-22 | AAIC-DELISTED | Stock | 218.0 | 224.2 | 214.4 | 218.2 | 1750300.0 |
| 2005-09-22 | AAME | Stock | 2.56 | 2.94 | 2.53 | 2.94 | 11300.0 |
| 2005-09-22 | AAON | Stock | 2.3309 | 2.3453 | 2.2953 | 2.3124 | 168581.0 |
| 2005-09-22 | AAP | Stock | 38.1667 | 39.2 | 37.8133 | 39.0 | 872100.0 |
| 2005-09-22 | AATI-DELISTED | Stock | 11.53 | 11.61 | 10.97 | 11.5 | 56812.0 |
| 2005-09-22 | AAV-DELISTED | Stock | 18.1 | 18.68 | 17.74 | 18.1 | 105100.0 |
| 2005-09-22 | AAXN-DELISTED | Stock | 7.55999994277954 | 7.55999994277954 | 7.1399998664856 | 7.21999979019165 | 2267300.0 |
| 2005-09-22 | ABAX-DELISTED | Stock | 12.55 | 13.0 | 12.5 | 12.95 | 107372.0 |
| 2005-09-22 | ABB-DELISTED | Stock | 7.23 | 7.25 | 7.17 | 7.21 | 957800.0 |
| 2005-09-22 | ABBC-DELISTED | Stock | 12.36 | 12.73 | 12.35 | 12.73 | 1100.0 |
| 2005-09-22 | ABC-DELISTED | Stock | 19.5 | 19.52 | 19.3 | 19.4 | 3498771.0 |
| 2005-09-22 | ABCB | Stock | 17.527 | 18.1397 | 17.527 | 18.0425 | 14497.0 |
| 2005-09-22 | ABCO-DELISTED | Stock | 24.15 | 24.42 | 23.98 | 24.05 | 294488.0 |
| 2005-09-22 | ABCW-DELISTED | Stock | 29.18 | 29.25 | 29.01 | 29.12 | 74130.0 |
| 2005-09-22 | ABD-DELISTED | Stock | 27.46 | 28.01 | 27.43 | 27.62 | 446850.0 |
| 2005-09-22 | ABE-DELISTED | Stock | 11.0 | 11.04 | 10.93 | 10.97 | 24300.0 |
| 2005-09-22 | ABFS-DELISTED | Stock | 32.35 | 32.79 | 32.09 | 32.51 | 265504.0 |
| 2005-09-22 | ABG | Stock | 16.36 | 16.59 | 16.15 | 16.38 | 78800.0 |
| 2005-09-22 | ABK-DELISTED | Stock | 68.05 | 69.07 | 67.58 | 69.01 | 521300.0 |
| 2005-09-22 | ABM | Stock | 20.45 | 20.74 | 20.2 | 20.74 | 150900.0 |
| 2005-09-22 | ABMD-DELISTED | Stock | 9.97 | 10.16 | 9.95 | 9.99 | 45774.0 |
| 2005-09-22 | ABP-DELISTED | Stock | 5.58 | 5.75 | 5.3 | 5.56 | 848700.0 |
| 2005-09-22 | ABR | Stock | 28.3 | 28.53 | 28.2 | 28.25 | 71000.0 |
| 2005-09-22 | ABT | Stock | 20.6794 | 21.1496 | 20.6746 | 21.068 | 9887662.0 |
| 2005-09-22 | ABTL-DELISTED | Stock | 24.3 | 24.65 | 23.15 | 24.3 | 32145.0 |
| 2005-09-22 | ABV-DELISTED | Stock | 36.0 | 36.15 | 35.7 | 35.74 | 766000.0 |
| 2005-09-22 | ABX-DELISTED | Stock | 28.91 | 28.91 | 28.328 | 28.71 | 2347900.0 |
| 2005-09-22 | ACAD | Stock | 10.61 | 11.12 | 10.13 | 10.9 | 150000.0 |
| 2005-09-22 | ACAP-DELISTED | Stock | 46.5 | 47.9 | 46.18 | 47.81 | 38594.0 |
| 2005-09-22 | ACAS-DELISTED | Stock | 36.74 | 37.021 | 36.01 | 36.8 | 879093.0 |
| 2005-09-22 | ACAT-DELISTED | Stock | 20.12 | 20.32 | 19.87 | 20.19 | 117929.0 |
| 2005-09-22 | ACC-DELISTED | Stock | 22.0 | 22.73 | 21.75 | 22.54 | 87400.0 |
| 2005-09-22 | ACCL-DELISTED | Stock | 6.08 | 6.18 | 5.8 | 5.84 | 155757.0 |
| 2005-09-22 | ACCO | Stock | 27.53 | 28.08 | 27.5 | 27.55 | 445800.0 |
| 2005-09-22 | ACE-DELISTED | Stock | 43.37 | 43.72 | 42.49 | 43.51 | 3483815.0 |
| 2005-09-22 | ACF-DELISTED | Stock | 24.23 | 24.25 | 23.73 | 24.1 | 1077900.0 |
| 2005-09-22 | ACFC-DELISTED | Stock | 70.92 | 71.28 | 70.92 | 71.28 | 163.0 |
| 2005-09-22 | ACG-DELISTED | Stock | 8.34 | 8.35 | 8.32 | 8.33 | 258000.0 |
| 2005-09-22 | ACGL | Stock | 5.2333 | 5.2333 | 5.0678 | 5.19 | 3616200.0 |
> showing 50 of 4,195 rows — these rows as CSV