PREVIEW / etf_daily / 2007-05-01
file: by_date/etf_daily/2007/2007-05-01.parquet size: 21 KB rows: 456
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-01 | SPY | ETF | 148.42 | 149.47 | 147.67 | 148.67 | 134342700.0 |
| 2007-05-01 | QQQ | ETF | 45.97 | 46.14 | 45.66 | 46.11 | 135091875.0 |
| 2007-05-01 | IWM | ETF | 80.99 | 81.16 | 80.13 | 81.07 | 88311800.0 |
| 2007-05-01 | DIA | ETF | 130.84 | 131.32 | 130.31 | 131.29 | 21228200.0 |
| 2007-05-01 | GLD | ETF | 66.98 | 67.0 | 66.54 | 66.69 | 3946300.0 |
| 2007-05-01 | TLT | ETF | 88.58 | 88.64 | 88.11 | 88.49 | 487200.0 |
| 2007-05-01 | AAA | ETF | 75.6 | 75.6 | 74.75 | 74.75 | 13300.0 |
| 2007-05-01 | ADRE | ETF | 40.71 | 40.97 | 40.53 | 40.93 | 213701.0 |
| 2007-05-01 | AGG | ETF | 100.0 | 100.1 | 99.8 | 100.02 | 1029900.0 |
| 2007-05-01 | AIQ | ETF | 44.75 | 45.1 | 41.75 | 45.0 | 63900.0 |
| 2007-05-01 | AIS | ETF | 1.5 | 1.5 | 1.46 | 1.5 | 159800.0 |
| 2007-05-01 | ARB | ETF | 49.22 | 49.5 | 48.65 | 49.24 | 134300.0 |
| 2007-05-01 | BAB | ETF | 101.43 | 101.78 | 100.61 | 101.08 | 43000.0 |
| 2007-05-01 | BBH | ETF | 62.5167 | 63.4333 | 62.4633 | 63.4333 | 684600.0 |
| 2007-05-01 | BITS | ETF | 34.92 | 35.72 | 34.28 | 34.4 | 17762.0 |
| 2007-05-01 | BIV | ETF | 75.54 | 75.57 | 75.1 | 75.33 | 19000.0 |
| 2007-05-01 | BLV | ETF | 75.74 | 75.87 | 75.22 | 75.6 | 28700.0 |
| 2007-05-01 | BMVP | ETF | 17.75 | 17.8267 | 17.7 | 17.8033 | 46000.0 |
| 2007-05-01 | BND | ETF | 75.37 | 75.39 | 75.21 | 75.32 | 54800.0 |
| 2007-05-01 | BNE | ETF | 16.66 | 16.67 | 16.53 | 16.6 | 156900.0 |
| 2007-05-01 | BRF | ETF | 14.5 | 14.53 | 14.49 | 14.5 | 7800.0 |
| 2007-05-01 | BSV | ETF | 75.38 | 75.38 | 75.21 | 75.26 | 50400.0 |
| 2007-05-01 | BTF | ETF | 110.99999999999999 | 111.35 | 110.8 | 110.99999999999999 | 2800.0 |
| 2007-05-01 | CBON | ETF | 30.79 | 30.87 | 30.3 | 30.83 | 41599.0 |
| 2007-05-01 | CDL | ETF | 9.18 | 9.24 | 9.1 | 9.13 | 224000.0 |
| 2007-05-01 | CEF | ETF | 9.32 | 9.4 | 9.19 | 9.39 | 325800.0 |
| 2007-05-01 | CGO | ETF | 17.68 | 17.68 | 17.4 | 17.51 | 21500.0 |
| 2007-05-01 | CHB | ETF | 10.33 | 10.4 | 10.02 | 10.17 | 2071700.0 |
| 2007-05-01 | CHI | ETF | 20.17 | 20.43 | 20.16 | 20.42 | 106400.0 |
| 2007-05-01 | CHIC | ETF | 27.28 | 27.53 | 26.84 | 27.05 | 527124.0 |
| 2007-05-01 | CHY | ETF | 17.05 | 17.14 | 17.0 | 17.14 | 102100.0 |
| 2007-05-01 | CIL | ETF | 25.85 | 25.94 | 25.85 | 25.91 | 3200.0 |
| 2007-05-01 | CN | ETF | 49.01 | 49.25 | 48.52 | 49.0 | 35900.0 |
| 2007-05-01 | CNXT | ETF | 1.55 | 1.57 | 1.52 | 1.54 | 13190274.0 |
| 2007-05-01 | CPI | ETF | 22.3 | 22.45 | 21.65 | 21.65 | 800.0 |
| 2007-05-01 | CPST | ETF | 1.0 | 1.02 | 0.89 | 0.95 | 8738909.0 |
| 2007-05-01 | CSA | ETF | 20.69 | 20.77 | 20.52 | 20.52 | 36800.0 |
| 2007-05-01 | CSB | ETF | 33.16 | 33.27 | 32.88 | 33.09 | 32600.0 |
| 2007-05-01 | CSD | ETF | 28.4 | 28.54 | 28.26 | 28.4 | 64100.0 |
| 2007-05-01 | CSM | ETF | 1.35 | 1.35 | 1.35 | 1.35 | 4800.0 |
| 2007-05-01 | CSQ | ETF | 15.46 | 15.4699 | 15.28 | 15.4 | 366000.0 |
| 2007-05-01 | CTEC | ETF | 97.24999999999999 | 97.24999999999999 | 87.24999999999999 | 87.79999999999998 | 33099.8 |
| 2007-05-01 | CVY | ETF | 27.53 | 27.59 | 27.38 | 27.52 | 26300.0 |
| 2007-05-01 | CWI | ETF | 26.5133 | 26.5133 | 26.2067 | 26.34 | 233400.0 |
| 2007-05-01 | DBA | ETF | 24.94 | 25.37 | 24.7 | 25.26 | 151600.0 |
| 2007-05-01 | DBB | ETF | 27.55 | 28.14 | 27.54 | 27.95 | 27900.0 |
| 2007-05-01 | DBC | ETF | 25.6 | 25.74 | 25.45 | 25.62 | 178400.0 |
| 2007-05-01 | DBE | ETF | 28.25 | 28.47 | 27.89 | 27.99 | 82400.0 |
| 2007-05-01 | DBO | ETF | 26.65 | 26.97 | 26.35 | 26.35 | 3800.0 |
| 2007-05-01 | DBP | ETF | 26.54 | 26.58 | 26.39 | 26.48 | 10400.0 |
> showing 50 of 456 rows — these rows as CSV