PREVIEW / stock_daily / 2005-10-04
file: by_date/stock_daily/2005/2005-10-04.parquet size: 141 KB rows: 4,196 symbols: 2,640
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-04 | AAPL | Stock | 1.9625 | 1.9768 | 1.9157 | 1.9196 | 539459200.0 |
| 2005-10-04 | MSFT | Stock | 25.36 | 25.39 | 24.75 | 24.98 | 151666300.0 |
| 2005-10-04 | NVDA | Stock | 0.2947 | 0.2996 | 0.289 | 0.2897 | 514476000.0 |
| 2005-10-04 | AMZN | Stock | 2.3 | 2.306 | 2.225 | 2.2465 | 130430000.0 |
| 2005-10-04 | CL | Stock | 26.375 | 26.695 | 26.1 | 26.515 | 5266600.0 |
| 2005-10-04 | A | Stock | 23.6338 | 23.7124 | 23.1259 | 23.2189 | 4797517.0 |
| 2005-10-04 | AABA-DELISTED | Stock | 33.75 | 34.3699989318848 | 33.5099983215332 | 33.5699996948242 | 14331000.0 |
| 2005-10-04 | AACC-DELISTED | Stock | 31.46 | 31.55 | 30.32 | 30.46 | 195606.0 |
| 2005-10-04 | AACQU-DELISTED | Stock | 6.27 | 6.27 | 6.27 | 6.27 | 1000.0 |
| 2005-10-04 | AACQW-DELISTED | Stock | 0.56 | 0.56 | 0.56 | 0.56 | 10000.0 |
| 2005-10-04 | AAI-DELISTED | Stock | 13.27 | 13.78 | 13.04 | 13.4 | 3723400.0 |
| 2005-10-04 | AAIC-DELISTED | Stock | 205.0 | 205.0 | 197.0 | 197.8 | 1703500.0 |
| 2005-10-04 | AAME | Stock | 2.83 | 2.94 | 2.83 | 2.94 | 1100.0 |
| 2005-10-04 | AAON | Stock | 2.3941 | 2.3941 | 2.3533 | 2.3572 | 195159.0 |
| 2005-10-04 | AAP | Stock | 39.49 | 40.0 | 38.75 | 38.76 | 962500.0 |
| 2005-10-04 | AATI-DELISTED | Stock | 11.7 | 11.7 | 11.23 | 11.3 | 84234.0 |
| 2005-10-04 | AAV-DELISTED | Stock | 17.49 | 20.27 | 17.39 | 17.49 | 117000.0 |
| 2005-10-04 | AAXN-DELISTED | Stock | 6.03000020980835 | 6.09999990463257 | 5.8600001335144 | 5.8899998664856 | 1728500.0 |
| 2005-10-04 | ABAX-DELISTED | Stock | 13.86 | 14.32 | 13.85 | 13.9 | 265165.0 |
| 2005-10-04 | ABB-DELISTED | Stock | 7.47 | 7.52 | 7.38 | 7.38 | 869200.0 |
| 2005-10-04 | ABBC-DELISTED | Stock | 12.5205 | 12.5205 | 12.5 | 12.5 | 1900.0 |
| 2005-10-04 | ABC-DELISTED | Stock | 19.4 | 19.61 | 19.39 | 19.46 | 2888400.0 |
| 2005-10-04 | ABCB | Stock | 18.6164 | 18.7817 | 18.4413 | 18.4413 | 3393.0 |
| 2005-10-04 | ABCO-DELISTED | Stock | 25.99 | 26.47 | 25.67 | 25.7 | 179663.0 |
| 2005-10-04 | ABCW-DELISTED | Stock | 29.83 | 29.9 | 29.44 | 29.49 | 61460.0 |
| 2005-10-04 | ABD-DELISTED | Stock | 27.85 | 27.97 | 27.38 | 27.71 | 341000.0 |
| 2005-10-04 | ABE-DELISTED | Stock | 11.42 | 11.68 | 11.42 | 11.48 | 36600.0 |
| 2005-10-04 | ABFS-DELISTED | Stock | 34.44 | 34.77 | 33.81 | 33.88 | 279091.0 |
| 2005-10-04 | ABG | Stock | 16.8 | 17.26 | 16.65 | 16.9 | 121900.0 |
| 2005-10-04 | ABK-DELISTED | Stock | 71.98 | 72.0 | 70.7 | 71.0 | 730900.0 |
| 2005-10-04 | ABM | Stock | 20.95 | 21.05 | 20.77 | 20.95 | 168800.0 |
| 2005-10-04 | ABMD-DELISTED | Stock | 10.04 | 10.15 | 9.76 | 9.82 | 85318.0 |
| 2005-10-04 | ABP-DELISTED | Stock | 9.0 | 9.25 | 8.3 | 8.87 | 3341000.0 |
| 2005-10-04 | ABR | Stock | 28.68 | 29.1 | 28.43 | 28.91 | 207300.0 |
| 2005-10-04 | ABT | Stock | 20.6314 | 21.1544 | 20.6314 | 21.116 | 21396207.0 |
| 2005-10-04 | ABTL-DELISTED | Stock | 24.82 | 25.07 | 24.33 | 24.43 | 54944.0 |
| 2005-10-04 | ABV-DELISTED | Stock | 38.41 | 38.78 | 38.13 | 38.16 | 462100.0 |
| 2005-10-04 | ABVA-DELISTED | Stock | 16.35 | 16.5 | 16.35 | 16.36 | 1000.0 |
| 2005-10-04 | ABX-DELISTED | Stock | 28.99 | 29.12 | 28.26 | 28.34 | 2897500.0 |
| 2005-10-04 | ACAD | Stock | 11.44 | 11.53 | 11.15 | 11.15 | 54400.0 |
| 2005-10-04 | ACAP-DELISTED | Stock | 48.42 | 48.5 | 47.11 | 47.54 | 58380.0 |
| 2005-10-04 | ACAS-DELISTED | Stock | 36.66 | 37.18 | 36.65 | 36.79 | 542357.0 |
| 2005-10-04 | ACAT-DELISTED | Stock | 20.6 | 20.6 | 20.25 | 20.26 | 183991.0 |
| 2005-10-04 | ACC-DELISTED | Stock | 24.01 | 24.14 | 23.9 | 24.01 | 113395.0 |
| 2005-10-04 | ACCL-DELISTED | Stock | 6.98 | 7.05 | 6.91 | 7.0 | 140342.0 |
| 2005-10-04 | ACCO | Stock | 27.85 | 27.97 | 27.38 | 27.71 | 341000.0 |
| 2005-10-04 | ACE-DELISTED | Stock | 45.8 | 47.52 | 45.8 | 47.3 | 9856600.0 |
| 2005-10-04 | ACF-DELISTED | Stock | 23.6 | 23.68 | 22.87 | 23.09 | 2357400.0 |
| 2005-10-04 | ACFC-DELISTED | Stock | 71.17 | 71.43 | 71.17 | 71.22 | 622.0 |
| 2005-10-04 | ACG-DELISTED | Stock | 8.34 | 8.35 | 8.32 | 8.33 | 306900.0 |
> showing 50 of 4,196 rows — these rows as CSV