PREVIEW / stock_daily / 2005-12-14
file: by_date/stock_daily/2005/2005-12-14.parquet size: 144 KB rows: 4,309 symbols: 2,726
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-12-14 | AAPL | Stock | 2.5904 | 2.6179 | 2.5096 | 2.5718 | 1450716400.0 |
| 2005-12-14 | MSFT | Stock | 27.0 | 27.24 | 26.85 | 27.09 | 65076200.0 |
| 2005-12-14 | NVDA | Stock | 0.3089 | 0.3104 | 0.3047 | 0.3083 | 287472000.0 |
| 2005-12-14 | AMZN | Stock | 2.46 | 2.48 | 2.4395 | 2.4705 | 99318000.0 |
| 2005-12-14 | CL | Stock | 28.0 | 28.305 | 27.9 | 28.125 | 4190600.0 |
| 2005-12-14 | A | Stock | 25.7153 | 25.7511 | 25.3219 | 25.4149 | 20195927.0 |
| 2005-12-14 | AABA-DELISTED | Stock | 41.1199989318848 | 41.6800003051758 | 40.8400001525879 | 41.2999992370605 | 23034200.0 |
| 2005-12-14 | AACC-DELISTED | Stock | 22.5 | 22.63 | 21.8 | 22.06 | 342755.0 |
| 2005-12-14 | AACQ-DELISTED | Stock | 5.19 | 5.19 | 5.19 | 5.19 | 4900.0 |
| 2005-12-14 | AACQU-DELISTED | Stock | 6.15 | 6.15 | 6.15 | 6.15 | 1500.0 |
| 2005-12-14 | AACQW-DELISTED | Stock | 0.49 | 0.51 | 0.49 | 0.5 | 51000.0 |
| 2005-12-14 | AAI-DELISTED | Stock | 13.6 | 13.95 | 13.51 | 13.68 | 1613800.0 |
| 2005-12-14 | AAIC-DELISTED | Stock | 208.4 | 220.0 | 207.8 | 218.8 | 1533800.0 |
| 2005-12-14 | AAME | Stock | 2.75 | 2.8 | 2.75 | 2.75 | 1300.0 |
| 2005-12-14 | AAON | Stock | 2.3875 | 2.4362 | 2.3875 | 2.4257 | 130612.0 |
| 2005-12-14 | AAP | Stock | 42.3 | 43.55 | 42.3 | 43.03 | 670400.0 |
| 2005-12-14 | AATI-DELISTED | Stock | 15.0 | 15.4 | 15.0 | 15.1 | 132819.0 |
| 2005-12-14 | AAV-DELISTED | Stock | 20.25 | 20.28 | 20.08 | 20.28 | 209200.0 |
| 2005-12-14 | AAWW-DELISTED | Stock | 42.5 | 42.5 | 41.25 | 41.75 | 7800.0 |
| 2005-12-14 | AAXN-DELISTED | Stock | 7.11999988555908 | 7.11999988555908 | 6.6399998664856 | 6.80999994277954 | 2745100.0 |
| 2005-12-14 | ABAX-DELISTED | Stock | 15.9 | 15.9 | 15.63 | 15.7 | 212403.0 |
| 2005-12-14 | ABB-DELISTED | Stock | 9.4 | 9.4 | 9.29 | 9.34 | 2250500.0 |
| 2005-12-14 | ABBC-DELISTED | Stock | 13.15 | 13.15 | 13.1 | 13.14 | 6188.0 |
| 2005-12-14 | ABC-DELISTED | Stock | 20.38 | 20.4 | 20.3 | 20.36 | 2440800.0 |
| 2005-12-14 | ABCB | Stock | 20.2018 | 20.3185 | 19.91 | 19.9391 | 6786.0 |
| 2005-12-14 | ABCO-DELISTED | Stock | 24.25 | 24.39 | 24.17 | 24.22 | 107306.0 |
| 2005-12-14 | ABCW-DELISTED | Stock | 31.26 | 31.42 | 30.94 | 31.19 | 68650.0 |
| 2005-12-14 | ABD-DELISTED | Stock | 23.88 | 23.98 | 23.61 | 23.85 | 161400.0 |
| 2005-12-14 | ABE-DELISTED | Stock | 11.65 | 11.75 | 11.63 | 11.68 | 26900.0 |
| 2005-12-14 | ABFS-DELISTED | Stock | 42.95 | 43.55 | 42.851 | 43.5 | 237627.0 |
| 2005-12-14 | ABG | Stock | 17.9 | 17.9 | 17.48 | 17.51 | 23600.0 |
| 2005-12-14 | ABK-DELISTED | Stock | 77.6 | 78.55 | 77.57 | 77.85 | 423800.0 |
| 2005-12-14 | ABM | Stock | 20.43 | 21.0 | 20.43 | 20.6 | 224400.0 |
| 2005-12-14 | ABMD-DELISTED | Stock | 9.09 | 9.23 | 8.9 | 8.92 | 54724.0 |
| 2005-12-14 | ABP-DELISTED | Stock | 6.4 | 6.48 | 6.25 | 6.34 | 345700.0 |
| 2005-12-14 | ABR | Stock | 26.5 | 26.55 | 26.05 | 26.23 | 135400.0 |
| 2005-12-14 | ABT | Stock | 18.8945 | 19.0912 | 18.7986 | 18.9377 | 7715090.0 |
| 2005-12-14 | ABTL-DELISTED | Stock | 26.2 | 26.25 | 25.75 | 26.1 | 7045.0 |
| 2005-12-14 | ABV-DELISTED | Stock | 38.35 | 38.51 | 37.84 | 38.06 | 668600.0 |
| 2005-12-14 | ABVA-DELISTED | Stock | 16.566 | 16.7 | 16.4 | 16.4 | 1903.0 |
| 2005-12-14 | ABX-DELISTED | Stock | 27.3 | 27.3 | 26.82 | 26.86 | 2728700.0 |
| 2005-12-14 | ACAD | Stock | 10.13 | 10.13 | 9.89 | 9.97 | 25800.0 |
| 2005-12-14 | ACAP-DELISTED | Stock | 47.11 | 47.15 | 46.09 | 46.18 | 52614.0 |
| 2005-12-14 | ACAS-DELISTED | Stock | 37.59 | 37.64 | 37.22 | 37.54 | 896638.0 |
| 2005-12-14 | ACAT-DELISTED | Stock | 21.42 | 21.42 | 20.77 | 20.84 | 58335.0 |
| 2005-12-14 | ACC-DELISTED | Stock | 25.55 | 25.58 | 25.39 | 25.47 | 40300.0 |
| 2005-12-14 | ACCL-DELISTED | Stock | 7.52 | 7.55 | 7.27 | 7.35 | 81441.0 |
| 2005-12-14 | ACCO | Stock | 23.88 | 23.98 | 23.61 | 23.85 | 166400.0 |
| 2005-12-14 | ACE-DELISTED | Stock | 55.1 | 55.34 | 54.64 | 54.89 | 1826500.0 |
| 2005-12-14 | ACF-DELISTED | Stock | 25.84 | 26.16 | 25.84 | 25.99 | 1339100.0 |
> showing 50 of 4,309 rows — these rows as CSV