PREVIEW / stock_daily / 2006-12-12
file: by_date/stock_daily/2006/2006-12-12.parquet size: 156 KB rows: 4,655 symbols: 2,949
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-12 | AAPL | Stock | 3.1646 | 3.1729 | 3.0546 | 3.0764 | 1026620000.0 |
| 2006-12-12 | MSFT | Stock | 29.56 | 29.63 | 29.22 | 29.43 | 68529400.0 |
| 2006-12-12 | NVDA | Stock | 0.5982 | 0.6002 | 0.5885 | 0.5965 | 568116000.0 |
| 2006-12-12 | AMZN | Stock | 1.922 | 1.947 | 1.9075 | 1.923 | 101664000.0 |
| 2006-12-12 | CL | Stock | 32.99 | 32.995 | 32.76 | 32.845 | 3156800.0 |
| 2006-12-12 | A | Stock | 23.9628 | 24.6209 | 23.7697 | 24.2203 | 5897463.0 |
| 2006-12-12 | AABA-DELISTED | Stock | 26.6299991607666 | 27.3799991607666 | 26.6000003814697 | 26.75 | 31971600.0 |
| 2006-12-12 | AACC-DELISTED | Stock | 16.16 | 16.29 | 16.1 | 16.1 | 59911.0 |
| 2006-12-12 | AACQ-DELISTED | Stock | 5.45 | 5.45 | 5.45 | 5.45 | 3000.0 |
| 2006-12-12 | AACQU-DELISTED | Stock | 6.53 | 6.53 | 6.53 | 6.53 | 5000.0 |
| 2006-12-12 | AACQW-DELISTED | Stock | 0.56 | 0.56 | 0.55 | 0.55 | 50500.0 |
| 2006-12-12 | AAI-DELISTED | Stock | 12.69 | 12.7 | 12.2 | 12.36 | 1896900.0 |
| 2006-12-12 | AAIC-DELISTED | Stock | 151.0 | 151.8 | 149.2 | 151.0 | 1284400.0 |
| 2006-12-12 | AAME | Stock | 3.25 | 3.25 | 2.82 | 2.86 | 17300.0 |
| 2006-12-12 | AAON | Stock | 3.5042 | 3.6227 | 3.466 | 3.574 | 136687.0 |
| 2006-12-12 | AAP | Stock | 36.0 | 36.04 | 35.28 | 35.6 | 1873700.0 |
| 2006-12-12 | AATI-DELISTED | Stock | 5.27 | 5.28 | 5.18 | 5.19 | 129134.0 |
| 2006-12-12 | AAU-DELISTED | Stock | 2.38 | 2.38 | 2.3 | 2.32 | 49000.0 |
| 2006-12-12 | AAUAF-DELISTED | Stock | 2.38 | 2.38 | 2.3 | 2.32 | 49000.0 |
| 2006-12-12 | AAV-DELISTED | Stock | 11.52 | 11.69 | 11.48 | 11.6 | 661200.0 |
| 2006-12-12 | AAWW-DELISTED | Stock | 45.31 | 46.06 | 45.31 | 45.71 | 187253.0 |
| 2006-12-12 | AAXN-DELISTED | Stock | 8.27000045776367 | 8.27999973297119 | 8.05000019073486 | 8.13000011444092 | 884200.0 |
| 2006-12-12 | AB | Stock | 78.81 | 79.23 | 78.24 | 78.72 | 292900.0 |
| 2006-12-12 | ABAX-DELISTED | Stock | 19.3 | 19.44 | 19.13 | 19.33 | 102667.0 |
| 2006-12-12 | ABB-DELISTED | Stock | 17.12 | 17.14 | 16.92 | 17.01 | 3761000.0 |
| 2006-12-12 | ABBC-DELISTED | Stock | 19.25 | 19.43 | 19.2 | 19.3 | 6151.0 |
| 2006-12-12 | ABC-DELISTED | Stock | 23.12 | 23.32 | 23.08 | 23.28 | 2333600.0 |
| 2006-12-12 | ABCB | Stock | 27.3021 | 27.3507 | 26.7865 | 27.0492 | 18095.0 |
| 2006-12-12 | ABCO-DELISTED | Stock | 26.56 | 27.26 | 26.56 | 26.86 | 194292.0 |
| 2006-12-12 | ABCW-DELISTED | Stock | 28.45 | 28.6 | 28.4 | 28.53 | 55510.0 |
| 2006-12-12 | ABD-DELISTED | Stock | 25.94 | 26.0 | 25.3 | 25.63 | 195700.0 |
| 2006-12-12 | ABE-DELISTED | Stock | 18.9 | 19.09 | 17.31 | 18.31 | 151700.0 |
| 2006-12-12 | ABFS-DELISTED | Stock | 37.39 | 37.5 | 36.09 | 36.13 | 658462.0 |
| 2006-12-12 | ABG | Stock | 23.92 | 23.97 | 23.58 | 23.87 | 198500.0 |
| 2006-12-12 | ABK-DELISTED | Stock | 85.15 | 85.81 | 85.15 | 85.72 | 504800.0 |
| 2006-12-12 | ABM | Stock | 20.75 | 20.95 | 20.59 | 20.95 | 103200.0 |
| 2006-12-12 | ABMD-DELISTED | Stock | 13.23 | 13.43 | 12.89 | 12.9 | 82654.0 |
| 2006-12-12 | ABP-DELISTED | Stock | 3.76 | 3.9 | 3.65 | 3.68 | 152500.0 |
| 2006-12-12 | ABR | Stock | 28.89 | 28.97 | 28.72 | 28.94 | 51700.0 |
| 2006-12-12 | ABT | Stock | 23.0064 | 23.0448 | 22.8769 | 23.0256 | 7268654.0 |
| 2006-12-12 | ABTL-DELISTED | Stock | 16.8 | 16.951 | 16.6 | 16.7 | 29320.0 |
| 2006-12-12 | ABV-DELISTED | Stock | 48.19 | 48.25 | 47.87 | 48.0 | 355600.0 |
| 2006-12-12 | ABVA-DELISTED | Stock | 16.0 | 16.11 | 16.0 | 16.11 | 2100.0 |
| 2006-12-12 | ABVT-DELISTED | Stock | 58.0 | 58.0 | 58.0 | 58.0 | 1351.0 |
| 2006-12-12 | ABX-DELISTED | Stock | 30.16 | 30.37 | 29.73 | 30.11 | 3077272.0 |
| 2006-12-12 | ACAD | Stock | 8.93 | 8.95 | 8.62 | 8.76 | 110700.0 |
| 2006-12-12 | ACAP-DELISTED | Stock | 39.18 | 39.39 | 38.62 | 38.92 | 30690.0 |
| 2006-12-12 | ACAS-DELISTED | Stock | 44.78 | 44.78 | 44.33 | 44.65 | 490696.0 |
| 2006-12-12 | ACAT-DELISTED | Stock | 18.12 | 18.18 | 17.97 | 18.15 | 64427.0 |
| 2006-12-12 | ACC-DELISTED | Stock | 29.58 | 29.98 | 29.05 | 29.17 | 146500.0 |
> showing 50 of 4,655 rows — these rows as CSV