PREVIEW / stock_daily / 2006-01-13
file: by_date/stock_daily/2006/2006-01-13.parquet size: 144 KB rows: 4,307 symbols: 2,721
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-13 | AAPL | Stock | 3.0354 | 3.0718 | 3.0214 | 3.0568 | 776305600.0 |
| 2006-01-13 | MSFT | Stock | 27.03 | 27.25 | 27.01 | 27.19 | 41418000.0 |
| 2006-01-13 | NVDA | Stock | 0.3566 | 0.3595 | 0.3492 | 0.3542 | 421296000.0 |
| 2006-01-13 | AMZN | Stock | 2.2235 | 2.2425 | 2.2 | 2.22 | 88644000.0 |
| 2006-01-13 | CL | Stock | 27.19 | 27.5 | 27.165 | 27.375 | 2844600.0 |
| 2006-01-13 | A | Stock | 24.4134 | 24.4993 | 24.0272 | 24.2918 | 4101592.0 |
| 2006-01-13 | AABA-DELISTED | Stock | 41.0 | 41.0800018310547 | 39.6199989318848 | 39.9000015258789 | 30960800.0 |
| 2006-01-13 | AACC-DELISTED | Stock | 22.82 | 23.07 | 22.68 | 22.82 | 148071.0 |
| 2006-01-13 | AACQ-DELISTED | Stock | 5.2 | 5.21 | 5.2 | 5.205 | 53300.0 |
| 2006-01-13 | AACQU-DELISTED | Stock | 6.3 | 6.3 | 6.3 | 6.3 | 7800.0 |
| 2006-01-13 | AACQW-DELISTED | Stock | 0.56 | 0.59 | 0.56 | 0.57 | 45000.0 |
| 2006-01-13 | AAI-DELISTED | Stock | 15.4 | 15.4 | 14.86 | 14.99 | 1648600.0 |
| 2006-01-13 | AAIC-DELISTED | Stock | 219.4 | 220.4 | 217.0 | 219.0 | 756800.0 |
| 2006-01-13 | AAME | Stock | 2.78 | 2.79 | 2.66 | 2.79 | 2700.0 |
| 2006-01-13 | AAON | Stock | 2.4033 | 2.4323 | 2.3704 | 2.4296 | 110109.0 |
| 2006-01-13 | AAP | Stock | 44.3 | 44.78 | 44.29 | 44.37 | 826600.0 |
| 2006-01-13 | AATI-DELISTED | Stock | 13.95 | 14.16 | 13.88 | 14.1 | 79752.0 |
| 2006-01-13 | AAU-DELISTED | Stock | 2.7 | 2.7 | 2.59 | 2.66 | 99300.0 |
| 2006-01-13 | AAUAF-DELISTED | Stock | 2.7 | 2.7 | 2.59 | 2.66 | 99300.0 |
| 2006-01-13 | AAV-DELISTED | Stock | 18.48 | 18.52 | 18.35 | 18.45 | 136300.0 |
| 2006-01-13 | AAWW-DELISTED | Stock | 45.0 | 45.75 | 44.0 | 45.75 | 10200.0 |
| 2006-01-13 | AAXN-DELISTED | Stock | 8.57999992370605 | 8.65999984741211 | 8.26000022888184 | 8.5600004196167 | 3297500.0 |
| 2006-01-13 | ABAX-DELISTED | Stock | 18.05 | 18.3 | 17.75 | 17.85 | 145224.0 |
| 2006-01-13 | ABB-DELISTED | Stock | 10.99 | 10.99 | 10.85 | 10.9299 | 1948500.0 |
| 2006-01-13 | ABBC-DELISTED | Stock | 13.1984 | 13.25 | 13.1984 | 13.22 | 3500.0 |
| 2006-01-13 | ABC-DELISTED | Stock | 20.62 | 20.74 | 20.48 | 20.7 | 1632400.0 |
| 2006-01-13 | ABCB | Stock | 20.0851 | 20.2698 | 19.8905 | 20.0169 | 9356.0 |
| 2006-01-13 | ABCO-DELISTED | Stock | 22.59 | 23.02 | 22.27 | 22.86 | 1159560.0 |
| 2006-01-13 | ABCW-DELISTED | Stock | 31.53 | 31.77 | 30.8 | 31.69 | 74060.0 |
| 2006-01-13 | ABD-DELISTED | Stock | 24.99 | 25.13 | 24.83 | 24.99 | 227410.0 |
| 2006-01-13 | ABE-DELISTED | Stock | 12.78 | 12.85 | 12.65 | 12.84 | 12100.0 |
| 2006-01-13 | ABFS-DELISTED | Stock | 44.91 | 45.85 | 44.91 | 45.34 | 237999.0 |
| 2006-01-13 | ABG | Stock | 16.41 | 16.91 | 16.41 | 16.91 | 15700.0 |
| 2006-01-13 | ABK-DELISTED | Stock | 77.6 | 78.31 | 77.46 | 78.27 | 375100.0 |
| 2006-01-13 | ABM | Stock | 19.69 | 19.87 | 19.6 | 19.7 | 79200.0 |
| 2006-01-13 | ABMD-DELISTED | Stock | 10.59 | 10.78 | 10.2 | 10.27 | 49934.0 |
| 2006-01-13 | ABP-DELISTED | Stock | 5.4 | 5.5 | 5.35 | 5.39 | 293100.0 |
| 2006-01-13 | ABR | Stock | 27.25 | 27.29 | 26.69 | 27.05 | 74300.0 |
| 2006-01-13 | ABT | Stock | 19.9021 | 19.9933 | 19.667 | 19.763 | 6033764.0 |
| 2006-01-13 | ABTL-DELISTED | Stock | 25.55 | 25.8 | 24.95 | 24.95 | 30785.0 |
| 2006-01-13 | ABV-DELISTED | Stock | 41.7 | 41.93 | 40.9 | 41.64 | 506500.0 |
| 2006-01-13 | ABVA-DELISTED | Stock | 16.5 | 16.5 | 16.5 | 16.5 | 1000.0 |
| 2006-01-13 | ABX-DELISTED | Stock | 29.14 | 29.87 | 28.96 | 29.77 | 5684800.0 |
| 2006-01-13 | ACAD | Stock | 10.64 | 10.84 | 10.64 | 10.71 | 134300.0 |
| 2006-01-13 | ACAP-DELISTED | Stock | 48.03 | 48.1 | 47.74 | 47.95 | 21155.0 |
| 2006-01-13 | ACAS-DELISTED | Stock | 35.45 | 36.0 | 35.42 | 35.79 | 971129.0 |
| 2006-01-13 | ACAT-DELISTED | Stock | 22.75 | 22.9 | 22.38 | 22.38 | 43736.0 |
| 2006-01-13 | ACC-DELISTED | Stock | 25.21 | 25.36 | 24.96 | 25.14 | 15400.0 |
| 2006-01-13 | ACCL-DELISTED | Stock | 6.81 | 7.15 | 6.71 | 7.12 | 136990.0 |
| 2006-01-13 | ACCO | Stock | 25.0 | 25.14 | 24.83 | 24.99 | 227400.0 |
> showing 50 of 4,307 rows — these rows as CSV