PREVIEW / etf_daily / 2007-05-11
file: by_date/etf_daily/2007/2007-05-11.parquet size: 22 KB rows: 466
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-11 | SPY | ETF | 149.75 | 150.93 | 149.72 | 150.86 | 113408900.0 |
| 2007-05-11 | QQQ | ETF | 46.24 | 46.78 | 46.18 | 46.78 | 107549307.0 |
| 2007-05-11 | IWM | ETF | 81.75 | 82.45 | 81.65 | 82.34 | 57249600.0 |
| 2007-05-11 | DIA | ETF | 132.64 | 133.56 | 132.6 | 133.56 | 10151200.0 |
| 2007-05-11 | GLD | ETF | 66.13 | 66.66 | 66.13 | 66.45 | 2937300.0 |
| 2007-05-11 | TLT | ETF | 88.64 | 88.7 | 88.13 | 88.19 | 1238400.0 |
| 2007-05-11 | AAA | ETF | 70.8 | 70.86 | 68.67 | 69.44 | 54400.0 |
| 2007-05-11 | ADRE | ETF | 42.23 | 42.76 | 42.23 | 42.68 | 134835.0 |
| 2007-05-11 | AGG | ETF | 100.22 | 100.23 | 99.84 | 99.91 | 185100.0 |
| 2007-05-11 | AIQ | ETF | 44.5 | 44.85 | 44.0 | 44.25 | 137020.0 |
| 2007-05-11 | AIS | ETF | 1.62 | 1.74 | 1.62 | 1.74 | 556100.0 |
| 2007-05-11 | ARB | ETF | 48.48 | 49.19 | 48.48 | 49.06 | 401200.0 |
| 2007-05-11 | BAB | ETF | 96.24 | 97.75 | 96.18 | 97.56 | 52700.0 |
| 2007-05-11 | BBH | ETF | 60.05 | 60.56 | 59.5833 | 60.4333 | 835200.0 |
| 2007-05-11 | BITS | ETF | 31.6 | 32.6 | 31.52 | 32.28 | 16286.0 |
| 2007-05-11 | BIV | ETF | 75.54 | 75.55 | 75.29 | 75.29 | 45600.0 |
| 2007-05-11 | BLV | ETF | 75.75 | 75.75 | 75.42 | 75.42 | 5700.0 |
| 2007-05-11 | BMVP | ETF | 17.97 | 18.052 | 17.937 | 18.052 | 30400.0 |
| 2007-05-11 | BND | ETF | 75.47 | 75.47 | 75.26 | 75.28 | 38200.0 |
| 2007-05-11 | BNE | ETF | 17.3 | 18.11 | 17.2 | 18.0 | 462400.0 |
| 2007-05-11 | BOSS | ETF | 48.0 | 50.2 | 48.0 | 50.2 | 100.0 |
| 2007-05-11 | BRF | ETF | 14.51 | 14.54 | 14.51 | 14.53 | 7700.0 |
| 2007-05-11 | BSV | ETF | 75.31 | 75.32 | 75.22 | 75.23 | 8800.0 |
| 2007-05-11 | BTF | ETF | 111.95 | 112.44999999999999 | 111.95 | 112.44999999999999 | 220.0 |
| 2007-05-11 | CBON | ETF | 30.34 | 30.86 | 30.33 | 30.53 | 29389.0 |
| 2007-05-11 | CDL | ETF | 8.61 | 8.68 | 8.6 | 8.62 | 905200.0 |
| 2007-05-11 | CEF | ETF | 9.25 | 9.33 | 9.23 | 9.27 | 272600.0 |
| 2007-05-11 | CGO | ETF | 17.98 | 18.02 | 17.86 | 18.0 | 19700.0 |
| 2007-05-11 | CHB | ETF | 11.16 | 11.51 | 11.16 | 11.31 | 1640328.0 |
| 2007-05-11 | CHI | ETF | 20.26 | 20.35 | 20.22 | 20.26 | 70100.0 |
| 2007-05-11 | CHIC | ETF | 25.96 | 26.22 | 25.5 | 25.59 | 315096.0 |
| 2007-05-11 | CHY | ETF | 17.1 | 17.16 | 17.09 | 17.14 | 96600.0 |
| 2007-05-11 | CIL | ETF | 25.87 | 25.87 | 25.87 | 25.87 | 200.0 |
| 2007-05-11 | CN | ETF | 48.62 | 52.44 | 48.62 | 50.68 | 390813.0 |
| 2007-05-11 | CNXT | ETF | 1.48 | 1.49 | 1.45 | 1.46 | 2515203.0 |
| 2007-05-11 | CPI | ETF | 23.6501 | 23.6501 | 23.6501 | 23.6501 | 400.0 |
| 2007-05-11 | CPST | ETF | 0.8779 | 0.95 | 0.87 | 0.95 | 3093539.0 |
| 2007-05-11 | CSA | ETF | 20.7 | 21.15 | 20.68 | 21.0 | 25100.0 |
| 2007-05-11 | CSB | ETF | 32.09 | 32.42 | 32.01 | 32.35 | 25400.0 |
| 2007-05-11 | CSD | ETF | 29.2 | 29.5 | 29.18 | 29.44 | 110400.0 |
| 2007-05-11 | CSM | ETF | 1.3875 | 1.39 | 1.38 | 1.39 | 21600.0 |
| 2007-05-11 | CSQ | ETF | 15.38 | 15.41 | 15.31 | 15.41 | 375400.0 |
| 2007-05-11 | CTEC | ETF | 88.94999999999999 | 89.0 | 86.8 | 88.35000000000001 | 23308.800000000003 |
| 2007-05-11 | CVY | ETF | 27.93 | 27.99 | 27.91 | 27.97 | 22800.0 |
| 2007-05-11 | CWI | ETF | 26.66 | 26.8533 | 26.6467 | 26.8533 | 16500.0 |
| 2007-05-11 | CZA | ETF | 26.48 | 26.5 | 26.48 | 26.5 | 1300.0 |
| 2007-05-11 | DBA | ETF | 24.62 | 25.4 | 24.62 | 25.33 | 281300.0 |
| 2007-05-11 | DBB | ETF | 28.32 | 28.56 | 28.2 | 28.46 | 44400.0 |
| 2007-05-11 | DBC | ETF | 25.01 | 25.36 | 24.9851 | 25.35 | 204600.0 |
| 2007-05-11 | DBE | ETF | 27.66 | 27.84 | 27.66 | 27.84 | 7100.0 |
> showing 50 of 466 rows — these rows as CSV