PREVIEW / etf_daily / 2006-12-05
file: by_date/etf_daily/2006/2006-12-05.parquet size: 19 KB rows: 388
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-12-05 | SPY | ETF | 141.56 | 141.96 | 141.26 | 141.9 | 73374400.0 |
| 2006-12-05 | QQQ | ETF | 44.39 | 44.55 | 44.19 | 44.42 | 84720410.0 |
| 2006-12-05 | IWM | ETF | 79.4 | 79.76 | 79.07 | 79.38 | 39558600.0 |
| 2006-12-05 | DIA | ETF | 122.98 | 123.37 | 122.73 | 123.36 | 6599200.0 |
| 2006-12-05 | GLD | ETF | 64.25 | 64.42 | 63.36 | 63.81 | 5254600.0 |
| 2006-12-05 | TLT | ETF | 91.36 | 91.52 | 91.0 | 91.15 | 1833700.0 |
| 2006-12-05 | AAA | ETF | 59.27 | 59.48 | 59.1609 | 59.48 | 1800.0 |
| 2006-12-05 | ADRE | ETF | 37.51 | 37.9 | 37.45 | 37.88 | 285287.0 |
| 2006-12-05 | AGG | ETF | 101.03 | 101.03 | 100.75 | 100.9 | 348500.0 |
| 2006-12-05 | AIQ | ETF | 30.05 | 30.25 | 29.8 | 30.15 | 65640.0 |
| 2006-12-05 | AIS | ETF | 1.25 | 1.28 | 1.23 | 1.2489 | 46700.0 |
| 2006-12-05 | ARB | ETF | 44.95 | 44.95 | 44.24 | 44.4 | 182800.0 |
| 2006-12-05 | BAB | ETF | 98.95 | 99.84 | 98.46 | 99.7 | 59000.0 |
| 2006-12-05 | BBC | ETF | 4.76 | 5.15 | 4.76 | 5.01 | 330100.0 |
| 2006-12-05 | BBH | ETF | 62.65 | 62.9433 | 62.1467 | 62.7233 | 715200.0 |
| 2006-12-05 | BITS | ETF | 35.8 | 35.8 | 35.0 | 35.44 | 19188.0 |
| 2006-12-05 | BNE | ETF | 15.91 | 16.12 | 15.72 | 15.75 | 116100.0 |
| 2006-12-05 | BRF | ETF | 14.34 | 14.4 | 14.34 | 14.37 | 20000.0 |
| 2006-12-05 | BTF | ETF | 109.25 | 114.39999999999999 | 109.25 | 111.89999999999999 | 19340.0 |
| 2006-12-05 | CBON | ETF | 31.09 | 31.35 | 30.64 | 30.79 | 26236.0 |
| 2006-12-05 | CDL | ETF | 9.79 | 9.85 | 9.67 | 9.83 | 294600.0 |
| 2006-12-05 | CEF | ETF | 9.78 | 9.78 | 9.51 | 9.61 | 811600.0 |
| 2006-12-05 | CFO | ETF | 11.05 | 11.05 | 11.03 | 11.03 | 14300.0 |
| 2006-12-05 | CGO | ETF | 16.21 | 16.3728 | 16.21 | 16.33 | 19000.0 |
| 2006-12-05 | CHB | ETF | 9.83 | 10.07 | 9.8 | 10.01 | 1339400.0 |
| 2006-12-05 | CHI | ETF | 19.9 | 20.23 | 19.9 | 20.04 | 112300.0 |
| 2006-12-05 | CHIC | ETF | 31.55 | 31.69 | 31.21 | 31.42 | 386199.0 |
| 2006-12-05 | CHY | ETF | 17.01 | 17.08 | 17.0 | 17.01 | 105700.0 |
| 2006-12-05 | CIL | ETF | 25.08 | 25.23 | 25.08 | 25.12 | 1300.0 |
| 2006-12-05 | CN | ETF | 41.2 | 41.75 | 40.95 | 41.4 | 231900.0 |
| 2006-12-05 | CNXT | ETF | 2.2 | 2.25 | 2.17 | 2.23 | 10646163.0 |
| 2006-12-05 | CPI | ETF | 23.55 | 23.55 | 23.41 | 23.41 | 900.0 |
| 2006-12-05 | CPST | ETF | 1.37 | 1.38 | 1.35 | 1.35 | 1445989.0 |
| 2006-12-05 | CSA | ETF | 23.0 | 23.0 | 22.36 | 22.57 | 45300.0 |
| 2006-12-05 | CSB | ETF | 32.66 | 33.03 | 32.66 | 33.03 | 20500.0 |
| 2006-12-05 | CSM | ETF | 1.3375 | 1.34 | 1.3375 | 1.3375 | 68000.0 |
| 2006-12-05 | CSQ | ETF | 15.35 | 15.3861 | 15.21 | 15.24 | 392400.0 |
| 2006-12-05 | CTEC | ETF | 90.89999999999999 | 91.3 | 85.0 | 89.94999999999999 | 24611.2 |
| 2006-12-05 | CVY | ETF | 26.8 | 26.83 | 26.7 | 26.82 | 40100.0 |
| 2006-12-05 | DBC | ETF | 25.79 | 25.88 | 25.4101 | 25.73 | 161900.0 |
| 2006-12-05 | DBV | ETF | 25.02 | 25.02 | 24.9 | 24.99 | 98500.0 |
| 2006-12-05 | DDM | ETF | 7.2642 | 7.325 | 7.2567 | 7.3225 | 632400.0 |
| 2006-12-05 | DES | ETF | 19.3933 | 19.4933 | 19.3933 | 19.4133 | 38700.0 |
| 2006-12-05 | DEW | ETF | 60.56 | 60.88 | 60.53 | 60.78 | 16400.0 |
| 2006-12-05 | DFE | ETF | 63.55 | 63.8 | 63.46 | 63.78 | 24000.0 |
| 2006-12-05 | DFJ | ETF | 50.75 | 50.79 | 50.5 | 50.77 | 26800.0 |
| 2006-12-05 | DGT | ETF | 74.8 | 75.32 | 74.8 | 75.16 | 28000.0 |
| 2006-12-05 | DHS | ETF | 56.8 | 57.07 | 56.8 | 56.96 | 9200.0 |
| 2006-12-05 | DIM | ETF | 62.12 | 62.47 | 62.07 | 62.45 | 35800.0 |
| 2006-12-05 | DIV | ETF | 13.47 | 13.57 | 13.46 | 13.52 | 23900.0 |
> showing 50 of 388 rows — these rows as CSV