PREVIEW / etf_daily / 2004-10-20
file: by_date/etf_daily/2004/2004-10-20.parquet size: 11 KB rows: 167
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-10-20 | SPY | ETF | 110.38 | 110.82 | 109.75 | 110.52 | 57118500.0 |
| 2004-10-20 | QQQ | ETF | 35.83 | 36.23 | 35.65 | 36.048 | 106874200.0 |
| 2004-10-20 | IWM | ETF | 56.27 | 56.945 | 56.035 | 56.755 | 14972600.0 |
| 2004-10-20 | DIA | ETF | 98.92 | 99.09 | 98.2 | 98.89 | 9636600.0 |
| 2004-10-20 | TLT | ETF | 89.26 | 89.61 | 89.2 | 89.55 | 1127100.0 |
| 2004-10-20 | AAA | ETF | 56.75 | 57.3 | 56.75 | 57.0 | 5700.0 |
| 2004-10-20 | ADRE | ETF | 72.71 | 72.71 | 71.711 | 72.44 | 2436.0 |
| 2004-10-20 | AGG | ETF | 102.91 | 103.27 | 102.91 | 103.27 | 135800.0 |
| 2004-10-20 | ARB | ETF | 36.67 | 36.67 | 35.9 | 36.37 | 276500.0 |
| 2004-10-20 | BBH | ETF | 45.7633 | 46.3 | 45.6333 | 46.1333 | 2513400.0 |
| 2004-10-20 | BITS | ETF | 6.04 | 6.04 | 5.64 | 5.88 | 470.0 |
| 2004-10-20 | BNE | ETF | 14.09 | 14.17 | 13.84 | 14.14 | 225800.0 |
| 2004-10-20 | CEF | ETF | 6.0 | 6.1 | 5.98 | 6.0 | 583300.0 |
| 2004-10-20 | CHB | ETF | 9.49 | 9.76 | 9.4 | 9.5 | 291800.0 |
| 2004-10-20 | CNXT | ETF | 1.685 | 1.7251 | 1.6649 | 1.705 | 3576500.0 |
| 2004-10-20 | CSB | ETF | 28.0 | 28.1000003814697 | 28.0 | 28.1000003814697 | 3200.0 |
| 2004-10-20 | DGT | ETF | 59.84 | 60.14 | 59.84 | 60.02 | 2200.0 |
| 2004-10-20 | DVY | ETF | 56.95 | 56.95 | 56.41 | 56.9 | 464800.0 |
| 2004-10-20 | EEM | ETF | 19.2311 | 19.2456 | 19.0689 | 19.1411 | 3414600.0 |
| 2004-10-20 | EFA | ETF | 47.8333 | 48.3067 | 47.6267 | 47.95 | 2554200.0 |
| 2004-10-20 | ELV | ETF | 36.7 | 38.35 | 36.3 | 38.115 | 7826200.0 |
| 2004-10-20 | EPP | ETF | 26.9167 | 26.9567 | 26.8533 | 26.8733 | 68700.0 |
| 2004-10-20 | EWA | ETF | 14.85 | 14.85 | 14.7 | 14.73 | 112400.0 |
| 2004-10-20 | EWC | ETF | 15.72 | 15.88 | 15.72 | 15.85 | 113300.0 |
| 2004-10-20 | EWD | ETF | 18.51 | 18.67 | 18.51 | 18.66 | 9700.0 |
| 2004-10-20 | EWG | ETF | 16.0 | 16.13 | 15.97 | 16.03 | 31500.0 |
| 2004-10-20 | EWH | ETF | 10.95 | 11.01 | 10.86 | 10.93 | 512100.0 |
| 2004-10-20 | EWI | ETF | 44.34 | 44.44 | 44.18 | 44.44 | 3900.0 |
| 2004-10-20 | EWJ | ETF | 39.12 | 39.24 | 38.84 | 39.12 | 1818575.0 |
| 2004-10-20 | EWK | ETF | 16.35 | 16.52 | 16.31 | 16.5 | 45700.0 |
| 2004-10-20 | EWL | ETF | 15.15 | 15.15 | 15.06 | 15.06 | 18500.0 |
| 2004-10-20 | EWM | ETF | 26.92 | 26.92 | 26.56 | 26.72 | 32425.0 |
| 2004-10-20 | EWN | ETF | 16.29 | 16.37 | 16.29 | 16.32 | 5700.0 |
| 2004-10-20 | EWO | ETF | 18.42 | 18.56 | 18.42 | 18.49 | 31700.0 |
| 2004-10-20 | EWP | ETF | 30.06 | 30.26 | 30.06 | 30.19 | 5500.0 |
| 2004-10-20 | EWQ | ETF | 21.49 | 21.61 | 21.48 | 21.58 | 6900.0 |
| 2004-10-20 | EWS | ETF | 13.46 | 13.62 | 13.4 | 13.6 | 39450.0 |
| 2004-10-20 | EWT | ETF | 21.1 | 21.38 | 21.08 | 21.38 | 310700.0 |
| 2004-10-20 | EWU | ETF | 33.12 | 33.32 | 32.94 | 33.3 | 109050.0 |
| 2004-10-20 | EWW | ETF | 20.54 | 20.65 | 20.46 | 20.58 | 247100.0 |
| 2004-10-20 | EWY | ETF | 24.95 | 24.99 | 24.7 | 24.95 | 469600.0 |
| 2004-10-20 | EWZ | ETF | 18.11 | 18.33 | 17.95 | 18.33 | 512300.0 |
| 2004-10-20 | EZA | ETF | 32.775 | 32.9 | 32.695 | 32.9 | 36800.0 |
| 2004-10-20 | EZU | ETF | 31.985 | 32.03 | 31.765 | 31.99 | 113200.0 |
| 2004-10-20 | FCTR | ETF | 25.4 | 25.76 | 25.19 | 25.67 | 28571.0 |
| 2004-10-20 | FEZ | ETF | 34.94 | 35.1 | 34.93 | 35.08 | 8300.0 |
| 2004-10-20 | FMAR | ETF | 17.1 | 17.25 | 17.1 | 17.2 | 44850.0 |
| 2004-10-20 | FVD | ETF | 14.41 | 14.44 | 14.34 | 14.44 | 85000.0 |
| 2004-10-20 | FXI | ETF | 17.1167 | 17.1567 | 16.96 | 17.1333 | 687000.0 |
| 2004-10-20 | GLDB | ETF | 14.0 | 14.0 | 13.84 | 13.85 | 545515.0 |
> showing 50 of 167 rows — these rows as CSV