PREVIEW / stock_daily / 2005-10-24
file: by_date/stock_daily/2005/2005-10-24.parquet size: 140 KB rows: 4,222 symbols: 2,658
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-24 | AAPL | Stock | 1.9732 | 2.0282 | 1.9675 | 2.0282 | 609753200.0 |
| 2005-10-24 | MSFT | Stock | 24.89 | 25.1 | 24.68 | 25.1 | 51868000.0 |
| 2005-10-24 | NVDA | Stock | 0.2685 | 0.2734 | 0.2661 | 0.2734 | 291012000.0 |
| 2005-10-24 | AMZN | Stock | 2.306 | 2.348 | 2.293 | 2.3465 | 109518000.0 |
| 2005-10-24 | CL | Stock | 25.98 | 26.25 | 25.91 | 26.25 | 2416800.0 |
| 2005-10-24 | A | Stock | 22.2389 | 22.5036 | 22.1459 | 22.2961 | 2351995.0 |
| 2005-10-24 | AABA-DELISTED | Stock | 35.2999992370605 | 35.4900016784668 | 34.939998626709 | 35.2799987792969 | 19591900.0 |
| 2005-10-24 | AACC-DELISTED | Stock | 25.46 | 26.08 | 25.4 | 25.88 | 383374.0 |
| 2005-10-24 | AACQ-DELISTED | Stock | 5.2 | 5.2 | 5.17 | 5.17 | 2500.0 |
| 2005-10-24 | AACQU-DELISTED | Stock | 6.14 | 6.14 | 6.13 | 6.13 | 2900.0 |
| 2005-10-24 | AACQW-DELISTED | Stock | 0.49 | 0.49 | 0.49 | 0.49 | 45000.0 |
| 2005-10-24 | AAI-DELISTED | Stock | 13.9 | 14.38 | 13.9 | 14.26 | 2214800.0 |
| 2005-10-24 | AAIC-DELISTED | Stock | 187.6 | 188.0 | 183.8 | 187.2 | 974600.0 |
| 2005-10-24 | AAME | Stock | 2.63 | 2.66 | 2.6 | 2.66 | 700.0 |
| 2005-10-24 | AAON | Stock | 2.1636 | 2.3651 | 2.1281 | 2.3585 | 227053.0 |
| 2005-10-24 | AAP | Stock | 35.9 | 37.0 | 35.9 | 37.0 | 1287000.0 |
| 2005-10-24 | AATI-DELISTED | Stock | 11.79 | 12.2 | 11.79 | 12.14 | 56882.0 |
| 2005-10-24 | AAV-DELISTED | Stock | 16.53 | 16.56 | 16.09 | 16.53 | 45300.0 |
| 2005-10-24 | AAXN-DELISTED | Stock | 6.23000001907349 | 6.80000019073486 | 6.13000011444092 | 6.51999998092651 | 14432600.0 |
| 2005-10-24 | ABAX-DELISTED | Stock | 14.17 | 14.47 | 14.17 | 14.41 | 158316.0 |
| 2005-10-24 | ABB-DELISTED | Stock | 7.02 | 7.15 | 7.02 | 7.11 | 954700.0 |
| 2005-10-24 | ABBC-DELISTED | Stock | 12.13 | 12.15 | 12.1 | 12.1 | 2600.0 |
| 2005-10-24 | ABC-DELISTED | Stock | 18.89 | 19.12 | 18.8 | 18.95 | 3560800.0 |
| 2005-10-24 | ABCB | Stock | 17.5854 | 18.3829 | 17.4103 | 18.3829 | 18198.0 |
| 2005-10-24 | ABCO-DELISTED | Stock | 24.21 | 24.51 | 23.81 | 24.21 | 105104.0 |
| 2005-10-24 | ABCW-DELISTED | Stock | 30.67 | 31.3 | 30.67 | 31.3 | 45280.0 |
| 2005-10-24 | ABD-DELISTED | Stock | 23.82 | 24.65 | 23.69 | 24.62 | 198050.0 |
| 2005-10-24 | ABE-DELISTED | Stock | 10.72 | 10.99 | 10.66 | 10.93 | 30000.0 |
| 2005-10-24 | ABFS-DELISTED | Stock | 35.11 | 39.62 | 35.11 | 37.82 | 2248750.0 |
| 2005-10-24 | ABG | Stock | 16.71 | 16.86 | 16.3 | 16.72 | 75500.0 |
| 2005-10-24 | ABK-DELISTED | Stock | 68.6 | 69.65 | 68.49 | 69.52 | 390400.0 |
| 2005-10-24 | ABM | Stock | 19.7 | 20.0 | 19.54 | 20.0 | 79500.0 |
| 2005-10-24 | ABMD-DELISTED | Stock | 8.53 | 8.55 | 8.39 | 8.5 | 247119.0 |
| 2005-10-24 | ABP-DELISTED | Stock | 6.36 | 6.55 | 6.19 | 6.47 | 749200.0 |
| 2005-10-24 | ABR | Stock | 27.9 | 28.07 | 27.72 | 27.95 | 168000.0 |
| 2005-10-24 | ABT | Stock | 20.6458 | 20.7322 | 20.521 | 20.5834 | 8635890.0 |
| 2005-10-24 | ABTL-DELISTED | Stock | 22.8 | 23.05 | 22.55 | 22.6 | 26782.0 |
| 2005-10-24 | ABV-DELISTED | Stock | 34.8 | 35.09 | 34.5 | 34.85 | 595800.0 |
| 2005-10-24 | ABVA-DELISTED | Stock | 16.5375 | 16.5375 | 16.5 | 16.5 | 212.0 |
| 2005-10-24 | ABX-DELISTED | Stock | 26.4 | 26.89 | 26.4 | 26.61 | 1901000.0 |
| 2005-10-24 | ACAD | Stock | 11.19 | 11.31 | 11.19 | 11.27 | 17000.0 |
| 2005-10-24 | ACAP-DELISTED | Stock | 44.39 | 45.85 | 44.39 | 45.25 | 42697.0 |
| 2005-10-24 | ACAS-DELISTED | Stock | 36.65 | 37.11 | 36.65 | 37.01 | 588891.0 |
| 2005-10-24 | ACAT-DELISTED | Stock | 18.47 | 19.0 | 18.47 | 18.87 | 78117.0 |
| 2005-10-24 | ACC-DELISTED | Stock | 23.5 | 23.94 | 23.41 | 23.91 | 73979.0 |
| 2005-10-24 | ACCL-DELISTED | Stock | 6.7 | 6.75 | 6.51 | 6.69 | 39390.0 |
| 2005-10-24 | ACCO | Stock | 23.8 | 24.64 | 23.67 | 24.64 | 202700.0 |
| 2005-10-24 | ACE-DELISTED | Stock | 50.51 | 50.72 | 50.18 | 50.49 | 3551806.0 |
| 2005-10-24 | ACF-DELISTED | Stock | 23.5 | 23.97 | 23.41 | 23.79 | 1615900.0 |
| 2005-10-24 | ACFC-DELISTED | Stock | 70.51 | 70.51 | 69.9 | 70.15 | 670.0 |
> showing 50 of 4,222 rows — these rows as CSV