PREVIEW / etf_daily / 2006-04-17
file: by_date/etf_daily/2006/2006-04-17.parquet size: 16 KB rows: 310
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-17 | SPY | ETF | 128.83 | 129.31 | 128.02 | 128.66 | 64167700.0 |
| 2006-04-17 | QQQ | ETF | 42.04 | 42.21 | 41.39 | 41.66 | 104085141.0 |
| 2006-04-17 | IWM | ETF | 74.63 | 74.93 | 73.9 | 74.61 | 38356100.0 |
| 2006-04-17 | DIA | ETF | 111.31 | 111.62 | 110.36 | 110.83 | 5455900.0 |
| 2006-04-17 | GLD | ETF | 60.38 | 61.3 | 60.2 | 61.09 | 6072600.0 |
| 2006-04-17 | TLT | ETF | 84.54 | 84.97 | 84.35 | 84.75 | 1465400.0 |
| 2006-04-17 | AAA | ETF | 59.55 | 59.96 | 59.55 | 59.9 | 2700.0 |
| 2006-04-17 | ADRE | ETF | 132.9 | 134.41 | 132.85 | 134.23 | 36980.0 |
| 2006-04-17 | AFK | ETF | 25.05 | 25.14 | 25.01 | 25.1 | 18300.0 |
| 2006-04-17 | AGG | ETF | 98.25 | 98.39 | 98.05 | 98.37 | 109200.0 |
| 2006-04-17 | AIQ | ETF | 29.25 | 29.25 | 28.0 | 28.35 | 8120.0 |
| 2006-04-17 | AIS | ETF | 1.51 | 1.63 | 1.51 | 1.59 | 300300.0 |
| 2006-04-17 | AOM | ETF | 6.8 | 6.84 | 6.75 | 6.78 | 22800.0 |
| 2006-04-17 | ARB | ETF | 33.07 | 33.12 | 32.86 | 33.08 | 193500.0 |
| 2006-04-17 | BAB | ETF | 59.25 | 59.81 | 58.89 | 59.02 | 47100.0 |
| 2006-04-17 | BBC | ETF | 16.6 | 17.12 | 16.11 | 16.72 | 539800.0 |
| 2006-04-17 | BBH | ETF | 62.8333 | 63.18 | 61.8333 | 62.52 | 1796400.0 |
| 2006-04-17 | BCM | ETF | 72.21 | 72.55 | 72.04 | 72.41 | 14300.0 |
| 2006-04-17 | BITS | ETF | 32.84 | 38.16 | 32.84 | 36.44 | 160552.0 |
| 2006-04-17 | BKF | ETF | 9.65 | 9.65 | 9.28 | 9.38 | 60200.0 |
| 2006-04-17 | BNE | ETF | 16.29 | 16.39 | 15.72 | 15.96 | 276000.0 |
| 2006-04-17 | BRF | ETF | 13.92 | 13.95 | 13.82 | 13.89 | 14700.0 |
| 2006-04-17 | BTF | ETF | 86.5 | 86.5 | 85.99999999999999 | 85.99999999999999 | 1100.0 |
| 2006-04-17 | CBON | ETF | 30.34 | 30.6 | 30.0 | 30.35 | 32228.0 |
| 2006-04-17 | CDL | ETF | 10.8 | 10.8 | 10.62 | 10.67 | 165700.0 |
| 2006-04-17 | CEF | ETF | 9.08 | 9.42 | 9.04 | 9.31 | 960100.0 |
| 2006-04-17 | CEW | ETF | 25.7 | 25.7 | 25.6 | 25.6 | 300.0 |
| 2006-04-17 | CFO | ETF | 10.1 | 10.15 | 10.1 | 10.14 | 26200.0 |
| 2006-04-17 | CGO | ETF | 14.1 | 14.18 | 14.1 | 14.18 | 15700.0 |
| 2006-04-17 | CHB | ETF | 14.62 | 14.88 | 14.4 | 14.87 | 591900.0 |
| 2006-04-17 | CHI | ETF | 20.3 | 20.35 | 20.01 | 20.05 | 128400.0 |
| 2006-04-17 | CHIC | ETF | 20.35 | 20.9 | 20.33 | 20.43 | 435471.0 |
| 2006-04-17 | CHIR | ETF | 47.94 | 47.97 | 47.9301 | 47.9499 | 753754.0 |
| 2006-04-17 | CHY | ETF | 16.0 | 16.05 | 15.73 | 15.78 | 141800.0 |
| 2006-04-17 | CIL | ETF | 25.67 | 25.6701 | 25.67 | 25.6701 | 1300.0 |
| 2006-04-17 | CIZ | ETF | 23.75 | 23.75 | 23.75 | 23.75 | 200.0 |
| 2006-04-17 | CN | ETF | 37.15 | 37.35 | 37.05 | 37.21 | 13600.0 |
| 2006-04-17 | CNXT | ETF | 3.55 | 3.64 | 3.31 | 3.38 | 22618674.0 |
| 2006-04-17 | CPST | ETF | 4.19 | 4.24 | 3.96 | 4.02 | 4446613.0 |
| 2006-04-17 | CSA | ETF | 19.81 | 19.89 | 19.75 | 19.81 | 22100.0 |
| 2006-04-17 | CSB | ETF | 30.19 | 30.4 | 30.19 | 30.4 | 6300.0 |
| 2006-04-17 | CSQ | ETF | 13.93 | 13.96 | 13.73 | 13.77 | 243000.0 |
| 2006-04-17 | CTEC | ETF | 63.65 | 65.05 | 63.49999999999999 | 64.95 | 3753.2000000000003 |
| 2006-04-17 | CYB | ETF | 6.12 | 6.12 | 6.0 | 6.0 | 10500.0 |
| 2006-04-17 | DBC | ETF | 25.2 | 25.35 | 25.08 | 25.32 | 526600.0 |
| 2006-04-17 | DGT | ETF | 67.15 | 67.33 | 66.83 | 67.1 | 5800.0 |
| 2006-04-17 | DIG | ETF | 17.7125 | 17.9 | 17.7125 | 17.7375 | 13840.0 |
| 2006-04-17 | DIV | ETF | 12.0 | 12.0 | 11.88 | 11.9 | 17900.0 |
| 2006-04-17 | DRIV | ETF | 43.89 | 44.67 | 43.09 | 43.38 | 317165.0 |
| 2006-04-17 | DSI | ETF | 6.21 | 6.21 | 6.21 | 6.21 | 2000.0 |
> showing 50 of 310 rows — these rows as CSV