PREVIEW / etf_daily / 2006-08-10
file: by_date/etf_daily/2006/2006-08-10.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-10 | SPY | ETF | 126.58 | 127.5 | 126.28 | 127.37 | 69322300.0 |
| 2006-08-10 | QQQ | ETF | 36.46 | 36.88 | 36.31 | 36.79 | 102511912.0 |
| 2006-08-10 | IWM | ETF | 67.31 | 68.61 | 67.03 | 68.3 | 54415200.0 |
| 2006-08-10 | DIA | ETF | 110.85 | 111.53 | 110.5 | 111.3 | 7656700.0 |
| 2006-08-10 | GLD | ETF | 64.02 | 64.38 | 62.97 | 63.25 | 6869900.0 |
| 2006-08-10 | TLT | ETF | 85.85 | 85.85 | 85.45 | 85.77 | 539000.0 |
| 2006-08-10 | AAA | ETF | 57.21 | 57.38 | 56.8 | 57.38 | 17100.0 |
| 2006-08-10 | ADRE | ETF | 32.0 | 32.25 | 31.93 | 32.24 | 96136.0 |
| 2006-08-10 | AFK | ETF | 25.14 | 25.2 | 25.14 | 25.2 | 9000.0 |
| 2006-08-10 | AGG | ETF | 98.69 | 98.7 | 98.35 | 98.64 | 143700.0 |
| 2006-08-10 | AIQ | ETF | 31.8 | 32.6 | 31.5 | 31.6 | 15180.0 |
| 2006-08-10 | AIS | ETF | 0.98 | 1.0 | 0.95 | 0.96 | 156600.0 |
| 2006-08-10 | AOM | ETF | 6.0 | 6.0 | 5.85 | 5.94 | 3500.0 |
| 2006-08-10 | ARB | ETF | 35.26 | 35.82 | 35.1 | 35.68 | 153200.0 |
| 2006-08-10 | BAB | ETF | 70.26 | 71.14 | 69.96 | 70.48 | 205300.0 |
| 2006-08-10 | BBC | ETF | 13.04 | 13.3099 | 12.7 | 12.95 | 211100.0 |
| 2006-08-10 | BBH | ETF | 58.3333 | 58.5367 | 58.0033 | 58.2967 | 792000.0 |
| 2006-08-10 | BITS | ETF | 22.84 | 23.28 | 22.08 | 22.52 | 21407.0 |
| 2006-08-10 | BKF | ETF | 3.8 | 4.03 | 3.8 | 4.02 | 134200.0 |
| 2006-08-10 | BNE | ETF | 14.7 | 15.25 | 14.57 | 14.94 | 532900.0 |
| 2006-08-10 | BRF | ETF | 14.06 | 14.09 | 14.05 | 14.05 | 12900.0 |
| 2006-08-10 | BTF | ETF | 89.1 | 89.49999999999999 | 88.8 | 89.49999999999999 | 7840.0 |
| 2006-08-10 | CBON | ETF | 33.0 | 33.37 | 32.89 | 33.11 | 77263.0 |
| 2006-08-10 | CDL | ETF | 8.84 | 8.9 | 8.66 | 8.7 | 412500.0 |
| 2006-08-10 | CEF | ETF | 9.2 | 9.2 | 8.89 | 8.97 | 327500.0 |
| 2006-08-10 | CEW | ETF | 25.96 | 25.96 | 25.8501 | 25.91 | 500.0 |
| 2006-08-10 | CFO | ETF | 10.05 | 10.05 | 10.01 | 10.01 | 1200.0 |
| 2006-08-10 | CGO | ETF | 14.95 | 14.95 | 14.82 | 14.95 | 23000.0 |
| 2006-08-10 | CHB | ETF | 5.2 | 5.4 | 5.04 | 5.15 | 2623800.0 |
| 2006-08-10 | CHI | ETF | 20.29 | 20.3 | 20.11 | 20.15 | 92500.0 |
| 2006-08-10 | CHIC | ETF | 25.5 | 26.13 | 25.15 | 26.02 | 300349.0 |
| 2006-08-10 | CHY | ETF | 16.21 | 16.23 | 16.1 | 16.13 | 124100.0 |
| 2006-08-10 | CIL | ETF | 25.4 | 25.4 | 25.3 | 25.31 | 1100.0 |
| 2006-08-10 | CIZ | ETF | 22.0 | 22.0 | 22.0 | 22.0 | 200.0 |
| 2006-08-10 | CN | ETF | 36.25 | 37.0 | 35.95 | 36.98 | 92800.0 |
| 2006-08-10 | CNXT | ETF | 1.64 | 1.72 | 1.63 | 1.71 | 9809647.0 |
| 2006-08-10 | COMB | ETF | 9.88 | 9.88 | 9.86 | 9.86 | 400.0 |
| 2006-08-10 | CPST | ETF | 1.88 | 1.98 | 1.82 | 1.98 | 1276087.0 |
| 2006-08-10 | CSA | ETF | 18.44 | 18.44 | 18.34 | 18.35 | 21800.0 |
| 2006-08-10 | CSB | ETF | 25.6 | 25.8 | 25.55 | 25.8 | 7000.0 |
| 2006-08-10 | CSQ | ETF | 14.1 | 14.21 | 14.07 | 14.17 | 240800.0 |
| 2006-08-10 | CTEC | ETF | 55.05 | 55.99999999999999 | 54.55 | 55.849999999999994 | 12432.400000000001 |
| 2006-08-10 | CYB | ETF | 5.22 | 5.56 | 5.21 | 5.56 | 26000.0 |
| 2006-08-10 | DBC | ETF | 25.97 | 25.98 | 25.57 | 25.79 | 347100.0 |
| 2006-08-10 | DDM | ETF | 5.9333 | 6.0083 | 5.9 | 5.9808 | 938400.0 |
| 2006-08-10 | DES | ETF | 16.8333 | 17.0233 | 16.8 | 17.0067 | 28200.0 |
| 2006-08-10 | DEW | ETF | 53.34 | 53.34 | 53.11 | 53.32 | 1000.0 |
| 2006-08-10 | DFE | ETF | 53.88 | 53.88 | 53.88 | 53.88 | 100.0 |
| 2006-08-10 | DFJ | ETF | 49.66 | 49.86 | 49.66 | 49.86 | 400.0 |
| 2006-08-10 | DGT | ETF | 69.69 | 69.8 | 69.27 | 69.78 | 13400.0 |
> showing 50 of 359 rows — these rows as CSV