PREVIEW / etf_daily / 2007-05-25
file: by_date/etf_daily/2007/2007-05-25.parquet size: 22 KB rows: 484
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-25 | SPY | ETF | 151.5 | 152.02 | 151.18 | 151.69 | 83309200.0 |
| 2007-05-25 | QQQ | ETF | 46.26 | 46.56 | 46.18 | 46.45 | 87154203.0 |
| 2007-05-25 | IWM | ETF | 82.24 | 82.71 | 82.04 | 82.49 | 44083500.0 |
| 2007-05-25 | DIA | ETF | 134.76 | 135.05 | 134.39 | 134.89 | 10227600.0 |
| 2007-05-25 | GLD | ETF | 64.96 | 65.08 | 64.73 | 64.94 | 4217600.0 |
| 2007-05-25 | TLT | ETF | 86.4 | 86.61 | 86.33 | 86.37 | 754900.0 |
| 2007-05-25 | ADRE | ETF | 42.8 | 43.47 | 42.8 | 43.42 | 212068.0 |
| 2007-05-25 | AGG | ETF | 99.32 | 99.41 | 99.17 | 99.36 | 222200.0 |
| 2007-05-25 | AIQ | ETF | 41.25 | 42.45 | 41.25 | 41.5 | 53189.0 |
| 2007-05-25 | AIS | ETF | 1.79 | 1.81 | 1.76 | 1.81 | 228400.0 |
| 2007-05-25 | ARB | ETF | 50.0 | 50.66 | 49.9 | 50.58 | 132900.0 |
| 2007-05-25 | BBH | ETF | 59.0767 | 59.4233 | 59.0733 | 59.3033 | 279300.0 |
| 2007-05-25 | BITS | ETF | 32.72 | 33.08 | 32.52 | 33.0 | 11684.0 |
| 2007-05-25 | BIV | ETF | 74.59 | 74.64 | 74.59 | 74.64 | 5800.0 |
| 2007-05-25 | BLV | ETF | 74.2 | 74.26 | 74.14 | 74.19 | 80500.0 |
| 2007-05-25 | BMVP | ETF | 18.0267 | 18.0867 | 18.0 | 18.0633 | 28600.0 |
| 2007-05-25 | BND | ETF | 74.81 | 74.87 | 74.8 | 74.86 | 21100.0 |
| 2007-05-25 | BNE | ETF | 19.0 | 19.28 | 18.84 | 19.18 | 140300.0 |
| 2007-05-25 | BOSS | ETF | 48.86 | 48.86 | 48.86 | 48.86 | 200.0 |
| 2007-05-25 | BRF | ETF | 14.52 | 14.52 | 14.49 | 14.49 | 7500.0 |
| 2007-05-25 | BSV | ETF | 75.12 | 75.14 | 75.08 | 75.12 | 74700.0 |
| 2007-05-25 | BTF | ETF | 108.85 | 109.94999999999999 | 108.85 | 109.49999999999999 | 2700.0 |
| 2007-05-25 | CBON | ETF | 29.83 | 30.2 | 29.64 | 29.76 | 41956.0 |
| 2007-05-25 | CDL | ETF | 8.35 | 8.56 | 8.3 | 8.52 | 886800.0 |
| 2007-05-25 | CEF | ETF | 8.95 | 9.06 | 8.94 | 9.01 | 188500.0 |
| 2007-05-25 | CGO | ETF | 17.65 | 17.71 | 17.3 | 17.71 | 56600.0 |
| 2007-05-25 | CGW | ETF | 24.89 | 25.12 | 24.89 | 25.12 | 140300.0 |
| 2007-05-25 | CHB | ETF | 11.52 | 11.75 | 10.93 | 11.22 | 2143800.0 |
| 2007-05-25 | CHI | ETF | 19.96 | 20.04 | 19.92 | 19.98 | 95500.0 |
| 2007-05-25 | CHIC | ETF | 26.1 | 26.63 | 25.94 | 26.26 | 439135.0 |
| 2007-05-25 | CHY | ETF | 17.13 | 17.19 | 16.96 | 17.13 | 182738.0 |
| 2007-05-25 | CN | ETF | 51.5 | 52.0 | 51.36 | 51.92 | 37700.0 |
| 2007-05-25 | CNXT | ETF | 1.32 | 1.34 | 1.28 | 1.3 | 6287005.0 |
| 2007-05-25 | CPI | ETF | 23.5 | 23.5 | 23.5 | 23.5 | 200.0 |
| 2007-05-25 | CPST | ETF | 0.902 | 0.9202 | 0.9 | 0.9 | 1390096.0 |
| 2007-05-25 | CSA | ETF | 20.13 | 20.65 | 20.12 | 20.41 | 18100.0 |
| 2007-05-25 | CSB | ETF | 32.0 | 32.12 | 31.81 | 31.95 | 43100.0 |
| 2007-05-25 | CSD | ETF | 29.8 | 30.12 | 29.8 | 30.1 | 16600.0 |
| 2007-05-25 | CSM | ETF | 1.4 | 1.4 | 1.4 | 1.4 | 3600.0 |
| 2007-05-25 | CSQ | ETF | 15.38 | 15.47 | 15.35 | 15.47 | 270400.0 |
| 2007-05-25 | CTEC | ETF | 86.5 | 86.5 | 84.64999999999999 | 85.39999999999999 | 14919.2 |
| 2007-05-25 | CVY | ETF | 27.97 | 28.03 | 27.89 | 27.98 | 29600.0 |
| 2007-05-25 | CWI | ETF | 26.8933 | 26.98 | 26.8733 | 26.98 | 29850.0 |
| 2007-05-25 | DBA | ETF | 25.79 | 26.12 | 25.7 | 26.0 | 208000.0 |
| 2007-05-25 | DBB | ETF | 26.52 | 26.89 | 26.35 | 26.81 | 21900.0 |
| 2007-05-25 | DBC | ETF | 25.41 | 25.61 | 25.31 | 25.6 | 162600.0 |
| 2007-05-25 | DBE | ETF | 28.52 | 28.56 | 28.39 | 28.5 | 8300.0 |
| 2007-05-25 | DBO | ETF | 26.48 | 26.68 | 26.41 | 26.53 | 37900.0 |
| 2007-05-25 | DBP | ETF | 25.75 | 25.8 | 25.7 | 25.75 | 1700.0 |
| 2007-05-25 | DBS | ETF | 25.4 | 25.52 | 25.4 | 25.52 | 1600.0 |
> showing 50 of 484 rows — these rows as CSV