PREVIEW / etf_daily / 2004-09-20
file: by_date/etf_daily/2004/2004-09-20.parquet size: 11 KB rows: 163
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-20 | SPY | ETF | 112.67 | 112.99 | 112.28 | 112.47 | 37149400.0 |
| 2004-09-20 | QQQ | ETF | 35.29 | 35.77 | 35.18 | 35.433 | 111357300.0 |
| 2004-09-20 | IWM | ETF | 56.955 | 57.34 | 56.81 | 56.96 | 10983200.0 |
| 2004-09-20 | DIA | ETF | 102.56 | 102.7 | 102.01 | 102.15 | 6733300.0 |
| 2004-09-20 | TLT | ETF | 88.26 | 88.57 | 88.19 | 88.5 | 727200.0 |
| 2004-09-20 | AAA | ETF | 57.87 | 58.39 | 57.87 | 58.25 | 3500.0 |
| 2004-09-20 | ADRE | ETF | 60.0 | 72.45 | 60.0 | 72.08 | 3328.0 |
| 2004-09-20 | AGG | ETF | 102.89 | 102.94 | 102.6 | 102.94 | 94600.0 |
| 2004-09-20 | ARB | ETF | 37.6 | 37.61 | 37.25 | 37.36 | 165800.0 |
| 2004-09-20 | BBH | ETF | 49.09 | 49.29 | 48.5133 | 48.89 | 3174600.0 |
| 2004-09-20 | BITS | ETF | 6.24 | 6.4 | 6.04 | 6.04 | 2175.0 |
| 2004-09-20 | BNE | ETF | 13.59 | 13.59 | 13.31 | 13.44 | 68000.0 |
| 2004-09-20 | CEF | ETF | 5.55 | 5.55 | 5.44 | 5.49 | 339500.0 |
| 2004-09-20 | CHB | ETF | 10.51 | 10.51 | 10.19 | 10.22 | 286800.0 |
| 2004-09-20 | CNXT | ETF | 1.83 | 1.96 | 1.8 | 1.91 | 10671950.0 |
| 2004-09-20 | CSB | ETF | 25.2000007629395 | 25.2000007629395 | 25.0 | 25.0 | 7800.0 |
| 2004-09-20 | DGT | ETF | 60.77 | 61.22 | 60.62 | 60.79 | 18100.0 |
| 2004-09-20 | DVY | ETF | 57.95 | 57.95 | 57.51 | 57.62 | 390000.0 |
| 2004-09-20 | EEM | ETF | 18.9189 | 18.9444 | 18.7056 | 18.9078 | 1203300.0 |
| 2004-09-20 | EFA | ETF | 46.6 | 46.81 | 46.4833 | 46.6733 | 889200.0 |
| 2004-09-20 | ELV | ETF | 43.13 | 43.325 | 42.5 | 42.85 | 1474400.0 |
| 2004-09-20 | EPP | ETF | 25.83 | 25.88 | 25.7633 | 25.86 | 97500.0 |
| 2004-09-20 | EWA | ETF | 13.77 | 13.86 | 13.76 | 13.85 | 41800.0 |
| 2004-09-20 | EWC | ETF | 14.75 | 14.98 | 14.75 | 14.85 | 18100.0 |
| 2004-09-20 | EWD | ETF | 17.48 | 17.59 | 17.46 | 17.54 | 13600.0 |
| 2004-09-20 | EWG | ETF | 15.61 | 15.7 | 15.55 | 15.7 | 73400.0 |
| 2004-09-20 | EWH | ETF | 11.3 | 11.34 | 11.27 | 11.32 | 352600.0 |
| 2004-09-20 | EWI | ETF | 41.62 | 41.78 | 41.62 | 41.78 | 16200.0 |
| 2004-09-20 | EWJ | ETF | 39.04 | 39.36 | 38.92 | 39.16 | 1202350.0 |
| 2004-09-20 | EWK | ETF | 15.26 | 15.59 | 15.26 | 15.55 | 26600.0 |
| 2004-09-20 | EWL | ETF | 14.89 | 14.91 | 14.81 | 14.82 | 6600.0 |
| 2004-09-20 | EWM | ETF | 27.6 | 27.6 | 27.4 | 27.6 | 17200.0 |
| 2004-09-20 | EWN | ETF | 16.23 | 16.23 | 16.13 | 16.16 | 3700.0 |
| 2004-09-20 | EWO | ETF | 17.2 | 17.35 | 17.1 | 17.35 | 30000.0 |
| 2004-09-20 | EWP | ETF | 28.0 | 28.05 | 28.0 | 28.04 | 1800.0 |
| 2004-09-20 | EWQ | ETF | 20.92 | 20.92 | 20.92 | 20.92 | 900.0 |
| 2004-09-20 | EWS | ETF | 13.74 | 13.76 | 13.66 | 13.74 | 152250.0 |
| 2004-09-20 | EWT | ETF | 21.48 | 21.58 | 21.32 | 21.58 | 280850.0 |
| 2004-09-20 | EWU | ETF | 32.04 | 32.34 | 32.04 | 32.28 | 118900.0 |
| 2004-09-20 | EWW | ETF | 20.38 | 20.44 | 20.29 | 20.41 | 162300.0 |
| 2004-09-20 | EWY | ETF | 25.65 | 25.73 | 25.62 | 25.66 | 176500.0 |
| 2004-09-20 | EWZ | ETF | 18.23 | 18.23 | 17.93 | 17.99 | 381900.0 |
| 2004-09-20 | EZA | ETF | 31.44 | 31.58 | 31.37 | 31.52 | 19000.0 |
| 2004-09-20 | EZU | ETF | 30.58 | 30.865 | 30.58 | 30.725 | 21000.0 |
| 2004-09-20 | FCTR | ETF | 23.6 | 24.55 | 23.6 | 23.68 | 29147.0 |
| 2004-09-20 | FEZ | ETF | 33.65 | 33.84 | 33.58 | 33.84 | 103900.0 |
| 2004-09-20 | FMAR | ETF | 16.9 | 16.99 | 16.82 | 16.82 | 1860.0 |
| 2004-09-20 | FVD | ETF | 14.63 | 14.63 | 14.47 | 14.47 | 119900.0 |
| 2004-09-20 | GLDB | ETF | 15.72 | 15.72 | 15.53 | 15.54 | 158936.0 |
| 2004-09-20 | GRNB | ETF | 23.4616 | 23.4616 | 23.3624 | 23.3634 | 1413.0 |
> showing 50 of 163 rows — these rows as CSV