PREVIEW / etf_daily / 2007-07-03
file: by_date/etf_daily/2007/2007-07-03.parquet size: 22 KB rows: 478
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-03 | SPY | ETF | 152.18 | 152.5 | 151.99 | 152.34 | 54048400.0 |
| 2007-07-03 | QQQ | ETF | 48.1 | 48.32 | 48.04 | 48.31 | 34803235.0 |
| 2007-07-03 | IWM | ETF | 84.12 | 84.51 | 84.03 | 84.37 | 34591600.0 |
| 2007-07-03 | DIA | ETF | 135.51 | 135.86 | 135.34 | 135.69 | 7521000.0 |
| 2007-07-03 | GLD | ETF | 65.06 | 65.06 | 64.58 | 64.74 | 1835300.0 |
| 2007-07-03 | TLT | ETF | 85.25 | 85.34 | 84.71 | 84.77 | 1387500.0 |
| 2007-07-03 | ADRE | ETF | 46.5 | 46.75 | 46.5 | 46.68 | 57757.0 |
| 2007-07-03 | AGG | ETF | 98.34 | 98.49 | 98.04 | 98.09 | 384200.0 |
| 2007-07-03 | AIQ | ETF | 51.2 | 51.2 | 49.55 | 49.8 | 30500.0 |
| 2007-07-03 | AIS | ETF | 1.68 | 1.69 | 1.61 | 1.62 | 154900.0 |
| 2007-07-03 | ARB | ETF | 52.03 | 53.66 | 52.03 | 53.21 | 227700.0 |
| 2007-07-03 | BBH | ETF | 56.6633 | 56.74 | 56.35 | 56.5967 | 117600.0 |
| 2007-07-03 | BIL | ETF | 91.56 | 91.62 | 91.56 | 91.62 | 3000.0 |
| 2007-07-03 | BITS | ETF | 26.52 | 27.16 | 26.52 | 27.0396 | 26118.0 |
| 2007-07-03 | BIV | ETF | 73.88 | 73.88 | 73.63 | 73.63 | 4500.0 |
| 2007-07-03 | BLV | ETF | 72.96 | 72.96 | 72.84 | 72.84 | 3300.0 |
| 2007-07-03 | BMVP | ETF | 18.08 | 18.14 | 18.08 | 18.12 | 24300.0 |
| 2007-07-03 | BND | ETF | 74.27 | 74.33 | 74.06 | 74.08 | 21900.0 |
| 2007-07-03 | BNE | ETF | 19.72 | 19.73 | 19.46 | 19.48 | 60000.0 |
| 2007-07-03 | BRF | ETF | 14.5 | 14.53 | 14.5 | 14.51 | 3300.0 |
| 2007-07-03 | BSV | ETF | 74.89 | 74.9 | 74.75 | 74.8 | 38700.0 |
| 2007-07-03 | BTF | ETF | 107.85 | 107.94999999999999 | 106.85 | 106.85 | 240.0 |
| 2007-07-03 | CBON | ETF | 28.09 | 28.16 | 27.34 | 27.5 | 66425.0 |
| 2007-07-03 | CDL | ETF | 6.4 | 6.45 | 6.29 | 6.38 | 1387742.0 |
| 2007-07-03 | CEF | ETF | 9.07 | 9.11 | 9.02 | 9.09 | 92600.0 |
| 2007-07-03 | CGO | ETF | 18.25 | 18.29 | 18.21 | 18.26 | 6000.0 |
| 2007-07-03 | CGW | ETF | 25.89 | 26.0 | 25.83 | 25.88 | 112600.0 |
| 2007-07-03 | CHB | ETF | 10.09 | 10.41 | 9.97 | 10.0 | 672800.0 |
| 2007-07-03 | CHI | ETF | 19.33 | 19.45 | 19.3 | 19.36 | 51400.0 |
| 2007-07-03 | CHIC | ETF | 26.18 | 26.21 | 25.3 | 25.35 | 394204.0 |
| 2007-07-03 | CHY | ETF | 16.24 | 16.4601 | 16.23 | 16.46 | 72500.0 |
| 2007-07-03 | CN | ETF | 54.45 | 55.33 | 54.38 | 54.5 | 168100.0 |
| 2007-07-03 | CNXT | ETF | 1.39 | 1.4 | 1.37 | 1.39 | 2355263.0 |
| 2007-07-03 | CPST | ETF | 1.1 | 1.13 | 1.07 | 1.11 | 1881721.0 |
| 2007-07-03 | CSA | ETF | 20.27 | 20.64 | 20.27 | 20.43 | 15600.0 |
| 2007-07-03 | CSB | ETF | 32.54 | 32.73 | 32.4 | 32.45 | 178100.0 |
| 2007-07-03 | CSD | ETF | 31.05 | 31.1 | 30.96 | 31.03 | 29800.0 |
| 2007-07-03 | CSQ | ETF | 15.28 | 15.5 | 15.24 | 15.36 | 159400.0 |
| 2007-07-03 | CTEC | ETF | 111.25 | 111.69999999999999 | 109.19999999999999 | 111.5 | 14523.6 |
| 2007-07-03 | CVY | ETF | 27.96 | 28.43 | 27.9 | 27.91 | 28700.0 |
| 2007-07-03 | CWI | ETF | 27.8 | 27.8333 | 27.7467 | 27.8333 | 5850.0 |
| 2007-07-03 | CZA | ETF | 27.45 | 27.45 | 27.45 | 27.45 | 300.0 |
| 2007-07-03 | DBA | ETF | 26.27 | 26.39 | 25.93 | 25.97 | 213300.0 |
| 2007-07-03 | DBB | ETF | 26.95 | 27.14 | 26.81 | 27.04 | 12700.0 |
| 2007-07-03 | DBC | ETF | 26.04 | 26.04 | 25.81 | 25.89 | 185500.0 |
| 2007-07-03 | DBE | ETF | 29.01 | 29.13 | 29.01 | 29.07 | 2900.0 |
| 2007-07-03 | DBO | ETF | 27.35 | 27.44 | 27.31 | 27.4 | 8400.0 |
| 2007-07-03 | DBP | ETF | 25.63 | 25.63 | 25.54 | 25.57 | 2400.0 |
| 2007-07-03 | DBS | ETF | 24.73 | 24.74 | 24.57 | 24.66 | 18000.0 |
| 2007-07-03 | DBV | ETF | 29.15 | 29.15 | 29.06 | 29.09 | 86600.0 |
> showing 50 of 478 rows — these rows as CSV