PREVIEW / etf_daily / 2008-09-12
file: by_date/etf_daily/2008/2008-09-12.parquet size: 27 KB rows: 611
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-09-12 | SPY | ETF | 124.29 | 126.21 | 123.83 | 126.09 | 297851200.0 |
| 2008-09-12 | QQQ | ETF | 43.23 | 43.71 | 42.9 | 43.43 | 172094276.0 |
| 2008-09-12 | IWM | ETF | 71.32 | 72.39 | 71.04 | 72.25 | 117705200.0 |
| 2008-09-12 | DIA | ETF | 113.64 | 114.84 | 113.01 | 114.79 | 28275000.0 |
| 2008-09-12 | GLD | ETF | 74.26 | 75.58 | 73.48 | 75.55 | 17595400.0 |
| 2008-09-12 | TLT | ETF | 96.21 | 96.33 | 94.75 | 94.94 | 4138200.0 |
| 2008-09-12 | AAXJ | ETF | 44.11 | 44.12 | 43.79 | 43.79 | 1600.0 |
| 2008-09-12 | ACWI | ETF | 44.25 | 44.85 | 44.07 | 44.73 | 17600.0 |
| 2008-09-12 | ACWX | ETF | 42.13 | 42.962 | 42.03 | 42.894 | 67415.0 |
| 2008-09-12 | ADRE | ETF | 39.47 | 40.85 | 39.26 | 40.69 | 361649.0 |
| 2008-09-12 | AFK | ETF | 35.195 | 35.195 | 35.195 | 35.195 | 100.0 |
| 2008-09-12 | AGG | ETF | 101.7 | 101.72 | 101.0 | 101.21 | 514800.0 |
| 2008-09-12 | AIA | ETF | 36.17 | 36.17 | 34.91 | 35.32 | 50972.0 |
| 2008-09-12 | AIQ | ETF | 58.65 | 58.8 | 57.45 | 58.35 | 20363.0 |
| 2008-09-12 | AIS | ETF | 0.69 | 0.75 | 0.69 | 0.73 | 50695.0 |
| 2008-09-12 | AIVI | ETF | 53.1 | 54.06 | 52.85 | 54.04 | 56400.0 |
| 2008-09-12 | ARB | ETF | 47.9 | 48.68 | 47.53 | 48.24 | 160545.0 |
| 2008-09-12 | BAL | ETF | 40.53 | 40.53 | 40.39 | 40.39 | 4100.0 |
| 2008-09-12 | BBH | ETF | 64.9233 | 65.1 | 64.4467 | 64.7167 | 370800.0 |
| 2008-09-12 | BIL | ETF | 91.76 | 91.82 | 91.74 | 91.8 | 96400.0 |
| 2008-09-12 | BITS | ETF | 22.56 | 22.84 | 22.24 | 22.6 | 500.0 |
| 2008-09-12 | BIV | ETF | 76.98 | 77.29 | 76.65 | 76.84 | 44500.0 |
| 2008-09-12 | BJK | ETF | 27.52 | 27.56 | 27.52 | 27.56 | 300.0 |
| 2008-09-12 | BKF | ETF | 37.6 | 38.66 | 37.1352 | 38.52 | 130116.0 |
| 2008-09-12 | BLV | ETF | 75.8 | 75.8 | 74.86 | 74.95 | 8200.0 |
| 2008-09-12 | BMVP | ETF | 14.44 | 14.66 | 14.41 | 14.61 | 19102.0 |
| 2008-09-12 | BND | ETF | 77.13 | 77.23 | 76.66 | 76.84 | 133700.0 |
| 2008-09-12 | BNE | ETF | 12.18 | 12.47 | 12.05 | 12.23 | 124153.0 |
| 2008-09-12 | BRF | ETF | 14.73 | 14.763 | 14.73 | 14.73 | 6207.0 |
| 2008-09-12 | BSV | ETF | 77.87 | 77.87 | 77.57 | 77.71 | 93200.0 |
| 2008-09-12 | BTF | ETF | 83.3 | 84.1 | 83.3 | 84.1 | 5676.0 |
| 2008-09-12 | BWX | ETF | 25.95 | 26.105 | 25.915 | 26.015 | 372588.0 |
| 2008-09-12 | CBON | ETF | 4.86 | 4.99 | 4.71 | 4.72 | 105208.0 |
| 2008-09-12 | CDL | ETF | 0.86 | 0.9 | 0.86 | 0.88 | 1333687.0 |
| 2008-09-12 | CEF | ETF | 8.76 | 9.45 | 8.76 | 9.44 | 1460500.0 |
| 2008-09-12 | CGO | ETF | 12.8 | 13.12 | 12.76 | 13.09 | 21260.0 |
| 2008-09-12 | CGW | ETF | 20.7 | 21.56 | 20.7 | 21.44 | 777954.0 |
| 2008-09-12 | CHB | ETF | 5.4 | 5.61 | 5.16 | 5.51 | 1177258.0 |
| 2008-09-12 | CHI | ETF | 12.0 | 12.02 | 11.85 | 12.0 | 309258.0 |
| 2008-09-12 | CHIC | ETF | 12.72 | 12.95 | 12.19 | 12.52 | 232774.0 |
| 2008-09-12 | CHW | ETF | 9.43 | 9.59 | 9.3751 | 9.5 | 198987.0 |
| 2008-09-12 | CHY | ETF | 12.02 | 12.05 | 11.84 | 11.93 | 203561.0 |
| 2008-09-12 | CMF | ETF | 51.915 | 51.97 | 51.665 | 51.91 | 3800.0 |
| 2008-09-12 | CN | ETF | 44.04 | 44.88 | 42.44 | 44.81 | 291898.0 |
| 2008-09-12 | CNXT | ETF | 4.89 | 5.1 | 4.82 | 5.05 | 492353.0 |
| 2008-09-12 | COW | ETF | 41.4 | 41.48 | 40.74 | 40.9 | 29534.0 |
| 2008-09-12 | CPI | ETF | 23.4 | 23.4 | 23.4 | 23.4 | 300.0 |
| 2008-09-12 | CPST | ETF | 1.75 | 1.89 | 1.7 | 1.88 | 1860486.0 |
| 2008-09-12 | CSA | ETF | 18.0 | 18.37 | 18.0 | 18.22 | 197912.0 |
| 2008-09-12 | CSB | ETF | 18.73 | 18.73 | 16.974 | 17.0 | 21067.0 |
> showing 50 of 611 rows — these rows as CSV