PREVIEW / etf_daily / 2006-05-09
file: by_date/etf_daily/2006/2006-05-09.parquet size: 17 KB rows: 319
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-09 | SPY | ETF | 132.42 | 132.77 | 132.31 | 132.62 | 29864000.0 |
| 2006-05-09 | QQQ | ETF | 42.1 | 42.1801 | 41.97 | 42.04 | 48566783.0 |
| 2006-05-09 | IWM | ETF | 77.57 | 77.79 | 77.35 | 77.52 | 21579600.0 |
| 2006-05-09 | DIA | ETF | 115.83 | 116.42 | 115.77 | 116.34 | 3952400.0 |
| 2006-05-09 | GLD | ETF | 68.54 | 69.72 | 68.45 | 69.68 | 12056900.0 |
| 2006-05-09 | TLT | ETF | 83.55 | 83.68 | 83.33 | 83.6 | 341300.0 |
| 2006-05-09 | AAA | ETF | 63.22 | 63.56 | 63.12 | 63.43 | 7000.0 |
| 2006-05-09 | ADRE | ETF | 146.92 | 147.39 | 146.0 | 147.39 | 34200.0 |
| 2006-05-09 | AFK | ETF | 25.16 | 25.2199 | 25.16 | 25.16 | 5000.0 |
| 2006-05-09 | AGG | ETF | 97.94 | 98.02 | 97.86 | 97.97 | 172500.0 |
| 2006-05-09 | AIQ | ETF | 30.3 | 31.75 | 30.3 | 31.55 | 55940.0 |
| 2006-05-09 | AIS | ETF | 1.5 | 1.58 | 1.47 | 1.56 | 325000.0 |
| 2006-05-09 | AOM | ETF | 6.84 | 6.84 | 6.7 | 6.84 | 8800.0 |
| 2006-05-09 | ARB | ETF | 36.43 | 36.79 | 36.24 | 36.7 | 845700.0 |
| 2006-05-09 | BAB | ETF | 63.23 | 63.68 | 63.15 | 63.68 | 42100.0 |
| 2006-05-09 | BBC | ETF | 13.25 | 13.4 | 12.5 | 12.95 | 342100.0 |
| 2006-05-09 | BBH | ETF | 58.8467 | 59.0 | 58.1667 | 58.3567 | 1688700.0 |
| 2006-05-09 | BCM | ETF | 75.3 | 75.78 | 74.7 | 74.71 | 24900.0 |
| 2006-05-09 | BITS | ETF | 32.92 | 35.0 | 29.0 | 34.2 | 107016.0 |
| 2006-05-09 | BKF | ETF | 9.3 | 9.48 | 9.18 | 9.44 | 30300.0 |
| 2006-05-09 | BNE | ETF | 15.98 | 16.09 | 15.86 | 15.98 | 129700.0 |
| 2006-05-09 | BRF | ETF | 14.0 | 14.1 | 13.96 | 14.07 | 15800.0 |
| 2006-05-09 | BTF | ETF | 88.85 | 89.0 | 88.8 | 89.0 | 2360.0 |
| 2006-05-09 | CBON | ETF | 32.76 | 34.0 | 32.17 | 33.55 | 36138.0 |
| 2006-05-09 | CDL | ETF | 10.62 | 10.7 | 10.3624 | 10.54 | 742400.0 |
| 2006-05-09 | CEF | ETF | 10.16 | 10.42 | 10.15 | 10.3 | 1229600.0 |
| 2006-05-09 | CEW | ETF | 25.39 | 25.39 | 25.39 | 25.39 | 1100.0 |
| 2006-05-09 | CFO | ETF | 10.35 | 10.35 | 10.35 | 10.35 | 7500.0 |
| 2006-05-09 | CGO | ETF | 14.79 | 14.96 | 14.79 | 14.94 | 69000.0 |
| 2006-05-09 | CHB | ETF | 16.1 | 16.1 | 15.78 | 15.79 | 434500.0 |
| 2006-05-09 | CHI | ETF | 20.13 | 20.21 | 20.03 | 20.07 | 72100.0 |
| 2006-05-09 | CHIC | ETF | 23.12 | 23.4 | 23.07 | 23.22 | 285219.0 |
| 2006-05-09 | CHY | ETF | 16.23 | 16.23 | 16.15 | 16.17 | 94400.0 |
| 2006-05-09 | CIL | ETF | 25.86 | 25.86 | 25.86 | 25.86 | 2900.0 |
| 2006-05-09 | CN | ETF | 39.73 | 40.71 | 39.65 | 40.28 | 81000.0 |
| 2006-05-09 | CNXT | ETF | 3.755 | 3.76 | 3.64 | 3.66 | 11719027.0 |
| 2006-05-09 | COMB | ETF | 10.15 | 10.15 | 10.05 | 10.1 | 9500.0 |
| 2006-05-09 | CPST | ETF | 3.88 | 3.89 | 3.69 | 3.81 | 1807533.0 |
| 2006-05-09 | CSA | ETF | 19.13 | 19.55 | 19.13 | 19.45 | 6600.0 |
| 2006-05-09 | CSB | ETF | 31.7 | 31.81 | 31.62 | 31.81 | 15600.0 |
| 2006-05-09 | CSQ | ETF | 14.05 | 14.07 | 13.96 | 14.06 | 357200.0 |
| 2006-05-09 | CTEC | ETF | 63.49999999999999 | 65.05 | 62.75 | 64.89999999999999 | 22747.600000000002 |
| 2006-05-09 | CYB | ETF | 6.15 | 6.1999 | 6.12 | 6.16 | 7300.0 |
| 2006-05-09 | DBC | ETF | 25.84 | 26.2 | 25.8 | 26.03 | 1164700.0 |
| 2006-05-09 | DGT | ETF | 69.7 | 70.01 | 69.7 | 69.97 | 1300.0 |
| 2006-05-09 | DIG | ETF | 17.8875 | 17.8875 | 17.8875 | 17.8875 | 400.0 |
| 2006-05-09 | DIV | ETF | 12.04 | 12.07 | 12.02 | 12.03 | 20800.0 |
| 2006-05-09 | DRIV | ETF | 45.44 | 47.37 | 45.43 | 47.33 | 1059754.0 |
| 2006-05-09 | DSI | ETF | 6.5 | 6.5 | 6.5 | 6.5 | 400.0 |
| 2006-05-09 | DUSA | ETF | 6.8 | 6.85 | 6.63 | 6.7 | 148219.0 |
> showing 50 of 319 rows — these rows as CSV