PREVIEW / etf_daily / 2006-04-27
file: by_date/etf_daily/2006/2006-04-27.parquet size: 17 KB rows: 315
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-27 | SPY | ETF | 129.9 | 131.63 | 129.59 | 131.03 | 124478600.0 |
| 2006-04-27 | QQQ | ETF | 41.67 | 42.49 | 41.5 | 42.26 | 174121982.0 |
| 2006-04-27 | IWM | ETF | 75.52 | 76.67 | 74.89 | 75.43 | 91908800.0 |
| 2006-04-27 | DIA | ETF | 112.89 | 114.1 | 112.68 | 113.77 | 14549000.0 |
| 2006-04-27 | GLD | ETF | 62.84 | 64.0 | 62.77 | 62.96 | 6421200.0 |
| 2006-04-27 | TLT | ETF | 83.75 | 84.3 | 83.65 | 84.1 | 1864200.0 |
| 2006-04-27 | AAA | ETF | 62.32 | 62.86 | 62.09 | 62.55 | 11600.0 |
| 2006-04-27 | ADRE | ETF | 138.06 | 138.51 | 136.49 | 136.9 | 63736.0 |
| 2006-04-27 | AFK | ETF | 25.15 | 25.15 | 25.1 | 25.14 | 16900.0 |
| 2006-04-27 | AGG | ETF | 98.0 | 98.46 | 97.95 | 98.33 | 143400.0 |
| 2006-04-27 | AIQ | ETF | 25.3 | 26.8 | 25.25 | 25.95 | 9240.0 |
| 2006-04-27 | AIS | ETF | 1.6 | 1.67 | 1.56 | 1.6499 | 412100.0 |
| 2006-04-27 | AOM | ETF | 7.0 | 7.01 | 6.75 | 6.93 | 23700.0 |
| 2006-04-27 | ARB | ETF | 34.87 | 35.26 | 34.63 | 34.98 | 264400.0 |
| 2006-04-27 | BAB | ETF | 60.82 | 61.71 | 60.82 | 61.48 | 11300.0 |
| 2006-04-27 | BBC | ETF | 15.2 | 15.3399 | 14.75 | 15.0 | 139700.0 |
| 2006-04-27 | BBH | ETF | 57.0733 | 58.3633 | 56.9333 | 57.9967 | 3827400.0 |
| 2006-04-27 | BCM | ETF | 73.97 | 74.66 | 73.97 | 74.36 | 22200.0 |
| 2006-04-27 | BITS | ETF | 36.6 | 37.0 | 36.2 | 36.44 | 15898.0 |
| 2006-04-27 | BKF | ETF | 9.0 | 9.1 | 8.75 | 9.0 | 75100.0 |
| 2006-04-27 | BNE | ETF | 15.93 | 16.35 | 15.63 | 16.08 | 157500.0 |
| 2006-04-27 | BRF | ETF | 13.83 | 13.84 | 13.79 | 13.84 | 46500.0 |
| 2006-04-27 | BTF | ETF | 87.3 | 87.5 | 86.99999999999999 | 86.99999999999999 | 3020.0 |
| 2006-04-27 | CBON | ETF | 33.34 | 33.7 | 33.04 | 33.46 | 2591.0 |
| 2006-04-27 | CDL | ETF | 9.37 | 9.37 | 9.28 | 9.35 | 397300.0 |
| 2006-04-27 | CEF | ETF | 9.25 | 9.52 | 9.14 | 9.15 | 576900.0 |
| 2006-04-27 | CEW | ETF | 25.85 | 25.85 | 25.61 | 25.61 | 500.0 |
| 2006-04-27 | CFO | ETF | 10.26 | 10.26 | 10.26 | 10.26 | 1600.0 |
| 2006-04-27 | CGO | ETF | 14.24 | 14.37 | 14.16 | 14.37 | 64400.0 |
| 2006-04-27 | CHB | ETF | 15.1 | 15.33 | 14.6016 | 15.11 | 689200.0 |
| 2006-04-27 | CHI | ETF | 20.05 | 20.24 | 20.05 | 20.1 | 50700.0 |
| 2006-04-27 | CHIC | ETF | 20.8 | 21.96 | 20.6 | 21.56 | 454503.0 |
| 2006-04-27 | CHY | ETF | 15.86 | 15.97 | 15.85 | 15.94 | 54100.0 |
| 2006-04-27 | CIL | ETF | 25.73 | 25.75 | 25.73 | 25.75 | 3800.0 |
| 2006-04-27 | CIZ | ETF | 23.65 | 23.65 | 22.5 | 23.0 | 28200.0 |
| 2006-04-27 | CN | ETF | 36.23 | 36.45 | 36.11 | 36.17 | 30100.0 |
| 2006-04-27 | CNXT | ETF | 3.75 | 3.9 | 3.71 | 3.87 | 43564226.0 |
| 2006-04-27 | COMB | ETF | 9.11 | 9.91 | 9.11 | 9.9 | 5545.0 |
| 2006-04-27 | CPST | ETF | 4.25 | 4.25 | 4.04 | 4.06 | 1521778.0 |
| 2006-04-27 | CSA | ETF | 19.58 | 19.58 | 19.0 | 19.16 | 19300.0 |
| 2006-04-27 | CSB | ETF | 30.19 | 30.39 | 30.0 | 30.32 | 6400.0 |
| 2006-04-27 | CSQ | ETF | 13.93 | 14.0 | 13.81 | 13.93 | 329400.0 |
| 2006-04-27 | CTEC | ETF | 64.0 | 64.95 | 62.66 | 64.4 | 6222.0 |
| 2006-04-27 | CYB | ETF | 6.44 | 6.44 | 6.21 | 6.25 | 23900.0 |
| 2006-04-27 | DBC | ETF | 25.45 | 25.51 | 25.12 | 25.2 | 427100.0 |
| 2006-04-27 | DGT | ETF | 68.15 | 69.05 | 68.15 | 68.87 | 5100.0 |
| 2006-04-27 | DIG | ETF | 17.825 | 17.825 | 17.825 | 17.825 | 400.0 |
| 2006-04-27 | DIV | ETF | 11.98 | 12.01 | 11.95 | 11.9501 | 22600.0 |
| 2006-04-27 | DRIV | ETF | 47.4 | 47.68 | 46.45 | 47.0 | 1751869.0 |
| 2006-04-27 | DSI | ETF | 6.415 | 6.415 | 6.415 | 6.415 | 2000.0 |
> showing 50 of 315 rows — these rows as CSV