PREVIEW / etf_daily / 2006-08-03
file: by_date/etf_daily/2006/2006-08-03.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-03 | SPY | ETF | 127.34 | 128.55 | 127.15 | 128.42 | 63693800.0 |
| 2006-08-03 | QQQ | ETF | 36.54 | 37.34 | 36.48 | 37.12 | 99296001.0 |
| 2006-08-03 | IWM | ETF | 68.78 | 70.34 | 68.54 | 70.34 | 49316900.0 |
| 2006-08-03 | DIA | ETF | 111.43 | 112.66 | 111.27 | 112.59 | 6181100.0 |
| 2006-08-03 | GLD | ETF | 64.0 | 64.33 | 63.55 | 64.12 | 3840600.0 |
| 2006-08-03 | TLT | ETF | 85.63 | 86.04 | 85.52 | 85.8 | 500500.0 |
| 2006-08-03 | AAA | ETF | 57.51 | 57.9 | 57.51 | 57.9 | 45300.0 |
| 2006-08-03 | ADRE | ETF | 31.71 | 32.21 | 31.71 | 32.04 | 159724.0 |
| 2006-08-03 | AFK | ETF | 25.1 | 25.15 | 25.06 | 25.15 | 84100.0 |
| 2006-08-03 | AGG | ETF | 98.39 | 98.44 | 98.15 | 98.29 | 330100.0 |
| 2006-08-03 | AIQ | ETF | 33.15 | 33.2 | 32.1 | 32.85 | 25680.0 |
| 2006-08-03 | AIS | ETF | 1.11 | 1.12 | 1.0601 | 1.1 | 56000.0 |
| 2006-08-03 | AOM | ETF | 6.08 | 6.08 | 5.9 | 6.0 | 15300.0 |
| 2006-08-03 | ARB | ETF | 35.88 | 36.62 | 35.6201 | 36.37 | 124100.0 |
| 2006-08-03 | BAB | ETF | 72.67 | 74.8 | 72.67 | 74.4 | 126200.0 |
| 2006-08-03 | BBC | ETF | 13.11 | 13.49 | 12.88 | 13.0 | 122700.0 |
| 2006-08-03 | BBH | ETF | 59.0 | 60.0 | 58.8967 | 59.66 | 561900.0 |
| 2006-08-03 | BITS | ETF | 17.6 | 18.6 | 17.24 | 17.8 | 10188.0 |
| 2006-08-03 | BKF | ETF | 3.91 | 4.02 | 3.91 | 4.0 | 8800.0 |
| 2006-08-03 | BNE | ETF | 13.79 | 14.21 | 13.63 | 14.1 | 69400.0 |
| 2006-08-03 | BOSS | ETF | 34.01 | 34.01 | 34.01 | 34.01 | 200.0 |
| 2006-08-03 | BRF | ETF | 14.03 | 14.1 | 14.02 | 14.1 | 14300.0 |
| 2006-08-03 | BTF | ETF | 86.99999999999999 | 87.55 | 86.6 | 87.55 | 1820.0 |
| 2006-08-03 | CBON | ETF | 33.61 | 33.99 | 33.35 | 33.95 | 21482.0 |
| 2006-08-03 | CDL | ETF | 9.51 | 9.51 | 9.03 | 9.05 | 520000.0 |
| 2006-08-03 | CEF | ETF | 8.86 | 9.1 | 8.86 | 9.07 | 261400.0 |
| 2006-08-03 | CEW | ETF | 26.05 | 26.1 | 25.9 | 25.9 | 2500.0 |
| 2006-08-03 | CFO | ETF | 10.02 | 10.02 | 10.0 | 10.0 | 5000.0 |
| 2006-08-03 | CGO | ETF | 15.08 | 15.31 | 14.99 | 15.31 | 28200.0 |
| 2006-08-03 | CHB | ETF | 6.46 | 6.46 | 6.25 | 6.35 | 1428100.0 |
| 2006-08-03 | CHI | ETF | 20.02 | 20.14 | 19.98 | 20.05 | 91900.0 |
| 2006-08-03 | CHIC | ETF | 25.36 | 26.22 | 25.26 | 26.05 | 602211.0 |
| 2006-08-03 | CHY | ETF | 16.15 | 16.23 | 16.15 | 16.22 | 148600.0 |
| 2006-08-03 | CIL | ETF | 25.42 | 25.42 | 25.42 | 25.42 | 2200.0 |
| 2006-08-03 | CN | ETF | 35.8 | 36.15 | 35.7125 | 36.0 | 47400.0 |
| 2006-08-03 | CNXT | ETF | 1.68 | 1.73 | 1.65 | 1.71 | 11565363.0 |
| 2006-08-03 | COMB | ETF | 9.8 | 9.81 | 9.49 | 9.78 | 52765.0 |
| 2006-08-03 | CPI | ETF | 28.85 | 28.85 | 28.66 | 28.67 | 900.0 |
| 2006-08-03 | CPST | ETF | 2.0 | 2.04 | 1.9 | 2.03 | 1129516.0 |
| 2006-08-03 | CSA | ETF | 18.75 | 18.8 | 18.5 | 18.55 | 15900.0 |
| 2006-08-03 | CSB | ETF | 26.35 | 26.5911 | 26.3 | 26.5 | 41100.0 |
| 2006-08-03 | CSQ | ETF | 14.22 | 14.25 | 14.09 | 14.24 | 314100.0 |
| 2006-08-03 | CTEC | ETF | 54.1 | 56.050000000000004 | 53.949999999999996 | 55.49999999999999 | 15108.2 |
| 2006-08-03 | CYB | ETF | 5.26 | 5.75 | 5.05 | 5.72 | 120600.0 |
| 2006-08-03 | DBC | ETF | 26.0 | 26.11 | 25.82 | 26.08 | 181000.0 |
| 2006-08-03 | DDM | ETF | 6.0167 | 6.1392 | 6.0167 | 6.1083 | 1044000.0 |
| 2006-08-03 | DES | ETF | 17.1333 | 17.3733 | 17.1333 | 17.3733 | 11400.0 |
| 2006-08-03 | DEW | ETF | 53.12 | 53.37 | 53.12 | 53.37 | 1200.0 |
| 2006-08-03 | DFE | ETF | 53.55 | 53.55 | 53.55 | 53.55 | 300.0 |
| 2006-08-03 | DFJ | ETF | 50.29 | 50.29 | 50.29 | 50.29 | 3900.0 |
> showing 50 of 355 rows — these rows as CSV