PREVIEW / etf_daily / 2006-11-14
file: by_date/etf_daily/2006/2006-11-14.parquet size: 19 KB rows: 385
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-11-14 | SPY | ETF | 138.97 | 139.74 | 138.12 | 139.62 | 96704000.0 |
| 2006-11-14 | QQQ | ETF | 43.5 | 43.97 | 43.24 | 43.93 | 121986641.0 |
| 2006-11-14 | IWM | ETF | 76.91 | 78.11 | 76.43 | 78.11 | 68600600.0 |
| 2006-11-14 | DIA | ETF | 121.67 | 122.45 | 120.99 | 122.32 | 7650200.0 |
| 2006-11-14 | GLD | ETF | 62.31 | 62.52 | 61.46 | 61.63 | 5706200.0 |
| 2006-11-14 | TLT | ETF | 90.34 | 90.39 | 90.12 | 90.19 | 916400.0 |
| 2006-11-14 | AAA | ETF | 57.41 | 57.49 | 57.11 | 57.48 | 2000.0 |
| 2006-11-14 | ADRE | ETF | 35.65 | 35.92 | 35.59 | 35.92 | 159164.0 |
| 2006-11-14 | AGG | ETF | 100.44 | 100.48 | 100.29 | 100.34 | 191800.0 |
| 2006-11-14 | AIQ | ETF | 37.45 | 37.5 | 36.6 | 37.15 | 17060.0 |
| 2006-11-14 | AIS | ETF | 1.29 | 1.3 | 1.24 | 1.28 | 93600.0 |
| 2006-11-14 | ARB | ETF | 44.03 | 45.25 | 44.01 | 44.9 | 395100.0 |
| 2006-11-14 | BAB | ETF | 88.4 | 88.84 | 87.4 | 88.84 | 41700.0 |
| 2006-11-14 | BBC | ETF | 6.61 | 6.75 | 5.8114 | 5.9 | 3895200.0 |
| 2006-11-14 | BBH | ETF | 62.13 | 62.4167 | 61.6167 | 62.3867 | 1638000.0 |
| 2006-11-14 | BITS | ETF | 39.12 | 39.4796 | 37.8 | 38.52 | 30770.0 |
| 2006-11-14 | BNE | ETF | 15.48 | 15.67 | 15.22 | 15.6 | 132000.0 |
| 2006-11-14 | BOSS | ETF | 40.45 | 40.45 | 40.45 | 40.45 | 100.0 |
| 2006-11-14 | BRF | ETF | 14.24 | 14.35 | 14.21 | 14.34 | 19500.0 |
| 2006-11-14 | BTF | ETF | 105.19999999999999 | 105.35 | 105.0 | 105.15 | 1320.0 |
| 2006-11-14 | CBON | ETF | 30.3 | 31.21 | 30.19 | 31.1 | 84203.0 |
| 2006-11-14 | CDL | ETF | 10.4 | 10.75 | 10.31 | 10.49 | 264600.0 |
| 2006-11-14 | CEF | ETF | 9.24 | 9.26 | 9.05 | 9.12 | 487200.0 |
| 2006-11-14 | CFO | ETF | 10.7 | 10.81 | 10.7 | 10.81 | 600.0 |
| 2006-11-14 | CGO | ETF | 15.66 | 15.78 | 15.66 | 15.78 | 33300.0 |
| 2006-11-14 | CHB | ETF | 8.55 | 9.12 | 8.39 | 8.99 | 1767100.0 |
| 2006-11-14 | CHI | ETF | 19.54 | 19.64 | 19.5 | 19.6399 | 130300.0 |
| 2006-11-14 | CHIC | ETF | 27.71 | 28.14 | 27.65 | 28.01 | 456776.0 |
| 2006-11-14 | CHY | ETF | 16.63 | 16.85 | 16.55 | 16.79 | 170800.0 |
| 2006-11-14 | CIL | ETF | 25.91 | 25.97 | 25.91 | 25.97 | 500.0 |
| 2006-11-14 | CIZ | ETF | 22.0 | 22.0 | 22.0 | 22.0 | 200.0 |
| 2006-11-14 | CN | ETF | 40.3 | 40.55 | 39.98 | 40.25 | 58800.0 |
| 2006-11-14 | CNXT | ETF | 2.21 | 2.3 | 2.19 | 2.26 | 18874468.0 |
| 2006-11-14 | CPST | ETF | 1.4 | 1.41 | 1.35 | 1.41 | 1887340.0 |
| 2006-11-14 | CSA | ETF | 20.33 | 20.5 | 20.33 | 20.43 | 17300.0 |
| 2006-11-14 | CSB | ETF | 31.64 | 31.72 | 31.372 | 31.69 | 14200.0 |
| 2006-11-14 | CSM | ETF | 1.305 | 1.305 | 1.305 | 1.305 | 4000.0 |
| 2006-11-14 | CSQ | ETF | 14.85 | 14.97 | 14.82 | 14.97 | 389900.0 |
| 2006-11-14 | CTEC | ETF | 85.64999999999999 | 89.64999999999999 | 85.64999999999999 | 89.0 | 38223.8 |
| 2006-11-14 | CVY | ETF | 25.93 | 26.04 | 25.79 | 26.04 | 22200.0 |
| 2006-11-14 | CYB | ETF | 6.36 | 6.6 | 6.25 | 6.6 | 46000.0 |
| 2006-11-14 | DBC | ETF | 24.56 | 24.8 | 24.55 | 24.65 | 189900.0 |
| 2006-11-14 | DBV | ETF | 25.18 | 25.25 | 25.17 | 25.21 | 32100.0 |
| 2006-11-14 | DDM | ETF | 7.1117 | 7.2025 | 7.0358 | 7.1925 | 688800.0 |
| 2006-11-14 | DES | ETF | 18.7433 | 19.0 | 18.71 | 19.0 | 47700.0 |
| 2006-11-14 | DEW | ETF | 59.5 | 59.79 | 59.1 | 59.77 | 6900.0 |
| 2006-11-14 | DFE | ETF | 60.78 | 60.8 | 60.63 | 60.67 | 2600.0 |
| 2006-11-14 | DFJ | ETF | 48.84 | 48.85 | 48.52 | 48.52 | 5800.0 |
| 2006-11-14 | DGT | ETF | 74.2 | 74.79 | 73.98 | 74.63 | 16300.0 |
| 2006-11-14 | DHS | ETF | 56.18 | 56.38 | 55.8 | 56.33 | 22000.0 |
> showing 50 of 385 rows — these rows as CSV