PREVIEW / etf_daily / 2006-12-15
file: by_date/etf_daily/2006/2006-12-15.parquet size: 19 KB rows: 389
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-15 | SPY | ETF | 142.64 | 142.89 | 142.24 | 142.34 | 70857400.0 |
| 2006-12-15 | QQQ | ETF | 44.66 | 44.76 | 44.35 | 44.43 | 99954904.0 |
| 2006-12-15 | IWM | ETF | 79.3 | 79.5 | 78.81 | 78.9 | 38923800.0 |
| 2006-12-15 | DIA | ETF | 124.19 | 124.59 | 124.1 | 124.15 | 9366400.0 |
| 2006-12-15 | GLD | ETF | 62.21 | 62.22 | 60.93 | 61.0 | 7427800.0 |
| 2006-12-15 | TLT | ETF | 90.58 | 90.66 | 89.6 | 89.73 | 1162100.0 |
| 2006-12-15 | AAA | ETF | 61.25 | 61.25 | 60.77 | 60.77 | 1100.0 |
| 2006-12-15 | ADRE | ETF | 37.93 | 38.1685 | 37.75 | 37.84 | 453172.0 |
| 2006-12-15 | AGG | ETF | 100.83 | 100.83 | 100.22 | 100.31 | 314000.0 |
| 2006-12-15 | AIQ | ETF | 31.7 | 32.3 | 31.0 | 31.95 | 55000.0 |
| 2006-12-15 | AIS | ETF | 1.15 | 1.15 | 1.0782 | 1.15 | 474600.0 |
| 2006-12-15 | ARB | ETF | 44.64 | 45.0 | 44.1 | 44.1 | 289800.0 |
| 2006-12-15 | BAB | ETF | 102.58 | 102.63 | 101.71 | 101.89 | 46500.0 |
| 2006-12-15 | BBC | ETF | 4.51 | 4.65 | 4.35 | 4.49 | 342300.0 |
| 2006-12-15 | BBH | ETF | 62.3667 | 62.4667 | 61.82 | 61.9 | 698100.0 |
| 2006-12-15 | BITS | ETF | 34.2 | 34.2 | 33.8 | 33.84 | 13783.0 |
| 2006-12-15 | BNE | ETF | 15.57 | 15.69 | 15.44 | 15.56 | 293000.0 |
| 2006-12-15 | BRF | ETF | 14.28 | 14.3 | 14.27 | 14.27 | 18500.0 |
| 2006-12-15 | BTF | ETF | 113.0 | 113.49999999999999 | 111.8 | 112.87499999999999 | 2300.0 |
| 2006-12-15 | CBON | ETF | 30.39 | 30.41 | 30.22 | 30.26 | 57506.0 |
| 2006-12-15 | CDL | ETF | 9.67 | 9.88 | 9.65 | 9.82 | 518600.0 |
| 2006-12-15 | CEF | ETF | 9.45 | 9.47 | 9.19 | 9.24 | 870400.0 |
| 2006-12-15 | CFO | ETF | 11.12 | 11.1266 | 11.12 | 11.12 | 9700.0 |
| 2006-12-15 | CGO | ETF | 16.77 | 16.82 | 16.54 | 16.82 | 26400.0 |
| 2006-12-15 | CHB | ETF | 10.0 | 10.1 | 9.45 | 9.47 | 2110300.0 |
| 2006-12-15 | CHI | ETF | 20.11 | 20.19 | 20.08 | 20.16 | 75800.0 |
| 2006-12-15 | CHIC | ETF | 31.74 | 32.19 | 31.63 | 31.93 | 485271.0 |
| 2006-12-15 | CHY | ETF | 17.0 | 17.05 | 16.95 | 17.04 | 91000.0 |
| 2006-12-15 | CIL | ETF | 25.34 | 25.35 | 25.2 | 25.2 | 2400.0 |
| 2006-12-15 | CN | ETF | 49.04 | 49.29 | 48.81 | 49.23 | 97600.0 |
| 2006-12-15 | CNXT | ETF | 2.17 | 2.19 | 2.12 | 2.13 | 6505178.0 |
| 2006-12-15 | CPI | ETF | 23.68 | 23.68 | 23.5 | 23.5 | 500.0 |
| 2006-12-15 | CPST | ETF | 1.34 | 1.34 | 1.29 | 1.3 | 1006340.0 |
| 2006-12-15 | CSA | ETF | 21.31 | 21.35 | 20.84 | 20.85 | 15100.0 |
| 2006-12-15 | CSB | ETF | 33.3 | 33.3 | 33.0 | 33.07 | 10400.0 |
| 2006-12-15 | CSD | ETF | 25.24 | 25.28 | 25.2 | 25.2 | 10000.0 |
| 2006-12-15 | CSM | ETF | 1.3225 | 1.3225 | 1.3225 | 1.3225 | 400.0 |
| 2006-12-15 | CSQ | ETF | 15.6 | 15.75 | 15.49 | 15.7 | 399800.0 |
| 2006-12-15 | CTEC | ETF | 95.25 | 95.44999999999999 | 93.55 | 94.04999999999998 | 15543.800000000001 |
| 2006-12-15 | CVY | ETF | 27.11 | 27.11 | 26.91 | 26.93 | 51400.0 |
| 2006-12-15 | DBC | ETF | 25.5 | 25.52 | 25.25 | 25.52 | 233700.0 |
| 2006-12-15 | DBV | ETF | 25.6 | 25.71 | 25.51 | 25.7 | 49900.0 |
| 2006-12-15 | DDM | ETF | 7.4642 | 7.4908 | 7.4442 | 7.4575 | 1365600.0 |
| 2006-12-15 | DEF | ETF | 25.13 | 25.13 | 25.09 | 25.1199 | 4100.0 |
| 2006-12-15 | DES | ETF | 19.3867 | 19.4267 | 19.3267 | 19.3267 | 24600.0 |
| 2006-12-15 | DEW | ETF | 62.05 | 62.08 | 61.63 | 61.63 | 19200.0 |
| 2006-12-15 | DFE | ETF | 64.8 | 64.8 | 64.39 | 64.5 | 11200.0 |
| 2006-12-15 | DFJ | ETF | 51.13 | 51.36 | 50.98 | 50.99 | 31100.0 |
| 2006-12-15 | DGT | ETF | 76.05 | 76.36 | 75.8 | 76.02 | 32500.0 |
| 2006-12-15 | DHS | ETF | 58.0 | 58.14 | 57.95 | 58.09 | 17100.0 |
> showing 50 of 389 rows — these rows as CSV