PREVIEW / etf_daily / 2006-10-10
file: by_date/etf_daily/2006/2006-10-10.parquet size: 18 KB rows: 363
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-10-10 | SPY | ETF | 135.1 | 135.45 | 134.84 | 135.27 | 56403700.0 |
| 2006-10-10 | QQQ | ETF | 41.61 | 41.75 | 41.31 | 41.62 | 98207340.0 |
| 2006-10-10 | IWM | ETF | 74.1 | 74.36 | 73.64 | 74.1 | 32950800.0 |
| 2006-10-10 | DIA | ETF | 118.67 | 118.77 | 118.3 | 118.56 | 6717700.0 |
| 2006-10-10 | GLD | ETF | 56.55 | 57.28 | 56.48 | 57.0 | 3422100.0 |
| 2006-10-10 | TLT | ETF | 87.95 | 88.11 | 87.63 | 87.81 | 1398700.0 |
| 2006-10-10 | AAA | ETF | 54.21 | 54.44 | 54.07 | 54.41 | 5800.0 |
| 2006-10-10 | ADRE | ETF | 32.73 | 33.11 | 32.62 | 33.1 | 823074.0 |
| 2006-10-10 | AGG | ETF | 99.47 | 99.5 | 99.32 | 99.35 | 336400.0 |
| 2006-10-10 | AIQ | ETF | 39.9 | 40.1 | 38.65 | 38.85 | 13100.0 |
| 2006-10-10 | AIS | ETF | 1.14 | 1.14 | 1.11 | 1.13 | 43700.0 |
| 2006-10-10 | ARB | ETF | 38.17 | 38.45 | 37.97 | 38.22 | 86800.0 |
| 2006-10-10 | BAB | ETF | 80.7 | 81.52 | 80.21 | 81.52 | 58300.0 |
| 2006-10-10 | BBC | ETF | 8.75 | 9.38 | 8.67 | 8.67 | 248700.0 |
| 2006-10-10 | BBH | ETF | 63.1167 | 63.4333 | 62.6 | 62.95 | 1269300.0 |
| 2006-10-10 | BITS | ETF | 34.4 | 36.44 | 34.4 | 36.08 | 53865.0 |
| 2006-10-10 | BNE | ETF | 15.0 | 15.05 | 14.83 | 14.95 | 101100.0 |
| 2006-10-10 | BRF | ETF | 14.22 | 14.2699 | 14.21 | 14.22 | 8900.0 |
| 2006-10-10 | BTF | ETF | 98.2 | 98.45 | 98.05 | 98.45 | 4220.0 |
| 2006-10-10 | CBON | ETF | 31.75 | 31.796 | 31.52 | 31.74 | 117830.0 |
| 2006-10-10 | CDL | ETF | 9.74 | 9.82 | 9.58 | 9.6 | 313400.0 |
| 2006-10-10 | CEF | ETF | 8.08 | 8.18 | 8.02 | 8.07 | 181200.0 |
| 2006-10-10 | CFO | ETF | 9.8 | 9.8 | 9.8 | 9.8 | 1500.0 |
| 2006-10-10 | CGO | ETF | 15.49 | 15.59 | 15.45 | 15.55 | 10400.0 |
| 2006-10-10 | CHB | ETF | 7.5 | 8.0 | 7.5 | 7.6 | 2149100.0 |
| 2006-10-10 | CHI | ETF | 19.3 | 19.35 | 19.2 | 19.27 | 110600.0 |
| 2006-10-10 | CHIC | ETF | 27.38 | 27.61 | 27.08 | 27.34 | 339079.0 |
| 2006-10-10 | CHY | ETF | 16.87 | 16.93 | 16.8 | 16.9 | 150600.0 |
| 2006-10-10 | CIL | ETF | 25.68 | 25.68 | 25.68 | 25.68 | 100.0 |
| 2006-10-10 | CN | ETF | 36.35 | 36.65 | 36.22 | 36.45 | 21600.0 |
| 2006-10-10 | CNXT | ETF | 1.831 | 1.85 | 1.8 | 1.81 | 6579378.0 |
| 2006-10-10 | COMB | ETF | 10.15 | 10.35 | 10.05 | 10.18 | 12685.0 |
| 2006-10-10 | CPST | ETF | 1.52 | 1.56 | 1.4499 | 1.56 | 1312808.0 |
| 2006-10-10 | CSA | ETF | 21.8 | 21.8 | 21.69 | 21.7 | 15200.0 |
| 2006-10-10 | CSB | ETF | 29.97 | 30.26 | 29.8 | 30.051 | 14400.0 |
| 2006-10-10 | CSQ | ETF | 14.88 | 14.88 | 14.6 | 14.69 | 440200.0 |
| 2006-10-10 | CTEC | ETF | 62.199999999999996 | 62.599999999999994 | 61.55 | 62.35 | 10125.6 |
| 2006-10-10 | CVY | ETF | 25.33 | 25.35 | 25.27 | 25.32 | 29100.0 |
| 2006-10-10 | CYB | ETF | 7.24 | 7.4 | 7.11 | 7.12 | 92400.0 |
| 2006-10-10 | DBC | ETF | 23.7 | 24.0 | 23.43 | 23.7 | 396700.0 |
| 2006-10-10 | DBV | ETF | 25.48 | 25.48 | 25.4101 | 25.45 | 55000.0 |
| 2006-10-10 | DDM | ETF | 6.7875 | 6.7933 | 6.7483 | 6.7858 | 290400.0 |
| 2006-10-10 | DES | ETF | 18.2333 | 18.3 | 18.17 | 18.2567 | 91800.0 |
| 2006-10-10 | DEW | ETF | 56.05 | 56.18 | 55.9 | 56.13 | 16800.0 |
| 2006-10-10 | DFE | ETF | 56.25 | 56.38 | 56.25 | 56.35 | 11200.0 |
| 2006-10-10 | DFJ | ETF | 48.8 | 48.8 | 48.56 | 48.66 | 21500.0 |
| 2006-10-10 | DGT | ETF | 71.95 | 72.21 | 71.84 | 72.2 | 7800.0 |
| 2006-10-10 | DHS | ETF | 55.4 | 55.5 | 55.18 | 55.38 | 31400.0 |
| 2006-10-10 | DIM | ETF | 56.78 | 56.85 | 56.66 | 56.85 | 8700.0 |
| 2006-10-10 | DIV | ETF | 12.78 | 12.79 | 12.66 | 12.6604 | 48200.0 |
> showing 50 of 363 rows — these rows as CSV