PREVIEW / stock_daily / 2008-06-27
file: by_date/stock_daily/2008/2008-06-27.parquet size: 185 KB rows: 5,747 symbols: 3,483
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-27 | AAPL | Stock | 5.9468 | 6.0918 | 5.8625 | 6.0746 | 1042249600.0 |
| 2008-06-27 | MSFT | Stock | 27.68 | 27.91 | 27.46 | 27.63 | 73450200.0 |
| 2008-06-27 | NVDA | Stock | 0.4788 | 0.4848 | 0.4678 | 0.482 | 584140000.0 |
| 2008-06-27 | AMZN | Stock | 3.7795 | 3.8035 | 3.631 | 3.733 | 236810000.0 |
| 2008-06-27 | TLT | Stock | 91.73 | 92.44 | 91.45 | 92.32 | 4144761.0 |
| 2008-06-27 | CL | Stock | 34.575 | 34.795 | 34.005 | 34.105 | 6826200.0 |
| 2008-06-27 | A | Stock | 25.4649 | 25.7296 | 25.3076 | 25.4578 | 5015325.0 |
| 2008-06-27 | AABA-DELISTED | Stock | 21.29 | 21.46 | 20.7 | 21.3 | 28569566.0 |
| 2008-06-27 | AACC-DELISTED | Stock | 12.5 | 12.96 | 12.14 | 12.41 | 438515.0 |
| 2008-06-27 | AACG | Stock | 14.23 | 14.31 | 14.04 | 14.15 | 14300.0 |
| 2008-06-27 | AAI-DELISTED | Stock | 2.23 | 2.23 | 2.07 | 2.11 | 4415888.0 |
| 2008-06-27 | AAIC-DELISTED | Stock | 33.8 | 35.0 | 31.2 | 31.4 | 1333367.0 |
| 2008-06-27 | AAME | Stock | 2.1 | 2.1 | 1.73 | 1.73 | 6000.0 |
| 2008-06-27 | AAON | Stock | 3.7353 | 3.921 | 3.7175 | 3.8281 | 1038825.0 |
| 2008-06-27 | AAP | Stock | 39.66 | 40.28 | 38.76 | 39.4 | 1498200.0 |
| 2008-06-27 | AATI-DELISTED | Stock | 4.45 | 4.5 | 4.11 | 4.23 | 2217430.0 |
| 2008-06-27 | AAU-DELISTED | Stock | 1.8 | 1.9 | 1.8 | 1.88 | 63064.0 |
| 2008-06-27 | AAUAF-DELISTED | Stock | 1.8 | 1.8999 | 1.8 | 1.88 | 65164.0 |
| 2008-06-27 | AAV-DELISTED | Stock | 12.55 | 12.92 | 12.55 | 12.9 | 477868.0 |
| 2008-06-27 | AAWW-DELISTED | Stock | 51.63 | 52.21 | 50.25 | 50.27 | 254872.0 |
| 2008-06-27 | AAXN-DELISTED | Stock | 5.09 | 5.1 | 4.95 | 5.04 | 1484090.0 |
| 2008-06-27 | AB | Stock | 57.35 | 57.51 | 55.52 | 56.92 | 462800.0 |
| 2008-06-27 | ABAX-DELISTED | Stock | 27.3 | 27.3 | 24.48 | 24.56 | 1250298.0 |
| 2008-06-27 | ABB-DELISTED | Stock | 28.42 | 28.96 | 28.29 | 28.81 | 4738633.0 |
| 2008-06-27 | ABBC-DELISTED | Stock | 9.47 | 9.63 | 9.15 | 9.6 | 1645189.0 |
| 2008-06-27 | ABBNY-DELISTED | Stock | 28.42 | 28.96 | 28.29 | 28.77 | 4901633.0 |
| 2008-06-27 | ABC-DELISTED | Stock | 19.64 | 19.77 | 19.48 | 19.55 | 3386870.0 |
| 2008-06-27 | ABCB | Stock | 9.7361 | 9.8723 | 8.355 | 8.6371 | 521775.0 |
| 2008-06-27 | ABCO-DELISTED | Stock | 19.992 | 20.05 | 19.578 | 19.693 | 398142.0 |
| 2008-06-27 | ABCW-DELISTED | Stock | 7.89 | 8.358 | 7.501 | 7.58 | 646500.0 |
| 2008-06-27 | ABD-DELISTED | Stock | 11.83 | 11.83 | 11.26 | 11.43 | 671590.0 |
| 2008-06-27 | ABE-DELISTED | Stock | 20.52 | 20.52 | 19.94 | 20.36 | 21353.0 |
| 2008-06-27 | ABEO | Stock | 3412.5 | 3437.5 | 3412.5 | 3437.5 | 1.0 |
| 2008-06-27 | ABFS-DELISTED | Stock | 37.15 | 37.35 | 35.86 | 36.85 | 796282.0 |
| 2008-06-27 | ABG | Stock | 13.26 | 13.5 | 12.92 | 13.29 | 749300.0 |
| 2008-06-27 | ABII-DELISTED | Stock | 61.72 | 64.77 | 61.595 | 63.43 | 34483.0 |
| 2008-06-27 | ABK-DELISTED | Stock | 1.85 | 1.88 | 1.55 | 1.56 | 33883648.0 |
| 2008-06-27 | ABM | Stock | 22.75 | 22.93 | 22.2 | 22.3 | 485600.0 |
| 2008-06-27 | ABMD-DELISTED | Stock | 18.21 | 18.42 | 17.92 | 18.24 | 577335.0 |
| 2008-06-27 | ABP-DELISTED | Stock | 4.91 | 5.02 | 4.75 | 5.02 | 3201586.0 |
| 2008-06-27 | ABR | Stock | 9.61 | 9.95 | 9.51 | 9.78 | 938400.0 |
| 2008-06-27 | ABT | Stock | 25.2807 | 25.5973 | 25.2183 | 25.4294 | 15937266.0 |
| 2008-06-27 | ABTL-DELISTED | Stock | 6.9381 | 7.733 | 6.8852 | 7.15 | 12966.0 |
| 2008-06-27 | ABV-DELISTED | Stock | 63.8 | 64.61 | 63.1 | 63.32 | 325582.0 |
| 2008-06-27 | ABVA-DELISTED | Stock | 3.59 | 3.63 | 3.58 | 3.6 | 22454.0 |
| 2008-06-27 | ABVT-DELISTED | Stock | 60.0 | 60.0 | 60.0 | 60.0 | 150.0 |
| 2008-06-27 | ABX-DELISTED | Stock | 43.96 | 45.68 | 43.7 | 44.95 | 14734569.0 |
| 2008-06-27 | ACAD | Stock | 3.87 | 4.0 | 3.81 | 3.82 | 992200.0 |
| 2008-06-27 | ACAP-DELISTED | Stock | 48.79 | 49.75 | 48.45 | 49.19 | 150729.0 |
| 2008-06-27 | ACAS-DELISTED | Stock | 25.6 | 25.81 | 24.89 | 24.97 | 3807885.0 |
> showing 50 of 5,747 rows — these rows as CSV