PREVIEW / etf_daily / 2006-08-14
file: by_date/etf_daily/2006/2006-08-14.parquet size: 18 KB rows: 359
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-08-14 | SPY | ETF | 127.63 | 128.16 | 126.92 | 127.11 | 57839000.0 |
| 2006-08-14 | QQQ | ETF | 36.86 | 37.27 | 36.7 | 36.77 | 109350755.0 |
| 2006-08-14 | IWM | ETF | 68.09 | 68.82 | 67.68 | 68.0 | 45029900.0 |
| 2006-08-14 | DIA | ETF | 111.62 | 112.13 | 110.89 | 111.15 | 7949500.0 |
| 2006-08-14 | GLD | ETF | 62.39 | 62.9 | 62.02 | 62.25 | 3526100.0 |
| 2006-08-14 | TLT | ETF | 85.35 | 85.37 | 85.19 | 85.25 | 662300.0 |
| 2006-08-14 | AAA | ETF | 56.69 | 56.8 | 56.4 | 56.48 | 3500.0 |
| 2006-08-14 | ADRE | ETF | 32.28 | 32.33 | 31.9 | 31.99 | 280239.0 |
| 2006-08-14 | AFK | ETF | 25.17 | 25.26 | 25.17 | 25.2 | 3000.0 |
| 2006-08-14 | AGG | ETF | 98.42 | 98.44 | 98.24 | 98.36 | 195400.0 |
| 2006-08-14 | AIQ | ETF | 30.75 | 31.8 | 30.75 | 30.95 | 24460.0 |
| 2006-08-14 | AIS | ETF | 0.95 | 0.98 | 0.9 | 0.92 | 129900.0 |
| 2006-08-14 | AOM | ETF | 5.8 | 5.94 | 5.73 | 5.9 | 12000.0 |
| 2006-08-14 | ARB | ETF | 35.68 | 36.39 | 35.68 | 35.91 | 107100.0 |
| 2006-08-14 | BAB | ETF | 70.47 | 71.38 | 70.36 | 70.56 | 121500.0 |
| 2006-08-14 | BBC | ETF | 13.6 | 13.75 | 11.5 | 12.49 | 1037200.0 |
| 2006-08-14 | BBH | ETF | 58.0567 | 58.4633 | 57.7867 | 57.8033 | 679800.0 |
| 2006-08-14 | BITS | ETF | 23.72 | 25.9196 | 23.24 | 25.44 | 69602.0 |
| 2006-08-14 | BKF | ETF | 4.0 | 4.0 | 3.97 | 3.97 | 38300.0 |
| 2006-08-14 | BNE | ETF | 15.19 | 15.29 | 14.94 | 15.1 | 116800.0 |
| 2006-08-14 | BOSS | ETF | 33.1 | 34.0 | 33.1 | 34.0 | 300.0 |
| 2006-08-14 | BRF | ETF | 14.04 | 14.09 | 14.04 | 14.04 | 3200.0 |
| 2006-08-14 | BTF | ETF | 89.3 | 90.0 | 89.25 | 89.49999999999999 | 6540.0 |
| 2006-08-14 | CBON | ETF | 32.74 | 33.05 | 32.64 | 32.93 | 25675.0 |
| 2006-08-14 | CDL | ETF | 8.75 | 8.8 | 8.58 | 8.58 | 221500.0 |
| 2006-08-14 | CEF | ETF | 8.94 | 8.97 | 8.85 | 8.88 | 217600.0 |
| 2006-08-14 | CEW | ETF | 25.96 | 26.1999 | 25.85 | 25.95 | 1600.0 |
| 2006-08-14 | CFO | ETF | 9.95 | 9.95 | 9.9 | 9.9 | 3500.0 |
| 2006-08-14 | CGO | ETF | 15.15 | 15.85 | 15.0 | 15.05 | 41900.0 |
| 2006-08-14 | CHB | ETF | 5.51 | 5.65 | 5.34 | 5.45 | 2173700.0 |
| 2006-08-14 | CHI | ETF | 20.19 | 20.25 | 20.11 | 20.21 | 102100.0 |
| 2006-08-14 | CHIC | ETF | 26.05 | 26.1155 | 25.63 | 25.91 | 311568.0 |
| 2006-08-14 | CHY | ETF | 16.26 | 16.31 | 16.13 | 16.21 | 142800.0 |
| 2006-08-14 | CIL | ETF | 25.41 | 25.42 | 25.29 | 25.4 | 1800.0 |
| 2006-08-14 | CIZ | ETF | 21.85 | 22.0 | 21.65 | 21.65 | 3800.0 |
| 2006-08-14 | CN | ETF | 36.45 | 36.68 | 36.3 | 36.41 | 52900.0 |
| 2006-08-14 | CNXT | ETF | 1.69 | 1.73 | 1.66 | 1.67 | 5715586.0 |
| 2006-08-14 | COMB | ETF | 9.9 | 9.9 | 9.72 | 9.8 | 11700.0 |
| 2006-08-14 | CPST | ETF | 1.9 | 1.93 | 1.82 | 1.84 | 825627.0 |
| 2006-08-14 | CSA | ETF | 18.6 | 18.6 | 18.3 | 18.3 | 18300.0 |
| 2006-08-14 | CSB | ETF | 25.93 | 26.3 | 25.8201 | 25.86 | 7700.0 |
| 2006-08-14 | CSQ | ETF | 14.25 | 14.3 | 14.19 | 14.23 | 313900.0 |
| 2006-08-14 | CTEC | ETF | 55.449999999999996 | 55.9 | 53.6 | 54.24999999999999 | 12295.2 |
| 2006-08-14 | CYB | ETF | 5.53 | 5.63 | 5.46 | 5.58 | 37800.0 |
| 2006-08-14 | DBC | ETF | 25.25 | 25.34 | 25.08 | 25.3 | 123400.0 |
| 2006-08-14 | DDM | ETF | 6.0083 | 6.0833 | 5.9458 | 5.955 | 1122000.0 |
| 2006-08-14 | DES | ETF | 17.05 | 17.2067 | 17.0267 | 17.0267 | 12900.0 |
| 2006-08-14 | DEW | ETF | 53.35 | 53.41 | 53.31 | 53.41 | 1900.0 |
| 2006-08-14 | DFE | ETF | 53.85 | 53.85 | 53.85 | 53.85 | 100.0 |
| 2006-08-14 | DFJ | ETF | 50.35 | 50.35 | 50.35 | 50.35 | 400.0 |
> showing 50 of 359 rows — these rows as CSV