PREVIEW / stock_daily / 2008-12-18
file: by_date/stock_daily/2008/2008-12-18.parquet size: 177 KB rows: 5,799 symbols: 3,478
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-12-18 | AAPL | Stock | 3.1896 | 3.2439 | 3.1586 | 3.1939 | 857416000.0 |
| 2008-12-18 | MSFT | Stock | 19.86 | 20.02 | 18.99 | 19.3 | 80759200.0 |
| 2008-12-18 | NVDA | Stock | 0.2315 | 0.2322 | 0.2088 | 0.2115 | 550808000.0 |
| 2008-12-18 | AMZN | Stock | 2.65 | 2.7425 | 2.56 | 2.604 | 150362000.0 |
| 2008-12-18 | TLT | Stock | 120.74 | 123.15 | 120.45 | 122.13 | 4441969.0 |
| 2008-12-18 | CL | Stock | 31.35 | 32.5 | 31.26 | 31.96 | 10490000.0 |
| 2008-12-18 | A | Stock | 11.7525 | 11.9599 | 11.495 | 11.6452 | 15649072.0 |
| 2008-12-18 | AABA-DELISTED | Stock | 13.1301 | 13.27 | 12.7 | 12.77 | 14761601.0 |
| 2008-12-18 | AACC-DELISTED | Stock | 5.89 | 6.25 | 5.84 | 6.0 | 282344.0 |
| 2008-12-18 | AACG | Stock | 5.23 | 5.3 | 5.16 | 5.27 | 14300.0 |
| 2008-12-18 | AAI-DELISTED | Stock | 4.0 | 4.25 | 4.0 | 4.13 | 3438718.0 |
| 2008-12-18 | AAIC-DELISTED | Stock | 3.0 | 3.8 | 2.82 | 3.2 | 1217155.0 |
| 2008-12-18 | AAON | Stock | 3.9388 | 3.9862 | 3.7886 | 3.8123 | 643444.0 |
| 2008-12-18 | AAP | Stock | 33.23 | 33.79 | 33.07 | 33.74 | 1611800.0 |
| 2008-12-18 | AATI-DELISTED | Stock | 2.59 | 2.83 | 2.515 | 2.73 | 337942.0 |
| 2008-12-18 | AAU-DELISTED | Stock | 0.64 | 0.75 | 0.59 | 0.59 | 71633.0 |
| 2008-12-18 | AAUAF-DELISTED | Stock | 0.64 | 0.75 | 0.59 | 0.59 | 72563.0 |
| 2008-12-18 | AAV-DELISTED | Stock | 4.15 | 4.18 | 3.88 | 3.94 | 1481457.0 |
| 2008-12-18 | AAWW-DELISTED | Stock | 16.53 | 16.74 | 14.77 | 14.93 | 266879.0 |
| 2008-12-18 | AAXJ | Stock | 35.66 | 35.66 | 33.5 | 34.44 | 306489.0 |
| 2008-12-18 | AAXN-DELISTED | Stock | 4.77 | 5.04 | 4.45 | 4.57 | 745670.0 |
| 2008-12-18 | AB | Stock | 20.13 | 20.13 | 18.29 | 19.14 | 534500.0 |
| 2008-12-18 | ABAX-DELISTED | Stock | 16.39 | 16.39 | 15.35 | 15.73 | 145127.0 |
| 2008-12-18 | ABB-DELISTED | Stock | 15.12 | 15.12 | 14.3 | 14.49 | 5482291.0 |
| 2008-12-18 | ABBC-DELISTED | Stock | 9.91 | 9.91 | 9.5 | 9.6 | 65222.0 |
| 2008-12-18 | ABBNY-DELISTED | Stock | 15.12 | 15.12 | 14.3 | 14.44 | 5482491.0 |
| 2008-12-18 | ABC-DELISTED | Stock | 17.09 | 17.43 | 16.86 | 17.08 | 4240706.0 |
| 2008-12-18 | ABCB | Stock | 10.6893 | 11.02 | 10.4948 | 10.7769 | 25395.0 |
| 2008-12-18 | ABCO-DELISTED | Stock | 11.195 | 11.47 | 11.06 | 11.275 | 381652.0 |
| 2008-12-18 | ABCW-DELISTED | Stock | 1.93 | 2.0 | 1.79 | 1.81 | 170790.0 |
| 2008-12-18 | ABD-DELISTED | Stock | 2.53 | 2.97 | 2.53 | 2.76 | 288370.0 |
| 2008-12-18 | ABE-DELISTED | Stock | 13.1 | 13.37 | 12.8 | 13.0 | 71240.0 |
| 2008-12-18 | ABEO | Stock | 1187.5 | 1250.0 | 1087.5 | 1250.0 | 20.0 |
| 2008-12-18 | ABFS-DELISTED | Stock | 26.7 | 27.44 | 25.58 | 25.98 | 422222.0 |
| 2008-12-18 | ABG | Stock | 4.86 | 5.0 | 4.09 | 4.45 | 466300.0 |
| 2008-12-18 | ABII-DELISTED | Stock | 66.81 | 67.2 | 64.17 | 65.62 | 20965.0 |
| 2008-12-18 | ABK-DELISTED | Stock | 1.37 | 1.46 | 1.25 | 1.29 | 8413450.0 |
| 2008-12-18 | ABM | Stock | 17.95 | 18.23 | 17.23 | 17.83 | 322800.0 |
| 2008-12-18 | ABMD-DELISTED | Stock | 16.78 | 17.31 | 16.48 | 16.8 | 214166.0 |
| 2008-12-18 | ABR | Stock | 2.68 | 2.9 | 2.55 | 2.72 | 160800.0 |
| 2008-12-18 | ABT | Stock | 25.1175 | 25.4774 | 24.6137 | 24.9448 | 19165486.0 |
| 2008-12-18 | ABTL-DELISTED | Stock | 1.9 | 2.0495 | 1.8 | 1.95 | 58377.0 |
| 2008-12-18 | ABV-DELISTED | Stock | 45.66 | 46.51 | 43.9 | 44.3 | 982489.0 |
| 2008-12-18 | ABVA-DELISTED | Stock | 2.05 | 2.06 | 1.89 | 1.89 | 2702.0 |
| 2008-12-18 | ABX-DELISTED | Stock | 35.11 | 35.22 | 32.51 | 33.28 | 19743116.0 |
| 2008-12-18 | ACAD | Stock | 1.1 | 1.1 | 0.92 | 0.97 | 252400.0 |
| 2008-12-18 | ACAP-DELISTED | Stock | 39.51 | 40.4 | 37.02 | 37.96 | 56876.0 |
| 2008-12-18 | ACAS-DELISTED | Stock | 3.07 | 3.34 | 3.0501 | 3.1 | 4060982.0 |
| 2008-12-18 | ACAT-DELISTED | Stock | 5.71 | 5.73 | 5.32 | 5.43 | 30458.0 |
| 2008-12-18 | ACC-DELISTED | Stock | 22.29 | 22.96 | 21.61 | 22.04 | 944865.0 |
> showing 50 of 5,799 rows — these rows as CSV