PREVIEW / etf_daily / 2007-05-16
file: by_date/etf_daily/2007/2007-05-16.parquet size: 22 KB rows: 483
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-05-16 | SPY | ETF | 150.8 | 151.63 | 150.38 | 151.6 | 114166500.0 |
| 2007-05-16 | QQQ | ETF | 46.21 | 46.56 | 45.91 | 46.55 | 144722516.0 |
| 2007-05-16 | IWM | ETF | 81.1 | 81.5 | 80.46 | 81.41 | 95727600.0 |
| 2007-05-16 | DIA | ETF | 134.31 | 135.15 | 133.85 | 135.12 | 14911200.0 |
| 2007-05-16 | GLD | ETF | 66.37 | 66.37 | 65.32 | 65.6 | 7268500.0 |
| 2007-05-16 | TLT | ETF | 87.86 | 88.0 | 87.83 | 87.87 | 599500.0 |
| 2007-05-16 | AAA | ETF | 27.22 | 27.25 | 26.34 | 26.63 | 128200.0 |
| 2007-05-16 | ADRE | ETF | 43.05 | 43.69 | 42.8518 | 43.69 | 152039.0 |
| 2007-05-16 | AGG | ETF | 99.75 | 99.93 | 99.7 | 99.91 | 238800.0 |
| 2007-05-16 | AIQ | ETF | 42.8 | 43.55 | 41.75 | 43.5 | 49820.0 |
| 2007-05-16 | AIS | ETF | 1.82 | 1.85 | 1.77 | 1.77 | 453100.0 |
| 2007-05-16 | ARB | ETF | 48.3 | 48.66 | 47.99 | 48.63 | 88800.0 |
| 2007-05-16 | BAB | ETF | 98.41 | 98.66 | 97.06 | 97.69 | 59000.0 |
| 2007-05-16 | BBH | ETF | 59.3 | 60.02 | 59.3 | 59.87 | 795600.0 |
| 2007-05-16 | BITS | ETF | 31.16 | 31.52 | 30.4 | 30.8 | 9704.0 |
| 2007-05-16 | BIV | ETF | 75.21 | 75.24 | 75.17 | 75.21 | 38300.0 |
| 2007-05-16 | BLV | ETF | 75.23 | 75.28 | 75.23 | 75.23 | 2200.0 |
| 2007-05-16 | BMVP | ETF | 17.95 | 18.0465 | 17.9233 | 18.04 | 26200.0 |
| 2007-05-16 | BND | ETF | 75.2 | 75.27 | 75.17 | 75.23 | 56600.0 |
| 2007-05-16 | BNE | ETF | 18.62 | 19.12 | 18.62 | 18.99 | 258500.0 |
| 2007-05-16 | BRF | ETF | 14.54 | 14.54 | 14.48 | 14.52 | 26100.0 |
| 2007-05-16 | BSV | ETF | 75.22 | 75.24 | 75.18 | 75.2 | 80300.0 |
| 2007-05-16 | BTF | ETF | 110.25 | 111.1 | 110.05 | 111.1 | 3400.0 |
| 2007-05-16 | CBON | ETF | 29.73 | 30.27 | 29.2 | 30.12 | 41726.0 |
| 2007-05-16 | CDL | ETF | 8.3 | 8.39 | 8.21 | 8.24 | 507500.0 |
| 2007-05-16 | CEF | ETF | 9.13 | 9.17 | 9.02 | 9.08 | 234700.0 |
| 2007-05-16 | CGO | ETF | 17.66 | 17.88 | 17.6 | 17.88 | 31400.0 |
| 2007-05-16 | CGW | ETF | 25.15 | 25.43 | 24.7 | 25.08 | 543200.0 |
| 2007-05-16 | CHB | ETF | 11.52 | 11.64 | 11.0 | 11.25 | 2341900.0 |
| 2007-05-16 | CHI | ETF | 20.24 | 20.29 | 20.23 | 20.28 | 69900.0 |
| 2007-05-16 | CHIC | ETF | 24.98 | 25.72 | 24.98 | 25.7 | 431872.0 |
| 2007-05-16 | CHY | ETF | 17.12 | 17.18 | 17.12 | 17.15 | 84000.0 |
| 2007-05-16 | CIL | ETF | 25.94 | 25.9899 | 25.94 | 25.9899 | 200.0 |
| 2007-05-16 | CN | ETF | 48.2 | 49.06 | 48.2 | 48.84 | 93800.0 |
| 2007-05-16 | CNXT | ETF | 1.43 | 1.44 | 1.36 | 1.39 | 12627688.0 |
| 2007-05-16 | CPI | ETF | 23.5 | 23.5 | 23.5 | 23.5 | 100.0 |
| 2007-05-16 | CPST | ETF | 0.9 | 0.92 | 0.88 | 0.9 | 5626183.0 |
| 2007-05-16 | CSA | ETF | 20.72 | 20.91 | 20.64 | 20.76 | 59400.0 |
| 2007-05-16 | CSB | ETF | 31.98 | 32.21 | 31.98 | 32.21 | 25800.0 |
| 2007-05-16 | CSD | ETF | 29.42 | 29.42 | 29.15 | 29.35 | 14800.0 |
| 2007-05-16 | CSM | ETF | 1.4 | 1.4 | 1.4 | 1.4 | 4000.0 |
| 2007-05-16 | CSQ | ETF | 15.53 | 15.56 | 15.43 | 15.56 | 357500.0 |
| 2007-05-16 | CTEC | ETF | 87.24999999999999 | 88.9 | 87.155 | 88.55 | 4624.2 |
| 2007-05-16 | CVY | ETF | 27.94 | 28.0 | 27.9 | 27.98 | 14700.0 |
| 2007-05-16 | CWI | ETF | 26.9 | 26.96 | 26.7667 | 26.96 | 87450.0 |
| 2007-05-16 | CZA | ETF | 26.5 | 26.5045 | 26.47 | 26.5045 | 600.0 |
| 2007-05-16 | DBA | ETF | 25.37 | 25.56 | 25.24 | 25.3 | 190400.0 |
| 2007-05-16 | DBB | ETF | 27.45 | 27.58 | 27.1 | 27.58 | 75300.0 |
| 2007-05-16 | DBC | ETF | 25.41 | 25.41 | 25.06 | 25.26 | 287400.0 |
| 2007-05-16 | DBE | ETF | 27.84 | 28.03 | 27.61 | 28.03 | 44500.0 |
> showing 50 of 483 rows — these rows as CSV