PREVIEW / etf_daily / 2004-07-23
file: by_date/etf_daily/2004/2004-07-23.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-07-23 | SPY | ETF | 109.62 | 109.71 | 108.69 | 108.96 | 49610500.0 |
| 2004-07-23 | QQQ | ETF | 34.63 | 34.66 | 34.03 | 34.21 | 107147200.0 |
| 2004-07-23 | IWM | ETF | 54.335 | 54.435 | 53.7 | 53.82 | 18983400.0 |
| 2004-07-23 | DIA | ETF | 100.32 | 100.33 | 99.5 | 99.82 | 6837100.0 |
| 2004-07-23 | TLT | ETF | 84.78 | 84.97 | 84.78 | 84.95 | 209200.0 |
| 2004-07-23 | AAA | ETF | 55.46 | 55.8 | 54.87 | 54.87 | 135200.0 |
| 2004-07-23 | ADRE | ETF | 64.95 | 64.95 | 64.76 | 64.76 | 900.0 |
| 2004-07-23 | AGG | ETF | 101.14 | 101.19 | 100.85 | 101.19 | 41200.0 |
| 2004-07-23 | ARB | ETF | 34.65 | 34.7 | 33.97 | 34.0 | 303900.0 |
| 2004-07-23 | BBH | ETF | 44.8 | 45.2833 | 44.39 | 44.5667 | 4307400.0 |
| 2004-07-23 | BITS | ETF | 7.48 | 7.48 | 6.68 | 6.964 | 460.0 |
| 2004-07-23 | BNE | ETF | 14.53 | 14.75 | 14.26 | 14.53 | 97400.0 |
| 2004-07-23 | CEF | ETF | 5.5 | 5.53 | 5.4 | 5.43 | 265800.0 |
| 2004-07-23 | CHB | ETF | 7.85 | 9.8 | 7.8 | 9.57 | 2568600.0 |
| 2004-07-23 | CNXT | ETF | 2.06 | 2.08 | 1.89 | 1.98 | 32970870.0 |
| 2004-07-23 | CSB | ETF | 24.7999992370605 | 24.7999992370605 | 24.4500007629395 | 24.7999992370605 | 16100.0 |
| 2004-07-23 | DGT | ETF | 59.29 | 59.34 | 59.14 | 59.3 | 25700.0 |
| 2004-07-23 | DVY | ETF | 54.65 | 54.69 | 54.05 | 54.19 | 376900.0 |
| 2004-07-23 | EEM | ETF | 17.3756 | 17.3756 | 17.0489 | 17.1222 | 1970100.0 |
| 2004-07-23 | EFA | ETF | 45.6633 | 45.6633 | 45.0233 | 45.07 | 1337700.0 |
| 2004-07-23 | ELV | ETF | 44.995 | 44.995 | 44.035 | 44.4 | 1993900.0 |
| 2004-07-23 | EPP | ETF | 24.5167 | 24.53 | 24.28 | 24.28 | 46200.0 |
| 2004-07-23 | EWA | ETF | 13.18 | 13.33 | 13.13 | 13.16 | 73900.0 |
| 2004-07-23 | EWC | ETF | 14.34 | 14.38 | 14.26 | 14.37 | 80700.0 |
| 2004-07-23 | EWD | ETF | 16.46 | 16.5 | 16.37 | 16.42 | 11900.0 |
| 2004-07-23 | EWG | ETF | 14.95 | 15.07 | 14.9 | 14.97 | 69000.0 |
| 2004-07-23 | EWH | ETF | 10.38 | 10.38 | 10.07 | 10.16 | 603600.0 |
| 2004-07-23 | EWI | ETF | 40.78 | 40.78 | 40.02 | 40.14 | 3150.0 |
| 2004-07-23 | EWJ | ETF | 39.52 | 39.76 | 39.08 | 39.16 | 790550.0 |
| 2004-07-23 | EWK | ETF | 13.92 | 14.05 | 13.78 | 13.83 | 54900.0 |
| 2004-07-23 | EWL | ETF | 14.6 | 15.1 | 14.6 | 14.91 | 60500.0 |
| 2004-07-23 | EWM | ETF | 26.12 | 26.36 | 25.76 | 26.0 | 30625.0 |
| 2004-07-23 | EWN | ETF | 15.59 | 15.73 | 15.38 | 15.45 | 42900.0 |
| 2004-07-23 | EWO | ETF | 17.1 | 17.1 | 16.7 | 16.75 | 83400.0 |
| 2004-07-23 | EWP | ETF | 27.55 | 27.64 | 27.4 | 27.41 | 86100.0 |
| 2004-07-23 | EWQ | ETF | 20.36 | 20.36 | 20.08 | 20.08 | 19800.0 |
| 2004-07-23 | EWS | ETF | 12.58 | 12.58 | 12.1 | 12.22 | 54400.0 |
| 2004-07-23 | EWT | ETF | 19.32 | 19.52 | 19.06 | 19.1 | 116100.0 |
| 2004-07-23 | EWU | ETF | 31.44 | 31.44 | 30.96 | 31.2 | 43000.0 |
| 2004-07-23 | EWW | ETF | 18.79 | 18.79 | 18.56 | 18.59 | 14800.0 |
| 2004-07-23 | EWY | ETF | 22.37 | 22.37 | 21.91 | 21.96 | 200500.0 |
| 2004-07-23 | EWZ | ETF | 15.15 | 15.4 | 15.02 | 15.06 | 119100.0 |
| 2004-07-23 | EZA | ETF | 28.37 | 28.37 | 28.25 | 28.25 | 26000.0 |
| 2004-07-23 | EZU | ETF | 29.72 | 29.72 | 29.125 | 29.21 | 52000.0 |
| 2004-07-23 | FCTR | ETF | 22.44 | 22.55 | 22.11 | 22.24 | 55068.0 |
| 2004-07-23 | FEZ | ETF | 32.63 | 32.64 | 32.29 | 32.3 | 11000.0 |
| 2004-07-23 | FMAR | ETF | 15.91 | 16.0 | 15.6 | 15.71 | 3520.0 |
| 2004-07-23 | FVD | ETF | 14.0 | 14.05 | 13.85 | 13.85 | 78100.0 |
| 2004-07-23 | GLDB | ETF | 15.36 | 15.53 | 15.28 | 15.37 | 115100.0 |
| 2004-07-23 | GRNB | ETF | 22.5781 | 22.6566 | 22.5781 | 22.5781 | 6359.0 |
> showing 50 of 162 rows — these rows as CSV