PREVIEW / etf_daily / 2004-08-27
file: by_date/etf_daily/2004/2004-08-27.parquet size: 11 KB rows: 161
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-08-27 | SPY | ETF | 111.2 | 111.63 | 111.05 | 111.45 | 24902900.0 |
| 2004-08-27 | QQQ | ETF | 34.465 | 34.68 | 34.44 | 34.56 | 58624300.0 |
| 2004-08-27 | IWM | ETF | 54.575 | 55.125 | 54.575 | 54.88 | 8073200.0 |
| 2004-08-27 | DIA | ETF | 101.91 | 102.25 | 101.72 | 102.16 | 2971100.0 |
| 2004-08-27 | TLT | ETF | 86.83 | 87.03 | 86.64 | 86.82 | 304400.0 |
| 2004-08-27 | AAA | ETF | 53.89 | 53.94 | 53.63 | 53.94 | 1700.0 |
| 2004-08-27 | ADRE | ETF | 64.111 | 68.83 | 64.111 | 68.79 | 756.0 |
| 2004-08-27 | AGG | ETF | 102.39 | 102.43 | 102.31 | 102.36 | 50600.0 |
| 2004-08-27 | ARB | ETF | 39.3 | 39.7 | 39.29 | 39.42 | 144300.0 |
| 2004-08-27 | BBH | ETF | 46.9167 | 48.0167 | 46.9 | 47.7333 | 2411700.0 |
| 2004-08-27 | BITS | ETF | 7.04 | 7.92 | 7.0 | 7.88 | 2525.0 |
| 2004-08-27 | BNE | ETF | 13.34 | 13.41 | 13.27 | 13.41 | 135600.0 |
| 2004-08-27 | CEF | ETF | 5.61 | 5.66 | 5.43 | 5.48 | 457600.0 |
| 2004-08-27 | CHB | ETF | 10.0 | 10.09 | 9.77 | 9.91 | 134300.0 |
| 2004-08-27 | CNXT | ETF | 1.59 | 1.6502 | 1.57 | 1.61 | 6343320.0 |
| 2004-08-27 | CSB | ETF | 25.0 | 25.0499992370605 | 24.6000003814697 | 24.6000003814697 | 24900.0 |
| 2004-08-27 | DGT | ETF | 60.47 | 60.63 | 60.38 | 60.63 | 1500.0 |
| 2004-08-27 | DVY | ETF | 56.67 | 56.75 | 56.5 | 56.7 | 731200.0 |
| 2004-08-27 | EEM | ETF | 18.0167 | 18.0178 | 17.93 | 17.9356 | 1988100.0 |
| 2004-08-27 | EFA | ETF | 45.9667 | 46.0167 | 45.7733 | 45.9167 | 1377600.0 |
| 2004-08-27 | ELV | ETF | 40.35 | 40.89 | 40.27 | 40.71 | 975400.0 |
| 2004-08-27 | EPP | ETF | 25.3033 | 25.3033 | 25.17 | 25.2233 | 212400.0 |
| 2004-08-27 | EWA | ETF | 13.63 | 13.63 | 13.49 | 13.56 | 48400.0 |
| 2004-08-27 | EWC | ETF | 14.35 | 14.41 | 14.26 | 14.3 | 18800.0 |
| 2004-08-27 | EWD | ETF | 16.93 | 17.05 | 16.82 | 17.05 | 20200.0 |
| 2004-08-27 | EWG | ETF | 15.1 | 15.12 | 15.02 | 15.12 | 13700.0 |
| 2004-08-27 | EWH | ETF | 10.86 | 10.9 | 10.8 | 10.89 | 216700.0 |
| 2004-08-27 | EWI | ETF | 40.12 | 40.2 | 40.08 | 40.2 | 350.0 |
| 2004-08-27 | EWJ | ETF | 39.8 | 39.96 | 38.0 | 39.84 | 2164725.0 |
| 2004-08-27 | EWK | ETF | 14.83 | 14.83 | 14.66 | 14.71 | 6800.0 |
| 2004-08-27 | EWL | ETF | 14.68 | 14.7 | 14.55 | 14.7 | 13700.0 |
| 2004-08-27 | EWM | ETF | 25.92 | 26.0 | 25.64 | 25.84 | 17950.0 |
| 2004-08-27 | EWN | ETF | 15.72 | 15.9 | 15.72 | 15.78 | 3100.0 |
| 2004-08-27 | EWO | ETF | 16.92 | 17.08 | 16.92 | 16.96 | 15800.0 |
| 2004-08-27 | EWP | ETF | 27.36 | 27.36 | 27.28 | 27.32 | 2700.0 |
| 2004-08-27 | EWQ | ETF | 20.56 | 20.59 | 20.55 | 20.59 | 2300.0 |
| 2004-08-27 | EWS | ETF | 13.02 | 13.1 | 12.98 | 13.1 | 38950.0 |
| 2004-08-27 | EWT | ETF | 21.7 | 21.7 | 21.38 | 21.4 | 212500.0 |
| 2004-08-27 | EWU | ETF | 31.8 | 31.84 | 31.66 | 31.76 | 24950.0 |
| 2004-08-27 | EWW | ETF | 19.32 | 19.37 | 19.26 | 19.33 | 23800.0 |
| 2004-08-27 | EWY | ETF | 24.6 | 24.64 | 24.3 | 24.49 | 143000.0 |
| 2004-08-27 | EWZ | ETF | 16.75 | 16.78 | 16.65 | 16.65 | 290000.0 |
| 2004-08-27 | EZA | ETF | 29.68 | 29.68 | 29.56 | 29.635 | 34600.0 |
| 2004-08-27 | EZU | ETF | 29.82 | 29.82 | 29.7 | 29.775 | 43600.0 |
| 2004-08-27 | FCTR | ETF | 23.25 | 23.44 | 23.17 | 23.17 | 23076.0 |
| 2004-08-27 | FEZ | ETF | 32.81 | 32.84 | 32.68 | 32.82 | 48800.0 |
| 2004-08-27 | FMAR | ETF | 16.09 | 16.19 | 16.0 | 16.19 | 8350.0 |
| 2004-08-27 | FVD | ETF | 14.35 | 14.37 | 14.25 | 14.3 | 75300.0 |
| 2004-08-27 | GLDB | ETF | 15.46 | 15.55 | 15.46 | 15.47 | 49338.0 |
| 2004-08-27 | GRNB | ETF | 23.1082 | 23.118 | 23.0002 | 23.0002 | 1413.0 |
> showing 50 of 161 rows — these rows as CSV