PREVIEW / stock_daily / 2006-08-24
file: by_date/stock_daily/2006/2006-08-24.parquet size: 148 KB rows: 4,466 symbols: 2,816
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-08-24 | AAPL | Stock | 2.4246 | 2.4354 | 2.3668 | 2.4218 | 655191600.0 |
| 2006-08-24 | MSFT | Stock | 25.82 | 25.86 | 25.5 | 25.74 | 35933300.0 |
| 2006-08-24 | NVDA | Stock | 0.4393 | 0.445 | 0.4323 | 0.4427 | 260802000.0 |
| 2006-08-24 | AMZN | Stock | 1.412 | 1.4125 | 1.377 | 1.3985 | 90338000.0 |
| 2006-08-24 | CL | Stock | 29.645 | 29.725 | 29.535 | 29.58 | 1819600.0 |
| 2006-08-24 | A | Stock | 21.9599 | 22.1745 | 21.8169 | 21.867 | 2402882.0 |
| 2006-08-24 | AABA-DELISTED | Stock | 28.75 | 29.1299991607666 | 28.7000007629395 | 28.9899997711182 | 8983600.0 |
| 2006-08-24 | AACC-DELISTED | Stock | 15.24 | 15.49 | 15.18 | 15.19 | 159119.0 |
| 2006-08-24 | AACQ-DELISTED | Stock | 5.3 | 5.3 | 5.3 | 5.3 | 2000.0 |
| 2006-08-24 | AACQW-DELISTED | Stock | 0.39 | 0.39 | 0.39 | 0.39 | 9000.0 |
| 2006-08-24 | AAI-DELISTED | Stock | 11.63 | 11.63 | 11.11 | 11.18 | 1012000.0 |
| 2006-08-24 | AAIC-DELISTED | Stock | 173.6 | 174.0 | 168.4 | 170.0 | 1314300.0 |
| 2006-08-24 | AAME | Stock | 2.77 | 2.77 | 2.52 | 2.52 | 17600.0 |
| 2006-08-24 | AAON | Stock | 2.9643 | 3.017 | 2.8681 | 2.8721 | 209587.0 |
| 2006-08-24 | AAP | Stock | 29.6 | 29.63 | 29.24 | 29.48 | 808100.0 |
| 2006-08-24 | AATI-DELISTED | Stock | 9.33 | 9.49 | 9.22 | 9.4 | 1291123.0 |
| 2006-08-24 | AAU-DELISTED | Stock | 2.78 | 2.79 | 2.59 | 2.7 | 60600.0 |
| 2006-08-24 | AAUAF-DELISTED | Stock | 2.78 | 2.79 | 2.59 | 2.7 | 60600.0 |
| 2006-08-24 | AAV-DELISTED | Stock | 16.18 | 16.18 | 16.07 | 16.13 | 287300.0 |
| 2006-08-24 | AAWW-DELISTED | Stock | 41.77 | 42.38 | 41.46 | 42.03 | 60171.0 |
| 2006-08-24 | AAXN-DELISTED | Stock | 7.57999992370605 | 7.69999980926514 | 7.46999979019165 | 7.53000020980835 | 555800.0 |
| 2006-08-24 | AB | Stock | 66.65 | 66.65 | 65.6 | 65.99 | 171500.0 |
| 2006-08-24 | ABAX-DELISTED | Stock | 22.52 | 22.74 | 22.2 | 22.58 | 85794.0 |
| 2006-08-24 | ABB-DELISTED | Stock | 13.3 | 13.31 | 13.05 | 13.1 | 1138600.0 |
| 2006-08-24 | ABBC-DELISTED | Stock | 14.36 | 14.51 | 14.25 | 14.33 | 10583.0 |
| 2006-08-24 | ABC-DELISTED | Stock | 22.16 | 22.18 | 21.91 | 21.92 | 1627000.0 |
| 2006-08-24 | ABCB | Stock | 24.7732 | 25.1136 | 24.2966 | 24.6175 | 18815.0 |
| 2006-08-24 | ABCO-DELISTED | Stock | 24.29 | 24.52 | 23.97 | 24.4 | 155896.0 |
| 2006-08-24 | ABCW-DELISTED | Stock | 28.79 | 29.22 | 28.55 | 29.15 | 63060.0 |
| 2006-08-24 | ABD-DELISTED | Stock | 20.96 | 21.2 | 20.66 | 20.82 | 126200.0 |
| 2006-08-24 | ABE-DELISTED | Stock | 13.12 | 13.358 | 13.12 | 13.15 | 5000.0 |
| 2006-08-24 | ABFS-DELISTED | Stock | 43.12 | 43.42 | 41.8 | 41.82 | 394882.0 |
| 2006-08-24 | ABG | Stock | 19.68 | 19.97 | 19.35 | 19.49 | 60800.0 |
| 2006-08-24 | ABK-DELISTED | Stock | 85.3 | 85.65 | 84.92 | 85.04 | 695000.0 |
| 2006-08-24 | ABM | Stock | 17.7 | 17.73 | 17.47 | 17.65 | 110500.0 |
| 2006-08-24 | ABMD-DELISTED | Stock | 13.02 | 13.2 | 12.63 | 13.13 | 175590.0 |
| 2006-08-24 | ABP-DELISTED | Stock | 4.21 | 4.23 | 4.15 | 4.19 | 97100.0 |
| 2006-08-24 | ABR | Stock | 24.67 | 25.07 | 24.65 | 25.02 | 70600.0 |
| 2006-08-24 | ABT | Stock | 23.4286 | 23.6349 | 23.395 | 23.4238 | 9727595.0 |
| 2006-08-24 | ABTL-DELISTED | Stock | 14.509 | 14.809 | 14.209 | 14.491 | 28072.0 |
| 2006-08-24 | ABV-DELISTED | Stock | 42.87 | 43.28 | 42.33 | 43.07 | 503700.0 |
| 2006-08-24 | ABVA-DELISTED | Stock | 16.41 | 16.83 | 15.61 | 16.5 | 13771.0 |
| 2006-08-24 | ABX-DELISTED | Stock | 33.52 | 33.81 | 32.63 | 32.83 | 2594168.0 |
| 2006-08-24 | ACAD | Stock | 7.75 | 8.2 | 7.75 | 8.15 | 252900.0 |
| 2006-08-24 | ACAP-DELISTED | Stock | 49.0 | 49.05 | 47.81 | 47.99 | 20716.0 |
| 2006-08-24 | ACAS-DELISTED | Stock | 37.72 | 37.88 | 37.57 | 37.77 | 657102.0 |
| 2006-08-24 | ACAT-DELISTED | Stock | 17.71 | 17.71 | 17.02 | 17.15 | 77287.0 |
| 2006-08-24 | ACC-DELISTED | Stock | 25.16 | 25.3 | 25.1 | 25.26 | 74600.0 |
| 2006-08-24 | ACCL-DELISTED | Stock | 6.02 | 6.1 | 5.96 | 6.07 | 24504.0 |
| 2006-08-24 | ACCO | Stock | 20.96 | 21.2 | 20.66 | 20.82 | 128900.0 |
> showing 50 of 4,466 rows — these rows as CSV