PREVIEW / etf_daily / 2007-06-25
file: by_date/etf_daily/2007/2007-06-25.parquet size: 22 KB rows: 487
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-25 | SPY | ETF | 150.24 | 151.25 | 149.02 | 149.83 | 232014400.0 |
| 2007-06-25 | QQQ | ETF | 47.31 | 47.58 | 46.82 | 47.09 | 136618872.0 |
| 2007-06-25 | IWM | ETF | 82.68 | 83.45 | 82.0 | 82.49 | 108393200.0 |
| 2007-06-25 | DIA | ETF | 133.81 | 134.77 | 132.89 | 133.62 | 18960000.0 |
| 2007-06-25 | GLD | ETF | 64.48 | 64.74 | 64.22 | 64.43 | 3424900.0 |
| 2007-06-25 | TLT | ETF | 84.15 | 84.35 | 83.96 | 84.22 | 1323500.0 |
| 2007-06-25 | ADRE | ETF | 45.59 | 45.81 | 45.0 | 45.09 | 98524.0 |
| 2007-06-25 | AGG | ETF | 98.24 | 98.29 | 98.04 | 98.17 | 305000.0 |
| 2007-06-25 | AIQ | ETF | 43.35 | 43.9 | 42.65 | 42.85 | 55500.0 |
| 2007-06-25 | AIS | ETF | 1.83 | 1.85 | 1.71 | 1.75 | 448200.0 |
| 2007-06-25 | ARB | ETF | 51.0 | 53.42 | 51.0 | 52.0 | 671500.0 |
| 2007-06-25 | BBH | ETF | 58.7533 | 58.8 | 58.14 | 58.2767 | 501300.0 |
| 2007-06-25 | BIL | ETF | 91.9 | 91.92 | 91.9 | 91.92 | 29700.0 |
| 2007-06-25 | BITS | ETF | 30.8 | 31.32 | 29.6 | 29.6 | 22600.0 |
| 2007-06-25 | BIV | ETF | 73.6 | 73.74 | 73.58 | 73.67 | 6100.0 |
| 2007-06-25 | BLV | ETF | 72.55 | 72.62 | 72.44 | 72.58 | 6900.0 |
| 2007-06-25 | BMVP | ETF | 17.75 | 17.8833 | 17.66 | 17.6967 | 58000.0 |
| 2007-06-25 | BND | ETF | 74.1 | 74.18 | 73.97 | 74.1 | 85500.0 |
| 2007-06-25 | BNE | ETF | 19.17 | 19.44 | 19.0 | 19.15 | 339100.0 |
| 2007-06-25 | BRF | ETF | 14.6 | 14.6 | 14.48 | 14.51 | 24900.0 |
| 2007-06-25 | BSV | ETF | 74.83 | 74.93 | 74.83 | 74.91 | 45900.0 |
| 2007-06-25 | BTF | ETF | 107.10000000000001 | 107.65 | 107.10000000000001 | 107.24999999999999 | 620.0 |
| 2007-06-25 | CBON | ETF | 28.26 | 28.31 | 27.52 | 27.67 | 87212.0 |
| 2007-06-25 | CDL | ETF | 6.12 | 6.17 | 6.0 | 6.0 | 7086796.0 |
| 2007-06-25 | CEF | ETF | 9.2 | 9.21 | 9.1 | 9.1 | 191500.0 |
| 2007-06-25 | CGO | ETF | 18.19 | 18.33 | 18.1 | 18.11 | 34100.0 |
| 2007-06-25 | CGW | ETF | 25.3 | 25.45 | 25.05 | 25.15 | 281100.0 |
| 2007-06-25 | CHB | ETF | 10.33 | 10.39 | 10.03 | 10.21 | 1280700.0 |
| 2007-06-25 | CHI | ETF | 19.86 | 19.88 | 19.5 | 19.58 | 125300.0 |
| 2007-06-25 | CHIC | ETF | 27.29 | 27.32 | 26.66 | 26.72 | 425572.0 |
| 2007-06-25 | CHY | ETF | 16.02 | 16.05 | 15.52 | 15.75 | 480500.0 |
| 2007-06-25 | CN | ETF | 58.32 | 58.98 | 57.67 | 58.1 | 98700.0 |
| 2007-06-25 | CNXT | ETF | 1.5 | 1.5 | 1.41 | 1.43 | 8366555.0 |
| 2007-06-25 | CPI | ETF | 22.6 | 22.6 | 22.5 | 22.5 | 400.0 |
| 2007-06-25 | CPST | ETF | 1.08 | 1.12 | 1.04 | 1.08 | 2274370.0 |
| 2007-06-25 | CSA | ETF | 20.0 | 20.05 | 19.69 | 19.75 | 25700.0 |
| 2007-06-25 | CSB | ETF | 32.01 | 32.61 | 31.8682 | 32.26 | 28000.0 |
| 2007-06-25 | CSD | ETF | 30.94 | 30.94 | 30.57 | 30.59 | 20600.0 |
| 2007-06-25 | CSM | ETF | 1.42 | 1.4225 | 1.4125 | 1.4125 | 2800.0 |
| 2007-06-25 | CSQ | ETF | 15.08 | 15.08 | 14.85 | 14.87 | 388200.0 |
| 2007-06-25 | CTEC | ETF | 110.29999999999998 | 110.29999999999998 | 107.14999999999999 | 108.0005 | 35967.0 |
| 2007-06-25 | CVY | ETF | 27.58 | 27.59 | 27.28 | 27.36 | 24600.0 |
| 2007-06-25 | CWI | ETF | 27.0667 | 27.3 | 26.9333 | 26.9867 | 16500.0 |
| 2007-06-25 | DBA | ETF | 26.7 | 26.7 | 26.2 | 26.3 | 258000.0 |
| 2007-06-25 | DBB | ETF | 26.18 | 26.7 | 26.17 | 26.68 | 20700.0 |
| 2007-06-25 | DBC | ETF | 25.92 | 26.19 | 25.78 | 26.14 | 397300.0 |
| 2007-06-25 | DBE | ETF | 28.6 | 29.08 | 28.57 | 29.03 | 9700.0 |
| 2007-06-25 | DBO | ETF | 26.9 | 27.36 | 26.85 | 27.28 | 18400.0 |
| 2007-06-25 | DBP | ETF | 25.45 | 25.65 | 25.45 | 25.53 | 14900.0 |
| 2007-06-25 | DBS | ETF | 25.36 | 25.48 | 25.32 | 25.35 | 9000.0 |
> showing 50 of 487 rows — these rows as CSV