PREVIEW / etf_daily / 2007-04-10
file: by_date/etf_daily/2007/2007-04-10.parquet size: 21 KB rows: 441
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-04-10 | SPY | ETF | 144.33 | 144.85 | 144.27 | 144.61 | 56620000.0 |
| 2007-04-10 | QQQ | ETF | 44.44 | 44.68 | 44.41 | 44.68 | 76438119.0 |
| 2007-04-10 | IWM | ETF | 80.5 | 81.06 | 80.38 | 80.8 | 48521000.0 |
| 2007-04-10 | DIA | ETF | 125.65 | 125.86 | 125.47 | 125.59 | 5668800.0 |
| 2007-04-10 | GLD | ETF | 67.16 | 67.55 | 66.98 | 67.16 | 2741900.0 |
| 2007-04-10 | TLT | ETF | 87.39 | 87.55 | 87.31 | 87.43 | 674400.0 |
| 2007-04-10 | AAA | ETF | 66.92 | 67.0 | 66.72 | 66.8101 | 18400.0 |
| 2007-04-10 | ADRE | ETF | 41.07 | 41.2325 | 40.97 | 41.16 | 92385.0 |
| 2007-04-10 | AGG | ETF | 99.74 | 99.86 | 99.54 | 99.69 | 314700.0 |
| 2007-04-10 | AIQ | ETF | 46.15 | 46.9 | 45.65 | 46.0 | 69420.0 |
| 2007-04-10 | AIS | ETF | 1.57 | 1.59 | 1.5 | 1.53 | 471200.0 |
| 2007-04-10 | ARB | ETF | 47.28 | 47.9 | 47.2 | 47.8 | 89000.0 |
| 2007-04-10 | BAB | ETF | 101.91 | 101.92 | 101.2 | 101.75 | 32300.0 |
| 2007-04-10 | BBH | ETF | 59.8333 | 59.9567 | 59.4267 | 59.5167 | 323400.0 |
| 2007-04-10 | BITS | ETF | 31.56 | 31.7996 | 30.92 | 30.96 | 6900.0 |
| 2007-04-10 | BIV | ETF | 75.02 | 75.06 | 75.0 | 75.06 | 12400.0 |
| 2007-04-10 | BLV | ETF | 74.82 | 74.95 | 74.82 | 74.95 | 7800.0 |
| 2007-04-10 | BND | ETF | 75.07 | 75.26 | 75.0 | 75.24 | 35000.0 |
| 2007-04-10 | BNE | ETF | 16.23 | 16.4 | 16.23 | 16.26 | 267700.0 |
| 2007-04-10 | BOSS | ETF | 46.9 | 48.34 | 46.9 | 48.34 | 300.0 |
| 2007-04-10 | BRF | ETF | 14.54 | 14.55 | 14.54 | 14.54 | 3000.0 |
| 2007-04-10 | BSV | ETF | 74.96 | 74.99 | 74.96 | 74.99 | 15800.0 |
| 2007-04-10 | BTF | ETF | 109.85 | 110.0 | 109.7 | 109.89999999999999 | 1420.0 |
| 2007-04-10 | CBON | ETF | 29.58 | 29.9 | 29.41 | 29.46 | 412327.0 |
| 2007-04-10 | CDL | ETF | 9.6 | 9.65 | 9.55 | 9.63 | 86200.0 |
| 2007-04-10 | CEF | ETF | 9.7 | 9.86 | 9.55 | 9.84 | 732800.0 |
| 2007-04-10 | CGO | ETF | 17.29 | 17.36 | 17.23 | 17.3 | 15700.0 |
| 2007-04-10 | CHB | ETF | 9.15 | 9.27 | 8.92 | 9.27 | 1718100.0 |
| 2007-04-10 | CHI | ETF | 20.2 | 20.36 | 20.13 | 20.352 | 79000.0 |
| 2007-04-10 | CHIC | ETF | 30.6 | 30.75 | 29.9 | 30.0 | 436415.0 |
| 2007-04-10 | CHY | ETF | 16.98 | 17.01 | 16.91 | 17.0 | 99600.0 |
| 2007-04-10 | CIL | ETF | 25.74 | 25.74 | 25.73 | 25.73 | 1100.0 |
| 2007-04-10 | CN | ETF | 52.09 | 52.43 | 51.61 | 52.2 | 32700.0 |
| 2007-04-10 | CNXT | ETF | 1.49 | 1.52 | 1.45 | 1.48 | 20236552.0 |
| 2007-04-10 | CPI | ETF | 21.94 | 21.94 | 21.42 | 21.42 | 1600.0 |
| 2007-04-10 | CPST | ETF | 1.04 | 1.23 | 1.02 | 1.16 | 12247667.0 |
| 2007-04-10 | CSA | ETF | 21.43 | 21.43 | 21.22 | 21.25 | 13300.0 |
| 2007-04-10 | CSB | ETF | 33.56 | 33.91 | 33.56 | 33.79 | 8600.0 |
| 2007-04-10 | CSD | ETF | 28.0 | 28.01 | 27.9 | 28.0 | 16400.0 |
| 2007-04-10 | CSQ | ETF | 15.21 | 15.28 | 15.18 | 15.28 | 254200.0 |
| 2007-04-10 | CTEC | ETF | 87.6 | 87.6 | 85.64999999999999 | 87.6 | 15593.800000000001 |
| 2007-04-10 | CVY | ETF | 26.93 | 26.96 | 26.89 | 26.96 | 12300.0 |
| 2007-04-10 | CWI | ETF | 26.1067 | 26.2067 | 26.0933 | 26.2067 | 45000.0 |
| 2007-04-10 | DBA | ETF | 25.51 | 25.71 | 25.27 | 25.55 | 211000.0 |
| 2007-04-10 | DBB | ETF | 27.3 | 27.3 | 26.64 | 26.7 | 55900.0 |
| 2007-04-10 | DBC | ETF | 25.32 | 25.51 | 25.1 | 25.45 | 229300.0 |
| 2007-04-10 | DBE | ETF | 27.74 | 27.82 | 27.42 | 27.76 | 3300.0 |
| 2007-04-10 | DBO | ETF | 26.01 | 26.49 | 26.0 | 26.33 | 18400.0 |
| 2007-04-10 | DBP | ETF | 26.99 | 26.99 | 26.85 | 26.92 | 7100.0 |
| 2007-04-10 | DBS | ETF | 27.43 | 27.45 | 27.3 | 27.4 | 27200.0 |
> showing 50 of 441 rows — these rows as CSV