PREVIEW / etf_daily / 2002-01-14
file: by_date/etf_daily/2002/2002-01-14.parquet size: 9 KB rows: 117
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-14 | SPY | ETF | 114.65 | 114.84 | 113.96 | 114.22 | 12301100.0 |
| 2002-01-14 | QQQ | ETF | 40.49 | 40.68 | 39.7 | 39.96 | 71310700.0 |
| 2002-01-14 | IWM | ETF | 48.63 | 48.63 | 47.85 | 47.975 | 781000.0 |
| 2002-01-14 | DIA | ETF | 99.74 | 99.86 | 98.91 | 99.15 | 3472000.0 |
| 2002-01-14 | ARB | ETF | 32.11 | 33.15 | 31.75 | 32.8 | 129900.0 |
| 2002-01-14 | BBH | ETF | 43.2333 | 43.44 | 42.1767 | 42.1767 | 3271500.0 |
| 2002-01-14 | BITS | ETF | 24.0 | 24.08 | 22.76 | 22.76 | 6525.0 |
| 2002-01-14 | CEF | ETF | 3.55 | 3.55 | 3.47 | 3.52 | 29900.0 |
| 2002-01-14 | CHB | ETF | 11.3 | 11.4 | 11.05 | 11.39 | 464300.0 |
| 2002-01-14 | CNXT | ETF | 13.89 | 13.9 | 13.15 | 13.17 | 4696900.0 |
| 2002-01-14 | CSB | ETF | 4.59999990463257 | 4.69999980926514 | 4.59999990463257 | 4.69999980926514 | 3800.0 |
| 2002-01-14 | DGT | ETF | 65.5 | 65.6 | 65.5 | 65.6 | 400.0 |
| 2002-01-14 | EFA | ETF | 38.85 | 39.0 | 38.5867 | 38.68 | 537600.0 |
| 2002-01-14 | ELV | ETF | 25.8 | 26.2 | 25.425 | 25.95 | 682300.0 |
| 2002-01-14 | EPP | ETF | 18.51 | 18.51 | 18.51 | 18.51 | 300.0 |
| 2002-01-14 | EWA | ETF | 9.55 | 9.6 | 9.45 | 9.45 | 82600.0 |
| 2002-01-14 | EWC | ETF | 10.87 | 11.05 | 10.51 | 10.58 | 146700.0 |
| 2002-01-14 | EWD | ETF | 13.36 | 13.53 | 13.36 | 13.37 | 900.0 |
| 2002-01-14 | EWG | ETF | 14.9 | 14.9 | 14.78 | 14.8 | 16200.0 |
| 2002-01-14 | EWH | ETF | 9.4 | 9.4 | 9.31 | 9.35 | 54000.0 |
| 2002-01-14 | EWI | ETF | 31.52 | 31.8 | 31.5 | 31.8 | 1300.0 |
| 2002-01-14 | EWJ | ETF | 30.2 | 30.24 | 29.76 | 29.8 | 79750.0 |
| 2002-01-14 | EWK | ETF | 10.63 | 10.63 | 10.63 | 10.63 | 100.0 |
| 2002-01-14 | EWL | ETF | 12.48 | 12.64 | 12.45 | 12.46 | 19000.0 |
| 2002-01-14 | EWM | ETF | 20.8 | 21.04 | 20.8 | 21.0 | 72875.0 |
| 2002-01-14 | EWN | ETF | 16.67 | 16.67 | 16.52 | 16.66 | 1300.0 |
| 2002-01-14 | EWO | ETF | 7.21 | 7.21 | 7.2 | 7.2 | 1400.0 |
| 2002-01-14 | EWP | ETF | 19.58 | 19.64 | 19.46 | 19.64 | 1200.0 |
| 2002-01-14 | EWQ | ETF | 18.2 | 18.3 | 18.1 | 18.1 | 11200.0 |
| 2002-01-14 | EWS | ETF | 10.68 | 10.98 | 10.64 | 10.78 | 112950.0 |
| 2002-01-14 | EWT | ETF | 21.68 | 21.96 | 21.5 | 21.64 | 17450.0 |
| 2002-01-14 | EWU | ETF | 28.8 | 28.88 | 28.44 | 28.44 | 4650.0 |
| 2002-01-14 | EWW | ETF | 15.18 | 15.29 | 14.98 | 14.98 | 47500.0 |
| 2002-01-14 | EWY | ETF | 19.0 | 19.19 | 18.96 | 19.03 | 107600.0 |
| 2002-01-14 | EWZ | ETF | 11.8 | 11.96 | 11.7 | 11.7 | 42700.0 |
| 2002-01-14 | EZU | ETF | 27.075 | 27.075 | 26.77 | 26.79 | 119800.0 |
| 2002-01-14 | FCTR | ETF | 17.175 | 17.59 | 17.0 | 17.25 | 23900.0 |
| 2002-01-14 | FMAR | ETF | 10.067 | 10.373 | 10.067 | 10.283 | 37120.0 |
| 2002-01-14 | GLDB | ETF | 7.14 | 7.15 | 7.03 | 7.1 | 43900.0 |
| 2002-01-14 | GRNB | ETF | 17.6698 | 17.6698 | 17.6698 | 17.6698 | 707.0 |
| 2002-01-14 | GSIG | ETF | 10.2 | 10.22 | 9.91 | 10.1 | 126900.0 |
| 2002-01-14 | IBB | ETF | 29.25 | 29.25 | 28.2667 | 28.29 | 515700.0 |
| 2002-01-14 | ICF | ETF | 21.0625 | 21.1875 | 20.935 | 21.1875 | 10400.0 |
| 2002-01-14 | IDU | ETF | 31.25 | 31.765 | 31.25 | 31.645 | 102400.0 |
| 2002-01-14 | IEV | ETF | 29.0 | 29.075 | 28.675 | 28.83 | 80600.0 |
| 2002-01-14 | IGLD | ETF | 108.0 | 111.0 | 108.0 | 109.0 | 319.0 |
| 2002-01-14 | IGM | ETF | 8.8333 | 8.8333 | 8.6583 | 8.7 | 159000.0 |
| 2002-01-14 | IGN | ETF | 32.0 | 32.0 | 31.35 | 31.35 | 2600.0 |
| 2002-01-14 | IGV | ETF | 9.68 | 9.724 | 9.45 | 9.532 | 41500.0 |
| 2002-01-14 | IJH | ETF | 10.16 | 10.16 | 9.995 | 9.995 | 459000.0 |
> showing 50 of 117 rows — these rows as CSV