PREVIEW / etf_daily / 2002-07-19
file: by_date/etf_daily/2002/2002-07-19.parquet size: 9 KB rows: 118
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-07-19 | SPY | ETF | 86.76 | 87.55 | 84.3 | 84.71 | 77572600.0 |
| 2002-07-19 | QQQ | ETF | 24.332 | 24.71 | 23.8 | 23.99 | 124500700.0 |
| 2002-07-19 | IWM | ETF | 39.025 | 39.335 | 38.325 | 38.625 | 2860400.0 |
| 2002-07-19 | DIA | ETF | 82.59 | 83.1 | 79.6 | 80.0 | 16165500.0 |
| 2002-07-19 | AAA | ETF | 47.25 | 47.25 | 46.6 | 47.2 | 4000.0 |
| 2002-07-19 | ARB | ETF | 32.15 | 32.45 | 31.77 | 32.05 | 225600.0 |
| 2002-07-19 | BBH | ETF | 23.8 | 24.01 | 23.1667 | 23.7633 | 3508200.0 |
| 2002-07-19 | BITS | ETF | 9.0 | 9.36 | 8.72 | 8.96 | 1975.0 |
| 2002-07-19 | CEF | ETF | 4.41 | 4.49 | 4.33 | 4.45 | 275100.0 |
| 2002-07-19 | CHB | ETF | 3.4 | 3.45 | 3.2 | 3.24 | 256100.0 |
| 2002-07-19 | CNXT | ETF | 2.27 | 2.35 | 1.96 | 2.13 | 9206930.0 |
| 2002-07-19 | DGT | ETF | 49.1 | 49.67 | 48.72 | 49.67 | 1000.0 |
| 2002-07-19 | EFA | ETF | 36.3333 | 36.73 | 35.6067 | 35.9133 | 1575300.0 |
| 2002-07-19 | ELV | ETF | 32.5 | 32.5 | 31.25 | 31.4 | 1451000.0 |
| 2002-07-19 | EPP | ETF | 18.2333 | 18.2333 | 18.01 | 18.01 | 34200.0 |
| 2002-07-19 | EWA | ETF | 9.35 | 9.44 | 9.15 | 9.15 | 38500.0 |
| 2002-07-19 | EWC | ETF | 9.8 | 9.84 | 9.61 | 9.63 | 5200.0 |
| 2002-07-19 | EWD | ETF | 10.42 | 10.42 | 10.26 | 10.26 | 24800.0 |
| 2002-07-19 | EWG | ETF | 13.2 | 13.24 | 12.9 | 13.0 | 34200.0 |
| 2002-07-19 | EWH | ETF | 8.4 | 8.54 | 8.22 | 8.27 | 60100.0 |
| 2002-07-19 | EWI | ETF | 30.18 | 30.48 | 30.16 | 30.48 | 4200.0 |
| 2002-07-19 | EWJ | ETF | 33.28 | 33.36 | 32.8 | 32.8 | 390000.0 |
| 2002-07-19 | EWK | ETF | 10.46 | 10.46 | 10.31 | 10.31 | 6900.0 |
| 2002-07-19 | EWL | ETF | 11.69 | 11.77 | 11.55 | 11.55 | 15300.0 |
| 2002-07-19 | EWM | ETF | 23.0 | 23.2 | 23.0 | 23.08 | 11825.0 |
| 2002-07-19 | EWN | ETF | 14.91 | 14.91 | 14.8 | 14.8 | 11100.0 |
| 2002-07-19 | EWO | ETF | 8.8 | 8.96 | 8.8 | 8.96 | 13200.0 |
| 2002-07-19 | EWP | ETF | 18.36 | 18.52 | 18.25 | 18.3 | 7100.0 |
| 2002-07-19 | EWQ | ETF | 16.06 | 16.06 | 15.75 | 15.9 | 75000.0 |
| 2002-07-19 | EWS | ETF | 10.6 | 10.7 | 10.42 | 10.52 | 15650.0 |
| 2002-07-19 | EWT | ETF | 20.0 | 20.14 | 19.82 | 19.82 | 5350.0 |
| 2002-07-19 | EWU | ETF | 25.86 | 25.88 | 24.9 | 25.02 | 59800.0 |
| 2002-07-19 | EWW | ETF | 14.31 | 14.55 | 14.25 | 14.45 | 38600.0 |
| 2002-07-19 | EWY | ETF | 22.05 | 22.3 | 21.85 | 21.86 | 92300.0 |
| 2002-07-19 | EWZ | ETF | 9.04 | 9.24 | 9.03 | 9.03 | 40700.0 |
| 2002-07-19 | EZU | ETF | 24.28 | 24.32 | 23.595 | 23.595 | 23600.0 |
| 2002-07-19 | FCTR | ETF | 17.42 | 17.85 | 17.42 | 17.51 | 27000.0 |
| 2002-07-19 | FMAR | ETF | 10.61 | 10.7 | 10.26 | 10.49 | 6200.0 |
| 2002-07-19 | GLDB | ETF | 10.51 | 10.7 | 10.25 | 10.3 | 106200.0 |
| 2002-07-19 | GRNB | ETF | 16.1974 | 16.1974 | 16.1974 | 16.1974 | 101.0 |
| 2002-07-19 | GSIG | ETF | 8.45 | 8.49 | 8.39 | 8.43 | 51900.0 |
| 2002-07-19 | IBB | ETF | 14.75 | 15.1333 | 14.6667 | 14.84 | 5363100.0 |
| 2002-07-19 | ICF | ETF | 20.4625 | 20.4625 | 20.175 | 20.2875 | 282000.0 |
| 2002-07-19 | IDU | ETF | 23.75 | 23.8 | 22.95 | 23.165 | 80200.0 |
| 2002-07-19 | IEV | ETF | 25.925 | 26.02 | 25.075 | 25.11 | 290400.0 |
| 2002-07-19 | IGE | ETF | 13.975 | 13.975 | 13.4333 | 13.4333 | 3000.0 |
| 2002-07-19 | IGM | ETF | 5.2167 | 5.3083 | 5.1267 | 5.1267 | 16800.0 |
| 2002-07-19 | IGN | ETF | 15.4 | 15.45 | 15.15 | 15.17 | 8400.0 |
| 2002-07-19 | IGV | ETF | 4.75 | 4.868 | 4.7 | 4.7 | 28000.0 |
| 2002-07-19 | IJH | ETF | 8.472 | 8.55 | 8.359 | 8.442 | 723000.0 |
> showing 50 of 118 rows — these rows as CSV