PREVIEW / etf_daily / 2002-06-18
file: by_date/etf_daily/2002/2002-06-18.parquet size: 9 KB rows: 121
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-06-18 | SPY | ETF | 103.74 | 105.03 | 103.63 | 104.97 | 21628500.0 |
| 2002-06-18 | QQQ | ETF | 28.317 | 29.15 | 28.28 | 29.02 | 100629000.0 |
| 2002-06-18 | IWM | ETF | 46.765 | 47.275 | 46.575 | 46.945 | 1905600.0 |
| 2002-06-18 | DIA | ETF | 96.75 | 98.0 | 96.58 | 97.9 | 2704200.0 |
| 2002-06-18 | AAA | ETF | 48.54 | 48.54 | 48.09 | 48.09 | 1500.0 |
| 2002-06-18 | ARB | ETF | 32.9 | 33.15 | 32.84 | 33.04 | 162200.0 |
| 2002-06-18 | BBH | ETF | 29.1667 | 29.7367 | 28.8333 | 29.0667 | 6097800.0 |
| 2002-06-18 | BITS | ETF | 12.24 | 12.596 | 11.36 | 12.56 | 850.0 |
| 2002-06-18 | CEF | ETF | 4.16 | 4.18 | 4.14 | 4.18 | 94200.0 |
| 2002-06-18 | CHB | ETF | 5.5 | 5.7 | 4.7 | 5.07 | 3721100.0 |
| 2002-06-18 | CNXT | ETF | 4.73 | 5.14 | 4.68 | 4.69 | 2431960.0 |
| 2002-06-18 | CSB | ETF | 4.30000019073486 | 4.30000019073486 | 4.30000019073486 | 4.30000019073486 | 6000.0 |
| 2002-06-18 | DGT | ETF | 57.93 | 58.05 | 57.78 | 58.05 | 2300.0 |
| 2002-06-18 | EFA | ETF | 38.7333 | 39.09 | 38.6667 | 39.0533 | 552300.0 |
| 2002-06-18 | ELV | ETF | 36.755 | 36.905 | 36.45 | 36.875 | 1049000.0 |
| 2002-06-18 | EPP | ETF | 19.3533 | 19.3633 | 19.2 | 19.25 | 32700.0 |
| 2002-06-18 | EWA | ETF | 10.2 | 10.28 | 10.09 | 10.28 | 34900.0 |
| 2002-06-18 | EWC | ETF | 10.85 | 11.0 | 10.85 | 10.85 | 67700.0 |
| 2002-06-18 | EWD | ETF | 11.55 | 11.66 | 11.44 | 11.46 | 15300.0 |
| 2002-06-18 | EWG | ETF | 13.87 | 14.0 | 13.75 | 13.91 | 19700.0 |
| 2002-06-18 | EWH | ETF | 9.12 | 9.17 | 9.02 | 9.12 | 68800.0 |
| 2002-06-18 | EWI | ETF | 32.5 | 32.5 | 32.22 | 32.32 | 29450.0 |
| 2002-06-18 | EWJ | ETF | 32.96 | 33.12 | 32.8 | 32.88 | 223275.0 |
| 2002-06-18 | EWK | ETF | 11.44 | 11.5 | 11.26 | 11.37 | 21600.0 |
| 2002-06-18 | EWL | ETF | 12.9 | 13.09 | 12.9 | 13.05 | 10000.0 |
| 2002-06-18 | EWM | ETF | 23.88 | 23.88 | 23.56 | 23.68 | 18325.0 |
| 2002-06-18 | EWN | ETF | 16.71 | 17.04 | 16.71 | 16.99 | 2400.0 |
| 2002-06-18 | EWO | ETF | 8.65 | 8.67 | 8.55 | 8.66 | 27700.0 |
| 2002-06-18 | EWP | ETF | 19.51 | 19.66 | 19.51 | 19.66 | 4500.0 |
| 2002-06-18 | EWQ | ETF | 17.9 | 17.94 | 17.75 | 17.9 | 22500.0 |
| 2002-06-18 | EWS | ETF | 10.48 | 10.48 | 10.24 | 10.36 | 15050.0 |
| 2002-06-18 | EWT | ETF | 21.18 | 21.48 | 21.04 | 21.48 | 148350.0 |
| 2002-06-18 | EWU | ETF | 27.24 | 27.84 | 27.2 | 27.72 | 9950.0 |
| 2002-06-18 | EWW | ETF | 15.49 | 15.49 | 14.87 | 15.07 | 201700.0 |
| 2002-06-18 | EWY | ETF | 23.48 | 23.74 | 23.21 | 23.74 | 37400.0 |
| 2002-06-18 | EWZ | ETF | 10.67 | 10.68 | 10.31 | 10.4 | 87200.0 |
| 2002-06-18 | EZU | ETF | 26.0 | 26.245 | 25.9 | 26.2 | 85800.0 |
| 2002-06-18 | FCTR | ETF | 18.231 | 18.749 | 18.12 | 18.529 | 25800.0 |
| 2002-06-18 | FMAR | ETF | 10.61 | 10.99 | 10.6 | 10.8 | 4100.0 |
| 2002-06-18 | GLDB | ETF | 10.68 | 10.9 | 10.58 | 10.9 | 89700.0 |
| 2002-06-18 | GSIG | ETF | 9.52 | 9.52 | 9.23 | 9.23 | 9000.0 |
| 2002-06-18 | IBB | ETF | 17.8 | 18.1167 | 17.5667 | 17.78 | 1888800.0 |
| 2002-06-18 | ICF | ETF | 22.675 | 22.71 | 22.53 | 22.53 | 158400.0 |
| 2002-06-18 | IDU | ETF | 30.225 | 30.4 | 30.1 | 30.2 | 63200.0 |
| 2002-06-18 | IEV | ETF | 27.89 | 28.125 | 27.77 | 27.925 | 77000.0 |
| 2002-06-18 | IGE | ETF | 16.04 | 16.0817 | 16.04 | 16.0817 | 6600.0 |
| 2002-06-18 | IGLD | ETF | 104.0 | 108.0 | 104.0 | 108.0 | 15.0 |
| 2002-06-18 | IGM | ETF | 6.1667 | 6.2767 | 6.1417 | 6.1417 | 21600.0 |
| 2002-06-18 | IGN | ETF | 18.14 | 18.14 | 17.51 | 17.65 | 320400.0 |
| 2002-06-18 | IGV | ETF | 5.92 | 5.996 | 5.822 | 5.898 | 93500.0 |
> showing 50 of 121 rows — these rows as CSV