PREVIEW / etf_daily / 2007-09-06
file: by_date/etf_daily/2007/2007-09-06.parquet size: 22 KB rows: 490
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-09-06 | SPY | ETF | 147.95 | 148.61 | 147.12 | 148.13 | 127878400.0 |
| 2007-09-06 | QQQ | ETF | 49.23 | 49.36 | 48.81 | 49.14 | 99222587.0 |
| 2007-09-06 | IWM | ETF | 79.07 | 79.37 | 78.2 | 79.03 | 65069100.0 |
| 2007-09-06 | DIA | ETF | 133.48 | 133.98 | 132.76 | 133.53 | 10084000.0 |
| 2007-09-06 | GLD | ETF | 67.92 | 69.08 | 67.89 | 68.86 | 15880800.0 |
| 2007-09-06 | TLT | ETF | 89.31 | 89.49 | 88.95 | 89.04 | 1768400.0 |
| 2007-09-06 | ADRE | ETF | 47.21 | 47.44 | 46.81 | 47.27 | 150398.0 |
| 2007-09-06 | AGG | ETF | 99.64 | 99.73 | 99.51 | 99.58 | 761000.0 |
| 2007-09-06 | AIQ | ETF | 45.4 | 45.85 | 44.5 | 44.75 | 16300.0 |
| 2007-09-06 | AIS | ETF | 1.44 | 1.44 | 1.39 | 1.42 | 152700.0 |
| 2007-09-06 | ARB | ETF | 48.5 | 48.9 | 48.13 | 48.7 | 248400.0 |
| 2007-09-06 | BBH | ETF | 56.63 | 57.4333 | 56.5867 | 57.1667 | 580200.0 |
| 2007-09-06 | BIL | ETF | 91.68 | 91.68 | 91.6 | 91.66 | 14500.0 |
| 2007-09-06 | BITS | ETF | 27.1196 | 27.16 | 26.76 | 26.8 | 4628.0 |
| 2007-09-06 | BIV | ETF | 75.53 | 75.63 | 75.35 | 75.39 | 30800.0 |
| 2007-09-06 | BLV | ETF | 75.1 | 75.1 | 74.73 | 74.89 | 2200.0 |
| 2007-09-06 | BMVP | ETF | 16.86 | 16.89 | 16.73 | 16.85 | 45700.0 |
| 2007-09-06 | BND | ETF | 75.44 | 75.47 | 75.27 | 75.34 | 46500.0 |
| 2007-09-06 | BNE | ETF | 17.16 | 17.17 | 16.98 | 17.09 | 402800.0 |
| 2007-09-06 | BRF | ETF | 14.57 | 14.57 | 14.56 | 14.56 | 13700.0 |
| 2007-09-06 | BSV | ETF | 75.76 | 75.82 | 75.7 | 75.79 | 49700.0 |
| 2007-09-06 | BTF | ETF | 106.4 | 106.4 | 105.85000000000001 | 105.85000000000001 | 2140.0 |
| 2007-09-06 | CBON | ETF | 24.22 | 24.89 | 24.22 | 24.75 | 52089.0 |
| 2007-09-06 | CDL | ETF | 4.14 | 4.21 | 4.06 | 4.14 | 1163400.0 |
| 2007-09-06 | CEF | ETF | 9.31 | 9.55 | 9.31 | 9.4 | 624600.0 |
| 2007-09-06 | CGO | ETF | 17.1 | 17.12 | 16.85 | 17.01 | 28100.0 |
| 2007-09-06 | CGW | ETF | 24.58 | 24.7 | 24.4 | 24.63 | 72700.0 |
| 2007-09-06 | CHB | ETF | 10.97 | 11.13 | 10.71 | 11.03 | 1390421.0 |
| 2007-09-06 | CHI | ETF | 17.37 | 17.42 | 17.09 | 17.42 | 128900.0 |
| 2007-09-06 | CHIC | ETF | 16.65 | 17.03 | 16.65 | 16.9 | 397789.0 |
| 2007-09-06 | CHW | ETF | 14.01 | 14.08 | 13.92 | 14.04 | 98300.0 |
| 2007-09-06 | CHY | ETF | 14.94 | 15.0 | 14.82 | 14.98 | 135100.0 |
| 2007-09-06 | CN | ETF | 51.96 | 51.96 | 48.5 | 49.2 | 196000.0 |
| 2007-09-06 | CNXT | ETF | 1.2 | 1.37 | 1.19 | 1.33 | 30258099.0 |
| 2007-09-06 | CPI | ETF | 24.2 | 24.2 | 24.19 | 24.2 | 300.0 |
| 2007-09-06 | CPST | ETF | 1.22 | 1.27 | 1.21 | 1.239 | 2171258.0 |
| 2007-09-06 | CSA | ETF | 18.2 | 18.46 | 18.06 | 18.07 | 38200.0 |
| 2007-09-06 | CSD | ETF | 28.99 | 29.02 | 28.91 | 28.99 | 11000.0 |
| 2007-09-06 | CSQ | ETF | 14.18 | 14.35 | 14.15 | 14.34 | 251200.0 |
| 2007-09-06 | CTEC | ETF | 103.94999999999999 | 106.25 | 103.64999999999999 | 105.25 | 15393.800000000001 |
| 2007-09-06 | CVY | ETF | 25.97 | 25.99 | 25.85 | 25.96 | 18400.0 |
| 2007-09-06 | CWI | ETF | 26.5733 | 26.8133 | 26.5667 | 26.7667 | 20400.0 |
| 2007-09-06 | DBA | ETF | 27.09 | 27.15 | 26.75 | 26.88 | 421200.0 |
| 2007-09-06 | DBB | ETF | 24.45 | 25.03 | 24.25 | 25.01 | 83400.0 |
| 2007-09-06 | DBC | ETF | 25.91 | 26.05 | 25.8 | 25.93 | 214500.0 |
| 2007-09-06 | DBE | ETF | 28.83 | 28.83 | 28.44 | 28.64 | 110800.0 |
| 2007-09-06 | DBO | ETF | 26.93 | 27.13 | 26.85 | 27.05 | 18800.0 |
| 2007-09-06 | DBP | ETF | 26.37 | 26.76 | 26.37 | 26.67 | 11800.0 |
| 2007-09-06 | DBS | ETF | 24.29 | 24.58 | 24.09 | 24.4269 | 12200.0 |
| 2007-09-06 | DBV | ETF | 27.43 | 27.51 | 27.32 | 27.49 | 269200.0 |
> showing 50 of 490 rows — these rows as CSV