PREVIEW / etf_daily / 2002-09-23
file: by_date/etf_daily/2002/2002-09-23.parquet size: 9 KB rows: 126
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-09-23 | SPY | ETF | 83.65 | 84.06 | 82.69 | 83.66 | 46893800.0 |
| 2002-09-23 | QQQ | ETF | 21.45 | 21.52 | 20.81 | 21.02 | 72774100.0 |
| 2002-09-23 | IWM | ETF | 36.3 | 36.445 | 35.4 | 35.65 | 2234800.0 |
| 2002-09-23 | DIA | ETF | 79.02 | 79.23 | 77.95 | 78.8 | 9102200.0 |
| 2002-09-23 | TLT | ETF | 90.0 | 90.24 | 89.77 | 90.1 | 163200.0 |
| 2002-09-23 | AAA | ETF | 38.16 | 38.65 | 37.85 | 38.24 | 5000.0 |
| 2002-09-23 | ARB | ETF | 32.3 | 32.3 | 31.42 | 31.94 | 100800.0 |
| 2002-09-23 | BBH | ETF | 25.35 | 25.5267 | 24.25 | 24.7067 | 3840000.0 |
| 2002-09-23 | BITS | ETF | 8.84 | 8.8888 | 8.84 | 8.844 | 675.0 |
| 2002-09-23 | CEF | ETF | 4.32 | 4.36 | 4.26 | 4.28 | 138800.0 |
| 2002-09-23 | CHB | ETF | 2.89 | 2.89 | 2.35 | 2.38 | 112500.0 |
| 2002-09-23 | CNXT | ETF | 1.15 | 1.26 | 1.15 | 1.2 | 2386510.0 |
| 2002-09-23 | CSB | ETF | 6.65999984741211 | 6.80000019073486 | 6.65999984741211 | 6.69999980926514 | 3900.0 |
| 2002-09-23 | DGT | ETF | 46.95 | 46.95 | 46.33 | 46.77 | 900.0 |
| 2002-09-23 | EFA | ETF | 31.7 | 31.7467 | 30.8733 | 30.9333 | 792300.0 |
| 2002-09-23 | ELV | ETF | 32.655 | 32.8 | 31.75 | 32.425 | 1647400.0 |
| 2002-09-23 | EPP | ETF | 16.9967 | 16.9967 | 16.84 | 16.84 | 5700.0 |
| 2002-09-23 | EWA | ETF | 9.0 | 9.05 | 8.92 | 8.92 | 8100.0 |
| 2002-09-23 | EWC | ETF | 8.8 | 8.8 | 8.58 | 8.58 | 9600.0 |
| 2002-09-23 | EWD | ETF | 8.7 | 8.7 | 8.41 | 8.59 | 2600.0 |
| 2002-09-23 | EWG | ETF | 9.7 | 9.8 | 9.41 | 9.8 | 74400.0 |
| 2002-09-23 | EWH | ETF | 7.22 | 7.4 | 7.2 | 7.35 | 321700.0 |
| 2002-09-23 | EWI | ETF | 26.0 | 26.04 | 25.52 | 25.84 | 2850.0 |
| 2002-09-23 | EWJ | ETF | 29.24 | 29.4 | 28.76 | 29.0 | 348450.0 |
| 2002-09-23 | EWK | ETF | 8.81 | 8.83 | 8.6 | 8.6 | 15000.0 |
| 2002-09-23 | EWL | ETF | 10.36 | 10.4 | 10.0 | 10.17 | 8800.0 |
| 2002-09-23 | EWM | ETF | 20.92 | 21.0 | 20.72 | 20.72 | 8775.0 |
| 2002-09-23 | EWN | ETF | 12.05 | 12.05 | 11.85 | 12.04 | 5100.0 |
| 2002-09-23 | EWO | ETF | 7.63 | 7.65 | 7.6 | 7.6 | 1900.0 |
| 2002-09-23 | EWP | ETF | 15.4 | 15.5 | 15.4 | 15.5 | 2400.0 |
| 2002-09-23 | EWQ | ETF | 13.2 | 13.25 | 12.9 | 12.92 | 5300.0 |
| 2002-09-23 | EWS | ETF | 9.0 | 9.0 | 8.86 | 8.9 | 25900.0 |
| 2002-09-23 | EWT | ETF | 15.02 | 15.26 | 15.0 | 15.1 | 8000.0 |
| 2002-09-23 | EWU | ETF | 23.32 | 23.4 | 22.82 | 22.92 | 72600.0 |
| 2002-09-23 | EWW | ETF | 12.38 | 12.4 | 11.9 | 12.4 | 25400.0 |
| 2002-09-23 | EWY | ETF | 19.4 | 19.44 | 18.65 | 18.71 | 33800.0 |
| 2002-09-23 | EWZ | ETF | 6.7 | 6.7 | 6.51 | 6.59 | 66900.0 |
| 2002-09-23 | EZU | ETF | 19.575 | 19.575 | 19.08 | 19.18 | 86200.0 |
| 2002-09-23 | FCTR | ETF | 16.74 | 16.94 | 16.6 | 16.74 | 15900.0 |
| 2002-09-23 | FMAR | ETF | 10.28 | 10.28 | 10.15 | 10.15 | 2600.0 |
| 2002-09-23 | GLDB | ETF | 9.99 | 9.99 | 9.73 | 9.78 | 71500.0 |
| 2002-09-23 | GSIG | ETF | 5.0 | 5.0 | 4.68 | 4.72 | 16200.0 |
| 2002-09-23 | IBB | ETF | 15.2667 | 15.2667 | 14.4033 | 14.5833 | 1579500.0 |
| 2002-09-23 | ICF | ETF | 21.165 | 21.2475 | 21.065 | 21.1075 | 58000.0 |
| 2002-09-23 | IDU | ETF | 22.95 | 23.235 | 22.39 | 22.8 | 59200.0 |
| 2002-09-23 | IEF | ETF | 86.88 | 87.06 | 86.72 | 86.89 | 293700.0 |
| 2002-09-23 | IEV | ETF | 21.65 | 21.85 | 21.065 | 21.15 | 797000.0 |
| 2002-09-23 | IGE | ETF | 12.835 | 12.835 | 12.7333 | 12.7333 | 241200.0 |
| 2002-09-23 | IGLD | ETF | 90.0 | 99.0 | 90.0 | 97.9 | 196.0 |
| 2002-09-23 | IGM | ETF | 4.35 | 4.35 | 4.2267 | 4.235 | 1851600.0 |
> showing 50 of 126 rows — these rows as CSV