PREVIEW / etf_daily / 2006-04-12
file: by_date/etf_daily/2006/2006-04-12.parquet size: 16 KB rows: 307
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-12 | SPY | ETF | 128.77 | 129.13 | 128.61 | 128.88 | 43033700.0 |
| 2006-04-12 | QQQ | ETF | 41.95 | 42.08 | 41.8 | 41.93 | 58884695.0 |
| 2006-04-12 | IWM | ETF | 73.62 | 74.4 | 73.55 | 74.37 | 40981200.0 |
| 2006-04-12 | DIA | ETF | 111.1 | 111.45 | 111.02 | 111.29 | 3721200.0 |
| 2006-04-12 | GLD | ETF | 59.45 | 59.71 | 59.15 | 59.43 | 3709300.0 |
| 2006-04-12 | TLT | ETF | 85.6 | 85.73 | 85.0 | 85.04 | 1902000.0 |
| 2006-04-12 | AAA | ETF | 59.23 | 59.23 | 58.97 | 59.01 | 4200.0 |
| 2006-04-12 | ADRE | ETF | 130.49 | 131.0 | 130.2 | 130.95 | 19804.0 |
| 2006-04-12 | AFK | ETF | 25.1 | 25.19 | 25.1 | 25.19 | 8600.0 |
| 2006-04-12 | AGG | ETF | 98.42 | 98.64 | 98.21 | 98.41 | 171400.0 |
| 2006-04-12 | AIQ | ETF | 26.75 | 28.8 | 26.75 | 28.45 | 12680.0 |
| 2006-04-12 | AIS | ETF | 1.47 | 1.5 | 1.45 | 1.4999 | 216200.0 |
| 2006-04-12 | AOM | ETF | 6.9 | 6.98 | 6.82 | 6.93 | 123300.0 |
| 2006-04-12 | ARB | ETF | 33.05 | 33.1 | 32.95 | 33.02 | 305800.0 |
| 2006-04-12 | BAB | ETF | 59.65 | 59.78 | 59.12 | 59.23 | 31500.0 |
| 2006-04-12 | BBC | ETF | 17.0 | 17.75 | 17.0 | 17.46 | 369900.0 |
| 2006-04-12 | BBH | ETF | 61.8167 | 62.8667 | 61.7033 | 62.21 | 1729800.0 |
| 2006-04-12 | BCM | ETF | 72.8 | 72.8 | 71.32 | 71.61 | 26700.0 |
| 2006-04-12 | BITS | ETF | 30.84 | 33.52 | 30.84 | 32.44 | 41227.0 |
| 2006-04-12 | BKF | ETF | 9.63 | 9.7 | 9.56 | 9.65 | 41300.0 |
| 2006-04-12 | BNE | ETF | 15.69 | 16.1 | 15.67 | 15.85 | 167600.0 |
| 2006-04-12 | BRF | ETF | 13.98 | 14.04 | 13.91 | 14.04 | 29500.0 |
| 2006-04-12 | BTF | ETF | 87.6 | 87.6 | 86.55049999999999 | 86.55049999999999 | 1220.0 |
| 2006-04-12 | CBON | ETF | 31.18 | 31.33 | 30.4 | 30.58 | 20138.0 |
| 2006-04-12 | CDL | ETF | 10.5 | 10.7 | 10.5 | 10.62 | 145600.0 |
| 2006-04-12 | CEF | ETF | 8.74 | 8.85 | 8.63 | 8.85 | 577200.0 |
| 2006-04-12 | CFO | ETF | 10.1 | 10.1 | 10.1 | 10.1 | 5900.0 |
| 2006-04-12 | CGO | ETF | 14.18 | 14.25 | 14.09 | 14.18 | 53800.0 |
| 2006-04-12 | CHB | ETF | 15.02 | 15.15 | 14.6 | 14.9 | 487300.0 |
| 2006-04-12 | CHI | ETF | 20.54 | 20.69 | 20.54 | 20.6 | 73000.0 |
| 2006-04-12 | CHIC | ETF | 20.9 | 21.04 | 20.78 | 20.821 | 104970.0 |
| 2006-04-12 | CHIR | ETF | 47.91 | 47.97 | 47.9001 | 47.9199 | 584297.0 |
| 2006-04-12 | CHY | ETF | 16.12 | 16.2 | 16.07 | 16.2 | 88700.0 |
| 2006-04-12 | CIZ | ETF | 23.75 | 23.75 | 23.75 | 23.75 | 200.0 |
| 2006-04-12 | CN | ETF | 36.2 | 36.44 | 36.2 | 36.44 | 22400.0 |
| 2006-04-12 | CNXT | ETF | 3.32 | 3.52 | 3.3 | 3.44 | 15545308.0 |
| 2006-04-12 | COMB | ETF | 8.45 | 8.5593 | 8.45 | 8.5593 | 1255.0 |
| 2006-04-12 | CPST | ETF | 4.01 | 4.11 | 3.86 | 4.04 | 3566308.0 |
| 2006-04-12 | CSA | ETF | 19.89 | 20.0 | 19.55 | 19.65 | 21500.0 |
| 2006-04-12 | CSB | ETF | 29.66 | 29.96 | 29.66 | 29.85 | 4400.0 |
| 2006-04-12 | CSQ | ETF | 13.93 | 13.93 | 13.75 | 13.9 | 354900.0 |
| 2006-04-12 | CTEC | ETF | 63.099999999999994 | 63.550000000000004 | 62.300000000000004 | 62.699999999999996 | 8343.2 |
| 2006-04-12 | CYB | ETF | 6.02 | 6.02 | 6.0 | 6.0 | 6600.0 |
| 2006-04-12 | DBC | ETF | 24.92 | 25.08 | 24.75 | 24.89 | 517700.0 |
| 2006-04-12 | DGT | ETF | 67.0 | 67.09 | 66.95 | 66.95 | 1700.0 |
| 2006-04-12 | DIV | ETF | 12.16 | 12.16 | 12.01 | 12.01 | 14800.0 |
| 2006-04-12 | DRIV | ETF | 43.16 | 44.24 | 43.1 | 43.58 | 460917.0 |
| 2006-04-12 | DSI | ETF | 6.24 | 6.25 | 6.24 | 6.25 | 5200.0 |
| 2006-04-12 | DUSA | ETF | 6.65 | 6.84 | 6.65 | 6.8 | 102005.0 |
| 2006-04-12 | DVY | ETF | 62.07 | 62.22 | 61.92 | 62.17 | 534000.0 |
> showing 50 of 307 rows — these rows as CSV