PREVIEW / etf_daily / 2005-04-27
file: by_date/etf_daily/2005/2005-04-27.parquet size: 14 KB rows: 258
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-04-27 | SPY | ETF | 114.86 | 116.07 | 114.44 | 115.65 | 84131900.0 |
| 2005-04-27 | QQQ | ETF | 34.87 | 35.25 | 34.73 | 35.1 | 112639749.0 |
| 2005-04-27 | IWM | ETF | 58.125 | 58.79 | 57.615 | 58.365 | 30928600.0 |
| 2005-04-27 | DIA | ETF | 101.11 | 102.17 | 100.74 | 101.9 | 10413200.0 |
| 2005-04-27 | GLD | ETF | 43.53 | 43.54 | 43.12 | 43.2 | 2762500.0 |
| 2005-04-27 | TLT | ETF | 92.05 | 92.2 | 91.8 | 91.92 | 684900.0 |
| 2005-04-27 | AAA | ETF | 65.35 | 65.65 | 65.3 | 65.65 | 2100.0 |
| 2005-04-27 | ADRE | ETF | 84.6 | 84.6 | 82.15 | 82.391 | 6656.0 |
| 2005-04-27 | AFK | ETF | 25.68 | 25.9 | 25.67 | 25.9 | 5900.0 |
| 2005-04-27 | AGG | ETF | 102.25 | 102.36 | 101.94 | 102.23 | 70500.0 |
| 2005-04-27 | AIQ | ETF | 47.0 | 47.6 | 46.55 | 47.6 | 19880.0 |
| 2005-04-27 | ARB | ETF | 41.09 | 42.42 | 41.08 | 42.2 | 423400.0 |
| 2005-04-27 | BAB | ETF | 45.7 | 46.36 | 45.58 | 46.25 | 24200.0 |
| 2005-04-27 | BBH | ETF | 52.1667 | 52.2 | 51.5733 | 51.9667 | 2113800.0 |
| 2005-04-27 | BCM | ETF | 59.11 | 59.34 | 58.96 | 59.02 | 16000.0 |
| 2005-04-27 | BITS | ETF | 11.324 | 11.4 | 10.68 | 11.04 | 2778.0 |
| 2005-04-27 | BKF | ETF | 34.8 | 34.9 | 32.6 | 34.05 | 133300.0 |
| 2005-04-27 | BNE | ETF | 13.92 | 13.94 | 13.43 | 13.74 | 104800.0 |
| 2005-04-27 | BRF | ETF | 15.25 | 15.37 | 15.25 | 15.36 | 14500.0 |
| 2005-04-27 | BTF | ETF | 84.8 | 84.8 | 83.6 | 84.60000000000001 | 1780.0 |
| 2005-04-27 | CBON | ETF | 24.01 | 25.0 | 23.661 | 24.66 | 8781.0 |
| 2005-04-27 | CDC | ETF | 7.85 | 7.85 | 7.6 | 7.6 | 8400.0 |
| 2005-04-27 | CDL | ETF | 12.61 | 12.74 | 12.53 | 12.64 | 681100.0 |
| 2005-04-27 | CEF | ETF | 5.48 | 5.49 | 5.35 | 5.4 | 483700.0 |
| 2005-04-27 | CEW | ETF | 26.4 | 26.4 | 26.25 | 26.25 | 1000.0 |
| 2005-04-27 | CGW | ETF | 28.5 | 28.95 | 28.5 | 28.59 | 1400.0 |
| 2005-04-27 | CHB | ETF | 9.44 | 9.79 | 9.27 | 9.7 | 723600.0 |
| 2005-04-27 | CHIC | ETF | 10.94 | 11.12 | 10.79 | 10.97 | 177134.0 |
| 2005-04-27 | CHIR | ETF | 33.9 | 34.68 | 33.7701 | 34.4301 | 1617868.0 |
| 2005-04-27 | CID | ETF | 9.35 | 9.35 | 9.19 | 9.25 | 14800.0 |
| 2005-04-27 | CIL | ETF | 26.1 | 26.22 | 26.1 | 26.15 | 1500.0 |
| 2005-04-27 | CN | ETF | 26.84 | 26.9 | 26.75 | 26.9 | 11100.0 |
| 2005-04-27 | CNXT | ETF | 1.245 | 1.26 | 1.17 | 1.18 | 12513621.0 |
| 2005-04-27 | CPI | ETF | 18.1 | 18.1 | 18.1 | 18.1 | 500.0 |
| 2005-04-27 | CSB | ETF | 31.58 | 31.96 | 31.48 | 31.79 | 17600.0 |
| 2005-04-27 | CTEC | ETF | 52.5 | 54.949999999999996 | 52.24999999999999 | 52.5 | 10972.800000000001 |
| 2005-04-27 | CURE | ETF | 0.22 | 0.2263 | 0.17 | 0.1988 | 7061432.0 |
| 2005-04-27 | CYA | ETF | 161.0 | 161.0 | 152.0 | 152.0 | 700.0 |
| 2005-04-27 | CYB | ETF | 4.02 | 4.02 | 3.83 | 3.84 | 74900.0 |
| 2005-04-27 | CZA | ETF | 10.12 | 10.12 | 10.12 | 10.12 | 2500.0 |
| 2005-04-27 | DGT | ETF | 62.7 | 62.83 | 62.44 | 62.83 | 2600.0 |
| 2005-04-27 | DIG | ETF | 11.625 | 11.625 | 11.4375 | 11.4375 | 2000.0 |
| 2005-04-27 | DIV | ETF | 12.87 | 12.9 | 12.8 | 12.9 | 21000.0 |
| 2005-04-27 | DRIV | ETF | 29.63 | 29.72 | 28.55 | 28.91 | 2269067.0 |
| 2005-04-27 | DSI | ETF | 5.87 | 5.89 | 5.87 | 5.89 | 6800.0 |
| 2005-04-27 | DUSA | ETF | 9.99 | 10.18 | 9.84 | 10.02 | 36239.0 |
| 2005-04-27 | DVY | ETF | 58.8 | 59.56 | 58.56 | 59.36 | 414900.0 |
| 2005-04-27 | EDEN | ETF | 0.58 | 0.58 | 0.53 | 0.53 | 18467.0 |
| 2005-04-27 | EDV | ETF | 26.15 | 26.2 | 26.12 | 26.16 | 5300.0 |
| 2005-04-27 | EEM | ETF | 22.2111 | 22.3078 | 22.0222 | 22.1644 | 5884200.0 |
> showing 50 of 258 rows — these rows as CSV