PREVIEW / etf_daily / 2006-05-08
file: by_date/etf_daily/2006/2006-05-08.parquet size: 17 KB rows: 323
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-05-08 | SPY | ETF | 132.51 | 132.77 | 132.36 | 132.36 | 30016700.0 |
| 2006-05-08 | QQQ | ETF | 42.08 | 42.28 | 42.07 | 42.2 | 45093337.0 |
| 2006-05-08 | IWM | ETF | 77.52 | 77.81 | 77.33 | 77.63 | 24715000.0 |
| 2006-05-08 | DIA | ETF | 115.63 | 116.0 | 115.63 | 115.75 | 3502300.0 |
| 2006-05-08 | GLD | ETF | 67.2 | 67.61 | 66.75 | 67.56 | 6528700.0 |
| 2006-05-08 | TLT | ETF | 83.74 | 83.77 | 83.53 | 83.65 | 666400.0 |
| 2006-05-08 | AAA | ETF | 62.3 | 62.3 | 61.87 | 62.22 | 7500.0 |
| 2006-05-08 | ADRE | ETF | 146.97 | 146.97 | 145.63 | 146.87 | 57628.0 |
| 2006-05-08 | AFK | ETF | 25.16 | 25.21 | 25.16 | 25.21 | 6600.0 |
| 2006-05-08 | AGG | ETF | 97.99 | 98.05 | 97.86 | 98.02 | 116000.0 |
| 2006-05-08 | AIQ | ETF | 30.75 | 31.13 | 29.1 | 30.3 | 65020.0 |
| 2006-05-08 | AIS | ETF | 1.46 | 1.52 | 1.42 | 1.51 | 294600.0 |
| 2006-05-08 | AOM | ETF | 6.93 | 6.93 | 6.74 | 6.83 | 17600.0 |
| 2006-05-08 | ARB | ETF | 35.25 | 36.59 | 35.25 | 36.58 | 524800.0 |
| 2006-05-08 | BAB | ETF | 62.49 | 62.6 | 62.29 | 62.5 | 9800.0 |
| 2006-05-08 | BBC | ETF | 13.4 | 13.86 | 13.16 | 13.35 | 411400.0 |
| 2006-05-08 | BBH | ETF | 58.31 | 58.8933 | 58.2 | 58.7833 | 2194800.0 |
| 2006-05-08 | BCM | ETF | 74.65 | 75.38 | 74.47 | 75.18 | 31000.0 |
| 2006-05-08 | BITS | ETF | 36.6 | 36.84 | 34.84 | 35.92 | 31384.0 |
| 2006-05-08 | BKF | ETF | 10.0 | 10.04 | 9.25 | 9.25 | 62700.0 |
| 2006-05-08 | BNE | ETF | 15.91 | 16.03 | 15.81 | 15.97 | 50300.0 |
| 2006-05-08 | BOSS | ETF | 37.26 | 37.26 | 37.2 | 37.2 | 200.0 |
| 2006-05-08 | BRF | ETF | 14.02 | 14.05 | 14.01 | 14.04 | 7600.0 |
| 2006-05-08 | BTF | ETF | 88.69999999999999 | 89.04999999999998 | 88.69999999999999 | 88.85 | 5780.0 |
| 2006-05-08 | CBON | ETF | 32.79 | 33.17 | 32.25 | 32.68 | 11140.0 |
| 2006-05-08 | CDL | ETF | 10.52 | 10.85 | 10.5 | 10.56 | 1308500.0 |
| 2006-05-08 | CEF | ETF | 10.16 | 10.16 | 9.81 | 10.04 | 1099200.0 |
| 2006-05-08 | CFO | ETF | 10.35 | 10.36 | 10.35 | 10.36 | 9300.0 |
| 2006-05-08 | CGO | ETF | 14.57 | 14.84 | 14.56 | 14.84 | 81800.0 |
| 2006-05-08 | CHB | ETF | 16.25 | 16.27 | 15.88 | 15.88 | 637400.0 |
| 2006-05-08 | CHI | ETF | 20.07 | 20.39 | 20.07 | 20.32 | 85400.0 |
| 2006-05-08 | CHIC | ETF | 23.13 | 23.4 | 23.08 | 23.21 | 485660.0 |
| 2006-05-08 | CHY | ETF | 16.09 | 16.35 | 16.0701 | 16.28 | 114700.0 |
| 2006-05-08 | CIL | ETF | 25.84 | 25.84 | 25.84 | 25.84 | 500.0 |
| 2006-05-08 | CN | ETF | 38.25 | 39.29 | 38.25 | 39.29 | 61400.0 |
| 2006-05-08 | CNXT | ETF | 3.77 | 3.8201 | 3.74 | 3.77 | 17666655.0 |
| 2006-05-08 | COMB | ETF | 10.2 | 10.2 | 10.01 | 10.01 | 18041.0 |
| 2006-05-08 | CPI | ETF | 31.0 | 31.0 | 31.0 | 31.0 | 1500.0 |
| 2006-05-08 | CPST | ETF | 3.925 | 3.97 | 3.82 | 3.89 | 1224464.0 |
| 2006-05-08 | CSA | ETF | 19.23 | 19.36 | 19.11 | 19.12 | 4800.0 |
| 2006-05-08 | CSB | ETF | 31.2 | 31.3 | 31.03 | 31.2 | 6700.0 |
| 2006-05-08 | CSQ | ETF | 14.1 | 14.1 | 14.02 | 14.09 | 292600.0 |
| 2006-05-08 | CTEC | ETF | 62.55 | 64.74999999999999 | 62.35 | 64.19999999999999 | 31235.0 |
| 2006-05-08 | CYB | ETF | 6.36 | 6.36 | 6.2 | 6.2 | 25600.0 |
| 2006-05-08 | DBC | ETF | 25.4 | 25.63 | 25.15 | 25.63 | 338900.0 |
| 2006-05-08 | DGT | ETF | 69.74 | 69.9 | 69.58 | 69.9 | 1200.0 |
| 2006-05-08 | DIV | ETF | 12.12 | 12.15 | 12.12 | 12.12 | 14100.0 |
| 2006-05-08 | DRIV | ETF | 45.56 | 45.71 | 44.9 | 45.31 | 754855.0 |
| 2006-05-08 | DSI | ETF | 6.475 | 6.5 | 6.475 | 6.5 | 2800.0 |
| 2006-05-08 | DUSA | ETF | 6.77 | 6.77 | 6.69 | 6.73 | 65023.0 |
> showing 50 of 323 rows — these rows as CSV