PREVIEW / stock_daily / 2005-11-17
file: by_date/stock_daily/2005/2005-11-17.parquet size: 143 KB rows: 4,253 symbols: 2,683
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-17 | AAPL | Stock | 2.3425 | 2.3529 | 2.2946 | 2.3043 | 676205600.0 |
| 2005-11-17 | MSFT | Stock | 27.85 | 28.0 | 27.76 | 27.97 | 91351000.0 |
| 2005-11-17 | NVDA | Stock | 0.2917 | 0.3024 | 0.2883 | 0.3022 | 703260000.0 |
| 2005-11-17 | AMZN | Stock | 2.2715 | 2.338 | 2.268 | 2.337 | 233752000.0 |
| 2005-11-17 | CL | Stock | 26.78 | 27.15 | 26.73 | 27.1 | 3781000.0 |
| 2005-11-17 | A | Stock | 24.4635 | 24.8856 | 24.4349 | 24.8641 | 8188645.0 |
| 2005-11-17 | AABA-DELISTED | Stock | 40.3199996948242 | 42.5 | 40.0299987792969 | 42.2299995422363 | 44796000.0 |
| 2005-11-17 | AACC-DELISTED | Stock | 19.51 | 19.82 | 19.45 | 19.8 | 254514.0 |
| 2005-11-17 | AACQ-DELISTED | Stock | 5.08 | 5.08 | 5.05 | 5.05 | 35000.0 |
| 2005-11-17 | AACQU-DELISTED | Stock | 5.88 | 5.9 | 5.88 | 5.9 | 23000.0 |
| 2005-11-17 | AACQW-DELISTED | Stock | 0.43 | 0.44 | 0.43 | 0.44 | 80000.0 |
| 2005-11-17 | AAI-DELISTED | Stock | 15.81 | 16.4 | 15.55 | 16.31 | 1798700.0 |
| 2005-11-17 | AAIC-DELISTED | Stock | 175.2 | 181.2 | 175.0 | 181.0 | 1209800.0 |
| 2005-11-17 | AAON | Stock | 2.1728 | 2.1952 | 2.1373 | 2.1439 | 115425.0 |
| 2005-11-17 | AAP | Stock | 39.4 | 40.34 | 39.4 | 40.27 | 829000.0 |
| 2005-11-17 | AATI-DELISTED | Stock | 12.1 | 12.54 | 11.8 | 12.27 | 150552.0 |
| 2005-11-17 | AAV-DELISTED | Stock | 17.0 | 17.2 | 16.87 | 17.0 | 39500.0 |
| 2005-11-17 | AAWW-DELISTED | Stock | 31.0 | 31.0 | 30.5 | 31.0 | 462600.0 |
| 2005-11-17 | AAXN-DELISTED | Stock | 7.38000011444092 | 7.53999996185303 | 7.28000020980835 | 7.34999990463257 | 1808900.0 |
| 2005-11-17 | ABAX-DELISTED | Stock | 17.95 | 18.08 | 17.81 | 17.96 | 92447.0 |
| 2005-11-17 | ABB-DELISTED | Stock | 8.51 | 8.53 | 8.2 | 8.28 | 5169100.0 |
| 2005-11-17 | ABBC-DELISTED | Stock | 12.1235 | 12.15 | 12.065 | 12.08 | 7400.0 |
| 2005-11-17 | ABC-DELISTED | Stock | 19.3 | 19.5 | 19.3 | 19.5 | 2867200.0 |
| 2005-11-17 | ABCB | Stock | 19.589 | 19.8711 | 19.3944 | 19.5987 | 12543.0 |
| 2005-11-17 | ABCO-DELISTED | Stock | 23.92 | 24.22 | 23.87 | 24.0 | 249000.0 |
| 2005-11-17 | ABCW-DELISTED | Stock | 30.35 | 30.45 | 30.09 | 30.21 | 398580.0 |
| 2005-11-17 | ABD-DELISTED | Stock | 23.4 | 23.72 | 23.37 | 23.69 | 746260.0 |
| 2005-11-17 | ABE-DELISTED | Stock | 11.3 | 11.4 | 11.3 | 11.4 | 21300.0 |
| 2005-11-17 | ABFS-DELISTED | Stock | 41.34 | 42.12 | 41.23 | 42.01 | 339585.0 |
| 2005-11-17 | ABG | Stock | 15.84 | 16.13 | 15.65 | 16.06 | 78400.0 |
| 2005-11-17 | ABK-DELISTED | Stock | 76.2 | 76.81 | 75.65 | 76.69 | 342100.0 |
| 2005-11-17 | ABM | Stock | 20.0 | 20.42 | 20.0 | 20.42 | 66300.0 |
| 2005-11-17 | ABMD-DELISTED | Stock | 8.77 | 8.95 | 8.71 | 8.93 | 55611.0 |
| 2005-11-17 | ABP-DELISTED | Stock | 6.4 | 6.5 | 6.36 | 6.43 | 507200.0 |
| 2005-11-17 | ABR | Stock | 27.45 | 27.58 | 27.23 | 27.4 | 46800.0 |
| 2005-11-17 | ABT | Stock | 19.4703 | 19.6718 | 19.4079 | 19.6046 | 9399541.0 |
| 2005-11-17 | ABTL-DELISTED | Stock | 24.18 | 24.67 | 23.88 | 24.67 | 21338.0 |
| 2005-11-17 | ABV-DELISTED | Stock | 37.9 | 38.13 | 37.74 | 37.84 | 346000.0 |
| 2005-11-17 | ABVA-DELISTED | Stock | 16.5 | 16.51 | 16.5 | 16.51 | 600.0 |
| 2005-11-17 | ABX-DELISTED | Stock | 26.95 | 27.27 | 26.69 | 26.9 | 3794500.0 |
| 2005-11-17 | ACAD | Stock | 9.65 | 9.8 | 9.2 | 9.76 | 27400.0 |
| 2005-11-17 | ACAP-DELISTED | Stock | 43.4 | 44.99 | 43.07 | 44.7 | 23094.0 |
| 2005-11-17 | ACAS-DELISTED | Stock | 38.17 | 38.52 | 38.06 | 38.4 | 833795.0 |
| 2005-11-17 | ACAT-DELISTED | Stock | 19.38 | 19.73 | 19.1 | 19.18 | 98110.0 |
| 2005-11-17 | ACC-DELISTED | Stock | 25.44 | 25.58 | 25.13 | 25.27 | 31100.0 |
| 2005-11-17 | ACCL-DELISTED | Stock | 7.55 | 7.9 | 7.53 | 7.87 | 242369.0 |
| 2005-11-17 | ACCO | Stock | 23.4 | 23.71 | 23.37 | 23.69 | 749800.0 |
| 2005-11-17 | ACE-DELISTED | Stock | 54.98 | 55.65 | 54.58 | 55.58 | 1707200.0 |
| 2005-11-17 | ACF-DELISTED | Stock | 23.27 | 23.9 | 23.21 | 23.86 | 1051900.0 |
| 2005-11-17 | ACFC-DELISTED | Stock | 73.01 | 73.98 | 72.5 | 73.88 | 3385.0 |
> showing 50 of 4,253 rows — these rows as CSV