PREVIEW / stock_daily / 2006-12-29
file: by_date/stock_daily/2006/2006-12-29.parquet size: 158 KB rows: 4,712 symbols: 2,996
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-29 | AAPL | Stock | 2.9982 | 3.05 | 2.9771 | 3.03 | 1076429200.0 |
| 2006-12-29 | MSFT | Stock | 29.86 | 30.15 | 29.83 | 29.86 | 41739800.0 |
| 2006-12-29 | NVDA | Stock | 0.6207 | 0.6337 | 0.6162 | 0.6168 | 386094000.0 |
| 2006-12-29 | AMZN | Stock | 2.003 | 2.0125 | 1.9675 | 1.973 | 83940000.0 |
| 2006-12-29 | CL | Stock | 32.86 | 32.935 | 32.57 | 32.62 | 2344600.0 |
| 2006-12-29 | A | Stock | 25.2146 | 25.5293 | 24.8784 | 24.9285 | 2443285.0 |
| 2006-12-29 | AABA-DELISTED | Stock | 25.4200000762939 | 25.8199996948242 | 25.3299999237061 | 25.5400009155273 | 16297800.0 |
| 2006-12-29 | AACC-DELISTED | Stock | 16.97 | 17.19 | 16.68 | 16.82 | 113923.0 |
| 2006-12-29 | AACQ-DELISTED | Stock | 5.49 | 5.49 | 5.46 | 5.46 | 14200.0 |
| 2006-12-29 | AACQW-DELISTED | Stock | 0.47 | 0.47 | 0.47 | 0.47 | 5500.0 |
| 2006-12-29 | AAI-DELISTED | Stock | 12.0 | 12.0 | 11.67 | 11.73 | 1261100.0 |
| 2006-12-29 | AAIC-DELISTED | Stock | 161.8 | 162.0 | 158.2 | 160.0 | 1687800.0 |
| 2006-12-29 | AAME | Stock | 2.97 | 2.97 | 2.96 | 2.96 | 7000.0 |
| 2006-12-29 | AAON | Stock | 3.5964 | 3.6043 | 3.4423 | 3.4607 | 176175.0 |
| 2006-12-29 | AAP | Stock | 35.85 | 36.06 | 35.35 | 35.56 | 578100.0 |
| 2006-12-29 | AATI-DELISTED | Stock | 5.43 | 5.45 | 5.31 | 5.38 | 313440.0 |
| 2006-12-29 | AAU-DELISTED | Stock | 2.28 | 2.29 | 2.21 | 2.25 | 170600.0 |
| 2006-12-29 | AAUAF-DELISTED | Stock | 2.28 | 2.29 | 2.21 | 2.25 | 170600.0 |
| 2006-12-29 | AAV-DELISTED | Stock | 10.68 | 10.69 | 10.47 | 10.68 | 1665900.0 |
| 2006-12-29 | AAWW-DELISTED | Stock | 44.88 | 45.01 | 44.39 | 44.45 | 176033.0 |
| 2006-12-29 | AAXN-DELISTED | Stock | 7.90999984741211 | 8.10999965667725 | 7.59000015258789 | 7.6100001335144 | 2702300.0 |
| 2006-12-29 | AB | Stock | 80.35 | 80.6 | 80.08 | 80.4 | 100100.0 |
| 2006-12-29 | ABAX-DELISTED | Stock | 19.38 | 19.38 | 18.94 | 19.25 | 285281.0 |
| 2006-12-29 | ABB-DELISTED | Stock | 17.82 | 18.03 | 17.78 | 17.98 | 1123100.0 |
| 2006-12-29 | ABBC-DELISTED | Stock | 19.24 | 19.25 | 19.06 | 19.07 | 11471.0 |
| 2006-12-29 | ABC-DELISTED | Stock | 22.48 | 22.6 | 22.46 | 22.5 | 1700800.0 |
| 2006-12-29 | ABCB | Stock | 27.234 | 27.5453 | 27.1853 | 27.409 | 42256.0 |
| 2006-12-29 | ABCO-DELISTED | Stock | 26.84 | 27.02 | 26.71 | 26.76 | 143972.0 |
| 2006-12-29 | ABCW-DELISTED | Stock | 29.0 | 29.35 | 28.73 | 28.78 | 43450.0 |
| 2006-12-29 | ABD-DELISTED | Stock | 26.99 | 26.99 | 26.47 | 26.47 | 153430.0 |
| 2006-12-29 | ABE-DELISTED | Stock | 18.1 | 18.29 | 18.04 | 18.29 | 36400.0 |
| 2006-12-29 | ABFS-DELISTED | Stock | 37.08 | 37.08 | 36.0 | 36.02 | 306268.0 |
| 2006-12-29 | ABG | Stock | 23.72 | 23.88 | 23.56 | 23.56 | 115600.0 |
| 2006-12-29 | ABK-DELISTED | Stock | 89.5 | 89.89 | 88.82 | 89.01 | 219600.0 |
| 2006-12-29 | ABM | Stock | 22.94 | 23.03 | 22.71 | 22.71 | 236400.0 |
| 2006-12-29 | ABMD-DELISTED | Stock | 14.64 | 14.7279 | 13.7 | 14.12 | 258991.0 |
| 2006-12-29 | ABP-DELISTED | Stock | 3.13 | 3.24 | 3.04 | 3.09 | 641800.0 |
| 2006-12-29 | ABR | Stock | 30.0 | 30.57 | 29.95 | 30.09 | 107100.0 |
| 2006-12-29 | ABT | Stock | 23.4142 | 23.5054 | 23.2703 | 23.3711 | 8392247.0 |
| 2006-12-29 | ABTL-DELISTED | Stock | 17.601 | 17.853 | 16.592 | 17.5 | 60707.0 |
| 2006-12-29 | ABV-DELISTED | Stock | 49.23 | 49.23 | 48.65 | 48.77 | 176900.0 |
| 2006-12-29 | ABVA-DELISTED | Stock | 15.64 | 15.722 | 15.34 | 15.65 | 9680.0 |
| 2006-12-29 | ABVT-DELISTED | Stock | 50.0 | 60.0 | 50.0 | 60.0 | 8292.0 |
| 2006-12-29 | ABX-DELISTED | Stock | 30.87 | 30.87 | 30.42 | 30.67 | 1931800.0 |
| 2006-12-29 | ACAD | Stock | 8.85 | 8.93 | 8.72 | 8.79 | 156600.0 |
| 2006-12-29 | ACAP-DELISTED | Stock | 40.44 | 40.58 | 40.14 | 40.14 | 47190.0 |
| 2006-12-29 | ACAS-DELISTED | Stock | 46.36 | 46.45 | 46.2 | 46.26 | 444456.0 |
| 2006-12-29 | ACAT-DELISTED | Stock | 17.67 | 17.89 | 17.58 | 17.58 | 66970.0 |
| 2006-12-29 | ACC-DELISTED | Stock | 28.32 | 28.65 | 28.31 | 28.47 | 113600.0 |
| 2006-12-29 | ACCL-DELISTED | Stock | 5.85 | 6.01 | 5.85 | 6.0 | 88661.0 |
> showing 50 of 4,712 rows — these rows as CSV