PREVIEW / etf_daily / 2007-08-13
file: by_date/etf_daily/2007/2007-08-13.parquet size: 23 KB rows: 496
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-13 | SPY | ETF | 146.5 | 146.89 | 145.02 | 145.23 | 181917200.0 |
| 2007-08-13 | QQQ | ETF | 47.68 | 47.88 | 47.48 | 47.6 | 116961168.0 |
| 2007-08-13 | IWM | ETF | 79.39 | 79.96 | 77.53 | 77.64 | 116492000.0 |
| 2007-08-13 | DIA | ETF | 133.24 | 133.44 | 132.15 | 132.18 | 17085800.0 |
| 2007-08-13 | GLD | ETF | 66.45 | 66.52 | 66.18 | 66.26 | 3644000.0 |
| 2007-08-13 | TLT | ETF | 85.92 | 86.4 | 85.9 | 86.33 | 1312600.0 |
| 2007-08-13 | ADRE | ETF | 44.81 | 45.93 | 44.09 | 44.13 | 325505.0 |
| 2007-08-13 | AGG | ETF | 98.04 | 98.49 | 98.04 | 98.33 | 220200.0 |
| 2007-08-13 | AIQ | ETF | 39.25 | 45.35 | 39.25 | 44.2 | 115380.0 |
| 2007-08-13 | AIS | ETF | 1.33 | 1.41 | 1.25 | 1.28 | 952800.0 |
| 2007-08-13 | ARB | ETF | 53.37 | 53.46 | 50.15 | 51.63 | 615100.0 |
| 2007-08-13 | BBH | ETF | 53.85 | 54.2733 | 53.6767 | 54.0667 | 1180200.0 |
| 2007-08-13 | BIL | ETF | 91.76 | 91.8 | 91.74 | 91.78 | 71800.0 |
| 2007-08-13 | BITS | ETF | 26.72 | 27.68 | 26.48 | 26.88 | 13365.0 |
| 2007-08-13 | BIV | ETF | 74.16 | 74.37 | 73.88 | 74.37 | 6400.0 |
| 2007-08-13 | BLV | ETF | 72.75 | 73.15 | 72.75 | 72.99 | 53400.0 |
| 2007-08-13 | BMVP | ETF | 16.6633 | 16.7767 | 16.54 | 16.54 | 51900.0 |
| 2007-08-13 | BND | ETF | 74.26 | 74.52 | 74.25 | 74.46 | 354100.0 |
| 2007-08-13 | BNE | ETF | 16.24 | 17.36 | 16.12 | 17.1 | 660100.0 |
| 2007-08-13 | BRF | ETF | 14.4501 | 14.46 | 14.4501 | 14.46 | 1400.0 |
| 2007-08-13 | BSV | ETF | 75.16 | 75.31 | 75.14 | 75.24 | 31100.0 |
| 2007-08-13 | BTF | ETF | 104.0 | 104.35 | 102.69999999999999 | 103.14949999999999 | 2140.0 |
| 2007-08-13 | CBON | ETF | 23.75 | 24.27 | 23.54 | 23.63 | 66312.0 |
| 2007-08-13 | CDL | ETF | 4.95 | 5.17 | 4.79 | 4.81 | 3158800.0 |
| 2007-08-13 | CEF | ETF | 9.4 | 9.4 | 9.27 | 9.38 | 370500.0 |
| 2007-08-13 | CGO | ETF | 16.19 | 16.27 | 15.95 | 16.11 | 23200.0 |
| 2007-08-13 | CGW | ETF | 24.44 | 24.6 | 24.1101 | 24.1101 | 107200.0 |
| 2007-08-13 | CHB | ETF | 11.62 | 11.83 | 10.93 | 11.09 | 1871500.0 |
| 2007-08-13 | CHI | ETF | 16.41 | 16.95 | 16.41 | 16.75 | 196500.0 |
| 2007-08-13 | CHIC | ETF | 17.23 | 18.07 | 17.01 | 17.21 | 1167105.0 |
| 2007-08-13 | CHW | ETF | 13.95 | 14.1 | 13.44 | 13.7 | 74100.0 |
| 2007-08-13 | CHY | ETF | 14.08 | 14.52 | 14.05 | 14.11 | 203000.0 |
| 2007-08-13 | CN | ETF | 48.7 | 49.03 | 48.37 | 48.37 | 154400.0 |
| 2007-08-13 | CNXT | ETF | 1.26 | 1.29 | 1.24 | 1.28 | 7559254.0 |
| 2007-08-13 | CPI | ETF | 28.2 | 28.356 | 28.2 | 28.356 | 300.0 |
| 2007-08-13 | CPST | ETF | 1.08 | 1.1 | 1.02 | 1.03 | 1219061.0 |
| 2007-08-13 | CSA | ETF | 16.95 | 17.06 | 16.24 | 16.24 | 44200.0 |
| 2007-08-13 | CSD | ETF | 28.98 | 29.08 | 28.81 | 28.81 | 5700.0 |
| 2007-08-13 | CSQ | ETF | 13.95 | 14.15 | 13.76 | 13.92 | 363700.0 |
| 2007-08-13 | CTEC | ETF | 100.0 | 104.8 | 100.0 | 102.3 | 36876.8 |
| 2007-08-13 | CVY | ETF | 25.76 | 25.78 | 25.51 | 25.55 | 18000.0 |
| 2007-08-13 | CWI | ETF | 26.4133 | 26.4133 | 26.22 | 26.22 | 41250.0 |
| 2007-08-13 | CZA | ETF | 25.56 | 25.56 | 25.56 | 25.56 | 1400.0 |
| 2007-08-13 | DBA | ETF | 26.46 | 26.56 | 26.27 | 26.43 | 196000.0 |
| 2007-08-13 | DBB | ETF | 26.37 | 26.53 | 26.3 | 26.45 | 8800.0 |
| 2007-08-13 | DBC | ETF | 25.66 | 25.7 | 25.28 | 25.35 | 162200.0 |
| 2007-08-13 | DBE | ETF | 28.39 | 28.46 | 27.92 | 27.94 | 9800.0 |
| 2007-08-13 | DBO | ETF | 26.41 | 26.98 | 26.24 | 26.24 | 24400.0 |
| 2007-08-13 | DBP | ETF | 26.19 | 26.19 | 26.0 | 26.04 | 11700.0 |
| 2007-08-13 | DBS | ETF | 25.2 | 25.2 | 25.16 | 25.16 | 300.0 |
> showing 50 of 496 rows — these rows as CSV