PREVIEW / stock_daily / 2008-11-14
file: by_date/stock_daily/2008/2008-11-14.parquet size: 174 KB rows: 5,709 symbols: 3,419
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-11-14 | AAPL | Stock | 3.3486 | 3.3568 | 3.2143 | 3.2229 | 1405266800.0 |
| 2008-11-14 | MSFT | Stock | 20.56 | 21.34 | 19.65 | 20.06 | 96624500.0 |
| 2008-11-14 | NVDA | Stock | 0.1905 | 0.1915 | 0.1785 | 0.1793 | 741024000.0 |
| 2008-11-14 | AMZN | Stock | 2.1805 | 2.225 | 2.075 | 2.0875 | 238994000.0 |
| 2008-11-14 | TLT | Stock | 95.11 | 95.46 | 94.79 | 95.17 | 1059631.0 |
| 2008-11-14 | CL | Stock | 31.18 | 32.5 | 30.89 | 31.03 | 8332000.0 |
| 2008-11-14 | A | Stock | 14.6853 | 16.0086 | 14.1059 | 14.8426 | 6379913.0 |
| 2008-11-14 | AABA-DELISTED | Stock | 10.82 | 11.5 | 10.63 | 10.79 | 19016707.0 |
| 2008-11-14 | AACC-DELISTED | Stock | 6.54 | 6.86 | 6.06 | 6.06 | 72972.0 |
| 2008-11-14 | AACG | Stock | 4.37 | 5.3 | 4.3 | 4.99 | 44400.0 |
| 2008-11-14 | AAI-DELISTED | Stock | 3.6 | 3.78 | 3.4 | 3.45 | 2153747.0 |
| 2008-11-14 | AAIC-DELISTED | Stock | 10.4 | 10.8 | 9.8 | 10.2 | 307799.0 |
| 2008-11-14 | AAON | Stock | 3.4785 | 3.5556 | 3.2593 | 3.279 | 676350.0 |
| 2008-11-14 | AAP | Stock | 28.22 | 28.48 | 25.89 | 26.04 | 1321600.0 |
| 2008-11-14 | AATI-DELISTED | Stock | 2.84 | 2.843 | 2.66 | 2.77 | 219844.0 |
| 2008-11-14 | AAU-DELISTED | Stock | 0.6 | 0.6 | 0.5 | 0.54 | 19825.0 |
| 2008-11-14 | AAUAF-DELISTED | Stock | 0.6 | 0.6 | 0.5 | 0.54 | 20825.0 |
| 2008-11-14 | AAV-DELISTED | Stock | 5.52 | 5.52 | 5.1 | 5.18 | 766642.0 |
| 2008-11-14 | AAWW-DELISTED | Stock | 17.47 | 17.98 | 15.84 | 15.87 | 228686.0 |
| 2008-11-14 | AAXJ | Stock | 31.2 | 32.9 | 30.2 | 30.45 | 575089.0 |
| 2008-11-14 | AAXN-DELISTED | Stock | 3.89 | 4.04 | 3.77 | 3.77 | 469126.0 |
| 2008-11-14 | AB | Stock | 18.3 | 19.52 | 17.41 | 17.7 | 410000.0 |
| 2008-11-14 | ABAX-DELISTED | Stock | 13.98 | 15.33 | 13.95 | 14.51 | 353840.0 |
| 2008-11-14 | ABB-DELISTED | Stock | 11.26 | 11.57 | 10.81 | 10.9 | 7576220.0 |
| 2008-11-14 | ABBC-DELISTED | Stock | 10.25 | 10.25 | 9.83 | 9.83 | 64493.0 |
| 2008-11-14 | ABBNY-DELISTED | Stock | 11.26 | 11.57 | 10.81 | 10.87 | 7659395.0 |
| 2008-11-14 | ABC-DELISTED | Stock | 14.94 | 15.6 | 14.42 | 15.0 | 5911228.0 |
| 2008-11-14 | ABCB | Stock | 8.9289 | 9.5805 | 8.2675 | 8.4522 | 25703.0 |
| 2008-11-14 | ABCO-DELISTED | Stock | 10.865 | 11.355 | 10.715 | 10.755 | 307205.0 |
| 2008-11-14 | ABCW-DELISTED | Stock | 4.34 | 4.43 | 3.8098 | 3.85 | 105800.0 |
| 2008-11-14 | ABD-DELISTED | Stock | 1.4 | 1.43 | 1.14 | 1.15 | 843870.0 |
| 2008-11-14 | ABE-DELISTED | Stock | 12.2 | 12.2 | 11.29 | 11.75 | 48805.0 |
| 2008-11-14 | ABEO | Stock | 1750.0 | 1812.5 | 1750.0 | 1812.5 | 2.0 |
| 2008-11-14 | ABFS-DELISTED | Stock | 25.51 | 25.825 | 23.86 | 23.96 | 386389.0 |
| 2008-11-14 | ABG | Stock | 3.18 | 3.78 | 3.0 | 3.72 | 979900.0 |
| 2008-11-14 | ABII-DELISTED | Stock | 59.92 | 60.25 | 59.53 | 60.0 | 17266.0 |
| 2008-11-14 | ABK-DELISTED | Stock | 1.37 | 1.46 | 1.3 | 1.35 | 12278286.0 |
| 2008-11-14 | ABM | Stock | 15.48 | 15.98 | 14.48 | 14.5 | 237200.0 |
| 2008-11-14 | ABMD-DELISTED | Stock | 14.89 | 15.38 | 13.93 | 13.97 | 168605.0 |
| 2008-11-14 | ABR | Stock | 4.24 | 4.24 | 3.67 | 3.9 | 233400.0 |
| 2008-11-14 | ABT | Stock | 27.0079 | 27.5069 | 26.3602 | 26.4178 | 16764068.0 |
| 2008-11-14 | ABTL-DELISTED | Stock | 3.5 | 3.5 | 3.15 | 3.15 | 4328.0 |
| 2008-11-14 | ABV-DELISTED | Stock | 47.12 | 50.0 | 46.34 | 46.54 | 1657073.0 |
| 2008-11-14 | ABVA-DELISTED | Stock | 3.05 | 3.44 | 3.05 | 3.44 | 4130.0 |
| 2008-11-14 | ABX-DELISTED | Stock | 23.81 | 24.61 | 22.21 | 22.22 | 14536327.0 |
| 2008-11-14 | ACAD | Stock | 1.66 | 1.83 | 1.43 | 1.43 | 42700.0 |
| 2008-11-14 | ACAP-DELISTED | Stock | 40.7 | 41.35 | 37.82 | 38.06 | 59902.0 |
| 2008-11-14 | ACAS-DELISTED | Stock | 6.24 | 6.9 | 6.11 | 6.31 | 4277334.0 |
| 2008-11-14 | ACAT-DELISTED | Stock | 6.69 | 6.88 | 6.24 | 6.24 | 17294.0 |
| 2008-11-14 | ACC-DELISTED | Stock | 22.6 | 23.13 | 21.28 | 21.36 | 433449.0 |
> showing 50 of 5,709 rows — these rows as CSV