PREVIEW / etf_daily / 2007-07-17
file: by_date/etf_daily/2007/2007-07-17.parquet size: 22 KB rows: 491
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-07-17 | SPY | ETF | 154.93 | 155.48 | 154.68 | 154.75 | 126201300.0 |
| 2007-07-17 | QQQ | ETF | 49.97 | 50.3 | 49.92 | 50.23 | 124837446.0 |
| 2007-07-17 | IWM | ETF | 84.62 | 85.06 | 84.46 | 84.54 | 57654400.0 |
| 2007-07-17 | DIA | ETF | 139.63 | 140.46 | 139.53 | 139.8 | 13299300.0 |
| 2007-07-17 | GLD | ETF | 65.66 | 66.08 | 65.65 | 65.75 | 1878600.0 |
| 2007-07-17 | TLT | ETF | 84.86 | 85.09 | 84.5 | 84.89 | 734200.0 |
| 2007-07-17 | ADRE | ETF | 49.02 | 49.24 | 48.52 | 49.1 | 203977.0 |
| 2007-07-17 | AGG | ETF | 98.04 | 98.13 | 97.85 | 97.92 | 221300.0 |
| 2007-07-17 | AIQ | ETF | 52.25 | 52.9 | 51.85 | 52.15 | 61880.0 |
| 2007-07-17 | AIS | ETF | 1.74 | 1.75 | 1.69 | 1.7199 | 212300.0 |
| 2007-07-17 | ARB | ETF | 53.49 | 53.9 | 53.13 | 53.27 | 212800.0 |
| 2007-07-17 | BBH | ETF | 56.09 | 56.26 | 55.8267 | 56.0567 | 747900.0 |
| 2007-07-17 | BIL | ETF | 91.8 | 91.8 | 91.72 | 91.8 | 46500.0 |
| 2007-07-17 | BITS | ETF | 28.8 | 28.88 | 28.28 | 28.44 | 12769.0 |
| 2007-07-17 | BIV | ETF | 73.55 | 73.65 | 73.47 | 73.59 | 4400.0 |
| 2007-07-17 | BLV | ETF | 72.69 | 72.85 | 72.57 | 72.81 | 8600.0 |
| 2007-07-17 | BMVP | ETF | 18.24 | 18.283 | 18.192 | 18.203 | 42400.0 |
| 2007-07-17 | BND | ETF | 74.06 | 74.09 | 73.89 | 74.04 | 37500.0 |
| 2007-07-17 | BNE | ETF | 19.84 | 20.46 | 19.84 | 20.22 | 263800.0 |
| 2007-07-17 | BRF | ETF | 14.46 | 14.51 | 14.46 | 14.49 | 9900.0 |
| 2007-07-17 | BSV | ETF | 74.82 | 74.85 | 74.78 | 74.85 | 31100.0 |
| 2007-07-17 | BTF | ETF | 107.94999999999999 | 108.64999999999999 | 107.89999999999999 | 108.55 | 1140.0 |
| 2007-07-17 | CBON | ETF | 26.82 | 27.45 | 26.8 | 26.94 | 60906.0 |
| 2007-07-17 | CDL | ETF | 6.18 | 6.25 | 6.14 | 6.16 | 1967600.0 |
| 2007-07-17 | CEF | ETF | 9.2 | 9.36 | 9.2 | 9.26 | 189000.0 |
| 2007-07-17 | CGO | ETF | 18.39 | 18.432 | 18.01 | 18.21 | 25100.0 |
| 2007-07-17 | CGW | ETF | 26.2 | 26.3 | 25.95 | 25.95 | 251900.0 |
| 2007-07-17 | CHB | ETF | 9.6 | 10.35 | 9.58 | 10.18 | 2716400.0 |
| 2007-07-17 | CHI | ETF | 17.55 | 18.27 | 17.55 | 17.93 | 307000.0 |
| 2007-07-17 | CHIC | ETF | 23.91 | 24.03 | 23.57 | 23.77 | 518167.0 |
| 2007-07-17 | CHY | ETF | 15.51 | 15.7 | 15.5 | 15.58 | 233700.0 |
| 2007-07-17 | CN | ETF | 54.82 | 54.97 | 54.5 | 54.74 | 70800.0 |
| 2007-07-17 | CNXT | ETF | 1.47 | 1.47 | 1.41 | 1.44 | 12942999.0 |
| 2007-07-17 | CPI | ETF | 23.95 | 23.95 | 23.95 | 23.95 | 200.0 |
| 2007-07-17 | CPST | ETF | 1.3 | 1.33 | 1.23 | 1.26 | 5315402.0 |
| 2007-07-17 | CSA | ETF | 18.62 | 18.63 | 18.3 | 18.53 | 59700.0 |
| 2007-07-17 | CSB | ETF | 32.47 | 32.66 | 32.27 | 32.485 | 35500.0 |
| 2007-07-17 | CSD | ETF | 31.42 | 31.5 | 31.33 | 31.41 | 18800.0 |
| 2007-07-17 | CSQ | ETF | 15.23 | 15.24 | 15.1 | 15.16 | 260400.0 |
| 2007-07-17 | CTEC | ETF | 109.8 | 113.0 | 109.39999999999999 | 109.85 | 26992.2 |
| 2007-07-17 | CVY | ETF | 27.95 | 28.05 | 27.93 | 27.95 | 40000.0 |
| 2007-07-17 | CWI | ETF | 28.4 | 28.4267 | 28.36 | 28.38 | 32550.0 |
| 2007-07-17 | CZA | ETF | 27.85 | 27.85 | 27.85 | 27.85 | 100.0 |
| 2007-07-17 | DBA | ETF | 26.7 | 26.79 | 25.96 | 26.1 | 510600.0 |
| 2007-07-17 | DBB | ETF | 27.52 | 27.64 | 27.32 | 27.64 | 30700.0 |
| 2007-07-17 | DBC | ETF | 26.24 | 26.33 | 25.88 | 26.02 | 423200.0 |
| 2007-07-17 | DBE | ETF | 29.03 | 29.25 | 28.71 | 28.94 | 43400.0 |
| 2007-07-17 | DBO | ETF | 27.4 | 27.54 | 27.13 | 27.2 | 30400.0 |
| 2007-07-17 | DBP | ETF | 26.12 | 26.12 | 26.0 | 26.0 | 12900.0 |
| 2007-07-17 | DBS | ETF | 25.51 | 25.62 | 25.37 | 25.4 | 7300.0 |
> showing 50 of 491 rows — these rows as CSV