PREVIEW / etf_daily / 2005-04-12
file: by_date/etf_daily/2005/2005-04-12.parquet size: 14 KB rows: 261
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-12 | SPY | ETF | 117.89 | 119.06 | 117.07 | 118.7 | 86144800.0 |
| 2005-04-12 | QQQ | ETF | 36.44 | 36.74 | 35.91 | 36.66 | 145341318.0 |
| 2005-04-12 | IWM | ETF | 60.26 | 61.055 | 59.65 | 60.915 | 32519000.0 |
| 2005-04-12 | DIA | ETF | 104.2 | 105.3 | 103.56 | 104.99 | 9085300.0 |
| 2005-04-12 | GLD | ETF | 42.7 | 42.84 | 42.61 | 42.84 | 2098700.0 |
| 2005-04-12 | TLT | ETF | 89.23 | 90.4 | 89.12 | 90.26 | 1931500.0 |
| 2005-04-12 | AAA | ETF | 66.0 | 66.5 | 65.7 | 66.5 | 2100.0 |
| 2005-04-12 | ADRE | ETF | 84.15 | 86.0 | 84.15 | 85.22 | 5808.0 |
| 2005-04-12 | AFK | ETF | 25.85 | 26.0 | 25.62 | 25.68 | 11800.0 |
| 2005-04-12 | AGG | ETF | 101.09 | 101.61 | 101.0 | 101.47 | 150600.0 |
| 2005-04-12 | AIQ | ETF | 52.0 | 53.95 | 51.13 | 52.65 | 47080.0 |
| 2005-04-12 | ARB | ETF | 43.1 | 43.46 | 42.8 | 43.3 | 284600.0 |
| 2005-04-12 | BAB | ETF | 50.93 | 51.46 | 50.47 | 51.37 | 30100.0 |
| 2005-04-12 | BBH | ETF | 47.5 | 48.67 | 47.3333 | 48.45 | 2745900.0 |
| 2005-04-12 | BCM | ETF | 59.71 | 59.99 | 59.3 | 59.88 | 15800.0 |
| 2005-04-12 | BIS | ETF | 609.6 | 609.6 | 601.6 | 601.6 | 43.75 |
| 2005-04-12 | BITS | ETF | 12.84 | 12.84 | 11.76 | 11.88 | 18840.0 |
| 2005-04-12 | BKF | ETF | 39.9 | 40.45 | 39.75 | 40.25 | 25100.0 |
| 2005-04-12 | BNE | ETF | 14.88 | 15.13 | 14.8 | 15.04 | 244300.0 |
| 2005-04-12 | BRF | ETF | 15.4 | 15.49 | 15.34 | 15.48 | 9200.0 |
| 2005-04-12 | BTF | ETF | 86.05 | 87.14999999999999 | 85.95 | 87.05 | 2360.0 |
| 2005-04-12 | CBON | ETF | 26.49 | 27.2 | 25.49 | 25.99 | 73890.0 |
| 2005-04-12 | CDC | ETF | 8.28 | 8.28 | 8.0 | 8.15 | 4800.0 |
| 2005-04-12 | CDL | ETF | 14.01 | 14.06 | 13.85 | 13.89 | 314600.0 |
| 2005-04-12 | CEF | ETF | 5.41 | 5.42 | 5.32 | 5.34 | 286800.0 |
| 2005-04-12 | CEW | ETF | 26.42 | 26.42 | 26.42 | 26.42 | 200.0 |
| 2005-04-12 | CHB | ETF | 9.36 | 9.45 | 9.17 | 9.45 | 302300.0 |
| 2005-04-12 | CHIC | ETF | 12.24 | 12.5 | 12.2 | 12.48 | 220714.0 |
| 2005-04-12 | CHIR | ETF | 37.6299 | 37.7901 | 36.75 | 37.7001 | 1220451.0 |
| 2005-04-12 | CID | ETF | 9.95 | 10.05 | 9.94 | 10.03 | 22100.0 |
| 2005-04-12 | CIL | ETF | 26.04 | 26.19 | 26.04 | 26.19 | 1800.0 |
| 2005-04-12 | CN | ETF | 27.3 | 27.3 | 27.0 | 27.3 | 75800.0 |
| 2005-04-12 | CNXT | ETF | 1.42 | 1.44 | 1.38 | 1.39 | 3592345.0 |
| 2005-04-12 | CSB | ETF | 33.52 | 33.73 | 33.22 | 33.68 | 11800.0 |
| 2005-04-12 | CSM | ETF | 2.38 | 2.38 | 2.38 | 2.38 | 6800.0 |
| 2005-04-12 | CTEC | ETF | 50.75 | 52.300000000000004 | 49.74999999999999 | 52.099999999999994 | 7415.0 |
| 2005-04-12 | CURE | ETF | 0.4062 | 0.4062 | 0.39 | 0.3937 | 1114736.0 |
| 2005-04-12 | CYA | ETF | 169.0 | 169.0 | 160.0 | 169.0 | 750.0 |
| 2005-04-12 | CYB | ETF | 4.29 | 4.29 | 4.16 | 4.25 | 4800.0 |
| 2005-04-12 | CZA | ETF | 10.42 | 10.43 | 10.42 | 10.43 | 300.0 |
| 2005-04-12 | DGT | ETF | 63.8 | 63.8 | 63.17 | 63.17 | 11900.0 |
| 2005-04-12 | DIG | ETF | 12.075 | 12.075 | 12.075 | 12.075 | 480.0 |
| 2005-04-12 | DIV | ETF | 13.12 | 13.17 | 13.11 | 13.14 | 17000.0 |
| 2005-04-12 | DJP | ETF | 27.11 | 27.11 | 27.11 | 27.11 | 600.0 |
| 2005-04-12 | DRIV | ETF | 30.88 | 30.88 | 29.78 | 30.5 | 660636.0 |
| 2005-04-12 | DSI | ETF | 5.995 | 5.995 | 5.995 | 5.995 | 2000.0 |
| 2005-04-12 | DUSA | ETF | 9.34 | 9.73 | 9.06 | 9.69 | 56069.0 |
| 2005-04-12 | DVY | ETF | 59.94 | 60.48 | 59.46 | 60.37 | 418200.0 |
| 2005-04-12 | EDEN | ETF | 0.51 | 0.58 | 0.51 | 0.53 | 35050.0 |
| 2005-04-12 | EDV | ETF | 25.9 | 25.9 | 25.77 | 25.87 | 18600.0 |
> showing 50 of 261 rows — these rows as CSV