PREVIEW / stock_daily / 2006-01-11
file: by_date/stock_daily/2006/2006-01-11.parquet size: 145 KB rows: 4,324 symbols: 2,732
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-01-11 | AAPL | Stock | 2.9943 | 3.0286 | 2.9496 | 2.9964 | 1493794400.0 |
| 2006-01-11 | MSFT | Stock | 27.01 | 27.39 | 26.9 | 27.29 | 70120700.0 |
| 2006-01-11 | NVDA | Stock | 0.3502 | 0.3646 | 0.3497 | 0.3626 | 626304000.0 |
| 2006-01-11 | AMZN | Stock | 2.2825 | 2.285 | 2.213 | 2.2465 | 169944000.0 |
| 2006-01-11 | CL | Stock | 27.425 | 27.585 | 27.275 | 27.34 | 5182600.0 |
| 2006-01-11 | A | Stock | 25.0358 | 25.093 | 24.7496 | 25.0286 | 2874987.0 |
| 2006-01-11 | AABA-DELISTED | Stock | 42.189998626709 | 42.310001373291 | 41.7200012207031 | 41.8699989318848 | 26191400.0 |
| 2006-01-11 | AACC-DELISTED | Stock | 23.24 | 23.59 | 23.0 | 23.13 | 92346.0 |
| 2006-01-11 | AACQW-DELISTED | Stock | 0.53 | 0.54 | 0.53 | 0.54 | 12500.0 |
| 2006-01-11 | AAI-DELISTED | Stock | 16.18 | 16.22 | 15.7 | 15.85 | 1508000.0 |
| 2006-01-11 | AAIC-DELISTED | Stock | 216.0 | 224.4 | 216.0 | 223.2 | 1463200.0 |
| 2006-01-11 | AAME | Stock | 2.66 | 2.66 | 2.66 | 2.66 | 1300.0 |
| 2006-01-11 | AAON | Stock | 2.4362 | 2.4362 | 2.3875 | 2.4138 | 88847.0 |
| 2006-01-11 | AAP | Stock | 44.3 | 44.59 | 43.85 | 44.23 | 707100.0 |
| 2006-01-11 | AATI-DELISTED | Stock | 13.9 | 14.75 | 13.74 | 14.2 | 361835.0 |
| 2006-01-11 | AAU-DELISTED | Stock | 2.61 | 2.78 | 2.61 | 2.76 | 133848.0 |
| 2006-01-11 | AAUAF-DELISTED | Stock | 2.61 | 2.77 | 2.61 | 2.75 | 134100.0 |
| 2006-01-11 | AAV-DELISTED | Stock | 18.49 | 18.52 | 18.25 | 18.35 | 143800.0 |
| 2006-01-11 | AAWW-DELISTED | Stock | 45.0 | 45.0 | 43.75 | 43.75 | 7000.0 |
| 2006-01-11 | AAXN-DELISTED | Stock | 8.94999980926514 | 9.38000011444092 | 8.80000019073486 | 9.05000019073486 | 6229300.0 |
| 2006-01-11 | ABAX-DELISTED | Stock | 17.69 | 18.1 | 17.53 | 18.08 | 140133.0 |
| 2006-01-11 | ABB-DELISTED | Stock | 11.1 | 11.22 | 11.08 | 11.18 | 2353300.0 |
| 2006-01-11 | ABBC-DELISTED | Stock | 13.3625 | 13.44 | 13.31 | 13.3805 | 7750.0 |
| 2006-01-11 | ABC-DELISTED | Stock | 20.56 | 20.68 | 20.5 | 20.51 | 1819000.0 |
| 2006-01-11 | ABCB | Stock | 20.3866 | 20.3866 | 19.8419 | 19.9391 | 22413.0 |
| 2006-01-11 | ABCO-DELISTED | Stock | 23.78 | 23.85 | 23.16 | 23.32 | 508682.0 |
| 2006-01-11 | ABCW-DELISTED | Stock | 31.64 | 31.65 | 31.09 | 31.38 | 41600.0 |
| 2006-01-11 | ABD-DELISTED | Stock | 24.65 | 24.98 | 24.62 | 24.97 | 216300.0 |
| 2006-01-11 | ABE-DELISTED | Stock | 12.68 | 12.85 | 12.65 | 12.78 | 29500.0 |
| 2006-01-11 | ABFS-DELISTED | Stock | 44.59 | 44.87 | 43.901 | 43.91 | 337997.0 |
| 2006-01-11 | ABG | Stock | 16.83 | 17.04 | 16.25 | 16.86 | 117600.0 |
| 2006-01-11 | ABK-DELISTED | Stock | 78.81 | 79.08 | 78.22 | 78.55 | 329600.0 |
| 2006-01-11 | ABM | Stock | 20.23 | 20.23 | 19.65 | 19.95 | 139000.0 |
| 2006-01-11 | ABMD-DELISTED | Stock | 10.21 | 10.67 | 10.15 | 10.53 | 149676.0 |
| 2006-01-11 | ABP-DELISTED | Stock | 5.61 | 5.73 | 5.46 | 5.47 | 1079900.0 |
| 2006-01-11 | ABR | Stock | 27.45 | 27.47 | 26.66 | 27.25 | 108000.0 |
| 2006-01-11 | ABT | Stock | 19.9453 | 19.9645 | 19.7534 | 19.8781 | 9657149.0 |
| 2006-01-11 | ABTL-DELISTED | Stock | 25.55 | 25.55 | 25.0 | 25.35 | 17785.0 |
| 2006-01-11 | ABV-DELISTED | Stock | 41.4 | 41.52 | 40.91 | 41.4 | 300800.0 |
| 2006-01-11 | ABVA-DELISTED | Stock | 16.409 | 16.409 | 16.409 | 16.409 | 200.0 |
| 2006-01-11 | ABX-DELISTED | Stock | 29.76 | 29.77 | 29.09 | 29.16 | 3585700.0 |
| 2006-01-11 | ACAD | Stock | 10.99 | 11.03 | 10.68 | 10.8 | 79400.0 |
| 2006-01-11 | ACAP-DELISTED | Stock | 48.25 | 49.26 | 47.66 | 49.01 | 64311.0 |
| 2006-01-11 | ACAS-DELISTED | Stock | 36.02 | 36.24 | 35.97 | 36.15 | 814817.0 |
| 2006-01-11 | ACAT-DELISTED | Stock | 22.68 | 23.0 | 22.68 | 22.85 | 119477.0 |
| 2006-01-11 | ACC-DELISTED | Stock | 25.5 | 25.5 | 25.18 | 25.2 | 34783.0 |
| 2006-01-11 | ACCL-DELISTED | Stock | 7.75 | 7.75 | 7.09 | 7.14 | 331397.0 |
| 2006-01-11 | ACCO | Stock | 24.65 | 24.99 | 24.62 | 24.97 | 216900.0 |
| 2006-01-11 | ACE-DELISTED | Stock | 56.41 | 56.98 | 56.21 | 56.66 | 718700.0 |
| 2006-01-11 | ACF-DELISTED | Stock | 27.52 | 27.85 | 27.5 | 27.75 | 1685700.0 |
> showing 50 of 4,324 rows — these rows as CSV