PREVIEW / stock_daily / 2005-12-19
file: by_date/stock_daily/2005/2005-12-19.parquet size: 144 KB rows: 4,308 symbols: 2,724
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-19 | AAPL | Stock | 2.5396 | 2.5929 | 2.5371 | 2.5493 | 529295200.0 |
| 2005-12-19 | MSFT | Stock | 26.82 | 26.87 | 26.65 | 26.83 | 68680100.0 |
| 2005-12-19 | NVDA | Stock | 0.3077 | 0.31 | 0.3012 | 0.302 | 292296000.0 |
| 2005-12-19 | AMZN | Stock | 2.4495 | 2.5 | 2.416 | 2.4185 | 166174000.0 |
| 2005-12-19 | CL | Stock | 27.965 | 28.02 | 27.685 | 27.94 | 3143200.0 |
| 2005-12-19 | A | Stock | 25.1931 | 25.3934 | 25.0215 | 25.0715 | 4719788.0 |
| 2005-12-19 | AABA-DELISTED | Stock | 42.1599998474121 | 42.8899993896484 | 40.8800010681152 | 41.0499992370605 | 18563700.0 |
| 2005-12-19 | AACC-DELISTED | Stock | 21.77 | 21.89 | 21.52 | 21.61 | 110393.0 |
| 2005-12-19 | AACQ-DELISTED | Stock | 5.2 | 5.2 | 5.2 | 5.2 | 400.0 |
| 2005-12-19 | AACQU-DELISTED | Stock | 6.19 | 6.19 | 6.19 | 6.19 | 1000.0 |
| 2005-12-19 | AACQW-DELISTED | Stock | 0.52 | 0.53 | 0.52 | 0.53 | 52000.0 |
| 2005-12-19 | AAI-DELISTED | Stock | 14.98 | 15.0299 | 14.46 | 14.53 | 1443500.0 |
| 2005-12-19 | AAIC-DELISTED | Stock | 216.6 | 218.0 | 211.2 | 211.4 | 1155700.0 |
| 2005-12-19 | AAME | Stock | 2.65 | 2.65 | 2.65 | 2.65 | 100.0 |
| 2005-12-19 | AAON | Stock | 2.3783 | 2.4428 | 2.3559 | 2.4257 | 529284.0 |
| 2005-12-19 | AAP | Stock | 42.26 | 42.4 | 42.03 | 42.1 | 425000.0 |
| 2005-12-19 | AATI-DELISTED | Stock | 14.99 | 15.0 | 14.32 | 14.52 | 142106.0 |
| 2005-12-19 | AAV-DELISTED | Stock | 19.55 | 19.78 | 19.49 | 19.5 | 151200.0 |
| 2005-12-19 | AAWW-DELISTED | Stock | 42.0 | 42.5 | 42.0 | 42.5 | 63400.0 |
| 2005-12-19 | AAXN-DELISTED | Stock | 6.51999998092651 | 6.63000011444092 | 6.25 | 6.28000020980835 | 1330000.0 |
| 2005-12-19 | ABAX-DELISTED | Stock | 15.43 | 15.58 | 15.17 | 15.34 | 92070.0 |
| 2005-12-19 | ABB-DELISTED | Stock | 9.23 | 9.27 | 9.17 | 9.19 | 2063600.0 |
| 2005-12-19 | ABBC-DELISTED | Stock | 13.24 | 13.24 | 13.06 | 13.06 | 6327.0 |
| 2005-12-19 | ABC-DELISTED | Stock | 20.45 | 20.47 | 20.2 | 20.22 | 4104000.0 |
| 2005-12-19 | ABCB | Stock | 19.8905 | 19.8905 | 19.4529 | 19.6571 | 21385.0 |
| 2005-12-19 | ABCO-DELISTED | Stock | 24.77 | 24.77 | 23.97 | 24.17 | 342038.0 |
| 2005-12-19 | ABCW-DELISTED | Stock | 31.07 | 31.07 | 30.44 | 30.78 | 112740.0 |
| 2005-12-19 | ABD-DELISTED | Stock | 23.35 | 23.37 | 23.1 | 23.2 | 186400.0 |
| 2005-12-19 | ABE-DELISTED | Stock | 11.56 | 11.68 | 11.5 | 11.5 | 31900.0 |
| 2005-12-19 | ABFS-DELISTED | Stock | 43.64 | 43.65 | 42.4 | 42.57 | 481566.0 |
| 2005-12-19 | ABG | Stock | 16.81 | 16.85 | 16.56 | 16.75 | 40100.0 |
| 2005-12-19 | ABK-DELISTED | Stock | 77.74 | 78.33 | 77.19 | 77.37 | 448300.0 |
| 2005-12-19 | ABM | Stock | 20.1 | 20.1 | 19.42 | 19.79 | 266200.0 |
| 2005-12-19 | ABMD-DELISTED | Stock | 9.06 | 9.14 | 8.81 | 8.87 | 84630.0 |
| 2005-12-19 | ABP-DELISTED | Stock | 6.0 | 6.05 | 5.81 | 5.88 | 513400.0 |
| 2005-12-19 | ABR | Stock | 25.23 | 25.5 | 25.1 | 25.37 | 92700.0 |
| 2005-12-19 | ABT | Stock | 19.6718 | 19.6718 | 19.288 | 19.3983 | 13566903.0 |
| 2005-12-19 | ABTL-DELISTED | Stock | 25.6 | 26.15 | 25.25 | 25.75 | 41699.0 |
| 2005-12-19 | ABV-DELISTED | Stock | 36.73 | 36.97 | 35.94 | 36.1 | 453600.0 |
| 2005-12-19 | ABVA-DELISTED | Stock | 16.2 | 16.52 | 16.2 | 16.45 | 1025.0 |
| 2005-12-19 | ABX-DELISTED | Stock | 27.29 | 27.51 | 26.84 | 26.85 | 2145991.0 |
| 2005-12-19 | ACAD | Stock | 9.6 | 9.99 | 9.57 | 9.75 | 36000.0 |
| 2005-12-19 | ACAP-DELISTED | Stock | 45.0 | 45.93 | 44.75 | 45.37 | 57616.0 |
| 2005-12-19 | ACAS-DELISTED | Stock | 37.05 | 37.19 | 36.9 | 36.96 | 509499.0 |
| 2005-12-19 | ACAT-DELISTED | Stock | 20.45 | 20.45 | 19.77 | 20.01 | 89740.0 |
| 2005-12-19 | ACC-DELISTED | Stock | 24.9 | 24.99 | 24.55 | 24.61 | 84500.0 |
| 2005-12-19 | ACCL-DELISTED | Stock | 7.58 | 8.4 | 7.41 | 7.92 | 487431.0 |
| 2005-12-19 | ACCO | Stock | 23.35 | 23.37 | 23.1 | 23.2 | 196000.0 |
| 2005-12-19 | ACE-DELISTED | Stock | 54.95 | 54.95 | 53.22 | 53.45 | 1836600.0 |
| 2005-12-19 | ACF-DELISTED | Stock | 25.45 | 25.48 | 24.79 | 25.3 | 1089000.0 |
> showing 50 of 4,308 rows — these rows as CSV