PREVIEW / etf_daily / 2007-08-31
file: by_date/etf_daily/2007/2007-08-31.parquet size: 23 KB rows: 494
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-08-31 | SPY | ETF | 147.65 | 148.5 | 146.83 | 147.59 | 185477500.0 |
| 2007-08-31 | QQQ | ETF | 48.86 | 49.06 | 48.61 | 48.87 | 94692123.0 |
| 2007-08-31 | IWM | ETF | 79.14 | 79.33 | 78.31 | 78.74 | 47035900.0 |
| 2007-08-31 | DIA | ETF | 133.56 | 134.25 | 132.9 | 133.4 | 11117600.0 |
| 2007-08-31 | GLD | ETF | 66.61 | 66.77 | 66.46 | 66.52 | 4089900.0 |
| 2007-08-31 | TLT | ETF | 88.59 | 89.2 | 88.54 | 88.88 | 2763200.0 |
| 2007-08-31 | ADRE | ETF | 46.15 | 47.0 | 46.15 | 46.6 | 276663.0 |
| 2007-08-31 | AGG | ETF | 99.7 | 100.09 | 99.52 | 99.82 | 201000.0 |
| 2007-08-31 | AIQ | ETF | 45.75 | 45.8 | 43.3 | 44.05 | 24680.0 |
| 2007-08-31 | AIS | ETF | 1.48 | 1.4899 | 1.43 | 1.46 | 159500.0 |
| 2007-08-31 | ARB | ETF | 49.77 | 50.1 | 49.49 | 49.83 | 178200.0 |
| 2007-08-31 | BBH | ETF | 54.54 | 55.3167 | 54.54 | 54.9433 | 253200.0 |
| 2007-08-31 | BIL | ETF | 91.88 | 91.98 | 91.86 | 91.98 | 9650.0 |
| 2007-08-31 | BITS | ETF | 25.84 | 26.84 | 25.84 | 26.76 | 5213.0 |
| 2007-08-31 | BIV | ETF | 75.35 | 75.68 | 75.28 | 75.67 | 9100.0 |
| 2007-08-31 | BLV | ETF | 74.72 | 75.25 | 74.61 | 75.25 | 3600.0 |
| 2007-08-31 | BMVP | ETF | 16.8733 | 16.9893 | 16.8003 | 16.8733 | 93000.0 |
| 2007-08-31 | BND | ETF | 75.29 | 90.91 | 75.29 | 75.53 | 23600.0 |
| 2007-08-31 | BNE | ETF | 16.96 | 17.0 | 16.76 | 16.95 | 150000.0 |
| 2007-08-31 | BRF | ETF | 14.55 | 14.6 | 14.55 | 14.6 | 2000.0 |
| 2007-08-31 | BSV | ETF | 75.8 | 76.21 | 74.94 | 75.93 | 43300.0 |
| 2007-08-31 | BTF | ETF | 107.14999999999999 | 107.57300000000001 | 107.14999999999999 | 107.35 | 180.0 |
| 2007-08-31 | CBON | ETF | 24.95 | 25.0 | 24.35 | 24.61 | 61595.0 |
| 2007-08-31 | CDL | ETF | 4.06 | 4.12 | 3.98 | 4.07 | 3470900.0 |
| 2007-08-31 | CEF | ETF | 9.12 | 9.21 | 9.11 | 9.12 | 193200.0 |
| 2007-08-31 | CGO | ETF | 17.18 | 17.18 | 16.97 | 16.99 | 10300.0 |
| 2007-08-31 | CGW | ETF | 25.03 | 25.25 | 24.9 | 25.13 | 182000.0 |
| 2007-08-31 | CHB | ETF | 12.0 | 12.0 | 11.41 | 11.55 | 1149100.0 |
| 2007-08-31 | CHI | ETF | 16.27 | 16.59 | 16.23 | 16.57 | 139800.0 |
| 2007-08-31 | CHIC | ETF | 17.29 | 17.5355 | 17.27 | 17.47 | 302852.0 |
| 2007-08-31 | CHW | ETF | 13.99 | 14.0 | 13.71 | 13.72 | 108700.0 |
| 2007-08-31 | CHY | ETF | 14.21 | 14.39 | 14.17 | 14.32 | 178400.0 |
| 2007-08-31 | CN | ETF | 48.31 | 49.49 | 48.29 | 48.95 | 133700.0 |
| 2007-08-31 | CNXT | ETF | 1.1 | 1.12 | 1.08 | 1.12 | 5521805.0 |
| 2007-08-31 | CPI | ETF | 24.5 | 24.8 | 24.2 | 24.2 | 1400.0 |
| 2007-08-31 | CPST | ETF | 1.13 | 1.15 | 1.1 | 1.12 | 847110.0 |
| 2007-08-31 | CSA | ETF | 17.62 | 18.19 | 17.62 | 17.83 | 52700.0 |
| 2007-08-31 | CSD | ETF | 28.76 | 29.02 | 28.72 | 28.97 | 21900.0 |
| 2007-08-31 | CSM | ETF | 1.4425 | 1.4425 | 1.4425 | 1.4425 | 4000.0 |
| 2007-08-31 | CSQ | ETF | 14.4 | 14.4 | 14.24 | 14.36 | 222900.0 |
| 2007-08-31 | CTEC | ETF | 99.39999999999999 | 104.55 | 99.14999999999999 | 103.45 | 36236.4 |
| 2007-08-31 | CVY | ETF | 26.16 | 26.25 | 26.01 | 26.1 | 25100.0 |
| 2007-08-31 | CWI | ETF | 26.8 | 26.94 | 26.7133 | 26.8667 | 47100.0 |
| 2007-08-31 | CZA | ETF | 25.59 | 25.59 | 25.59 | 25.59 | 800.0 |
| 2007-08-31 | DBA | ETF | 27.21 | 27.26 | 26.54 | 26.64 | 189800.0 |
| 2007-08-31 | DBB | ETF | 26.0 | 26.0 | 25.66 | 25.93 | 7600.0 |
| 2007-08-31 | DBC | ETF | 26.0 | 26.0 | 25.55 | 25.69 | 122500.0 |
| 2007-08-31 | DBE | ETF | 28.4 | 28.4 | 28.15 | 28.4 | 10900.0 |
| 2007-08-31 | DBO | ETF | 26.74 | 26.76 | 26.62 | 26.62 | 3000.0 |
| 2007-08-31 | DBP | ETF | 25.81 | 25.9 | 25.78 | 25.82 | 2200.0 |
> showing 50 of 494 rows — these rows as CSV