PREVIEW / stock_daily / 2005-09-29
file: by_date/stock_daily/2005/2005-09-29.parquet size: 140 KB rows: 4,194 symbols: 2,641
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-29 | AAPL | Stock | 1.8296 | 1.8782 | 1.8146 | 1.8693 | 636846000.0 |
| 2005-09-29 | MSFT | Stock | 25.61 | 26.0 | 25.5 | 25.94 | 66807100.0 |
| 2005-09-29 | NVDA | Stock | 0.2775 | 0.2833 | 0.2752 | 0.2832 | 513372000.0 |
| 2005-09-29 | AMZN | Stock | 2.169 | 2.24 | 2.1565 | 2.2395 | 127856000.0 |
| 2005-09-29 | CL | Stock | 26.095 | 26.405 | 25.895 | 26.28 | 3728600.0 |
| 2005-09-29 | A | Stock | 23.6767 | 23.834 | 23.2403 | 23.3691 | 8579666.0 |
| 2005-09-29 | AABA-DELISTED | Stock | 32.4000015258789 | 33.7000007629395 | 32.1199989318848 | 33.4599990844727 | 22209100.0 |
| 2005-09-29 | AACC-DELISTED | Stock | 28.6 | 29.86 | 28.6 | 29.59 | 85526.0 |
| 2005-09-29 | AACQ-DELISTED | Stock | 5.11 | 5.11 | 5.11 | 5.11 | 50000.0 |
| 2005-09-29 | AACQW-DELISTED | Stock | 0.59 | 0.6 | 0.57 | 0.59 | 44500.0 |
| 2005-09-29 | AAI-DELISTED | Stock | 12.01 | 12.23 | 11.89 | 12.11 | 1376100.0 |
| 2005-09-29 | AAIC-DELISTED | Stock | 200.8 | 207.0 | 197.0 | 205.0 | 1812900.0 |
| 2005-09-29 | AAME | Stock | 2.8 | 2.96 | 2.8 | 2.96 | 1300.0 |
| 2005-09-29 | AAON | Stock | 2.3177 | 2.4086 | 2.3177 | 2.4086 | 73659.0 |
| 2005-09-29 | AAP | Stock | 37.9 | 38.29 | 37.45 | 38.26 | 1072500.0 |
| 2005-09-29 | AATI-DELISTED | Stock | 12.2 | 12.41 | 11.75 | 12.09 | 18407.0 |
| 2005-09-29 | AAV-DELISTED | Stock | 18.28 | 18.39 | 18.09 | 18.28 | 50000.0 |
| 2005-09-29 | AAXN-DELISTED | Stock | 5.94999980926514 | 6.38000011444092 | 5.90000009536743 | 6.13000011444092 | 3838900.0 |
| 2005-09-29 | ABAX-DELISTED | Stock | 13.0 | 13.0 | 12.65 | 12.96 | 90678.0 |
| 2005-09-29 | ABB-DELISTED | Stock | 7.27 | 7.32 | 7.23 | 7.31 | 1382300.0 |
| 2005-09-29 | ABBC-DELISTED | Stock | 12.53 | 12.58 | 12.5 | 12.57 | 1300.0 |
| 2005-09-29 | ABC-DELISTED | Stock | 19.4 | 19.4 | 19.1 | 19.3 | 3221600.0 |
| 2005-09-29 | ABCB | Stock | 17.8188 | 18.6455 | 17.6632 | 18.6455 | 8122.0 |
| 2005-09-29 | ABCO-DELISTED | Stock | 25.32 | 25.81 | 24.92 | 25.74 | 195496.0 |
| 2005-09-29 | ABCW-DELISTED | Stock | 29.27 | 29.6 | 29.22 | 29.48 | 41530.0 |
| 2005-09-29 | ABD-DELISTED | Stock | 27.77 | 28.02 | 27.53 | 27.98 | 407940.0 |
| 2005-09-29 | ABE-DELISTED | Stock | 11.15 | 11.19 | 11.1 | 11.19 | 29300.0 |
| 2005-09-29 | ABFS-DELISTED | Stock | 33.65 | 35.14 | 33.51 | 34.48 | 299372.0 |
| 2005-09-29 | ABG | Stock | 16.77 | 17.13 | 16.35 | 17.13 | 81100.0 |
| 2005-09-29 | ABK-DELISTED | Stock | 70.55 | 72.35 | 70.45 | 72.34 | 730900.0 |
| 2005-09-29 | ABM | Stock | 20.42 | 20.88 | 20.17 | 20.88 | 108100.0 |
| 2005-09-29 | ABMD-DELISTED | Stock | 9.9 | 10.13 | 9.89 | 9.99 | 56589.0 |
| 2005-09-29 | ABP-DELISTED | Stock | 8.02 | 8.95 | 7.89 | 8.75 | 4626200.0 |
| 2005-09-29 | ABR | Stock | 28.37 | 28.6 | 28.25 | 28.6 | 81200.0 |
| 2005-09-29 | ABT | Stock | 20.1036 | 20.2955 | 19.9453 | 20.1948 | 13150688.0 |
| 2005-09-29 | ABTL-DELISTED | Stock | 24.8 | 25.0 | 24.15 | 24.95 | 36721.0 |
| 2005-09-29 | ABV-DELISTED | Stock | 37.11 | 37.48 | 36.95 | 37.28 | 185100.0 |
| 2005-09-29 | ABVA-DELISTED | Stock | 16.2 | 17.0 | 16.2 | 16.46 | 24227.0 |
| 2005-09-29 | ABX-DELISTED | Stock | 28.9 | 29.47 | 28.85 | 29.3 | 3038300.0 |
| 2005-09-29 | ACAD | Stock | 10.78 | 11.13 | 10.71 | 11.13 | 99600.0 |
| 2005-09-29 | ACAP-DELISTED | Stock | 49.04 | 49.87 | 48.63 | 49.59 | 49082.0 |
| 2005-09-29 | ACAS-DELISTED | Stock | 36.28 | 36.36 | 34.24 | 36.24 | 1643887.0 |
| 2005-09-29 | ACAT-DELISTED | Stock | 20.37 | 20.57 | 20.17 | 20.52 | 200731.0 |
| 2005-09-29 | ACC-DELISTED | Stock | 22.9 | 23.25 | 22.85 | 23.25 | 39300.0 |
| 2005-09-29 | ACCL-DELISTED | Stock | 6.48 | 6.71 | 6.4 | 6.68 | 118328.0 |
| 2005-09-29 | ACCO | Stock | 27.8 | 28.05 | 27.56 | 27.95 | 408200.0 |
| 2005-09-29 | ACE-DELISTED | Stock | 45.5 | 46.63 | 45.34 | 46.63 | 1391300.0 |
| 2005-09-29 | ACF-DELISTED | Stock | 23.94 | 24.1 | 23.4 | 23.87 | 1707800.0 |
| 2005-09-29 | ACFC-DELISTED | Stock | 71.43 | 71.58 | 70.97 | 71.02 | 1511.0 |
| 2005-09-29 | ACG-DELISTED | Stock | 8.34 | 8.37 | 8.33 | 8.34 | 305800.0 |
> showing 50 of 4,194 rows — these rows as CSV