PREVIEW / etf_daily / 2004-05-27
file: by_date/etf_daily/2004/2004-05-27.parquet size: 11 KB rows: 157
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-05-27 | SPY | ETF | 112.54 | 113.03 | 112.06 | 112.87 | 45306900.0 |
| 2004-05-27 | QQQ | ETF | 36.29 | 36.5 | 36.0 | 36.42 | 110234100.0 |
| 2004-05-27 | IWM | ETF | 56.825 | 57.13 | 56.185 | 56.65 | 19802800.0 |
| 2004-05-27 | DIA | ETF | 101.7 | 102.37 | 101.68 | 102.3 | 5972800.0 |
| 2004-05-27 | TLT | ETF | 83.03 | 83.4 | 82.83 | 83.33 | 1122800.0 |
| 2004-05-27 | AAA | ETF | 65.51 | 65.6 | 65.35 | 65.35 | 2000.0 |
| 2004-05-27 | ADRE | ETF | 68.76 | 69.849 | 68.76 | 69.83 | 7844.0 |
| 2004-05-27 | AGG | ETF | 100.15 | 100.49 | 100.15 | 100.48 | 99600.0 |
| 2004-05-27 | ARB | ETF | 38.65 | 38.73 | 38.2 | 38.62 | 104600.0 |
| 2004-05-27 | BBH | ETF | 49.8133 | 50.15 | 49.1467 | 49.4033 | 4027800.0 |
| 2004-05-27 | BITS | ETF | 9.0 | 9.72 | 9.0 | 9.68 | 1750.0 |
| 2004-05-27 | BNE | ETF | 16.18 | 16.2 | 15.89 | 16.0 | 83800.0 |
| 2004-05-27 | CEF | ETF | 5.47 | 5.54 | 5.47 | 5.51 | 340800.0 |
| 2004-05-27 | CHB | ETF | 9.4 | 9.45 | 9.26 | 9.39 | 397900.0 |
| 2004-05-27 | CNXT | ETF | 4.82 | 4.97 | 4.7714 | 4.86 | 23204930.0 |
| 2004-05-27 | CSB | ETF | 21.5 | 21.75 | 21.0 | 21.75 | 8500.0 |
| 2004-05-27 | DGT | ETF | 61.2 | 61.2 | 60.83 | 60.94 | 14100.0 |
| 2004-05-27 | DVY | ETF | 54.8 | 54.91 | 54.35 | 54.66 | 347800.0 |
| 2004-05-27 | EEM | ETF | 17.8767 | 17.9078 | 17.7344 | 17.8333 | 1737000.0 |
| 2004-05-27 | EFA | ETF | 46.2967 | 46.4833 | 46.1367 | 46.4 | 1328100.0 |
| 2004-05-27 | ELV | ETF | 43.925 | 44.215 | 43.055 | 44.025 | 3081100.0 |
| 2004-05-27 | EPP | ETF | 24.0833 | 24.31 | 24.0833 | 24.2433 | 116700.0 |
| 2004-05-27 | EWA | ETF | 13.25 | 13.3 | 13.2 | 13.28 | 107300.0 |
| 2004-05-27 | EWC | ETF | 13.56 | 13.66 | 13.55 | 13.66 | 60400.0 |
| 2004-05-27 | EWD | ETF | 16.95 | 16.96 | 16.79 | 16.96 | 36500.0 |
| 2004-05-27 | EWG | ETF | 15.59 | 15.72 | 15.5 | 15.72 | 24400.0 |
| 2004-05-27 | EWH | ETF | 10.02 | 10.05 | 9.95 | 10.03 | 625500.0 |
| 2004-05-27 | EWI | ETF | 40.88 | 40.88 | 40.82 | 40.82 | 2750.0 |
| 2004-05-27 | EWJ | ETF | 39.32 | 39.88 | 39.32 | 39.64 | 1370325.0 |
| 2004-05-27 | EWK | ETF | 13.75 | 13.88 | 13.65 | 13.88 | 6900.0 |
| 2004-05-27 | EWL | ETF | 15.12 | 15.4 | 15.12 | 15.32 | 22500.0 |
| 2004-05-27 | EWM | ETF | 25.64 | 25.8 | 25.24 | 25.52 | 17475.0 |
| 2004-05-27 | EWN | ETF | 16.3 | 16.34 | 16.11 | 16.29 | 52600.0 |
| 2004-05-27 | EWO | ETF | 15.78 | 15.94 | 15.72 | 15.94 | 20000.0 |
| 2004-05-27 | EWP | ETF | 27.8 | 28.02 | 27.8 | 28.02 | 11400.0 |
| 2004-05-27 | EWQ | ETF | 20.75 | 20.89 | 20.71 | 20.89 | 39400.0 |
| 2004-05-27 | EWS | ETF | 12.08 | 12.2 | 12.06 | 12.12 | 71850.0 |
| 2004-05-27 | EWT | ETF | 22.22 | 22.4 | 22.2 | 22.4 | 233150.0 |
| 2004-05-27 | EWU | ETF | 32.12 | 32.12 | 31.8 | 31.96 | 147800.0 |
| 2004-05-27 | EWW | ETF | 19.1 | 19.36 | 19.1 | 19.3 | 112000.0 |
| 2004-05-27 | EWY | ETF | 24.67 | 24.67 | 24.5 | 24.65 | 135000.0 |
| 2004-05-27 | EWZ | ETF | 13.65 | 14.03 | 13.6 | 13.96 | 286700.0 |
| 2004-05-27 | EZA | ETF | 28.055 | 28.055 | 28.05 | 28.05 | 800.0 |
| 2004-05-27 | EZU | ETF | 30.4 | 30.4 | 30.125 | 30.39 | 95200.0 |
| 2004-05-27 | FCTR | ETF | 21.1 | 21.1 | 20.59 | 20.95 | 18957.0 |
| 2004-05-27 | FEZ | ETF | 34.31 | 34.42 | 34.24 | 34.37 | 48600.0 |
| 2004-05-27 | FMAR | ETF | 18.0 | 18.0 | 17.8 | 17.8 | 3000.0 |
| 2004-05-27 | FVD | ETF | 13.74 | 13.75 | 13.57 | 13.65 | 141400.0 |
| 2004-05-27 | GLDB | ETF | 16.35 | 16.39 | 16.2913 | 16.36 | 358384.0 |
| 2004-05-27 | GRNB | ETF | 20.6835 | 20.6835 | 20.2221 | 20.4479 | 12919.0 |
> showing 50 of 157 rows — these rows as CSV