PREVIEW / etf_daily / 2007-06-05
file: by_date/etf_daily/2007/2007-06-05.parquet size: 22 KB rows: 479
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-05 | SPY | ETF | 153.74 | 153.9 | 152.86 | 153.49 | 126917900.0 |
| 2007-06-05 | QQQ | ETF | 47.43 | 47.58 | 47.0 | 47.58 | 151176309.0 |
| 2007-06-05 | IWM | ETF | 84.59 | 84.72 | 83.83 | 84.45 | 84623400.0 |
| 2007-06-05 | DIA | ETF | 136.26 | 136.32 | 135.43 | 135.98 | 13404800.0 |
| 2007-06-05 | GLD | ETF | 66.7 | 66.7 | 66.23 | 66.37 | 3728100.0 |
| 2007-06-05 | TLT | ETF | 85.89 | 85.94 | 85.38 | 85.44 | 1145400.0 |
| 2007-06-05 | ADRE | ETF | 45.0 | 45.03 | 44.51 | 44.82 | 200236.0 |
| 2007-06-05 | AGG | ETF | 98.67 | 98.7 | 98.37 | 98.47 | 244800.0 |
| 2007-06-05 | AIQ | ETF | 44.75 | 45.35 | 44.0 | 45.25 | 47520.0 |
| 2007-06-05 | AIS | ETF | 2.15 | 2.15 | 1.97 | 2.06 | 727800.0 |
| 2007-06-05 | ARB | ETF | 52.7 | 52.71 | 52.08 | 52.48 | 128600.0 |
| 2007-06-05 | BBH | ETF | 60.6067 | 60.8133 | 60.43 | 60.59 | 336300.0 |
| 2007-06-05 | BIL | ETF | 91.66 | 91.68 | 91.64 | 91.64 | 3750.0 |
| 2007-06-05 | BITS | ETF | 33.0 | 33.04 | 31.56 | 32.4 | 20610.0 |
| 2007-06-05 | BIV | ETF | 74.05 | 74.07 | 73.94 | 73.94 | 37600.0 |
| 2007-06-05 | BLV | ETF | 73.76 | 73.82 | 73.53 | 73.56 | 11100.0 |
| 2007-06-05 | BMVP | ETF | 18.3 | 18.3 | 18.1767 | 18.2167 | 49900.0 |
| 2007-06-05 | BND | ETF | 74.37 | 74.41 | 74.25 | 74.3 | 37400.0 |
| 2007-06-05 | BNE | ETF | 19.56 | 19.62 | 19.04 | 19.26 | 324900.0 |
| 2007-06-05 | BRF | ETF | 14.55 | 14.55 | 14.53 | 14.53 | 10900.0 |
| 2007-06-05 | BSV | ETF | 74.69 | 74.69 | 74.58 | 74.63 | 33100.0 |
| 2007-06-05 | BTF | ETF | 110.1 | 110.5 | 109.85 | 110.23999999999998 | 1980.0 |
| 2007-06-05 | CBON | ETF | 30.11 | 30.68 | 29.74 | 29.94 | 59240.0 |
| 2007-06-05 | CDL | ETF | 8.52 | 8.52 | 8.27 | 8.36 | 1767400.0 |
| 2007-06-05 | CEF | ETF | 9.29 | 9.3 | 9.21 | 9.27 | 174800.0 |
| 2007-06-05 | CGO | ETF | 18.19 | 18.23 | 18.03 | 18.08 | 22700.0 |
| 2007-06-05 | CGW | ETF | 25.89 | 26.0 | 25.6976 | 25.71 | 421600.0 |
| 2007-06-05 | CHB | ETF | 11.25 | 11.25 | 10.78 | 10.92 | 1455600.0 |
| 2007-06-05 | CHI | ETF | 20.25 | 20.33 | 20.24 | 20.2801 | 69400.0 |
| 2007-06-05 | CHIC | ETF | 29.01 | 29.08 | 28.65 | 28.89 | 668928.0 |
| 2007-06-05 | CHY | ETF | 17.11 | 17.23 | 17.11 | 17.2 | 92500.0 |
| 2007-06-05 | CN | ETF | 51.41 | 51.64 | 50.74 | 50.81 | 62800.0 |
| 2007-06-05 | CNXT | ETF | 1.29 | 1.29 | 1.23 | 1.25 | 7424516.0 |
| 2007-06-05 | CPI | ETF | 23.7 | 23.7 | 23.7 | 23.7 | 20100.0 |
| 2007-06-05 | CPST | ETF | 1.04 | 1.05 | 1.0 | 1.04 | 1871923.0 |
| 2007-06-05 | CSA | ETF | 21.11 | 21.11 | 20.36 | 20.45 | 27700.0 |
| 2007-06-05 | CSB | ETF | 32.6 | 32.65 | 32.48 | 32.59 | 19900.0 |
| 2007-06-05 | CSD | ETF | 31.25 | 31.25 | 30.98 | 31.21 | 41200.0 |
| 2007-06-05 | CSM | ETF | 1.4025 | 1.4375 | 1.4025 | 1.4375 | 6000.0 |
| 2007-06-05 | CSQ | ETF | 15.63 | 15.67 | 15.55 | 15.65 | 350000.0 |
| 2007-06-05 | CTEC | ETF | 96.64999999999999 | 98.49999999999999 | 95.44999999999999 | 97.24999999999999 | 259410.40000000002 |
| 2007-06-05 | CVY | ETF | 28.49 | 28.55 | 28.33 | 28.4 | 38100.0 |
| 2007-06-05 | CWI | ETF | 27.52 | 27.54 | 27.3333 | 27.44 | 36300.0 |
| 2007-06-05 | CZA | ETF | 27.29 | 27.31 | 27.25 | 27.2619 | 1900.0 |
| 2007-06-05 | DBA | ETF | 26.3 | 26.52 | 26.14 | 26.31 | 154900.0 |
| 2007-06-05 | DBB | ETF | 27.15 | 27.39 | 27.09 | 27.28 | 31400.0 |
| 2007-06-05 | DBC | ETF | 25.76 | 25.9799 | 25.74 | 25.83 | 325000.0 |
| 2007-06-05 | DBE | ETF | 28.42 | 28.54 | 28.32 | 28.39 | 11000.0 |
| 2007-06-05 | DBO | ETF | 26.5 | 26.61 | 26.49 | 26.53 | 1010000.0 |
| 2007-06-05 | DBP | ETF | 26.55 | 26.6 | 26.51 | 26.57 | 2800.0 |
> showing 50 of 479 rows — these rows as CSV