PREVIEW / etf_daily / 2004-08-20
file: by_date/etf_daily/2004/2004-08-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-08-20 | SPY | ETF | 109.61 | 110.63 | 109.51 | 110.48 | 44870900.0 |
| 2004-08-20 | QQQ | ETF | 33.57 | 34.141 | 33.51 | 34.01 | 92070400.0 |
| 2004-08-20 | IWM | ETF | 53.56 | 54.7 | 53.455 | 54.51 | 11919400.0 |
| 2004-08-20 | DIA | ETF | 100.39 | 101.44 | 100.31 | 101.25 | 5462800.0 |
| 2004-08-20 | TLT | ETF | 86.58 | 86.75 | 86.4 | 86.54 | 875400.0 |
| 2004-08-20 | AAA | ETF | 54.08 | 54.36 | 54.04 | 54.34 | 10100.0 |
| 2004-08-20 | ADRE | ETF | 68.17 | 68.33 | 68.17 | 68.33 | 900.0 |
| 2004-08-20 | AGG | ETF | 102.39 | 102.39 | 102.05 | 102.05 | 57900.0 |
| 2004-08-20 | ARB | ETF | 39.0 | 39.31 | 38.6 | 39.24 | 545500.0 |
| 2004-08-20 | BBH | ETF | 45.6667 | 46.6 | 45.6667 | 46.6 | 1757400.0 |
| 2004-08-20 | BITS | ETF | 7.36 | 7.76 | 7.36 | 7.48 | 1018.0 |
| 2004-08-20 | BNE | ETF | 13.3 | 13.69 | 13.3 | 13.67 | 120100.0 |
| 2004-08-20 | CEF | ETF | 5.7 | 5.75 | 5.66 | 5.74 | 639900.0 |
| 2004-08-20 | CHB | ETF | 10.04 | 10.22 | 9.82 | 10.17 | 613700.0 |
| 2004-08-20 | CNXT | ETF | 1.56 | 1.64 | 1.54 | 1.59 | 7066460.0 |
| 2004-08-20 | CSB | ETF | 26.1700000762939 | 26.1700000762939 | 25.7999992370605 | 25.7999992370605 | 62900.0 |
| 2004-08-20 | DGT | ETF | 59.71 | 59.82 | 59.67 | 59.67 | 1000.0 |
| 2004-08-20 | DVY | ETF | 55.7 | 56.08 | 55.55 | 56.08 | 376000.0 |
| 2004-08-20 | EEM | ETF | 17.6278 | 17.7711 | 17.6 | 17.6889 | 1683000.0 |
| 2004-08-20 | EFA | ETF | 45.3633 | 45.7667 | 45.2667 | 45.6667 | 1521300.0 |
| 2004-08-20 | ELV | ETF | 40.78 | 41.345 | 40.78 | 41.105 | 727800.0 |
| 2004-08-20 | EPP | ETF | 25.0967 | 25.1967 | 25.05 | 25.19 | 118500.0 |
| 2004-08-20 | EWA | ETF | 13.66 | 13.71 | 13.61 | 13.71 | 26400.0 |
| 2004-08-20 | EWC | ETF | 14.4 | 14.55 | 14.39 | 14.5 | 329700.0 |
| 2004-08-20 | EWD | ETF | 16.44 | 16.6 | 16.37 | 16.6 | 4900.0 |
| 2004-08-20 | EWG | ETF | 14.87 | 14.97 | 14.85 | 14.93 | 71000.0 |
| 2004-08-20 | EWH | ETF | 10.36 | 10.5 | 10.36 | 10.49 | 521600.0 |
| 2004-08-20 | EWI | ETF | 40.26 | 40.38 | 40.24 | 40.38 | 2300.0 |
| 2004-08-20 | EWJ | ETF | 38.76 | 39.52 | 38.72 | 39.48 | 655875.0 |
| 2004-08-20 | EWK | ETF | 14.47 | 14.73 | 14.47 | 14.69 | 7400.0 |
| 2004-08-20 | EWL | ETF | 14.59 | 14.65 | 14.41 | 14.65 | 10400.0 |
| 2004-08-20 | EWM | ETF | 25.2 | 25.4 | 25.16 | 25.32 | 228400.0 |
| 2004-08-20 | EWN | ETF | 15.75 | 15.78 | 15.74 | 15.75 | 1900.0 |
| 2004-08-20 | EWO | ETF | 16.92 | 16.99 | 16.85 | 16.97 | 47900.0 |
| 2004-08-20 | EWP | ETF | 27.39 | 27.67 | 27.39 | 27.49 | 500.0 |
| 2004-08-20 | EWQ | ETF | 20.41 | 20.48 | 20.41 | 20.48 | 2700.0 |
| 2004-08-20 | EWS | ETF | 12.88 | 12.94 | 12.82 | 12.9 | 21400.0 |
| 2004-08-20 | EWT | ETF | 20.7 | 21.0 | 20.54 | 20.98 | 435000.0 |
| 2004-08-20 | EWU | ETF | 31.48 | 31.56 | 31.42 | 31.54 | 132500.0 |
| 2004-08-20 | EWW | ETF | 19.17 | 19.3 | 19.12 | 19.27 | 122800.0 |
| 2004-08-20 | EWY | ETF | 23.98 | 24.22 | 23.81 | 24.21 | 150400.0 |
| 2004-08-20 | EWZ | ETF | 17.09 | 17.22 | 16.95 | 17.14 | 327000.0 |
| 2004-08-20 | EZA | ETF | 29.34 | 29.75 | 29.34 | 29.75 | 17400.0 |
| 2004-08-20 | EZU | ETF | 29.545 | 29.9 | 29.45 | 29.895 | 43000.0 |
| 2004-08-20 | FCTR | ETF | 22.59 | 22.99 | 22.33 | 22.99 | 29513.0 |
| 2004-08-20 | FEZ | ETF | 32.43 | 32.89 | 32.43 | 32.84 | 36100.0 |
| 2004-08-20 | FMAR | ETF | 15.76 | 15.9 | 15.76 | 15.85 | 10900.0 |
| 2004-08-20 | FVD | ETF | 14.04 | 14.12 | 14.04 | 14.11 | 106200.0 |
| 2004-08-20 | GLDB | ETF | 15.54 | 15.59 | 15.45 | 15.57 | 55829.0 |
| 2004-08-20 | GRNB | ETF | 22.6468 | 22.7744 | 22.6174 | 22.7744 | 1918.0 |
> showing 50 of 163 rows — these rows as CSV