PREVIEW / etf_daily / 2006-01-24
file: by_date/etf_daily/2006/2006-01-24.parquet size: 16 KB rows: 298
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-24 | SPY | ETF | 126.63 | 127.15 | 126.42 | 126.55 | 53008800.0 |
| 2006-01-24 | QQQ | ETF | 41.36 | 41.7 | 41.31 | 41.44 | 77967258.0 |
| 2006-01-24 | IWM | ETF | 70.45 | 71.43 | 70.44 | 71.2 | 36770600.0 |
| 2006-01-24 | DIA | ETF | 106.95 | 107.41 | 106.78 | 106.94 | 7147800.0 |
| 2006-01-24 | GLD | ETF | 55.5 | 55.73 | 55.27 | 55.73 | 3419100.0 |
| 2006-01-24 | TLT | ETF | 92.0 | 92.19 | 91.76 | 91.9 | 300500.0 |
| 2006-01-24 | AAA | ETF | 53.74 | 54.0 | 53.49 | 53.99 | 2100.0 |
| 2006-01-24 | ADRE | ETF | 125.11 | 125.92 | 124.02 | 125.91 | 27864.0 |
| 2006-01-24 | AFK | ETF | 25.32 | 25.44 | 25.28 | 25.42 | 9000.0 |
| 2006-01-24 | AGG | ETF | 101.1 | 101.13 | 100.8 | 100.93 | 209400.0 |
| 2006-01-24 | AIQ | ETF | 26.05 | 26.45 | 24.5 | 24.8 | 19860.0 |
| 2006-01-24 | AIS | ETF | 1.52 | 1.54 | 1.48 | 1.53 | 245300.0 |
| 2006-01-24 | AOM | ETF | 5.5 | 5.51 | 5.49 | 5.51 | 12600.0 |
| 2006-01-24 | ARB | ETF | 39.81 | 40.77 | 38.26 | 40.3 | 333500.0 |
| 2006-01-24 | BAB | ETF | 56.93 | 57.14 | 56.61 | 56.76 | 47600.0 |
| 2006-01-24 | BBC | ETF | 16.7 | 18.98 | 16.7 | 18.65 | 515700.0 |
| 2006-01-24 | BBH | ETF | 64.62 | 65.0333 | 64.26 | 64.8567 | 1203900.0 |
| 2006-01-24 | BCM | ETF | 68.41 | 68.59 | 67.98 | 68.09 | 46300.0 |
| 2006-01-24 | BITS | ETF | 15.4 | 15.48 | 14.92 | 15.24 | 2532.0 |
| 2006-01-24 | BKF | ETF | 14.17 | 14.33 | 13.19 | 13.26 | 171900.0 |
| 2006-01-24 | BNE | ETF | 14.58 | 14.9 | 14.57 | 14.72 | 449000.0 |
| 2006-01-24 | BRF | ETF | 15.39 | 15.45 | 15.39 | 15.45 | 11100.0 |
| 2006-01-24 | BTF | ETF | 84.8 | 85.15 | 84.74999999999999 | 85.0 | 820.0 |
| 2006-01-24 | CBON | ETF | 29.94 | 30.96 | 29.92 | 30.96 | 40209.0 |
| 2006-01-24 | CDL | ETF | 12.27 | 12.48 | 12.27 | 12.33 | 726100.0 |
| 2006-01-24 | CEF | ETF | 7.3 | 7.3 | 7.13 | 7.19 | 475100.0 |
| 2006-01-24 | CEW | ETF | 26.3 | 26.3 | 26.3 | 26.3 | 100.0 |
| 2006-01-24 | CFO | ETF | 10.1 | 10.15 | 10.06 | 10.15 | 12600.0 |
| 2006-01-24 | CGO | ETF | 14.1 | 14.38 | 14.0 | 14.34 | 43400.0 |
| 2006-01-24 | CHB | ETF | 13.6 | 13.8 | 13.45 | 13.57 | 858600.0 |
| 2006-01-24 | CHI | ETF | 20.39 | 20.42 | 20.21 | 20.38 | 115100.0 |
| 2006-01-24 | CHIC | ETF | 15.55 | 15.75 | 15.34 | 15.63 | 758049.0 |
| 2006-01-24 | CHIR | ETF | 44.73 | 44.7501 | 44.6601 | 44.67 | 808877.0 |
| 2006-01-24 | CHY | ETF | 16.13 | 16.27 | 16.06 | 16.23 | 106200.0 |
| 2006-01-24 | CIZ | ETF | 23.75 | 24.0 | 23.75 | 24.0 | 800.0 |
| 2006-01-24 | CN | ETF | 34.28 | 34.76 | 34.28 | 34.56 | 23300.0 |
| 2006-01-24 | CNXT | ETF | 3.23 | 3.31 | 3.18 | 3.31 | 21539976.0 |
| 2006-01-24 | COMB | ETF | 8.35 | 8.41 | 8.35 | 8.41 | 6800.0 |
| 2006-01-24 | CPI | ETF | 30.15 | 30.15 | 30.05 | 30.06 | 900.0 |
| 2006-01-24 | CPST | ETF | 3.89 | 3.99 | 3.63 | 3.72 | 13771101.0 |
| 2006-01-24 | CSA | ETF | 17.55 | 17.8 | 17.55 | 17.8 | 28900.0 |
| 2006-01-24 | CSB | ETF | 33.0 | 33.0 | 32.82 | 33.0 | 11400.0 |
| 2006-01-24 | CSQ | ETF | 13.83 | 13.95 | 13.8201 | 13.89 | 373000.0 |
| 2006-01-24 | CTEC | ETF | 51.55 | 52.35 | 50.99999999999999 | 52.0 | 17649.0 |
| 2006-01-24 | CURE | ETF | 0.035 | 0.0362 | 0.0337 | 0.0338 | 1677784.0 |
| 2006-01-24 | CYB | ETF | 4.15 | 4.19 | 4.12 | 4.19 | 5000.0 |
| 2006-01-24 | DGT | ETF | 65.75 | 65.96 | 65.7 | 65.75 | 4800.0 |
| 2006-01-24 | DIG | ETF | 17.1875 | 17.1875 | 17.0125 | 17.1875 | 2640.0 |
| 2006-01-24 | DIV | ETF | 12.4 | 12.49 | 12.35 | 12.48 | 18300.0 |
| 2006-01-24 | DRIV | ETF | 31.5 | 32.07 | 31.2 | 31.76 | 832399.0 |
> showing 50 of 298 rows — these rows as CSV