PREVIEW / stock_daily / 2005-11-25
file: by_date/stock_daily/2005/2005-11-25.parquet size: 135 KB rows: 4,076 symbols: 2,530
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-11-25 | AAPL | Stock | 2.4164 | 2.4836 | 2.4107 | 2.4764 | 395012800.0 |
| 2005-11-25 | MSFT | Stock | 27.8 | 27.94 | 27.47 | 27.76 | 44082500.0 |
| 2005-11-25 | NVDA | Stock | 0.3157 | 0.3177 | 0.3135 | 0.3172 | 116676000.0 |
| 2005-11-25 | AMZN | Stock | 2.4025 | 2.424 | 2.381 | 2.403 | 53916000.0 |
| 2005-11-25 | CL | Stock | 27.09 | 27.195 | 27.025 | 27.025 | 1077200.0 |
| 2005-11-25 | A | Stock | 25.5007 | 25.5866 | 25.4721 | 25.5293 | 1500613.0 |
| 2005-11-25 | AABA-DELISTED | Stock | 42.7099990844727 | 42.8400001525879 | 41.939998626709 | 42.1300010681152 | 8253000.0 |
| 2005-11-25 | AACC-DELISTED | Stock | 20.3 | 20.8 | 20.3 | 20.63 | 37780.0 |
| 2005-11-25 | AACQW-DELISTED | Stock | 0.41 | 0.41 | 0.41 | 0.41 | 10000.0 |
| 2005-11-25 | AAI-DELISTED | Stock | 15.6 | 15.65 | 15.41 | 15.56 | 530400.0 |
| 2005-11-25 | AAIC-DELISTED | Stock | 220.0 | 220.8 | 217.6 | 218.2 | 510500.0 |
| 2005-11-25 | AAON | Stock | 2.2453 | 2.2453 | 2.2123 | 2.2123 | 3797.0 |
| 2005-11-25 | AAP | Stock | 42.9 | 43.53 | 42.56 | 43.5 | 245800.0 |
| 2005-11-25 | AATI-DELISTED | Stock | 12.64 | 12.64 | 12.39 | 12.6 | 15475.0 |
| 2005-11-25 | AAV-DELISTED | Stock | 18.34 | 18.5 | 18.0 | 18.34 | 66700.0 |
| 2005-11-25 | AAXN-DELISTED | Stock | 6.75 | 6.90000009536743 | 6.34999990463257 | 6.5 | 4547000.0 |
| 2005-11-25 | ABAX-DELISTED | Stock | 17.78 | 17.81 | 17.6 | 17.8 | 22327.0 |
| 2005-11-25 | ABB-DELISTED | Stock | 8.79 | 8.8 | 8.72 | 8.75 | 263500.0 |
| 2005-11-25 | ABBC-DELISTED | Stock | 12.75 | 12.75 | 12.75 | 12.75 | 1600.0 |
| 2005-11-25 | ABC-DELISTED | Stock | 19.73 | 19.85 | 19.6 | 19.84 | 1233600.0 |
| 2005-11-25 | ABCB | Stock | 19.5987 | 19.9975 | 19.5987 | 19.8808 | 3496.0 |
| 2005-11-25 | ABCO-DELISTED | Stock | 23.98 | 23.98 | 23.59 | 23.87 | 63559.0 |
| 2005-11-25 | ABCW-DELISTED | Stock | 30.9 | 31.3 | 30.89 | 31.22 | 12660.0 |
| 2005-11-25 | ABD-DELISTED | Stock | 23.73 | 24.15 | 23.73 | 24.01 | 86300.0 |
| 2005-11-25 | ABE-DELISTED | Stock | 11.65 | 11.72 | 11.62 | 11.643 | 7200.0 |
| 2005-11-25 | ABFS-DELISTED | Stock | 41.95 | 42.1 | 41.65 | 41.88 | 31444.0 |
| 2005-11-25 | ABG | Stock | 16.53 | 16.59 | 16.46 | 16.5 | 29300.0 |
| 2005-11-25 | ABK-DELISTED | Stock | 77.5 | 77.5 | 76.41 | 76.5 | 175700.0 |
| 2005-11-25 | ABM | Stock | 20.8 | 21.18 | 20.7 | 21.09 | 23300.0 |
| 2005-11-25 | ABMD-DELISTED | Stock | 8.75 | 8.91 | 8.73 | 8.91 | 7502.0 |
| 2005-11-25 | ABP-DELISTED | Stock | 7.1 | 7.19 | 7.0 | 7.11 | 278400.0 |
| 2005-11-25 | ABR | Stock | 27.24 | 27.5 | 27.06 | 27.48 | 15100.0 |
| 2005-11-25 | ABT | Stock | 18.7794 | 18.8561 | 18.6642 | 18.7026 | 5110463.0 |
| 2005-11-25 | ABTL-DELISTED | Stock | 27.48 | 27.67 | 26.73 | 27.52 | 10488.0 |
| 2005-11-25 | ABV-DELISTED | Stock | 38.0 | 38.71 | 38.0 | 38.67 | 257300.0 |
| 2005-11-25 | ABVA-DELISTED | Stock | 16.6145 | 16.6145 | 16.5 | 16.5 | 1460.0 |
| 2005-11-25 | ABX-DELISTED | Stock | 27.53 | 27.69 | 27.3 | 27.44 | 1142600.0 |
| 2005-11-25 | ACAD | Stock | 9.25 | 9.34 | 9.25 | 9.3 | 5900.0 |
| 2005-11-25 | ACAP-DELISTED | Stock | 44.04 | 44.41 | 44.04 | 44.32 | 1938.0 |
| 2005-11-25 | ACAS-DELISTED | Stock | 38.92 | 38.92 | 38.42 | 38.43 | 326641.0 |
| 2005-11-25 | ACAT-DELISTED | Stock | 21.48 | 21.48 | 20.52 | 20.69 | 25365.0 |
| 2005-11-25 | ACC-DELISTED | Stock | 25.35 | 25.75 | 25.3 | 25.58 | 12600.0 |
| 2005-11-25 | ACCL-DELISTED | Stock | 8.27 | 8.27 | 7.46 | 7.64 | 208481.0 |
| 2005-11-25 | ACCO | Stock | 23.73 | 24.15 | 23.73 | 24.01 | 86700.0 |
| 2005-11-25 | ACE-DELISTED | Stock | 56.28 | 56.28 | 55.43 | 56.0 | 444300.0 |
| 2005-11-25 | ACF-DELISTED | Stock | 25.15 | 25.48 | 25.09 | 25.2 | 580600.0 |
| 2005-11-25 | ACFC-DELISTED | Stock | 75.61 | 75.61 | 74.18 | 74.18 | 1314.0 |
| 2005-11-25 | ACG-DELISTED | Stock | 8.24 | 8.24 | 8.22 | 8.23 | 108800.0 |
| 2005-11-25 | ACGL | Stock | 6.1144 | 6.1167 | 6.0667 | 6.0811 | 604800.0 |
| 2005-11-25 | ACGN-DELISTED | Stock | 827.3288 | 827.3288 | 816.0 | 827.3288 | 1600.0 |
> showing 50 of 4,076 rows — these rows as CSV