PREVIEW / etf_daily / 2007-08-10
file: by_date/etf_daily/2007/2007-08-10.parquet size: 23 KB rows: 498
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-08-10 | SPY | ETF | 144.39 | 146.5 | 143.12 | 144.71 | 411018400.0 |
| 2007-08-10 | QQQ | ETF | 47.21 | 47.83 | 46.63 | 47.28 | 247012970.0 |
| 2007-08-10 | IWM | ETF | 76.91 | 79.77 | 76.43 | 78.06 | 267042500.0 |
| 2007-08-10 | DIA | ETF | 131.9 | 133.12 | 130.64 | 131.94 | 37277200.0 |
| 2007-08-10 | GLD | ETF | 65.44 | 66.96 | 65.44 | 66.57 | 8831700.0 |
| 2007-08-10 | TLT | ETF | 86.49 | 86.7 | 85.98 | 86.08 | 1496400.0 |
| 2007-08-10 | ADRE | ETF | 43.44 | 44.29 | 42.5 | 44.0 | 570712.0 |
| 2007-08-10 | AGG | ETF | 98.68 | 98.68 | 98.12 | 98.15 | 398700.0 |
| 2007-08-10 | AIQ | ETF | 38.85 | 39.3 | 37.5 | 38.7 | 132140.0 |
| 2007-08-10 | AIS | ETF | 1.38 | 1.43 | 1.31 | 1.36 | 545200.0 |
| 2007-08-10 | ARB | ETF | 51.92 | 53.3 | 50.5 | 52.94 | 623900.0 |
| 2007-08-10 | BBH | ETF | 54.3333 | 54.3333 | 53.1767 | 53.5167 | 1284900.0 |
| 2007-08-10 | BIL | ETF | 91.76 | 91.78 | 91.74 | 91.76 | 112100.0 |
| 2007-08-10 | BITS | ETF | 25.4 | 26.68 | 25.0 | 26.68 | 25903.0 |
| 2007-08-10 | BIV | ETF | 74.41 | 74.43 | 74.2 | 74.21 | 8600.0 |
| 2007-08-10 | BLV | ETF | 73.43 | 73.48 | 73.09 | 73.12 | 2800.0 |
| 2007-08-10 | BMVP | ETF | 15.7 | 16.4267 | 15.3633 | 16.37 | 336700.0 |
| 2007-08-10 | BND | ETF | 74.69 | 74.69 | 74.31 | 74.39 | 33900.0 |
| 2007-08-10 | BNE | ETF | 14.29 | 16.19 | 14.22 | 16.08 | 811300.0 |
| 2007-08-10 | BRF | ETF | 14.49 | 14.53 | 14.49 | 14.5 | 4300.0 |
| 2007-08-10 | BSV | ETF | 75.32 | 75.36 | 75.17 | 75.21 | 45700.0 |
| 2007-08-10 | BTF | ETF | 102.5 | 103.2 | 102.35 | 103.2 | 3180.0 |
| 2007-08-10 | CBON | ETF | 23.23 | 23.87 | 22.65 | 23.78 | 189118.0 |
| 2007-08-10 | CDL | ETF | 4.2 | 4.99 | 4.17 | 4.93 | 5798654.0 |
| 2007-08-10 | CEF | ETF | 9.15 | 9.36 | 9.13 | 9.3 | 273300.0 |
| 2007-08-10 | CGO | ETF | 16.2 | 16.2 | 15.67 | 16.09 | 42900.0 |
| 2007-08-10 | CGW | ETF | 24.55 | 24.72 | 24.25 | 24.58 | 185300.0 |
| 2007-08-10 | CHB | ETF | 11.43 | 12.1 | 11.08 | 11.35 | 3353950.0 |
| 2007-08-10 | CHI | ETF | 16.75 | 16.77 | 16.35 | 16.41 | 236000.0 |
| 2007-08-10 | CHIC | ETF | 16.13 | 16.95 | 15.67 | 16.89 | 987862.0 |
| 2007-08-10 | CHW | ETF | 13.8 | 13.91 | 13.4 | 13.87 | 86800.0 |
| 2007-08-10 | CHY | ETF | 14.4 | 14.4 | 14.0 | 14.06 | 311300.0 |
| 2007-08-10 | CN | ETF | 47.6 | 49.43 | 47.03 | 49.11 | 252400.0 |
| 2007-08-10 | CNXT | ETF | 1.21 | 1.3 | 1.18 | 1.26 | 14379523.0 |
| 2007-08-10 | CPI | ETF | 28.0 | 28.0 | 28.0 | 28.0 | 1000.0 |
| 2007-08-10 | CPST | ETF | 1.02 | 1.1 | 0.92 | 1.04 | 1533165.0 |
| 2007-08-10 | CSA | ETF | 16.91 | 17.24 | 16.3 | 16.83 | 65200.0 |
| 2007-08-10 | CSD | ETF | 28.19 | 28.71 | 27.83 | 28.7 | 73600.0 |
| 2007-08-10 | CSQ | ETF | 13.97 | 13.99 | 13.7 | 13.8 | 357500.0 |
| 2007-08-10 | CTEC | ETF | 102.39999999999999 | 104.19999999999999 | 99.60000000000001 | 101.25 | 73473.0 |
| 2007-08-10 | CVY | ETF | 25.34 | 25.57 | 24.99 | 25.49 | 34400.0 |
| 2007-08-10 | CWI | ETF | 25.94 | 26.2867 | 25.9067 | 26.26 | 28500.0 |
| 2007-08-10 | CZA | ETF | 25.05 | 25.05 | 25.05 | 25.05 | 4000.0 |
| 2007-08-10 | DBA | ETF | 26.17 | 26.58 | 25.88 | 26.38 | 150400.0 |
| 2007-08-10 | DBB | ETF | 25.91 | 26.31 | 25.8 | 26.28 | 30800.0 |
| 2007-08-10 | DBC | ETF | 25.12 | 25.54 | 24.98 | 25.53 | 462400.0 |
| 2007-08-10 | DBE | ETF | 27.72 | 28.09 | 27.58 | 27.99 | 29700.0 |
| 2007-08-10 | DBO | ETF | 26.2 | 26.58 | 26.17 | 26.41 | 53100.0 |
| 2007-08-10 | DBP | ETF | 25.91 | 26.31 | 25.88 | 26.21 | 10000.0 |
| 2007-08-10 | DBS | ETF | 25.12 | 25.503 | 25.05 | 25.28 | 3400.0 |
> showing 50 of 498 rows — these rows as CSV