PREVIEW / etf_daily / 2006-01-10
file: by_date/etf_daily/2006/2006-01-10.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-10 | SPY | ETF | 128.39 | 128.98 | 128.26 | 128.9 | 44960800.0 |
| 2006-01-10 | QQQ | ETF | 42.64 | 42.92 | 42.55 | 42.88 | 84420431.0 |
| 2006-01-10 | IWM | ETF | 69.73 | 70.7 | 69.68 | 70.7 | 27130700.0 |
| 2006-01-10 | DIA | ETF | 109.56 | 110.14 | 109.47 | 110.08 | 6390700.0 |
| 2006-01-10 | GLD | ETF | 53.96 | 54.38 | 53.76 | 54.06 | 5700600.0 |
| 2006-01-10 | TLT | ETF | 91.63 | 91.68 | 91.03 | 91.04 | 698900.0 |
| 2006-01-10 | AAA | ETF | 55.87 | 55.87 | 55.39 | 55.63 | 3400.0 |
| 2006-01-10 | ADRE | ETF | 124.9 | 124.9 | 121.88 | 122.26 | 80612.0 |
| 2006-01-10 | AFK | ETF | 25.25 | 25.32 | 25.24 | 25.24 | 7500.0 |
| 2006-01-10 | AGG | ETF | 100.82 | 100.84 | 100.55 | 100.56 | 251500.0 |
| 2006-01-10 | AIQ | ETF | 28.45 | 28.75 | 27.75 | 28.25 | 9420.0 |
| 2006-01-10 | AIS | ETF | 1.49 | 1.5 | 1.45 | 1.47 | 120000.0 |
| 2006-01-10 | AOM | ETF | 4.33 | 4.39 | 4.31 | 4.39 | 30600.0 |
| 2006-01-10 | ARB | ETF | 38.75 | 39.65 | 38.6 | 39.65 | 148600.0 |
| 2006-01-10 | BAB | ETF | 56.91 | 57.31 | 56.74 | 57.21 | 47900.0 |
| 2006-01-10 | BBC | ETF | 15.35 | 15.8 | 15.11 | 15.5 | 140800.0 |
| 2006-01-10 | BBH | ETF | 68.0333 | 68.1133 | 67.45 | 68.1133 | 1669200.0 |
| 2006-01-10 | BCM | ETF | 67.7 | 68.14 | 67.52 | 67.98 | 28800.0 |
| 2006-01-10 | BITS | ETF | 14.92 | 15.0 | 14.4 | 14.48 | 6330.0 |
| 2006-01-10 | BKF | ETF | 18.48 | 18.54 | 18.4 | 18.48 | 21700.0 |
| 2006-01-10 | BNE | ETF | 14.93 | 15.11 | 14.93 | 15.09 | 77200.0 |
| 2006-01-10 | BRF | ETF | 15.44 | 15.44 | 15.44 | 15.44 | 2000.0 |
| 2006-01-10 | BTF | ETF | 85.64949999999999 | 85.99999999999999 | 85.15 | 85.95 | 2360.0 |
| 2006-01-10 | CBON | ETF | 32.18 | 32.99 | 32.18 | 32.87 | 5771.0 |
| 2006-01-10 | CDL | ETF | 13.42 | 13.45 | 13.21 | 13.3 | 533900.0 |
| 2006-01-10 | CEF | ETF | 7.12 | 7.13 | 7.03 | 7.1 | 469500.0 |
| 2006-01-10 | CEW | ETF | 26.14 | 26.14 | 26.12 | 26.12 | 800.0 |
| 2006-01-10 | CFO | ETF | 9.85 | 9.9 | 9.85 | 9.9 | 22900.0 |
| 2006-01-10 | CGO | ETF | 14.32 | 14.32 | 14.12 | 14.32 | 47100.0 |
| 2006-01-10 | CHB | ETF | 13.85 | 14.3 | 13.8 | 14.2 | 551600.0 |
| 2006-01-10 | CHI | ETF | 20.32 | 20.38 | 20.0 | 20.21 | 112400.0 |
| 2006-01-10 | CHIC | ETF | 21.45 | 21.6 | 20.1 | 20.42 | 1455252.0 |
| 2006-01-10 | CHIR | ETF | 44.6799 | 44.7501 | 44.6499 | 44.7201 | 746280.0 |
| 2006-01-10 | CHY | ETF | 16.08 | 16.1299 | 15.9101 | 15.94 | 122000.0 |
| 2006-01-10 | CIZ | ETF | 22.3 | 22.5 | 22.25 | 22.5 | 2800.0 |
| 2006-01-10 | CN | ETF | 34.15 | 34.41 | 34.05 | 34.1 | 31100.0 |
| 2006-01-10 | CNXT | ETF | 2.8 | 2.87 | 2.75 | 2.83 | 39356833.0 |
| 2006-01-10 | COMB | ETF | 8.35 | 8.35 | 8.33 | 8.33 | 2100.0 |
| 2006-01-10 | CPI | ETF | 27.9 | 27.9 | 27.81 | 27.81 | 400.0 |
| 2006-01-10 | CPST | ETF | 3.2 | 3.24 | 3.13 | 3.2 | 2598960.0 |
| 2006-01-10 | CSA | ETF | 17.46 | 17.55 | 17.41 | 17.47 | 17200.0 |
| 2006-01-10 | CSB | ETF | 31.9 | 32.21 | 31.87 | 32.11 | 5400.0 |
| 2006-01-10 | CSM | ETF | 2.46 | 2.46 | 2.46 | 2.46 | 2000.0 |
| 2006-01-10 | CSQ | ETF | 13.97 | 14.04 | 13.85 | 14.04 | 372500.0 |
| 2006-01-10 | CTEC | ETF | 50.25 | 50.25 | 49.349999999999994 | 50.0 | 13543.0 |
| 2006-01-10 | CURE | ETF | 0.03 | 0.0312 | 0.0275 | 0.0312 | 2976624.0 |
| 2006-01-10 | CYB | ETF | 3.71 | 3.74 | 3.71 | 3.74 | 1900.0 |
| 2006-01-10 | DGT | ETF | 67.13 | 67.26 | 66.95 | 67.08 | 16200.0 |
| 2006-01-10 | DIG | ETF | 16.925 | 16.925 | 16.925 | 16.925 | 2080.0 |
| 2006-01-10 | DIV | ETF | 12.48 | 12.62 | 12.44 | 12.6 | 27700.0 |
> showing 50 of 302 rows — these rows as CSV