PREVIEW / etf_daily / 2002-08-20
file: by_date/etf_daily/2002/2002-08-20.parquet size: 9 KB rows: 124
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-08-20 | SPY | ETF | 94.82 | 95.4 | 93.62 | 94.39 | 30508300.0 |
| 2002-08-20 | QQQ | ETF | 25.188 | 25.43 | 24.85 | 25.19 | 90014500.0 |
| 2002-08-20 | IWM | ETF | 39.905 | 39.945 | 39.525 | 39.825 | 2326600.0 |
| 2002-08-20 | DIA | ETF | 89.32 | 89.64 | 88.25 | 89.0 | 10107600.0 |
| 2002-08-20 | TLT | ETF | 85.62 | 86.29 | 85.6 | 86.27 | 40800.0 |
| 2002-08-20 | ARB | ETF | 33.6 | 33.7 | 33.05 | 33.66 | 176800.0 |
| 2002-08-20 | BBH | ETF | 28.6033 | 29.4333 | 28.6 | 29.0833 | 3919200.0 |
| 2002-08-20 | BITS | ETF | 8.76 | 8.76 | 8.6016 | 8.76 | 225.0 |
| 2002-08-20 | CEF | ETF | 4.09 | 4.11 | 4.04 | 4.09 | 37200.0 |
| 2002-08-20 | CHB | ETF | 2.93 | 3.0 | 2.88 | 2.95 | 97200.0 |
| 2002-08-20 | CNXT | ETF | 1.68 | 1.75 | 1.62 | 1.69 | 3280900.0 |
| 2002-08-20 | CSB | ETF | 5.5 | 5.69999980926514 | 5.5 | 5.69999980926514 | 15000.0 |
| 2002-08-20 | DGT | ETF | 54.22 | 54.22 | 54.22 | 54.22 | 100.0 |
| 2002-08-20 | EFA | ETF | 36.0667 | 36.2333 | 35.7333 | 35.7333 | 834900.0 |
| 2002-08-20 | ELV | ETF | 30.95 | 31.775 | 30.925 | 31.26 | 1280800.0 |
| 2002-08-20 | EPP | ETF | 17.9633 | 17.9667 | 17.8867 | 17.95 | 71700.0 |
| 2002-08-20 | EWA | ETF | 9.45 | 9.57 | 9.36 | 9.55 | 18000.0 |
| 2002-08-20 | EWC | ETF | 9.6 | 9.65 | 9.5 | 9.65 | 5000.0 |
| 2002-08-20 | EWD | ETF | 9.61 | 9.89 | 9.61 | 9.65 | 57700.0 |
| 2002-08-20 | EWG | ETF | 12.15 | 12.4 | 12.15 | 12.3 | 95900.0 |
| 2002-08-20 | EWH | ETF | 8.08 | 8.19 | 7.99 | 8.14 | 138900.0 |
| 2002-08-20 | EWI | ETF | 30.58 | 31.18 | 30.58 | 31.18 | 7700.0 |
| 2002-08-20 | EWJ | ETF | 31.2 | 31.2 | 30.84 | 30.88 | 180400.0 |
| 2002-08-20 | EWK | ETF | 10.34 | 10.34 | 10.16 | 10.16 | 800.0 |
| 2002-08-20 | EWL | ETF | 11.82 | 11.94 | 11.65 | 11.81 | 17000.0 |
| 2002-08-20 | EWM | ETF | 23.72 | 23.76 | 23.24 | 23.36 | 139200.0 |
| 2002-08-20 | EWN | ETF | 14.9 | 14.9 | 14.9 | 14.9 | 5200.0 |
| 2002-08-20 | EWO | ETF | 7.9 | 7.9 | 7.8 | 7.81 | 29400.0 |
| 2002-08-20 | EWP | ETF | 17.86 | 17.9 | 17.86 | 17.9 | 4900.0 |
| 2002-08-20 | EWQ | ETF | 15.67 | 15.67 | 15.55 | 15.6 | 9100.0 |
| 2002-08-20 | EWS | ETF | 10.26 | 10.3 | 10.06 | 10.22 | 35600.0 |
| 2002-08-20 | EWT | ETF | 18.8 | 18.8 | 17.74 | 17.84 | 5750.0 |
| 2002-08-20 | EWU | ETF | 26.64 | 26.64 | 26.3 | 26.48 | 19000.0 |
| 2002-08-20 | EWW | ETF | 13.86 | 13.9 | 13.79 | 13.82 | 5200.0 |
| 2002-08-20 | EWY | ETF | 21.11 | 21.34 | 21.11 | 21.16 | 17500.0 |
| 2002-08-20 | EWZ | ETF | 7.73 | 7.74 | 7.36 | 7.37 | 64300.0 |
| 2002-08-20 | EZU | ETF | 23.49 | 23.57 | 23.3 | 23.5 | 30200.0 |
| 2002-08-20 | FCTR | ETF | 16.6 | 16.899 | 16.2 | 16.5 | 15100.0 |
| 2002-08-20 | FMAR | ETF | 10.47 | 10.7 | 10.35 | 10.5 | 10000.0 |
| 2002-08-20 | GLDB | ETF | 10.3 | 10.65 | 10.3 | 10.47 | 74500.0 |
| 2002-08-20 | GSIG | ETF | 6.8 | 6.8 | 6.62 | 6.71 | 292800.0 |
| 2002-08-20 | IBB | ETF | 17.1667 | 17.5333 | 17.0 | 17.35 | 2563200.0 |
| 2002-08-20 | ICF | ETF | 21.4 | 21.4225 | 21.25 | 21.2975 | 85200.0 |
| 2002-08-20 | IDU | ETF | 26.25 | 26.535 | 25.975 | 26.425 | 40200.0 |
| 2002-08-20 | IEF | ETF | 83.8 | 84.23 | 83.7 | 84.23 | 56900.0 |
| 2002-08-20 | IEV | ETF | 25.915 | 25.945 | 25.605 | 25.735 | 75200.0 |
| 2002-08-20 | IGE | ETF | 14.0833 | 14.0833 | 14.0417 | 14.0433 | 25800.0 |
| 2002-08-20 | IGM | ETF | 5.4 | 5.4033 | 5.3333 | 5.3917 | 107400.0 |
| 2002-08-20 | IGN | ETF | 13.55 | 13.65 | 13.22 | 13.5 | 11800.0 |
| 2002-08-20 | IGV | ETF | 4.996 | 5.036 | 4.96 | 4.98 | 1560000.0 |
> showing 50 of 124 rows — these rows as CSV