PREVIEW / etf_daily / 2006-01-19
file: by_date/etf_daily/2006/2006-01-19.parquet size: 16 KB rows: 300
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-19 | SPY | ETF | 128.13 | 128.77 | 127.81 | 128.31 | 81530400.0 |
| 2006-01-19 | QQQ | ETF | 42.4 | 42.82 | 42.29 | 42.52 | 111105162.0 |
| 2006-01-19 | IWM | ETF | 70.05 | 71.17 | 69.94 | 71.0 | 26801500.0 |
| 2006-01-19 | DIA | ETF | 108.73 | 109.18 | 108.54 | 108.73 | 4596400.0 |
| 2006-01-19 | GLD | ETF | 54.96 | 55.71 | 54.95 | 55.59 | 5290700.0 |
| 2006-01-19 | TLT | ETF | 92.07 | 92.44 | 91.96 | 92.14 | 490600.0 |
| 2006-01-19 | AAA | ETF | 54.28 | 54.69 | 54.26 | 54.64 | 2700.0 |
| 2006-01-19 | ADRE | ETF | 121.5 | 124.02 | 121.5 | 124.0 | 35732.0 |
| 2006-01-19 | AFK | ETF | 25.48 | 25.49 | 25.3 | 25.45 | 5600.0 |
| 2006-01-19 | AGG | ETF | 101.04 | 101.11 | 100.81 | 101.05 | 156500.0 |
| 2006-01-19 | AIQ | ETF | 26.25 | 27.45 | 26.0 | 26.85 | 19160.0 |
| 2006-01-19 | AIS | ETF | 1.5 | 1.5 | 1.41 | 1.44 | 733800.0 |
| 2006-01-19 | AOM | ETF | 5.72 | 5.81 | 5.68 | 5.7 | 133000.0 |
| 2006-01-19 | ARB | ETF | 39.65 | 40.15 | 39.46 | 40.15 | 154700.0 |
| 2006-01-19 | BAB | ETF | 56.35 | 56.37 | 55.61 | 55.9 | 62600.0 |
| 2006-01-19 | BBC | ETF | 16.5 | 17.22 | 16.35 | 16.88 | 187100.0 |
| 2006-01-19 | BBH | ETF | 66.9333 | 67.06 | 66.23 | 66.9067 | 1690500.0 |
| 2006-01-19 | BCM | ETF | 68.51 | 69.0 | 68.2 | 68.8 | 17300.0 |
| 2006-01-19 | BITS | ETF | 15.44 | 15.68 | 15.0 | 15.48 | 6671.0 |
| 2006-01-19 | BKF | ETF | 16.08 | 16.18 | 13.66 | 14.51 | 391000.0 |
| 2006-01-19 | BNE | ETF | 14.35 | 14.77 | 14.32 | 14.74 | 106100.0 |
| 2006-01-19 | BRF | ETF | 15.4 | 15.45 | 15.32 | 15.45 | 5100.0 |
| 2006-01-19 | BTF | ETF | 85.15 | 85.6 | 85.0 | 85.44999999999999 | 1800.0 |
| 2006-01-19 | CBON | ETF | 32.4 | 32.6 | 32.16 | 32.18 | 25707.0 |
| 2006-01-19 | CDL | ETF | 13.02 | 13.23 | 12.95 | 13.18 | 116800.0 |
| 2006-01-19 | CEF | ETF | 7.2 | 7.4 | 7.18 | 7.4 | 640000.0 |
| 2006-01-19 | CFO | ETF | 10.0 | 10.05 | 9.91 | 10.05 | 18800.0 |
| 2006-01-19 | CGO | ETF | 14.21 | 14.36 | 14.1 | 14.22 | 22300.0 |
| 2006-01-19 | CHB | ETF | 13.54 | 14.16 | 13.43 | 14.12 | 817900.0 |
| 2006-01-19 | CHI | ETF | 20.2 | 20.45 | 20.15 | 20.36 | 82900.0 |
| 2006-01-19 | CHIC | ETF | 18.1 | 18.1 | 15.87 | 15.9 | 5370434.0 |
| 2006-01-19 | CHIR | ETF | 44.7399 | 44.8701 | 44.67 | 44.8101 | 599676.0 |
| 2006-01-19 | CHY | ETF | 16.05 | 16.22 | 16.0 | 16.16 | 108300.0 |
| 2006-01-19 | CIZ | ETF | 23.25 | 23.25 | 23.15 | 23.25 | 4200.0 |
| 2006-01-19 | CN | ETF | 34.04 | 34.4 | 34.02 | 34.4 | 28500.0 |
| 2006-01-19 | CNXT | ETF | 3.275 | 3.35 | 3.2599 | 3.34 | 28195289.0 |
| 2006-01-19 | COMB | ETF | 8.35 | 8.37 | 8.35 | 8.37 | 860.0 |
| 2006-01-19 | CPI | ETF | 29.75 | 29.9 | 29.75 | 29.9 | 800.0 |
| 2006-01-19 | CPST | ETF | 3.48 | 3.48 | 3.32 | 3.3492 | 3093045.0 |
| 2006-01-19 | CSA | ETF | 17.5 | 17.65 | 17.5 | 17.64 | 14000.0 |
| 2006-01-19 | CSB | ETF | 31.46 | 31.77 | 31.44 | 31.72 | 6900.0 |
| 2006-01-19 | CSM | ETF | 2.465 | 2.465 | 2.465 | 2.465 | 1600.0 |
| 2006-01-19 | CSQ | ETF | 14.1 | 14.14 | 14.03 | 14.05 | 447300.0 |
| 2006-01-19 | CTEC | ETF | 49.85 | 50.49999999999999 | 49.45 | 49.699999999999996 | 15457.0 |
| 2006-01-19 | CURE | ETF | 0.0375 | 0.04 | 0.0325 | 0.035 | 3077360.0 |
| 2006-01-19 | CYB | ETF | 4.35 | 4.48 | 4.29 | 4.35 | 25000.0 |
| 2006-01-19 | DGT | ETF | 66.62 | 66.63 | 66.6 | 66.61 | 800.0 |
| 2006-01-19 | DIG | ETF | 16.8875 | 17.1875 | 16.8875 | 17.1875 | 2880.0 |
| 2006-01-19 | DIV | ETF | 12.45 | 12.49 | 12.39 | 12.44 | 28300.0 |
| 2006-01-19 | DRIV | ETF | 32.58 | 32.81 | 31.8 | 31.9 | 1088493.0 |
> showing 50 of 300 rows — these rows as CSV