PREVIEW / etf_daily / 2005-05-27
file: by_date/etf_daily/2005/2005-05-27.parquet size: 14 KB rows: 260
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-05-27 | SPY | ETF | 120.06 | 120.25 | 119.8 | 120.25 | 24596100.0 |
| 2005-05-27 | QQQ | ETF | 38.14 | 38.25 | 38.02 | 38.21 | 50134134.0 |
| 2005-05-27 | IWM | ETF | 61.3 | 61.54 | 60.9 | 61.475 | 15095200.0 |
| 2005-05-27 | DIA | ETF | 105.3 | 105.44 | 105.07 | 105.37 | 2107100.0 |
| 2005-05-27 | GLD | ETF | 41.81 | 41.96 | 41.74 | 41.88 | 2453600.0 |
| 2005-05-27 | TLT | ETF | 93.74 | 93.98 | 93.54 | 93.84 | 650600.0 |
| 2005-05-27 | AAA | ETF | 61.16 | 61.7 | 60.9 | 61.7 | 46200.0 |
| 2005-05-27 | ADRE | ETF | 87.65 | 88.19 | 87.65 | 88.19 | 3992.0 |
| 2005-05-27 | AFK | ETF | 26.21 | 26.33 | 26.09 | 26.09 | 6700.0 |
| 2005-05-27 | AGG | ETF | 102.59 | 102.73 | 102.41 | 102.55 | 140400.0 |
| 2005-05-27 | AIQ | ETF | 53.5 | 53.65 | 52.8 | 53.35 | 14660.0 |
| 2005-05-27 | ARB | ETF | 40.83 | 40.86 | 40.42 | 40.56 | 170700.0 |
| 2005-05-27 | BAB | ETF | 50.44 | 50.51 | 50.23 | 50.46 | 6400.0 |
| 2005-05-27 | BBH | ETF | 55.9633 | 56.4933 | 55.8333 | 56.43 | 855000.0 |
| 2005-05-27 | BCM | ETF | 57.27 | 57.62 | 56.99 | 57.55 | 13200.0 |
| 2005-05-27 | BIS | ETF | 660.8 | 660.8 | 660.8 | 660.8 | 6.25 |
| 2005-05-27 | BITS | ETF | 10.84 | 10.84 | 10.64 | 10.7212 | 2100.0 |
| 2005-05-27 | BKF | ETF | 35.28 | 37.65 | 35.28 | 37.49 | 63900.0 |
| 2005-05-27 | BNE | ETF | 13.06 | 13.49 | 13.01 | 13.49 | 426000.0 |
| 2005-05-27 | BRF | ETF | 15.46 | 15.52 | 15.46 | 15.46 | 12200.0 |
| 2005-05-27 | BTF | ETF | 86.1 | 86.64999999999999 | 86.1 | 86.6 | 1820.0 |
| 2005-05-27 | CBON | ETF | 28.75 | 28.75 | 28.06 | 28.49 | 15980.0 |
| 2005-05-27 | CDC | ETF | 7.95 | 8.95 | 7.95 | 8.51 | 19400.0 |
| 2005-05-27 | CDL | ETF | 11.98 | 12.05 | 11.92 | 11.97 | 919000.0 |
| 2005-05-27 | CEF | ETF | 5.27 | 5.33 | 5.2 | 5.31 | 370900.0 |
| 2005-05-27 | CEW | ETF | 26.5 | 26.5 | 26.5 | 26.5 | 200.0 |
| 2005-05-27 | CGW | ETF | 28.25 | 28.25 | 27.75 | 28.05 | 600.0 |
| 2005-05-27 | CHB | ETF | 9.83 | 9.84 | 9.53 | 9.67 | 341700.0 |
| 2005-05-27 | CHIC | ETF | 11.4542 | 11.6 | 11.42 | 11.55 | 219339.0 |
| 2005-05-27 | CHIR | ETF | 37.8699 | 38.3799 | 37.56 | 38.25 | 1675911.0 |
| 2005-05-27 | CIL | ETF | 25.45 | 25.5 | 25.37 | 25.5 | 1100.0 |
| 2005-05-27 | CN | ETF | 27.32 | 27.46 | 27.25 | 27.4 | 8600.0 |
| 2005-05-27 | CNXT | ETF | 1.41 | 1.43 | 1.37 | 1.4 | 3013553.0 |
| 2005-05-27 | CPI | ETF | 22.95 | 23.04 | 22.87 | 23.04 | 10100.0 |
| 2005-05-27 | CSB | ETF | 30.95 | 30.95 | 30.5 | 30.78 | 8400.0 |
| 2005-05-27 | CTEC | ETF | 47.99999999999999 | 48.25 | 45.0 | 45.99999999999999 | 9333.4 |
| 2005-05-27 | CURE | ETF | 0.3187 | 0.3187 | 0.31 | 0.3113 | 869936.0 |
| 2005-05-27 | CYA | ETF | 168.0 | 174.0 | 168.0 | 174.0 | 200.0 |
| 2005-05-27 | CYB | ETF | 3.15 | 3.15 | 3.07 | 3.09 | 2800.0 |
| 2005-05-27 | CZA | ETF | 10.42 | 10.45 | 10.42 | 10.44 | 4600.0 |
| 2005-05-27 | DGT | ETF | 64.24 | 64.32 | 64.16 | 64.32 | 1300.0 |
| 2005-05-27 | DIG | ETF | 11.2875 | 11.3125 | 11.2875 | 11.3125 | 880.0 |
| 2005-05-27 | DIV | ETF | 13.61 | 13.62 | 13.52 | 13.56 | 9500.0 |
| 2005-05-27 | DRIV | ETF | 26.3 | 26.56 | 25.99 | 26.48 | 1049135.0 |
| 2005-05-27 | DSI | ETF | 6.01 | 6.015 | 6.01 | 6.015 | 4800.0 |
| 2005-05-27 | DUSA | ETF | 11.1 | 11.64 | 11.05 | 11.56 | 103570.0 |
| 2005-05-27 | DVY | ETF | 61.2 | 61.5 | 61.2 | 61.48 | 260900.0 |
| 2005-05-27 | EDEN | ETF | 0.59 | 0.63 | 0.55 | 0.57 | 49185.0 |
| 2005-05-27 | EDV | ETF | 26.24 | 26.4 | 26.19 | 26.39 | 8700.0 |
| 2005-05-27 | EEM | ETF | 23.1 | 23.1856 | 23.0511 | 23.1556 | 1422900.0 |
> showing 50 of 260 rows — these rows as CSV