PREVIEW / etf_daily / 2006-01-03
file: by_date/etf_daily/2006/2006-01-03.parquet size: 16 KB rows: 302
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-01-03 | SPY | ETF | 125.19 | 127.0 | 124.39 | 126.7 | 73256700.0 |
| 2006-01-03 | QQQ | ETF | 40.65 | 41.49 | 40.16 | 41.31 | 109422192.0 |
| 2006-01-03 | IWM | ETF | 67.21 | 68.15 | 66.05 | 68.05 | 40428100.0 |
| 2006-01-03 | DIA | ETF | 107.44 | 108.56 | 106.74 | 108.33 | 9761900.0 |
| 2006-01-03 | GLD | ETF | 52.29 | 53.18 | 52.23 | 53.12 | 4606500.0 |
| 2006-01-03 | TLT | ETF | 91.59 | 92.25 | 91.48 | 91.78 | 1392700.0 |
| 2006-01-03 | AAA | ETF | 55.4 | 55.79 | 55.4 | 55.79 | 1200.0 |
| 2006-01-03 | ADRE | ETF | 117.69 | 119.76 | 117.0 | 119.5 | 74344.0 |
| 2006-01-03 | AFK | ETF | 25.26 | 25.29 | 25.2 | 25.2 | 6800.0 |
| 2006-01-03 | AGG | ETF | 100.47 | 100.72 | 100.36 | 100.64 | 170600.0 |
| 2006-01-03 | AIQ | ETF | 29.75 | 29.95 | 28.25 | 28.75 | 14140.0 |
| 2006-01-03 | AIS | ETF | 1.59 | 1.6 | 1.45 | 1.54 | 210100.0 |
| 2006-01-03 | AOM | ETF | 4.15 | 4.48 | 4.15 | 4.48 | 21500.0 |
| 2006-01-03 | ARB | ETF | 38.32 | 39.0 | 38.1 | 38.8 | 342400.0 |
| 2006-01-03 | BAB | ETF | 58.05 | 59.26 | 58.0 | 59.15 | 36200.0 |
| 2006-01-03 | BBC | ETF | 14.25 | 14.35 | 13.1401 | 14.06 | 271400.0 |
| 2006-01-03 | BBH | ETF | 67.0333 | 68.4867 | 66.1433 | 68.1633 | 2910000.0 |
| 2006-01-03 | BCM | ETF | 65.61 | 67.25 | 65.61 | 66.98 | 49400.0 |
| 2006-01-03 | BITS | ETF | 14.88 | 15.36 | 14.2 | 14.6 | 7131.0 |
| 2006-01-03 | BKF | ETF | 19.01 | 19.25 | 18.6 | 18.8 | 62200.0 |
| 2006-01-03 | BNE | ETF | 14.94 | 15.2 | 14.48 | 15.14 | 104300.0 |
| 2006-01-03 | BRF | ETF | 15.18 | 15.24 | 15.18 | 15.24 | 4800.0 |
| 2006-01-03 | BTF | ETF | 84.64999999999999 | 87.85 | 84.60000000000001 | 85.29999999999998 | 7020.0 |
| 2006-01-03 | CBON | ETF | 31.66 | 32.75 | 31.45 | 32.58 | 14014.0 |
| 2006-01-03 | CDL | ETF | 13.54 | 13.64 | 13.27 | 13.5 | 481800.0 |
| 2006-01-03 | CEF | ETF | 6.95 | 7.75 | 6.85 | 7.09 | 1086500.0 |
| 2006-01-03 | CEW | ETF | 26.0 | 26.24 | 26.0 | 26.24 | 2400.0 |
| 2006-01-03 | CFO | ETF | 9.9 | 9.9 | 9.9 | 9.9 | 10500.0 |
| 2006-01-03 | CGO | ETF | 14.08 | 14.2 | 13.89 | 14.16 | 41200.0 |
| 2006-01-03 | CHB | ETF | 13.67 | 13.69 | 13.06 | 13.44 | 1109000.0 |
| 2006-01-03 | CHI | ETF | 19.91 | 20.11 | 19.81 | 20.04 | 59300.0 |
| 2006-01-03 | CHIC | ETF | 21.02 | 21.44 | 20.22 | 21.32 | 560040.0 |
| 2006-01-03 | CHIR | ETF | 44.4399 | 44.8599 | 44.4399 | 44.6301 | 1080095.0 |
| 2006-01-03 | CHY | ETF | 15.74 | 15.91 | 15.61 | 15.86 | 103800.0 |
| 2006-01-03 | CIL | ETF | 25.28 | 25.28 | 25.28 | 25.28 | 100.0 |
| 2006-01-03 | CIZ | ETF | 22.7 | 22.7 | 22.7 | 22.7 | 100.0 |
| 2006-01-03 | CN | ETF | 32.6 | 33.15 | 32.6 | 33.1 | 28600.0 |
| 2006-01-03 | CNXT | ETF | 2.31 | 2.4101 | 2.28 | 2.36 | 9700840.0 |
| 2006-01-03 | COMB | ETF | 8.1 | 8.1 | 8.1 | 8.1 | 300.0 |
| 2006-01-03 | CPST | ETF | 3.07 | 3.08 | 2.96 | 3.03 | 2112433.0 |
| 2006-01-03 | CSA | ETF | 16.9 | 17.5 | 16.9 | 17.35 | 60500.0 |
| 2006-01-03 | CSB | ETF | 32.82 | 33.18 | 32.64 | 33.18 | 16200.0 |
| 2006-01-03 | CSM | ETF | 2.45 | 2.45 | 2.45 | 2.45 | 5200.0 |
| 2006-01-03 | CSQ | ETF | 13.55 | 13.74 | 13.45 | 13.71 | 442300.0 |
| 2006-01-03 | CTEC | ETF | 50.4 | 50.849999999999994 | 48.4 | 50.55 | 5551.400000000001 |
| 2006-01-03 | CURE | ETF | 0.0275 | 0.0338 | 0.0262 | 0.0312 | 6065832.0 |
| 2006-01-03 | CYB | ETF | 3.65 | 3.65 | 3.6 | 3.6 | 1000.0 |
| 2006-01-03 | DGT | ETF | 65.54 | 66.21 | 65.29 | 66.21 | 7300.0 |
| 2006-01-03 | DIG | ETF | 16.525 | 16.925 | 16.525 | 16.925 | 5440.0 |
| 2006-01-03 | DIV | ETF | 12.11 | 12.1799 | 12.1 | 12.17 | 25300.0 |
> showing 50 of 302 rows — these rows as CSV