PREVIEW / etf_daily / 2002-01-17
file: by_date/etf_daily/2002/2002-01-17.parquet size: 9 KB rows: 116
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-17 | SPY | ETF | 113.76 | 114.24 | 113.4 | 113.67 | 17283400.0 |
| 2002-01-17 | QQQ | ETF | 39.48 | 39.977 | 39.01 | 39.65 | 75285900.0 |
| 2002-01-17 | IWM | ETF | 47.75 | 48.0 | 47.26 | 47.55 | 813400.0 |
| 2002-01-17 | DIA | ETF | 97.84 | 98.75 | 97.52 | 98.23 | 3493700.0 |
| 2002-01-17 | ARB | ETF | 32.25 | 32.25 | 31.8 | 32.25 | 36600.0 |
| 2002-01-17 | BBH | ETF | 42.2 | 42.2167 | 40.56 | 41.3833 | 8303400.0 |
| 2002-01-17 | BITS | ETF | 20.8 | 21.2 | 20.16 | 20.36 | 9100.0 |
| 2002-01-17 | CEF | ETF | 3.59 | 3.6 | 3.54 | 3.55 | 43700.0 |
| 2002-01-17 | CHB | ETF | 10.97 | 11.23 | 10.65 | 11.2 | 182600.0 |
| 2002-01-17 | CNXT | ETF | 13.75 | 13.8 | 12.9 | 13.75 | 10361500.0 |
| 2002-01-17 | CSB | ETF | 4.75 | 4.80000019073486 | 4.75 | 4.80000019073486 | 7000.0 |
| 2002-01-17 | DGT | ETF | 65.37 | 65.37 | 65.37 | 65.37 | 100.0 |
| 2002-01-17 | EFA | ETF | 38.5833 | 38.63 | 38.3167 | 38.5167 | 526200.0 |
| 2002-01-17 | ELV | ETF | 25.5 | 25.525 | 25.0 | 25.15 | 456000.0 |
| 2002-01-17 | EPP | ETF | 18.25 | 18.28 | 18.2267 | 18.28 | 2100.0 |
| 2002-01-17 | EWA | ETF | 9.3 | 9.5 | 9.3 | 9.44 | 48700.0 |
| 2002-01-17 | EWC | ETF | 10.56 | 10.7 | 10.56 | 10.6 | 1700.0 |
| 2002-01-17 | EWD | ETF | 13.09 | 13.09 | 12.91 | 13.09 | 2000.0 |
| 2002-01-17 | EWG | ETF | 14.63 | 14.85 | 14.63 | 14.84 | 25800.0 |
| 2002-01-17 | EWH | ETF | 9.2 | 9.34 | 9.19 | 9.34 | 64100.0 |
| 2002-01-17 | EWI | ETF | 31.7 | 31.7 | 31.66 | 31.66 | 4000.0 |
| 2002-01-17 | EWJ | ETF | 29.96 | 30.0 | 29.76 | 29.92 | 57850.0 |
| 2002-01-17 | EWK | ETF | 10.74 | 10.74 | 10.73 | 10.73 | 1000.0 |
| 2002-01-17 | EWL | ETF | 12.32 | 12.49 | 12.32 | 12.49 | 11200.0 |
| 2002-01-17 | EWM | ETF | 21.04 | 21.04 | 20.68 | 21.0 | 4525.0 |
| 2002-01-17 | EWN | ETF | 16.52 | 16.69 | 16.52 | 16.69 | 3500.0 |
| 2002-01-17 | EWO | ETF | 7.25 | 7.39 | 7.25 | 7.3 | 16500.0 |
| 2002-01-17 | EWP | ETF | 19.74 | 19.74 | 19.74 | 19.74 | 1200.0 |
| 2002-01-17 | EWQ | ETF | 18.0 | 18.16 | 18.0 | 18.02 | 5500.0 |
| 2002-01-17 | EWS | ETF | 10.34 | 10.68 | 10.34 | 10.68 | 52800.0 |
| 2002-01-17 | EWT | ETF | 20.96 | 21.58 | 20.96 | 21.5 | 18700.0 |
| 2002-01-17 | EWU | ETF | 28.74 | 28.74 | 28.38 | 28.38 | 25500.0 |
| 2002-01-17 | EWW | ETF | 15.82 | 15.93 | 15.65 | 15.93 | 192600.0 |
| 2002-01-17 | EWY | ETF | 18.15 | 18.44 | 18.15 | 18.33 | 34300.0 |
| 2002-01-17 | EWZ | ETF | 12.25 | 12.25 | 11.93 | 12.14 | 1037800.0 |
| 2002-01-17 | EZU | ETF | 26.8 | 26.925 | 26.7 | 26.885 | 13200.0 |
| 2002-01-17 | FCTR | ETF | 17.45 | 18.0 | 17.31 | 17.65 | 130200.0 |
| 2002-01-17 | GLDB | ETF | 7.01 | 7.15 | 6.97 | 7.04 | 20200.0 |
| 2002-01-17 | GRNB | ETF | 17.6698 | 17.6698 | 17.6698 | 17.6698 | 303.0 |
| 2002-01-17 | GSIG | ETF | 9.76 | 10.08 | 9.76 | 9.81 | 40800.0 |
| 2002-01-17 | IBB | ETF | 27.95 | 27.9833 | 26.9333 | 27.5767 | 815700.0 |
| 2002-01-17 | ICF | ETF | 21.05 | 21.075 | 21.045 | 21.075 | 17600.0 |
| 2002-01-17 | IDU | ETF | 31.475 | 31.59 | 31.155 | 31.4 | 251400.0 |
| 2002-01-17 | IEV | ETF | 28.675 | 28.85 | 28.59 | 28.815 | 47600.0 |
| 2002-01-17 | IGLD | ETF | 112.0 | 114.0 | 110.0 | 112.0 | 651.0 |
| 2002-01-17 | IGM | ETF | 8.5833 | 8.725 | 8.5833 | 8.725 | 33000.0 |
| 2002-01-17 | IGN | ETF | 30.75 | 30.99 | 30.35 | 30.99 | 908800.0 |
| 2002-01-17 | IGV | ETF | 9.45 | 9.546 | 9.322 | 9.518 | 43500.0 |
| 2002-01-17 | IJH | ETF | 9.995 | 10.051 | 9.91 | 10.051 | 212000.0 |
| 2002-01-17 | IJJ | ETF | 22.2625 | 22.355 | 22.16 | 22.355 | 54800.0 |
> showing 50 of 116 rows — these rows as CSV