PREVIEW / etf_daily / 2004-08-19
file: by_date/etf_daily/2004/2004-08-19.parquet size: 11 KB rows: 162
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-19 | SPY | ETF | 109.81 | 110.02 | 109.18 | 109.71 | 39881600.0 |
| 2004-08-19 | QQQ | ETF | 33.73 | 33.85 | 33.41 | 33.672 | 106881900.0 |
| 2004-08-19 | IWM | ETF | 53.86 | 54.04 | 53.365 | 53.56 | 10119000.0 |
| 2004-08-19 | DIA | ETF | 101.01 | 101.18 | 100.32 | 100.85 | 5510900.0 |
| 2004-08-19 | TLT | ETF | 86.5 | 86.75 | 86.34 | 86.62 | 372900.0 |
| 2004-08-19 | AAA | ETF | 54.04 | 54.19 | 54.0 | 54.07 | 3000.0 |
| 2004-08-19 | ADRE | ETF | 67.99 | 68.14 | 67.95 | 68.0 | 944.0 |
| 2004-08-19 | AGG | ETF | 102.12 | 102.35 | 102.0 | 102.35 | 32700.0 |
| 2004-08-19 | ARB | ETF | 37.85 | 38.73 | 37.69 | 38.3 | 598800.0 |
| 2004-08-19 | BBH | ETF | 45.92 | 45.9267 | 45.5 | 45.8267 | 1859700.0 |
| 2004-08-19 | BITS | ETF | 7.08 | 7.44 | 7.08 | 7.4 | 250.0 |
| 2004-08-19 | BNE | ETF | 13.46 | 13.52 | 13.25 | 13.25 | 78200.0 |
| 2004-08-19 | CEF | ETF | 5.68 | 5.71 | 5.66 | 5.69 | 375400.0 |
| 2004-08-19 | CHB | ETF | 9.99 | 10.17 | 9.82 | 10.02 | 388100.0 |
| 2004-08-19 | CNXT | ETF | 1.65 | 1.65 | 1.55 | 1.59 | 8471480.0 |
| 2004-08-19 | CSB | ETF | 26.0 | 26.25 | 26.0 | 26.1700000762939 | 14600.0 |
| 2004-08-19 | DGT | ETF | 59.84 | 59.84 | 59.53 | 59.53 | 1500.0 |
| 2004-08-19 | DVY | ETF | 55.98 | 55.98 | 55.5 | 55.7 | 294500.0 |
| 2004-08-19 | EEM | ETF | 17.7722 | 17.7722 | 17.54 | 17.6011 | 1306800.0 |
| 2004-08-19 | EFA | ETF | 45.5467 | 45.6467 | 45.3333 | 45.4533 | 1177500.0 |
| 2004-08-19 | ELV | ETF | 41.5 | 41.505 | 40.33 | 40.745 | 1509600.0 |
| 2004-08-19 | EPP | ETF | 24.9333 | 25.0633 | 24.8967 | 25.0167 | 43200.0 |
| 2004-08-19 | EWA | ETF | 13.5 | 13.65 | 13.48 | 13.63 | 39200.0 |
| 2004-08-19 | EWC | ETF | 14.26 | 14.46 | 14.26 | 14.33 | 12000.0 |
| 2004-08-19 | EWD | ETF | 16.62 | 16.62 | 16.48 | 16.5 | 1500.0 |
| 2004-08-19 | EWG | ETF | 14.92 | 15.0 | 14.92 | 14.97 | 16900.0 |
| 2004-08-19 | EWH | ETF | 10.36 | 10.45 | 10.29 | 10.33 | 143500.0 |
| 2004-08-19 | EWI | ETF | 40.46 | 40.56 | 40.46 | 40.56 | 3350.0 |
| 2004-08-19 | EWJ | ETF | 38.84 | 39.0 | 38.6 | 38.72 | 594150.0 |
| 2004-08-19 | EWK | ETF | 14.51 | 14.59 | 14.51 | 14.57 | 6300.0 |
| 2004-08-19 | EWL | ETF | 14.62 | 14.62 | 14.55 | 14.55 | 7100.0 |
| 2004-08-19 | EWM | ETF | 25.8 | 25.8 | 25.2 | 25.36 | 38550.0 |
| 2004-08-19 | EWN | ETF | 15.69 | 15.69 | 15.68 | 15.68 | 4800.0 |
| 2004-08-19 | EWO | ETF | 17.52 | 17.55 | 16.97 | 17.12 | 76600.0 |
| 2004-08-19 | EWP | ETF | 27.67 | 27.8 | 27.62 | 27.75 | 2300.0 |
| 2004-08-19 | EWQ | ETF | 20.45 | 20.46 | 20.43 | 20.46 | 9600.0 |
| 2004-08-19 | EWS | ETF | 12.94 | 12.96 | 12.92 | 12.96 | 18600.0 |
| 2004-08-19 | EWT | ETF | 20.58 | 20.7 | 20.42 | 20.6 | 311500.0 |
| 2004-08-19 | EWU | ETF | 31.56 | 31.58 | 31.42 | 31.54 | 37050.0 |
| 2004-08-19 | EWW | ETF | 19.06 | 19.22 | 19.06 | 19.17 | 59300.0 |
| 2004-08-19 | EWY | ETF | 23.9 | 24.1 | 23.75 | 23.98 | 273200.0 |
| 2004-08-19 | EWZ | ETF | 17.0 | 17.09 | 16.73 | 16.87 | 231300.0 |
| 2004-08-19 | EZA | ETF | 29.495 | 29.6 | 29.205 | 29.31 | 23200.0 |
| 2004-08-19 | EZU | ETF | 29.82 | 29.82 | 29.5 | 29.77 | 8000.0 |
| 2004-08-19 | FCTR | ETF | 22.33 | 22.6 | 22.16 | 22.51 | 34773.0 |
| 2004-08-19 | FEZ | ETF | 32.8 | 32.8 | 32.66 | 32.66 | 900.0 |
| 2004-08-19 | FMAR | ETF | 15.77 | 15.9 | 15.77 | 15.77 | 3360.0 |
| 2004-08-19 | FVD | ETF | 14.1 | 14.13 | 14.03 | 14.03 | 93400.0 |
| 2004-08-19 | GLDB | ETF | 15.44 | 15.52 | 15.41 | 15.5 | 97052.0 |
| 2004-08-19 | GRNB | ETF | 22.3719 | 22.9904 | 22.3719 | 22.9904 | 2120.0 |
> showing 50 of 162 rows — these rows as CSV