PREVIEW / etf_daily / 2007-05-23
file: by_date/etf_daily/2007/2007-05-23.parquet size: 22 KB rows: 482
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-23 | SPY | ETF | 152.95 | 153.5 | 152.36 | 152.44 | 133786600.0 |
| 2007-05-23 | QQQ | ETF | 47.19 | 47.37 | 46.8 | 46.83 | 119434425.0 |
| 2007-05-23 | IWM | ETF | 83.55 | 84.1 | 82.97 | 83.05 | 59384400.0 |
| 2007-05-23 | DIA | ETF | 135.56 | 135.99 | 134.94 | 135.2 | 10997000.0 |
| 2007-05-23 | GLD | ETF | 65.52 | 65.89 | 65.45 | 65.54 | 6441800.0 |
| 2007-05-23 | TLT | ETF | 86.84 | 86.84 | 86.31 | 86.49 | 914500.0 |
| 2007-05-23 | ADRE | ETF | 43.95 | 44.21 | 43.63 | 43.7 | 154270.0 |
| 2007-05-23 | AGG | ETF | 99.4 | 99.52 | 99.16 | 99.37 | 1081300.0 |
| 2007-05-23 | AIQ | ETF | 42.5 | 42.8 | 40.7195 | 41.9 | 45820.0 |
| 2007-05-23 | AIS | ETF | 1.74 | 1.74 | 1.64 | 1.69 | 444800.0 |
| 2007-05-23 | ARB | ETF | 50.25 | 50.49 | 49.93 | 50.11 | 175000.0 |
| 2007-05-23 | BBH | ETF | 59.5533 | 59.75 | 59.3367 | 59.3633 | 459000.0 |
| 2007-05-23 | BITS | ETF | 32.12 | 33.16 | 32.12 | 32.9596 | 14408.0 |
| 2007-05-23 | BIV | ETF | 74.78 | 74.79 | 74.58 | 74.62 | 7600.0 |
| 2007-05-23 | BLV | ETF | 74.46 | 74.48 | 74.13 | 74.2 | 26800.0 |
| 2007-05-23 | BMVP | ETF | 18.19 | 18.27 | 18.11 | 18.11 | 38200.0 |
| 2007-05-23 | BND | ETF | 74.94 | 74.96 | 74.78 | 74.86 | 47200.0 |
| 2007-05-23 | BNE | ETF | 19.25 | 19.32 | 18.94 | 18.94 | 329800.0 |
| 2007-05-23 | BRF | ETF | 14.52 | 14.52 | 14.52 | 14.52 | 3900.0 |
| 2007-05-23 | BSV | ETF | 75.08 | 75.1 | 75.03 | 75.05 | 75100.0 |
| 2007-05-23 | BTF | ETF | 111.14999999999999 | 111.6 | 110.5 | 110.5 | 2000.0 |
| 2007-05-23 | CBON | ETF | 29.44 | 29.66 | 29.01 | 29.03 | 41009.0 |
| 2007-05-23 | CDL | ETF | 8.53 | 8.57 | 8.45 | 8.48 | 230800.0 |
| 2007-05-23 | CEF | ETF | 9.05 | 9.17 | 9.05 | 9.09 | 400700.0 |
| 2007-05-23 | CGO | ETF | 18.09 | 18.3 | 17.75 | 17.83 | 62500.0 |
| 2007-05-23 | CGW | ETF | 25.23 | 25.4 | 25.15 | 25.17 | 265900.0 |
| 2007-05-23 | CHB | ETF | 11.63 | 12.0 | 11.61 | 11.69 | 1645890.0 |
| 2007-05-23 | CHI | ETF | 20.0 | 20.09 | 19.98 | 20.02 | 95600.0 |
| 2007-05-23 | CHIC | ETF | 26.58 | 26.93 | 25.86 | 25.9 | 570850.0 |
| 2007-05-23 | CHY | ETF | 17.15 | 17.2 | 17.12 | 17.19 | 132500.0 |
| 2007-05-23 | CIL | ETF | 25.91 | 25.95 | 25.91 | 25.91 | 3300.0 |
| 2007-05-23 | CN | ETF | 52.9 | 54.08 | 52.9 | 52.93 | 73100.0 |
| 2007-05-23 | CNXT | ETF | 1.37 | 1.37 | 1.34 | 1.35 | 5842881.0 |
| 2007-05-23 | CPST | ETF | 0.925 | 0.93 | 0.9 | 0.92 | 683994.0 |
| 2007-05-23 | CSA | ETF | 19.85 | 20.34 | 19.85 | 20.34 | 96000.0 |
| 2007-05-23 | CSB | ETF | 32.38 | 32.4696 | 32.22 | 32.36 | 11600.0 |
| 2007-05-23 | CSD | ETF | 30.29 | 30.35 | 30.08 | 30.1 | 68100.0 |
| 2007-05-23 | CSM | ETF | 1.4 | 1.4 | 1.4 | 1.4 | 120000.0 |
| 2007-05-23 | CSQ | ETF | 15.7 | 15.75 | 15.6 | 15.65 | 434800.0 |
| 2007-05-23 | CTEC | ETF | 87.14999999999999 | 87.14999999999999 | 85.05 | 86.14999999999999 | 11830.0 |
| 2007-05-23 | CVY | ETF | 28.33 | 28.44 | 28.25 | 28.28 | 34100.0 |
| 2007-05-23 | CWI | ETF | 27.2333 | 27.2867 | 27.1067 | 27.14 | 22050.0 |
| 2007-05-23 | CZA | ETF | 26.87 | 26.97 | 26.87 | 26.97 | 700.0 |
| 2007-05-23 | DBA | ETF | 25.25 | 25.25 | 25.04 | 25.1 | 110400.0 |
| 2007-05-23 | DBB | ETF | 26.97 | 26.97 | 26.51 | 26.84 | 39600.0 |
| 2007-05-23 | DBC | ETF | 25.36 | 25.44 | 25.18 | 25.43 | 251500.0 |
| 2007-05-23 | DBE | ETF | 28.24 | 28.38 | 28.12 | 28.38 | 3800.0 |
| 2007-05-23 | DBO | ETF | 26.35 | 26.59 | 26.33 | 26.56 | 13100.0 |
| 2007-05-23 | DBP | ETF | 26.01 | 26.1 | 25.98 | 25.98 | 2400.0 |
| 2007-05-23 | DBS | ETF | 25.77 | 25.8139 | 25.6401 | 25.72 | 6300.0 |
> showing 50 of 482 rows — these rows as CSV