PREVIEW / etf_daily / 2007-06-01
file: by_date/etf_daily/2007/2007-06-01.parquet size: 22 KB rows: 483
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-06-01 | SPY | ETF | 153.88 | 154.4 | 153.51 | 154.08 | 107771700.0 |
| 2007-06-01 | QQQ | ETF | 47.58 | 47.77 | 47.37 | 47.44 | 125122471.0 |
| 2007-06-01 | IWM | ETF | 84.54 | 85.17 | 84.19 | 84.7 | 71003000.0 |
| 2007-06-01 | DIA | ETF | 136.61 | 136.84 | 136.16 | 136.61 | 9593200.0 |
| 2007-06-01 | GLD | ETF | 65.7 | 66.54 | 65.7 | 66.44 | 5634800.0 |
| 2007-06-01 | TLT | ETF | 85.9 | 86.84 | 85.54 | 85.59 | 1694300.0 |
| 2007-06-01 | ADRE | ETF | 44.64 | 45.13 | 44.5001 | 45.1148 | 115539.0 |
| 2007-06-01 | AGG | ETF | 98.72 | 98.77 | 98.53 | 98.63 | 942500.0 |
| 2007-06-01 | AIQ | ETF | 43.8 | 44.9 | 43.2 | 44.8 | 39840.0 |
| 2007-06-01 | AIS | ETF | 1.91 | 2.04 | 1.9 | 2.02 | 1032900.0 |
| 2007-06-01 | ARB | ETF | 52.6 | 52.97 | 52.3 | 52.64 | 318500.0 |
| 2007-06-01 | BBH | ETF | 60.9333 | 61.1667 | 60.8467 | 61.0167 | 1055700.0 |
| 2007-06-01 | BIL | ETF | 91.62 | 91.62 | 91.62 | 91.62 | 1450.0 |
| 2007-06-01 | BITS | ETF | 33.52 | 33.56 | 32.68 | 33.52 | 15718.0 |
| 2007-06-01 | BIV | ETF | 74.13 | 74.14 | 73.97 | 73.97 | 19100.0 |
| 2007-06-01 | BLV | ETF | 73.85 | 73.85 | 73.56 | 73.58 | 21500.0 |
| 2007-06-01 | BMVP | ETF | 18.31 | 18.34 | 18.25 | 18.28 | 34800.0 |
| 2007-06-01 | BND | ETF | 74.43 | 74.43 | 74.32 | 74.34 | 84900.0 |
| 2007-06-01 | BNE | ETF | 19.4 | 19.55 | 19.29 | 19.34 | 419300.0 |
| 2007-06-01 | BOSS | ETF | 50.0 | 50.25 | 50.0 | 50.25 | 100.0 |
| 2007-06-01 | BRF | ETF | 14.55 | 14.55 | 14.53 | 14.55 | 5700.0 |
| 2007-06-01 | BSV | ETF | 74.7 | 74.74 | 74.65 | 74.65 | 52800.0 |
| 2007-06-01 | BTF | ETF | 110.0 | 110.64999999999999 | 109.738 | 109.74999999999999 | 1160.0 |
| 2007-06-01 | CBON | ETF | 29.66 | 30.33 | 29.66 | 30.09 | 26179.0 |
| 2007-06-01 | CDL | ETF | 8.37 | 8.43 | 8.17 | 8.2 | 2703100.0 |
| 2007-06-01 | CEF | ETF | 9.22 | 9.35 | 9.18 | 9.31 | 422400.0 |
| 2007-06-01 | CGO | ETF | 18.19 | 18.46 | 18.19 | 18.33 | 24700.0 |
| 2007-06-01 | CGW | ETF | 25.63 | 25.7 | 25.6 | 25.67 | 134500.0 |
| 2007-06-01 | CHB | ETF | 11.37 | 11.74 | 11.11 | 11.23 | 1583800.0 |
| 2007-06-01 | CHI | ETF | 20.13 | 20.34 | 20.13 | 20.24 | 105300.0 |
| 2007-06-01 | CHIC | ETF | 28.06 | 28.85 | 28.01 | 28.52 | 770139.0 |
| 2007-06-01 | CHY | ETF | 17.28 | 17.35 | 17.24 | 17.25 | 111400.0 |
| 2007-06-01 | CN | ETF | 50.9 | 51.44 | 50.9 | 51.18 | 48900.0 |
| 2007-06-01 | CNXT | ETF | 1.29 | 1.35 | 1.28 | 1.34 | 8804903.0 |
| 2007-06-01 | CPI | ETF | 23.5 | 23.6 | 23.5 | 23.6 | 1100.0 |
| 2007-06-01 | CPST | ETF | 1.0 | 1.04 | 1.0 | 1.01 | 3806821.0 |
| 2007-06-01 | CSA | ETF | 21.44 | 21.56 | 21.25 | 21.27 | 18400.0 |
| 2007-06-01 | CSB | ETF | 32.04 | 32.3501 | 32.04 | 32.24 | 22200.0 |
| 2007-06-01 | CSD | ETF | 30.95 | 31.03 | 30.9 | 31.01 | 122800.0 |
| 2007-06-01 | CSQ | ETF | 15.56 | 15.62 | 15.55 | 15.62 | 253600.0 |
| 2007-06-01 | CTEC | ETF | 83.8 | 85.0 | 82.35 | 83.94999999999999 | 14749.400000000001 |
| 2007-06-01 | CVY | ETF | 28.49 | 28.54 | 28.48 | 28.5 | 25000.0 |
| 2007-06-01 | CWI | ETF | 27.3867 | 27.46 | 27.3867 | 27.4533 | 26850.0 |
| 2007-06-01 | CZA | ETF | 27.3 | 27.3 | 27.27 | 27.29 | 14000.0 |
| 2007-06-01 | DBA | ETF | 26.26 | 26.62 | 26.11 | 26.39 | 290800.0 |
| 2007-06-01 | DBB | ETF | 27.19 | 27.25 | 26.86 | 26.86 | 100000.0 |
| 2007-06-01 | DBC | ETF | 25.43 | 25.78 | 25.39 | 25.7 | 294500.0 |
| 2007-06-01 | DBE | ETF | 27.91 | 28.25 | 27.83 | 28.09 | 295100.0 |
| 2007-06-01 | DBO | ETF | 26.05 | 26.41 | 25.98 | 26.32 | 13000.0 |
| 2007-06-01 | DBP | ETF | 26.43 | 26.59 | 26.35 | 26.58 | 5600.0 |
> showing 50 of 483 rows — these rows as CSV