PREVIEW / etf_daily / 2002-07-09
file: by_date/etf_daily/2002/2002-07-09.parquet size: 9 KB rows: 120
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-09 | SPY | ETF | 97.73 | 98.34 | 95.01 | 95.6 | 28620400.0 |
| 2002-07-09 | QQQ | ETF | 25.251 | 25.48 | 24.59 | 24.66 | 91102300.0 |
| 2002-07-09 | IWM | ETF | 43.1 | 43.435 | 42.65 | 42.885 | 1619000.0 |
| 2002-07-09 | DIA | ETF | 92.78 | 93.49 | 90.91 | 91.19 | 5230600.0 |
| 2002-07-09 | AAA | ETF | 52.6 | 53.0 | 52.6 | 53.0 | 3000.0 |
| 2002-07-09 | ARB | ETF | 30.0 | 30.78 | 30.0 | 30.1 | 337200.0 |
| 2002-07-09 | BBH | ETF | 24.8467 | 25.1667 | 23.52 | 23.6 | 2895600.0 |
| 2002-07-09 | BITS | ETF | 10.12 | 10.24 | 9.28 | 9.96 | 4950.0 |
| 2002-07-09 | CEF | ETF | 4.3 | 4.4 | 4.3 | 4.38 | 277100.0 |
| 2002-07-09 | CHB | ETF | 4.75 | 5.1 | 4.75 | 4.88 | 97000.0 |
| 2002-07-09 | CNXT | ETF | 1.5 | 1.61 | 1.45 | 1.5 | 5080300.0 |
| 2002-07-09 | CSB | ETF | 5.0 | 5.0 | 4.94999980926514 | 5.0 | 10500.0 |
| 2002-07-09 | DGT | ETF | 54.4 | 54.4 | 54.4 | 54.4 | 4600.0 |
| 2002-07-09 | EFA | ETF | 39.56 | 39.6033 | 38.8833 | 39.0833 | 740700.0 |
| 2002-07-09 | ELV | ETF | 33.35 | 33.55 | 31.76 | 31.765 | 1556800.0 |
| 2002-07-09 | EPP | ETF | 19.2433 | 19.2633 | 19.0067 | 19.1 | 168000.0 |
| 2002-07-09 | EWA | ETF | 10.09 | 10.2 | 10.03 | 10.15 | 27200.0 |
| 2002-07-09 | EWC | ETF | 10.64 | 10.7 | 10.53 | 10.7 | 25200.0 |
| 2002-07-09 | EWD | ETF | 11.36 | 11.36 | 11.36 | 11.36 | 1400.0 |
| 2002-07-09 | EWG | ETF | 14.4 | 14.43 | 14.15 | 14.3 | 7700.0 |
| 2002-07-09 | EWH | ETF | 9.15 | 9.15 | 8.81 | 8.92 | 85100.0 |
| 2002-07-09 | EWI | ETF | 32.82 | 32.84 | 32.82 | 32.82 | 150.0 |
| 2002-07-09 | EWJ | ETF | 35.0 | 35.04 | 34.6 | 34.68 | 225650.0 |
| 2002-07-09 | EWK | ETF | 11.66 | 11.67 | 11.66 | 11.67 | 500.0 |
| 2002-07-09 | EWL | ETF | 13.54 | 13.54 | 13.16 | 13.26 | 17000.0 |
| 2002-07-09 | EWM | ETF | 23.4 | 23.8 | 23.4 | 23.52 | 46300.0 |
| 2002-07-09 | EWN | ETF | 17.25 | 17.25 | 17.12 | 17.12 | 9400.0 |
| 2002-07-09 | EWO | ETF | 9.06 | 9.06 | 8.93 | 8.93 | 6500.0 |
| 2002-07-09 | EWP | ETF | 19.65 | 19.65 | 19.65 | 19.65 | 200.0 |
| 2002-07-09 | EWQ | ETF | 17.82 | 17.87 | 17.63 | 17.63 | 42700.0 |
| 2002-07-09 | EWS | ETF | 11.08 | 11.18 | 10.76 | 10.96 | 19300.0 |
| 2002-07-09 | EWT | ETF | 21.0 | 21.0 | 20.54 | 20.7 | 13400.0 |
| 2002-07-09 | EWU | ETF | 27.52 | 27.58 | 27.12 | 27.12 | 42950.0 |
| 2002-07-09 | EWW | ETF | 14.41 | 14.69 | 14.2 | 14.25 | 116500.0 |
| 2002-07-09 | EWY | ETF | 23.75 | 23.89 | 23.56 | 23.61 | 122400.0 |
| 2002-07-09 | EWZ | ETF | 9.18 | 9.2 | 9.01 | 9.07 | 1285500.0 |
| 2002-07-09 | EZU | ETF | 26.525 | 26.565 | 26.255 | 26.27 | 31400.0 |
| 2002-07-09 | FCTR | ETF | 17.48 | 17.65 | 17.21 | 17.35 | 17300.0 |
| 2002-07-09 | FMAR | ETF | 11.2 | 11.67 | 11.2 | 11.67 | 8900.0 |
| 2002-07-09 | GLDB | ETF | 10.85 | 10.98 | 10.75 | 10.98 | 95100.0 |
| 2002-07-09 | GSIG | ETF | 7.95 | 8.35 | 7.95 | 8.11 | 40500.0 |
| 2002-07-09 | IBB | ETF | 15.0567 | 15.1667 | 14.3067 | 14.3333 | 1603500.0 |
| 2002-07-09 | ICF | ETF | 22.375 | 22.375 | 22.0375 | 22.0375 | 115200.0 |
| 2002-07-09 | IDU | ETF | 28.005 | 28.05 | 27.215 | 27.215 | 247000.0 |
| 2002-07-09 | IEV | ETF | 28.085 | 28.345 | 27.65 | 27.75 | 179200.0 |
| 2002-07-09 | IGE | ETF | 15.6167 | 15.6167 | 15.6167 | 15.6167 | 600.0 |
| 2002-07-09 | IGLD | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 35.0 |
| 2002-07-09 | IGM | ETF | 5.4667 | 5.4683 | 5.3717 | 5.3717 | 6600.0 |
| 2002-07-09 | IGN | ETF | 14.8 | 15.15 | 14.8 | 15.05 | 600.0 |
| 2002-07-09 | IGV | ETF | 5.25 | 5.25 | 5.104 | 5.13 | 27000.0 |
> showing 50 of 120 rows — these rows as CSV