PREVIEW / etf_daily / 2006-01-13
file: by_date/etf_daily/2006/2006-01-13.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-13 | SPY | ETF | 128.57 | 128.9 | 128.2 | 128.68 | 44856700.0 |
| 2006-01-13 | QQQ | ETF | 42.94 | 43.05 | 42.73 | 42.98 | 64586061.0 |
| 2006-01-13 | IWM | ETF | 70.27 | 70.47 | 70.02 | 70.36 | 20630300.0 |
| 2006-01-13 | DIA | ETF | 109.63 | 109.93 | 109.19 | 109.54 | 3712200.0 |
| 2006-01-13 | GLD | ETF | 54.55 | 55.56 | 54.51 | 55.44 | 4346200.0 |
| 2006-01-13 | TLT | ETF | 91.59 | 92.3 | 91.58 | 92.03 | 491000.0 |
| 2006-01-13 | AAA | ETF | 55.05 | 55.26 | 54.96 | 55.26 | 5200.0 |
| 2006-01-13 | ADRE | ETF | 123.5 | 123.55 | 122.5401 | 123.55 | 46008.0 |
| 2006-01-13 | AFK | ETF | 25.3 | 25.31 | 25.25 | 25.31 | 5400.0 |
| 2006-01-13 | AGG | ETF | 100.88 | 101.13 | 100.81 | 101.03 | 108400.0 |
| 2006-01-13 | AIQ | ETF | 27.5 | 28.05 | 27.1 | 27.65 | 30840.0 |
| 2006-01-13 | AIS | ETF | 1.42 | 1.42 | 1.38 | 1.41 | 302900.0 |
| 2006-01-13 | AOM | ETF | 5.23 | 5.25 | 5.1 | 5.149 | 187800.0 |
| 2006-01-13 | ARB | ETF | 39.32 | 39.45 | 39.1 | 39.25 | 81000.0 |
| 2006-01-13 | BAB | ETF | 58.41 | 59.15 | 58.26 | 58.78 | 35400.0 |
| 2006-01-13 | BBC | ETF | 17.53 | 17.67 | 16.24 | 16.58 | 305600.0 |
| 2006-01-13 | BBH | ETF | 65.6733 | 66.3667 | 65.5467 | 66.3333 | 1043400.0 |
| 2006-01-13 | BCM | ETF | 68.75 | 69.22 | 68.57 | 68.94 | 35100.0 |
| 2006-01-13 | BITS | ETF | 14.596 | 15.32 | 14.56 | 15.32 | 4365.0 |
| 2006-01-13 | BKF | ETF | 18.41 | 18.67 | 18.26 | 18.48 | 25300.0 |
| 2006-01-13 | BNE | ETF | 14.5 | 14.72 | 14.28 | 14.38 | 180800.0 |
| 2006-01-13 | BRF | ETF | 15.26 | 15.42 | 15.26 | 15.3 | 6100.0 |
| 2006-01-13 | BTF | ETF | 85.6 | 85.99999999999999 | 85.6 | 85.8 | 3000.0 |
| 2006-01-13 | CBON | ETF | 32.59 | 32.9 | 32.59 | 32.85 | 4456.0 |
| 2006-01-13 | CDL | ETF | 13.14 | 13.16 | 12.98 | 13.13 | 179200.0 |
| 2006-01-13 | CEF | ETF | 7.14 | 7.35 | 7.12 | 7.32 | 719300.0 |
| 2006-01-13 | CEW | ETF | 26.2 | 26.45 | 26.2 | 26.45 | 1200.0 |
| 2006-01-13 | CFO | ETF | 10.0 | 10.0 | 10.0 | 10.0 | 5000.0 |
| 2006-01-13 | CGO | ETF | 14.47 | 14.55 | 14.2 | 14.35 | 35100.0 |
| 2006-01-13 | CHB | ETF | 13.46 | 13.75 | 13.23 | 13.25 | 743800.0 |
| 2006-01-13 | CHI | ETF | 20.2 | 20.34 | 20.11 | 20.21 | 82500.0 |
| 2006-01-13 | CHIC | ETF | 20.44 | 20.89 | 20.09 | 20.18 | 283530.0 |
| 2006-01-13 | CHIR | ETF | 44.7201 | 44.7699 | 44.6499 | 44.7399 | 458302.0 |
| 2006-01-13 | CHY | ETF | 16.14 | 16.23 | 16.08 | 16.18 | 92200.0 |
| 2006-01-13 | CIL | ETF | 25.34 | 25.34 | 25.34 | 25.34 | 3200.0 |
| 2006-01-13 | CN | ETF | 34.2 | 34.2 | 34.0 | 34.15 | 23200.0 |
| 2006-01-13 | CNXT | ETF | 3.39 | 3.39 | 3.149 | 3.26 | 26745963.0 |
| 2006-01-13 | COMB | ETF | 8.4 | 8.559 | 8.35 | 8.559 | 3452.0 |
| 2006-01-13 | CPI | ETF | 28.4 | 29.08 | 28.4 | 29.07 | 3000.0 |
| 2006-01-13 | CPST | ETF | 3.455 | 3.65 | 3.44 | 3.6 | 4772643.0 |
| 2006-01-13 | CSA | ETF | 17.8 | 17.8 | 17.65 | 17.68 | 9300.0 |
| 2006-01-13 | CSB | ETF | 32.17 | 32.46 | 31.97 | 32.46 | 12700.0 |
| 2006-01-13 | CSM | ETF | 2.4725 | 2.4725 | 2.47 | 2.4725 | 13600.0 |
| 2006-01-13 | CSQ | ETF | 14.06 | 14.08 | 13.98 | 14.06 | 343600.0 |
| 2006-01-13 | CTEC | ETF | 48.6 | 49.05 | 47.9 | 48.699999999999996 | 12642.0 |
| 2006-01-13 | CURE | ETF | 0.0288 | 0.0312 | 0.0288 | 0.0312 | 1971192.0 |
| 2006-01-13 | CYB | ETF | 3.9 | 3.95 | 3.9 | 3.95 | 2600.0 |
| 2006-01-13 | DGT | ETF | 67.06 | 67.17 | 67.06 | 67.15 | 1900.0 |
| 2006-01-13 | DIG | ETF | 16.9875 | 17.05 | 16.975 | 16.9875 | 5280.0 |
| 2006-01-13 | DIV | ETF | 12.45 | 12.55 | 12.42 | 12.55 | 13200.0 |
> showing 50 of 302 rows — these rows as CSV