PREVIEW / etf_daily / 2007-08-03
file: by_date/etf_daily/2007/2007-08-03.parquet size: 23 KB rows: 493
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-03 | SPY | ETF | 147.28 | 147.58 | 143.2 | 143.8 | 359398200.0 |
| 2007-08-03 | QQQ | ETF | 48.25 | 48.31 | 47.15 | 47.42 | 166048313.0 |
| 2007-08-03 | IWM | ETF | 78.01 | 78.21 | 74.96 | 75.35 | 158340000.0 |
| 2007-08-03 | DIA | ETF | 134.44 | 134.72 | 131.54 | 132.19 | 34061000.0 |
| 2007-08-03 | GLD | ETF | 65.85 | 66.92 | 65.85 | 66.69 | 10736000.0 |
| 2007-08-03 | TLT | ETF | 87.28 | 87.93 | 87.28 | 87.93 | 1577600.0 |
| 2007-08-03 | ADRE | ETF | 46.1 | 46.39 | 44.24 | 44.28 | 249287.0 |
| 2007-08-03 | AGG | ETF | 98.52 | 98.71 | 98.39 | 98.71 | 371600.0 |
| 2007-08-03 | AIQ | ETF | 42.55 | 43.85 | 42.0 | 43.3 | 244720.0 |
| 2007-08-03 | AIS | ETF | 1.6 | 1.6 | 1.5 | 1.55 | 305800.0 |
| 2007-08-03 | ARB | ETF | 51.99 | 52.33 | 51.13 | 51.35 | 791900.0 |
| 2007-08-03 | BBH | ETF | 54.6133 | 54.8367 | 54.1333 | 54.1333 | 312000.0 |
| 2007-08-03 | BIL | ETF | 91.62 | 91.64 | 91.54 | 91.54 | 26200.0 |
| 2007-08-03 | BITS | ETF | 25.36 | 25.36 | 24.2 | 24.2804 | 25040.0 |
| 2007-08-03 | BIV | ETF | 74.36 | 74.66 | 74.36 | 74.66 | 7100.0 |
| 2007-08-03 | BLV | ETF | 73.74 | 74.17 | 73.74 | 74.17 | 8800.0 |
| 2007-08-03 | BMVP | ETF | 17.1133 | 17.1133 | 16.5167 | 16.5467 | 46900.0 |
| 2007-08-03 | BND | ETF | 74.61 | 74.8 | 74.58 | 74.77 | 118800.0 |
| 2007-08-03 | BNE | ETF | 17.54 | 17.56 | 16.41 | 16.55 | 278600.0 |
| 2007-08-03 | BRF | ETF | 14.52 | 14.53 | 14.52 | 14.53 | 900.0 |
| 2007-08-03 | BSV | ETF | 75.18 | 75.32 | 75.18 | 75.32 | 31400.0 |
| 2007-08-03 | BTF | ETF | 103.1 | 103.1 | 103.0 | 103.0 | 840.0 |
| 2007-08-03 | CBON | ETF | 23.3901 | 23.49 | 22.41 | 22.48 | 90548.0 |
| 2007-08-03 | CDL | ETF | 4.94 | 5.0 | 4.66 | 4.68 | 3189006.0 |
| 2007-08-03 | CEF | ETF | 9.17 | 9.35 | 9.17 | 9.26 | 288700.0 |
| 2007-08-03 | CGO | ETF | 17.04 | 17.04 | 16.7 | 16.7 | 35100.0 |
| 2007-08-03 | CGW | ETF | 25.1 | 25.11 | 24.55 | 24.65 | 53000.0 |
| 2007-08-03 | CHB | ETF | 11.98 | 12.05 | 10.64 | 10.69 | 3341900.0 |
| 2007-08-03 | CHI | ETF | 17.39 | 17.6 | 17.31 | 17.49 | 83300.0 |
| 2007-08-03 | CHIC | ETF | 17.09 | 17.28 | 16.33 | 16.35 | 931430.0 |
| 2007-08-03 | CHW | ETF | 14.07 | 14.22 | 14.0 | 14.12 | 101600.0 |
| 2007-08-03 | CHY | ETF | 15.29 | 15.44 | 15.2 | 15.25 | 130500.0 |
| 2007-08-03 | CN | ETF | 49.8 | 49.86 | 48.06 | 48.15 | 111500.0 |
| 2007-08-03 | CNXT | ETF | 1.27 | 1.29 | 1.21 | 1.23 | 8254015.0 |
| 2007-08-03 | CPST | ETF | 1.03 | 1.04 | 0.99 | 1.019 | 2277310.0 |
| 2007-08-03 | CSA | ETF | 17.31 | 17.43 | 16.5 | 16.6 | 50400.0 |
| 2007-08-03 | CSD | ETF | 29.02 | 29.02 | 28.26 | 28.26 | 33400.0 |
| 2007-08-03 | CSQ | ETF | 14.21 | 14.38 | 14.1 | 14.13 | 238100.0 |
| 2007-08-03 | CTEC | ETF | 97.69999999999999 | 102.69999999999999 | 97.65 | 99.85 | 15180.800000000001 |
| 2007-08-03 | CVY | ETF | 26.05 | 26.05 | 25.22 | 25.22 | 68000.0 |
| 2007-08-03 | CWI | ETF | 26.8533 | 26.8933 | 26.3333 | 26.3333 | 145200.0 |
| 2007-08-03 | CZA | ETF | 25.73 | 25.74 | 25.73 | 25.74 | 300.0 |
| 2007-08-03 | DBA | ETF | 26.19 | 26.29 | 26.03 | 26.03 | 167700.0 |
| 2007-08-03 | DBB | ETF | 27.13 | 27.24 | 26.71 | 26.91 | 134200.0 |
| 2007-08-03 | DBC | ETF | 26.2 | 26.2 | 25.9 | 25.9 | 141400.0 |
| 2007-08-03 | DBE | ETF | 29.27 | 29.33 | 28.94 | 28.99 | 61900.0 |
| 2007-08-03 | DBO | ETF | 27.99 | 27.99 | 27.45 | 27.54 | 35700.0 |
| 2007-08-03 | DBP | ETF | 26.15 | 26.39 | 26.13 | 26.38 | 7300.0 |
| 2007-08-03 | DBS | ETF | 25.54 | 25.8 | 25.54 | 25.77 | 3900.0 |
| 2007-08-03 | DBV | ETF | 28.55 | 28.84 | 28.05 | 28.69 | 372400.0 |
> showing 50 of 493 rows — these rows as CSV