PREVIEW / stock_daily / 2008-10-28
file: by_date/stock_daily/2008/2008-10-28.parquet size: 177 KB rows: 5,814 symbols: 3,499
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-10-28 | AAPL | Stock | 3.4082 | 3.5893 | 3.2989 | 3.5682 | 1634133200.0 |
| 2008-10-28 | MSFT | Stock | 21.64 | 23.21 | 21.34 | 23.1 | 134088800.0 |
| 2008-10-28 | NVDA | Stock | 0.1835 | 0.2007 | 0.1803 | 0.2005 | 849920000.0 |
| 2008-10-28 | AMZN | Stock | 2.575 | 2.815 | 2.4535 | 2.802 | 296694000.0 |
| 2008-10-28 | TLT | Stock | 96.18 | 96.9 | 95.15 | 95.39 | 1505478.0 |
| 2008-10-28 | CL | Stock | 27.86 | 30.06 | 27.765 | 29.96 | 12468000.0 |
| 2008-10-28 | A | Stock | 13.8197 | 15.1288 | 13.5551 | 15.1288 | 4767320.0 |
| 2008-10-28 | AABA-DELISTED | Stock | 11.93 | 12.4 | 11.25 | 12.37 | 22346287.0 |
| 2008-10-28 | AACC-DELISTED | Stock | 7.67 | 7.9 | 6.92 | 7.6 | 142793.0 |
| 2008-10-28 | AACG | Stock | 8.17 | 8.29 | 8.05 | 8.29 | 4000.0 |
| 2008-10-28 | AAI-DELISTED | Stock | 3.35 | 3.4 | 3.2 | 3.4 | 3952560.0 |
| 2008-10-28 | AAIC-DELISTED | Stock | 7.6 | 10.2 | 7.6 | 10.2 | 538856.0 |
| 2008-10-28 | AAME | Stock | 1.01 | 1.01 | 0.95 | 0.95 | 6200.0 |
| 2008-10-28 | AAON | Stock | 2.6015 | 3.0242 | 2.5877 | 3.0044 | 506756.0 |
| 2008-10-28 | AAP | Stock | 25.0 | 26.45 | 24.36 | 26.45 | 1850300.0 |
| 2008-10-28 | AATI-DELISTED | Stock | 2.5 | 2.8 | 2.31 | 2.75 | 408723.0 |
| 2008-10-28 | AAU-DELISTED | Stock | 0.46 | 0.5 | 0.46 | 0.5 | 52538.0 |
| 2008-10-28 | AAUAF-DELISTED | Stock | 0.4601 | 0.5 | 0.4601 | 0.5 | 52638.0 |
| 2008-10-28 | AAV-DELISTED | Stock | 5.64 | 5.82 | 5.28 | 5.67 | 1203084.0 |
| 2008-10-28 | AAWW-DELISTED | Stock | 19.53 | 20.3 | 18.04 | 18.97 | 389955.0 |
| 2008-10-28 | AAXJ | Stock | 27.63 | 29.9 | 26.67 | 29.9 | 145464.0 |
| 2008-10-28 | AAXN-DELISTED | Stock | 4.46 | 4.5 | 3.97 | 4.24 | 910543.0 |
| 2008-10-28 | AB | Stock | 18.5 | 19.82 | 17.82 | 19.63 | 697500.0 |
| 2008-10-28 | ABAX-DELISTED | Stock | 10.7 | 12.25 | 10.7 | 12.12 | 1057974.0 |
| 2008-10-28 | ABB-DELISTED | Stock | 10.45 | 11.3 | 10.12 | 11.25 | 20866299.0 |
| 2008-10-28 | ABBC-DELISTED | Stock | 9.32 | 9.86 | 9.0 | 9.62 | 81727.0 |
| 2008-10-28 | ABBNY-DELISTED | Stock | 10.45 | 11.3 | 10.12 | 11.3 | 21503099.0 |
| 2008-10-28 | ABC-DELISTED | Stock | 15.21 | 15.76 | 14.66 | 15.72 | 5562486.0 |
| 2008-10-28 | ABCB | Stock | 9.9307 | 10.1739 | 9.4833 | 10.0279 | 45752.0 |
| 2008-10-28 | ABCO-DELISTED | Stock | 11.23 | 11.824 | 10.671 | 11.34 | 491138.0 |
| 2008-10-28 | ABCW-DELISTED | Stock | 4.8251 | 4.9649 | 4.4455 | 4.9649 | 343140.0 |
| 2008-10-28 | ABD-DELISTED | Stock | 2.6669 | 2.6867 | 2.3509 | 2.42 | 1100760.0 |
| 2008-10-28 | ABE-DELISTED | Stock | 11.0 | 11.9 | 10.45 | 11.85 | 41340.0 |
| 2008-10-28 | ABEO | Stock | 2537.5 | 2625.0 | 2412.5 | 2412.5 | 6.0 |
| 2008-10-28 | ABFS-DELISTED | Stock | 27.13 | 27.22 | 24.37 | 26.93 | 841346.0 |
| 2008-10-28 | ABG | Stock | 2.11 | 2.32 | 2.05 | 2.3 | 635200.0 |
| 2008-10-28 | ABII-DELISTED | Stock | 61.25 | 64.59 | 60.8 | 64.59 | 16821.0 |
| 2008-10-28 | ABK-DELISTED | Stock | 2.39 | 2.51 | 2.02 | 2.28 | 19437374.0 |
| 2008-10-28 | ABM | Stock | 13.5 | 14.32 | 13.15 | 14.3 | 361700.0 |
| 2008-10-28 | ABMD-DELISTED | Stock | 10.94 | 11.39 | 10.65 | 11.25 | 430696.0 |
| 2008-10-28 | ABR | Stock | 3.9 | 4.19 | 2.87 | 3.99 | 693800.0 |
| 2008-10-28 | ABT | Stock | 26.0339 | 26.5425 | 25.0072 | 26.389 | 27886828.0 |
| 2008-10-28 | ABTL-DELISTED | Stock | 3.0529 | 3.0969 | 2.7472 | 2.8971 | 6095.0 |
| 2008-10-28 | ABV-DELISTED | Stock | 40.67 | 44.97 | 39.85 | 44.97 | 2197133.0 |
| 2008-10-28 | ABVA-DELISTED | Stock | 3.28 | 3.59 | 2.61 | 3.57 | 4192.0 |
| 2008-10-28 | ABX-DELISTED | Stock | 18.887 | 20.48 | 18.013 | 20.37 | 16407004.0 |
| 2008-10-28 | ACAD | Stock | 1.45 | 1.7 | 1.33 | 1.65 | 372100.0 |
| 2008-10-28 | ACAP-DELISTED | Stock | 35.56 | 38.0 | 34.11 | 38.0 | 102597.0 |
| 2008-10-28 | ACAS-DELISTED | Stock | 10.58 | 13.37 | 9.97 | 12.88 | 5263636.0 |
| 2008-10-28 | ACAT-DELISTED | Stock | 6.46 | 6.52 | 6.07 | 6.26 | 69121.0 |
> showing 50 of 5,814 rows — these rows as CSV