PREVIEW / etf_daily / 2005-06-01
file: by_date/etf_daily/2005/2005-06-01.parquet size: 15 KB rows: 262
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-06-01 | SPY | ETF | 119.52 | 120.92 | 119.45 | 120.5 | 69611000.0 |
| 2005-06-01 | QQQ | ETF | 38.03 | 38.68 | 38.02 | 38.39 | 110985243.0 |
| 2005-06-01 | IWM | ETF | 61.34 | 62.25 | 61.32 | 62.04 | 26634800.0 |
| 2005-06-01 | DIA | ETF | 104.64 | 105.83 | 104.61 | 105.33 | 7951400.0 |
| 2005-06-01 | GLD | ETF | 41.41 | 41.65 | 41.4 | 41.53 | 1787900.0 |
| 2005-06-01 | TLT | ETF | 95.2 | 95.84 | 95.19 | 95.81 | 3823200.0 |
| 2005-06-01 | AAA | ETF | 58.45 | 58.81 | 58.38 | 58.41 | 7100.0 |
| 2005-06-01 | ADRE | ETF | 87.7 | 88.829 | 87.68 | 88.829 | 4016.0 |
| 2005-06-01 | AFK | ETF | 26.5 | 26.5 | 26.45 | 26.45 | 11100.0 |
| 2005-06-01 | AGG | ETF | 102.69 | 103.24 | 102.59 | 103.24 | 266900.0 |
| 2005-06-01 | AIQ | ETF | 50.6 | 54.4 | 50.55 | 53.55 | 26740.0 |
| 2005-06-01 | ARB | ETF | 40.45 | 41.58 | 40.43 | 41.35 | 231200.0 |
| 2005-06-01 | BAB | ETF | 48.83 | 49.17 | 48.42 | 48.92 | 88800.0 |
| 2005-06-01 | BBH | ETF | 56.4067 | 57.4633 | 56.3667 | 57.1467 | 2186700.0 |
| 2005-06-01 | BCM | ETF | 57.98 | 58.31 | 57.98 | 58.2 | 6200.0 |
| 2005-06-01 | BITS | ETF | 11.08 | 11.1596 | 10.92 | 10.92 | 2637.0 |
| 2005-06-01 | BKF | ETF | 36.31 | 36.69 | 36.31 | 36.6 | 25800.0 |
| 2005-06-01 | BNE | ETF | 13.27 | 13.55 | 13.16 | 13.51 | 137000.0 |
| 2005-06-01 | BRF | ETF | 15.49 | 15.49 | 15.41 | 15.45 | 21800.0 |
| 2005-06-01 | BTF | ETF | 86.5 | 86.5 | 85.6 | 85.85000000000001 | 5920.0 |
| 2005-06-01 | CBON | ETF | 28.5 | 29.0 | 28.219 | 28.95 | 10020.0 |
| 2005-06-01 | CDC | ETF | 8.71 | 9.06 | 8.71 | 8.76 | 4500.0 |
| 2005-06-01 | CDL | ETF | 11.94 | 12.02 | 11.89 | 11.99 | 116500.0 |
| 2005-06-01 | CEF | ETF | 5.31 | 5.38 | 5.26 | 5.31 | 314600.0 |
| 2005-06-01 | CGW | ETF | 29.0 | 29.0 | 28.2 | 28.4 | 7300.0 |
| 2005-06-01 | CHB | ETF | 9.68 | 9.82 | 9.6 | 9.7 | 381500.0 |
| 2005-06-01 | CHIC | ETF | 12.01 | 12.28 | 11.95 | 12.25 | 319989.0 |
| 2005-06-01 | CHIR | ETF | 37.6401 | 38.1699 | 37.4601 | 37.98 | 838010.0 |
| 2005-06-01 | CIL | ETF | 25.7 | 25.7 | 25.5 | 25.5 | 600.0 |
| 2005-06-01 | CIZ | ETF | 21.6 | 22.0 | 21.6 | 21.8 | 3600.0 |
| 2005-06-01 | CN | ETF | 27.05 | 27.4 | 27.05 | 27.25 | 8100.0 |
| 2005-06-01 | CNXT | ETF | 1.45 | 1.51 | 1.41 | 1.48 | 7657873.0 |
| 2005-06-01 | CSB | ETF | 30.01 | 30.48 | 30.01 | 30.45 | 8000.0 |
| 2005-06-01 | CSM | ETF | 2.4025 | 2.4025 | 2.4025 | 2.4025 | 7600.0 |
| 2005-06-01 | CTEC | ETF | 46.199999999999996 | 46.5 | 43.49999999999999 | 45.55 | 10831.800000000001 |
| 2005-06-01 | CURE | ETF | 0.33 | 0.3375 | 0.3162 | 0.32 | 1066712.0 |
| 2005-06-01 | CYA | ETF | 173.0 | 180.0 | 173.0 | 176.0 | 375.0 |
| 2005-06-01 | CYB | ETF | 3.05 | 3.12 | 3.05 | 3.05 | 9800.0 |
| 2005-06-01 | CZA | ETF | 10.46 | 10.46 | 10.46 | 10.46 | 800.0 |
| 2005-06-01 | DGT | ETF | 64.07 | 64.32 | 63.96 | 63.96 | 1500.0 |
| 2005-06-01 | DIG | ETF | 11.6125 | 11.6125 | 11.6125 | 11.6125 | 800.0 |
| 2005-06-01 | DIV | ETF | 13.58 | 13.79 | 13.56 | 13.72 | 19300.0 |
| 2005-06-01 | DRIV | ETF | 27.87 | 27.96 | 27.29 | 27.62 | 1120051.0 |
| 2005-06-01 | DSI | ETF | 6.0 | 6.0 | 5.99 | 5.995 | 2200.0 |
| 2005-06-01 | DUSA | ETF | 11.3 | 11.3 | 11.07 | 11.16 | 44712.0 |
| 2005-06-01 | DVY | ETF | 61.45 | 62.13 | 61.33 | 61.95 | 3043500.0 |
| 2005-06-01 | EDEN | ETF | 0.59 | 0.6 | 0.57 | 0.59 | 25350.0 |
| 2005-06-01 | EDV | ETF | 26.32 | 26.47 | 26.32 | 26.32 | 7900.0 |
| 2005-06-01 | EEM | ETF | 22.8889 | 23.2444 | 22.8756 | 23.2267 | 12789000.0 |
| 2005-06-01 | EFA | ETF | 51.6867 | 52.1167 | 51.6867 | 51.9633 | 2512500.0 |
> showing 50 of 262 rows — these rows as CSV