PREVIEW / etf_daily / 2005-07-11
file: by_date/etf_daily/2005/2005-07-11.parquet size: 15 KB rows: 271
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-11 | SPY | ETF | 121.33 | 122.1 | 121.31 | 121.94 | 49688300.0 |
| 2005-07-11 | QQQ | ETF | 37.87 | 38.16 | 37.8 | 38.12 | 96455481.0 |
| 2005-07-11 | IWM | ETF | 66.01 | 66.99 | 65.98 | 66.78 | 35662900.0 |
| 2005-07-11 | DIA | ETF | 104.63 | 105.38 | 104.63 | 105.24 | 6848700.0 |
| 2005-07-11 | GLD | ETF | 42.33 | 42.57 | 42.28 | 42.54 | 2252900.0 |
| 2005-07-11 | TLT | ETF | 94.11 | 94.65 | 93.95 | 94.63 | 982000.0 |
| 2005-07-11 | AAA | ETF | 50.64 | 51.09 | 50.64 | 51.0 | 11800.0 |
| 2005-07-11 | ADRE | ETF | 93.28 | 93.72 | 93.03 | 93.43 | 12220.0 |
| 2005-07-11 | AFK | ETF | 25.98 | 26.09 | 25.83 | 25.83 | 69000.0 |
| 2005-07-11 | AGG | ETF | 102.18 | 102.47 | 102.15 | 102.43 | 141800.0 |
| 2005-07-11 | AIQ | ETF | 55.15 | 56.6 | 54.95 | 55.9 | 22180.0 |
| 2005-07-11 | AIS | ETF | 1.19 | 1.19 | 1.15 | 1.19 | 29100.0 |
| 2005-07-11 | ARB | ETF | 43.48 | 43.48 | 42.15 | 42.75 | 361100.0 |
| 2005-07-11 | BAB | ETF | 47.16 | 47.51 | 46.77 | 47.51 | 34800.0 |
| 2005-07-11 | BBH | ETF | 59.11 | 59.5667 | 58.96 | 59.1267 | 2040300.0 |
| 2005-07-11 | BCM | ETF | 62.67 | 63.32 | 62.66 | 63.03 | 11700.0 |
| 2005-07-11 | BIS | ETF | 616.0 | 651.2 | 616.0 | 651.2 | 44.4 |
| 2005-07-11 | BITS | ETF | 13.84 | 14.8 | 13.2 | 13.6 | 10503.0 |
| 2005-07-11 | BKF | ETF | 37.5 | 37.55 | 37.09 | 37.09 | 21700.0 |
| 2005-07-11 | BNE | ETF | 14.3 | 14.56 | 14.29 | 14.37 | 365800.0 |
| 2005-07-11 | BRF | ETF | 15.5 | 15.51 | 15.49 | 15.5 | 6000.0 |
| 2005-07-11 | BTF | ETF | 87.55 | 87.6 | 87.24999999999999 | 87.2525 | 1800.0 |
| 2005-07-11 | CBON | ETF | 30.81 | 31.5 | 30.57 | 31.25 | 72025.0 |
| 2005-07-11 | CDC | ETF | 6.72 | 6.75 | 6.71 | 6.75 | 2100.0 |
| 2005-07-11 | CDL | ETF | 11.75 | 11.81 | 11.65 | 11.75 | 2287500.0 |
| 2005-07-11 | CEF | ETF | 5.25 | 5.32 | 5.25 | 5.29 | 192700.0 |
| 2005-07-11 | CEW | ETF | 26.55 | 26.6 | 26.55 | 26.6 | 5700.0 |
| 2005-07-11 | CHB | ETF | 10.39 | 10.66 | 10.37 | 10.6 | 368000.0 |
| 2005-07-11 | CHI | ETF | 20.1 | 20.15 | 19.9 | 20.02 | 101400.0 |
| 2005-07-11 | CHIC | ETF | 12.89 | 13.3 | 12.89 | 13.3 | 287572.0 |
| 2005-07-11 | CHIR | ETF | 36.3801 | 36.3801 | 35.67 | 35.9199 | 724631.0 |
| 2005-07-11 | CHY | ETF | 16.75 | 16.8 | 16.7 | 16.76 | 105700.0 |
| 2005-07-11 | CIL | ETF | 25.76 | 25.77 | 25.76 | 25.77 | 1000.0 |
| 2005-07-11 | CN | ETF | 29.75 | 30.1 | 29.5 | 29.7 | 20300.0 |
| 2005-07-11 | CNXT | ETF | 1.71 | 1.85 | 1.71 | 1.83 | 11115927.0 |
| 2005-07-11 | CPI | ETF | 23.8 | 24.0 | 23.8 | 24.0 | 1200.0 |
| 2005-07-11 | CPST | ETF | 1.59 | 1.64 | 1.52 | 1.52 | 617620.0 |
| 2005-07-11 | CSB | ETF | 28.95 | 29.35 | 28.95 | 29.24 | 8000.0 |
| 2005-07-11 | CSQ | ETF | 14.2 | 14.27 | 14.13 | 14.24 | 536500.0 |
| 2005-07-11 | CTEC | ETF | 55.0 | 55.49999999999999 | 53.4 | 53.550000000000004 | 10233.0 |
| 2005-07-11 | CURE | ETF | 0.3113 | 0.3125 | 0.3 | 0.3088 | 545368.0 |
| 2005-07-11 | CYA | ETF | 137.0 | 140.8 | 136.2 | 140.8 | 105.0 |
| 2005-07-11 | CYB | ETF | 3.05 | 3.05 | 2.95 | 3.0 | 6400.0 |
| 2005-07-11 | DGT | ETF | 63.68 | 64.15 | 63.68 | 63.88 | 2800.0 |
| 2005-07-11 | DIG | ETF | 12.4875 | 12.5625 | 12.4875 | 12.5625 | 11360.0 |
| 2005-07-11 | DIV | ETF | 13.85 | 13.95 | 13.8 | 13.89 | 44500.0 |
| 2005-07-11 | DRIV | ETF | 34.12 | 35.75 | 34.12 | 35.65 | 1003426.0 |
| 2005-07-11 | DSI | ETF | 5.835 | 5.835 | 5.835 | 5.835 | 400.0 |
| 2005-07-11 | DUSA | ETF | 9.43 | 9.48 | 9.35 | 9.4 | 48870.0 |
| 2005-07-11 | DVY | ETF | 62.76 | 63.17 | 62.75 | 63.15 | 2946100.0 |
> showing 50 of 271 rows — these rows as CSV