PREVIEW / stock_daily / 2005-12-20
file: by_date/stock_daily/2005/2005-12-20.parquet size: 144 KB rows: 4,311 symbols: 2,731
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-20 | AAPL | Stock | 2.5582 | 2.585 | 2.54 | 2.5754 | 479108000.0 |
| 2005-12-20 | MSFT | Stock | 26.76 | 26.88 | 26.67 | 26.86 | 62960600.0 |
| 2005-12-20 | NVDA | Stock | 0.3017 | 0.3062 | 0.2978 | 0.3018 | 304356000.0 |
| 2005-12-20 | AMZN | Stock | 2.423 | 2.43 | 2.384 | 2.407 | 110704000.0 |
| 2005-12-20 | CL | Stock | 27.975 | 28.03 | 27.67 | 27.675 | 3687800.0 |
| 2005-12-20 | A | Stock | 25.0358 | 25.0715 | 24.6781 | 24.907 | 4113056.0 |
| 2005-12-20 | AABA-DELISTED | Stock | 41.2599983215332 | 41.3600006103516 | 40.4799995422363 | 40.6800003051758 | 15269500.0 |
| 2005-12-20 | AACC-DELISTED | Stock | 21.6 | 21.93 | 21.35 | 21.61 | 133621.0 |
| 2005-12-20 | AAI-DELISTED | Stock | 14.46 | 14.71 | 14.21 | 14.5 | 964100.0 |
| 2005-12-20 | AAIC-DELISTED | Stock | 211.6 | 212.6 | 205.0 | 206.0 | 1508500.0 |
| 2005-12-20 | AAME | Stock | 2.64 | 2.64 | 2.6 | 2.6 | 8900.0 |
| 2005-12-20 | AAON | Stock | 2.373 | 2.398 | 2.3348 | 2.3691 | 56194.0 |
| 2005-12-20 | AAP | Stock | 42.24 | 42.56 | 41.84 | 42.31 | 561400.0 |
| 2005-12-20 | AATI-DELISTED | Stock | 14.6 | 14.74 | 14.44 | 14.7 | 36166.0 |
| 2005-12-20 | AAU-DELISTED | Stock | 1.62 | 1.64 | 1.6 | 1.63 | 14100.0 |
| 2005-12-20 | AAUAF-DELISTED | Stock | 1.62 | 1.64 | 1.6 | 1.63 | 14100.0 |
| 2005-12-20 | AAV-DELISTED | Stock | 19.8 | 19.8 | 19.25 | 19.43 | 170400.0 |
| 2005-12-20 | AAWW-DELISTED | Stock | 42.5 | 43.0 | 42.5 | 43.0 | 45000.0 |
| 2005-12-20 | AAXN-DELISTED | Stock | 6.26999998092651 | 6.42999982833862 | 6.11999988555908 | 6.15000009536743 | 1129900.0 |
| 2005-12-20 | ABAX-DELISTED | Stock | 15.33 | 16.21 | 15.15 | 16.03 | 252449.0 |
| 2005-12-20 | ABB-DELISTED | Stock | 9.25 | 9.29 | 9.15 | 9.1701 | 1103200.0 |
| 2005-12-20 | ABBC-DELISTED | Stock | 13.05 | 13.18 | 12.91 | 13.06 | 7450.0 |
| 2005-12-20 | ABC-DELISTED | Stock | 20.2 | 20.37 | 20.2 | 20.36 | 3153600.0 |
| 2005-12-20 | ABCB | Stock | 19.5015 | 19.5598 | 19.4529 | 19.5209 | 7608.0 |
| 2005-12-20 | ABCO-DELISTED | Stock | 24.16 | 24.44 | 23.9 | 24.01 | 460038.0 |
| 2005-12-20 | ABCW-DELISTED | Stock | 31.07 | 31.07 | 30.71 | 30.71 | 60190.0 |
| 2005-12-20 | ABD-DELISTED | Stock | 23.18 | 23.25 | 23.01 | 23.22 | 487970.0 |
| 2005-12-20 | ABE-DELISTED | Stock | 11.58 | 11.8 | 11.58 | 11.74 | 17600.0 |
| 2005-12-20 | ABFS-DELISTED | Stock | 42.82 | 43.02 | 41.87 | 42.13 | 503593.0 |
| 2005-12-20 | ABG | Stock | 16.85 | 17.22 | 16.73 | 16.85 | 34700.0 |
| 2005-12-20 | ABK-DELISTED | Stock | 77.5 | 78.36 | 77.5 | 77.95 | 324900.0 |
| 2005-12-20 | ABM | Stock | 19.79 | 20.05 | 19.7 | 19.95 | 134100.0 |
| 2005-12-20 | ABMD-DELISTED | Stock | 8.81 | 9.13 | 8.81 | 8.95 | 48246.0 |
| 2005-12-20 | ABP-DELISTED | Stock | 5.83 | 5.9 | 5.66 | 5.83 | 434900.0 |
| 2005-12-20 | ABR | Stock | 25.35 | 26.05 | 25.29 | 25.98 | 135700.0 |
| 2005-12-20 | ABT | Stock | 19.3215 | 19.5279 | 19.144 | 19.192 | 13913714.0 |
| 2005-12-20 | ABTL-DELISTED | Stock | 25.75 | 25.85 | 25.05 | 25.2 | 27359.0 |
| 2005-12-20 | ABV-DELISTED | Stock | 36.6 | 37.57 | 36.6 | 37.4 | 883500.0 |
| 2005-12-20 | ABVA-DELISTED | Stock | 16.45 | 16.49 | 16.25 | 16.25 | 3200.0 |
| 2005-12-20 | ABX-DELISTED | Stock | 26.99 | 27.1 | 26.51 | 26.81 | 3130600.0 |
| 2005-12-20 | ACAD | Stock | 9.76 | 10.05 | 9.61 | 9.67 | 61200.0 |
| 2005-12-20 | ACAP-DELISTED | Stock | 45.31 | 45.75 | 44.27 | 44.33 | 56931.0 |
| 2005-12-20 | ACAS-DELISTED | Stock | 36.98 | 37.08 | 36.94 | 36.99 | 453821.0 |
| 2005-12-20 | ACAT-DELISTED | Stock | 19.97 | 20.05 | 19.9 | 19.93 | 69316.0 |
| 2005-12-20 | ACC-DELISTED | Stock | 24.61 | 24.7 | 24.55 | 24.65 | 133500.0 |
| 2005-12-20 | ACCL-DELISTED | Stock | 8.07 | 8.07 | 7.59 | 7.8 | 88800.0 |
| 2005-12-20 | ACCO | Stock | 23.17 | 23.23 | 23.0 | 23.23 | 488200.0 |
| 2005-12-20 | ACE-DELISTED | Stock | 53.5 | 53.97 | 53.41 | 53.8 | 1189800.0 |
| 2005-12-20 | ACF-DELISTED | Stock | 25.25 | 25.45 | 25.0 | 25.17 | 1150500.0 |
| 2005-12-20 | ACFC-DELISTED | Stock | 73.78 | 74.18 | 73.67 | 73.78 | 1045.0 |
> showing 50 of 4,311 rows — these rows as CSV