PREVIEW / etf_daily / 2006-04-05
file: by_date/etf_daily/2006/2006-04-05.parquet size: 16 KB rows: 312
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-04-05 | SPY | ETF | 130.61 | 131.28 | 130.38 | 131.01 | 50607200.0 |
| 2006-04-05 | QQQ | ETF | 42.3 | 42.67 | 42.21 | 42.61 | 91662248.0 |
| 2006-04-05 | IWM | ETF | 75.83 | 76.2 | 75.27 | 76.07 | 27471100.0 |
| 2006-04-05 | DIA | ETF | 111.96 | 112.47 | 111.59 | 112.36 | 7691900.0 |
| 2006-04-05 | GLD | ETF | 58.64 | 58.71 | 58.0 | 58.66 | 6660300.0 |
| 2006-04-05 | TLT | ETF | 86.7 | 86.78 | 86.5 | 86.6 | 638600.0 |
| 2006-04-05 | AAA | ETF | 62.18 | 62.9 | 62.18 | 62.9 | 5000.0 |
| 2006-04-05 | ADRE | ETF | 134.15 | 134.4 | 133.01 | 134.322 | 38196.0 |
| 2006-04-05 | AFK | ETF | 25.11 | 25.11 | 25.09 | 25.11 | 18800.0 |
| 2006-04-05 | AGG | ETF | 98.96 | 98.96 | 98.7 | 98.8 | 195900.0 |
| 2006-04-05 | AIQ | ETF | 31.0 | 31.2 | 29.95 | 30.15 | 21340.0 |
| 2006-04-05 | AIS | ETF | 1.5 | 1.54 | 1.44 | 1.51 | 374800.0 |
| 2006-04-05 | AOM | ETF | 6.65 | 7.09 | 6.62 | 7.0 | 162400.0 |
| 2006-04-05 | ARB | ETF | 33.27 | 33.4 | 32.74 | 32.89 | 377900.0 |
| 2006-04-05 | BAB | ETF | 62.42 | 62.8 | 62.25 | 62.65 | 10600.0 |
| 2006-04-05 | BBC | ETF | 16.75 | 16.9899 | 16.55 | 16.85 | 344100.0 |
| 2006-04-05 | BBH | ETF | 64.0533 | 64.0833 | 63.5333 | 63.75 | 927300.0 |
| 2006-04-05 | BCM | ETF | 72.8 | 73.31 | 72.33 | 73.31 | 21300.0 |
| 2006-04-05 | BITS | ETF | 31.96 | 31.96 | 30.2 | 30.92 | 32083.0 |
| 2006-04-05 | BKF | ETF | 10.13 | 10.7 | 10.07 | 10.13 | 168000.0 |
| 2006-04-05 | BNE | ETF | 16.56 | 16.88 | 16.28 | 16.34 | 118000.0 |
| 2006-04-05 | BRF | ETF | 14.18 | 14.25 | 14.18 | 14.25 | 3400.0 |
| 2006-04-05 | BTF | ETF | 88.55 | 88.85 | 88.55 | 88.8 | 640.0 |
| 2006-04-05 | CBON | ETF | 30.82 | 31.67 | 30.82 | 31.29 | 7614.0 |
| 2006-04-05 | CDL | ETF | 10.9 | 10.94 | 10.69 | 10.73 | 337000.0 |
| 2006-04-05 | CEF | ETF | 8.18 | 8.34 | 8.15 | 8.34 | 711700.0 |
| 2006-04-05 | CEW | ETF | 25.65 | 25.65 | 25.55 | 25.55 | 800.0 |
| 2006-04-05 | CFO | ETF | 10.1 | 10.1 | 10.1 | 10.1 | 4500.0 |
| 2006-04-05 | CGO | ETF | 14.61 | 14.66 | 14.43 | 14.5 | 44000.0 |
| 2006-04-05 | CHB | ETF | 15.3 | 15.5 | 15.19 | 15.31 | 738100.0 |
| 2006-04-05 | CHI | ETF | 20.74 | 21.0 | 20.74 | 20.91 | 67700.0 |
| 2006-04-05 | CHIC | ETF | 21.11 | 21.28 | 20.68 | 20.76 | 389628.0 |
| 2006-04-05 | CHIR | ETF | 47.9001 | 47.9199 | 47.8701 | 47.88 | 549834.0 |
| 2006-04-05 | CHY | ETF | 16.35 | 16.47 | 16.35 | 16.47 | 77800.0 |
| 2006-04-05 | CN | ETF | 36.3 | 36.82 | 36.3 | 36.64 | 43000.0 |
| 2006-04-05 | CNXT | ETF | 3.66 | 3.81 | 3.61 | 3.79 | 24073391.0 |
| 2006-04-05 | COMB | ETF | 8.65 | 8.65 | 8.6 | 8.65 | 4000.0 |
| 2006-04-05 | CPST | ETF | 3.715 | 3.85 | 3.69 | 3.74 | 2498990.0 |
| 2006-04-05 | CSA | ETF | 20.66 | 20.68 | 20.6 | 20.6 | 9300.0 |
| 2006-04-05 | CSB | ETF | 30.25 | 30.62 | 30.25 | 30.51 | 24900.0 |
| 2006-04-05 | CSQ | ETF | 14.09 | 14.15 | 14.05 | 14.14 | 265300.0 |
| 2006-04-05 | CTEC | ETF | 65.3 | 65.3 | 63.75 | 65.0 | 34322.0 |
| 2006-04-05 | CYB | ETF | 5.71 | 6.08 | 5.71 | 6.01 | 26000.0 |
| 2006-04-05 | DBC | ETF | 24.0 | 24.2 | 23.95 | 24.07 | 297300.0 |
| 2006-04-05 | DGT | ETF | 67.7 | 67.85 | 67.7 | 67.85 | 500.0 |
| 2006-04-05 | DIG | ETF | 17.6 | 17.6 | 17.6 | 17.6 | 11600.0 |
| 2006-04-05 | DIV | ETF | 12.41 | 12.49 | 12.3 | 12.42 | 21900.0 |
| 2006-04-05 | DRIV | ETF | 45.1 | 45.55 | 44.5 | 45.52 | 671601.0 |
| 2006-04-05 | DSI | ETF | 6.3 | 6.32 | 6.3 | 6.32 | 5000.0 |
| 2006-04-05 | DUSA | ETF | 6.81 | 6.9 | 6.76 | 6.89 | 95304.0 |
> showing 50 of 312 rows — these rows as CSV