PREVIEW / etf_daily / 2006-08-08
file: by_date/etf_daily/2006/2006-08-08.parquet size: 18 KB rows: 355
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-08 | SPY | ETF | 128.09 | 128.46 | 126.95 | 127.41 | 90901300.0 |
| 2006-08-08 | QQQ | ETF | 36.81 | 36.9 | 36.26 | 36.48 | 124510764.0 |
| 2006-08-08 | IWM | ETF | 69.43 | 69.96 | 68.18 | 68.39 | 76243800.0 |
| 2006-08-08 | DIA | ETF | 112.47 | 112.76 | 111.15 | 111.84 | 9064600.0 |
| 2006-08-08 | GLD | ETF | 63.98 | 64.57 | 63.85 | 63.97 | 5574200.0 |
| 2006-08-08 | TLT | ETF | 86.38 | 86.57 | 86.09 | 86.18 | 844400.0 |
| 2006-08-08 | AAA | ETF | 57.5 | 57.9199 | 56.85 | 57.35 | 64300.0 |
| 2006-08-08 | ADRE | ETF | 32.3 | 32.4 | 31.96 | 32.05 | 196657.0 |
| 2006-08-08 | AFK | ETF | 25.15 | 25.25 | 25.15 | 25.22 | 3300.0 |
| 2006-08-08 | AGG | ETF | 98.59 | 98.77 | 98.51 | 98.61 | 137300.0 |
| 2006-08-08 | AIQ | ETF | 32.75 | 32.75 | 31.5 | 32.15 | 14580.0 |
| 2006-08-08 | AIS | ETF | 1.06 | 1.06 | 0.99 | 1.03 | 245000.0 |
| 2006-08-08 | AOM | ETF | 6.0 | 6.06 | 6.0 | 6.06 | 18500.0 |
| 2006-08-08 | ARB | ETF | 35.85 | 36.32 | 35.48 | 35.65 | 146400.0 |
| 2006-08-08 | BAB | ETF | 72.37 | 72.63 | 71.52 | 71.86 | 57700.0 |
| 2006-08-08 | BBC | ETF | 13.25 | 13.4 | 12.91 | 12.96 | 127500.0 |
| 2006-08-08 | BBH | ETF | 58.6667 | 58.93 | 58.1467 | 58.4267 | 591000.0 |
| 2006-08-08 | BITS | ETF | 21.28 | 24.6 | 20.16 | 23.7204 | 353350.0 |
| 2006-08-08 | BKF | ETF | 3.92 | 3.97 | 3.92 | 3.94 | 11300.0 |
| 2006-08-08 | BNE | ETF | 14.01 | 14.21 | 13.73 | 13.75 | 108600.0 |
| 2006-08-08 | BRF | ETF | 14.0601 | 14.0601 | 14.0601 | 14.0601 | 1700.0 |
| 2006-08-08 | BTF | ETF | 88.05 | 88.49999999999999 | 88.05 | 88.39999999999999 | 740.0 |
| 2006-08-08 | CBON | ETF | 33.75 | 33.94 | 33.17 | 33.46 | 29176.0 |
| 2006-08-08 | CDL | ETF | 8.33 | 8.72 | 8.18 | 8.71 | 674500.0 |
| 2006-08-08 | CEF | ETF | 9.23 | 9.23 | 9.09 | 9.16 | 218300.0 |
| 2006-08-08 | CEW | ETF | 26.1 | 26.1 | 26.0 | 26.0 | 200.0 |
| 2006-08-08 | CFO | ETF | 10.1 | 10.1 | 10.05 | 10.05 | 9400.0 |
| 2006-08-08 | CGO | ETF | 15.24 | 15.24 | 15.01 | 15.06 | 24500.0 |
| 2006-08-08 | CHB | ETF | 6.28 | 6.33 | 5.82 | 5.9 | 1489000.0 |
| 2006-08-08 | CHI | ETF | 20.19 | 20.35 | 20.17 | 20.35 | 102400.0 |
| 2006-08-08 | CHIC | ETF | 26.0 | 26.0 | 25.14 | 25.34 | 389787.0 |
| 2006-08-08 | CHY | ETF | 16.36 | 16.41 | 16.29 | 16.41 | 152900.0 |
| 2006-08-08 | CIZ | ETF | 22.1 | 22.15 | 22.03 | 22.15 | 300.0 |
| 2006-08-08 | CN | ETF | 35.48 | 35.63 | 35.1 | 35.25 | 33000.0 |
| 2006-08-08 | CNXT | ETF | 1.621 | 1.65 | 1.5999 | 1.6 | 12488449.0 |
| 2006-08-08 | COMB | ETF | 9.8 | 9.8 | 9.7 | 9.7937 | 73700.0 |
| 2006-08-08 | CPI | ETF | 28.6 | 28.6 | 28.6 | 28.6 | 200.0 |
| 2006-08-08 | CPST | ETF | 1.93 | 1.97 | 1.8099 | 1.83 | 807386.0 |
| 2006-08-08 | CSA | ETF | 18.2 | 18.75 | 18.2 | 18.4 | 10300.0 |
| 2006-08-08 | CSB | ETF | 26.07 | 26.29 | 26.0401 | 26.08 | 11500.0 |
| 2006-08-08 | CSQ | ETF | 14.23 | 14.25 | 14.1 | 14.15 | 340400.0 |
| 2006-08-08 | CTEC | ETF | 55.05 | 56.699999999999996 | 55.0 | 55.99999999999999 | 7860.8 |
| 2006-08-08 | CYB | ETF | 5.66 | 5.6899 | 5.38 | 5.38 | 29300.0 |
| 2006-08-08 | DBC | ETF | 26.18 | 26.3 | 25.95 | 26.09 | 243800.0 |
| 2006-08-08 | DDM | ETF | 6.1033 | 6.1475 | 6.0017 | 6.0325 | 1832400.0 |
| 2006-08-08 | DES | ETF | 17.25 | 17.3767 | 17.0467 | 17.0467 | 40500.0 |
| 2006-08-08 | DEW | ETF | 53.55 | 53.55 | 53.39 | 53.39 | 600.0 |
| 2006-08-08 | DFE | ETF | 54.32 | 54.32 | 54.32 | 54.32 | 200.0 |
| 2006-08-08 | DFJ | ETF | 49.43 | 49.43 | 49.32 | 49.41 | 700.0 |
| 2006-08-08 | DGT | ETF | 69.5 | 69.53 | 69.29 | 69.34 | 18500.0 |
> showing 50 of 355 rows — these rows as CSV