PREVIEW / etf_daily / 2004-01-23
file: by_date/etf_daily/2004/2004-01-23.parquet size: 10 KB rows: 141
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-01-23 | SPY | ETF | 115.0 | 115.37 | 113.95 | 114.43 | 44245300.0 |
| 2004-01-23 | QQQ | ETF | 38.21 | 38.46 | 37.78 | 38.01 | 88805500.0 |
| 2004-01-23 | IWM | ETF | 59.095 | 59.41 | 58.69 | 59.36 | 8255400.0 |
| 2004-01-23 | DIA | ETF | 106.57 | 106.59 | 105.36 | 105.86 | 6833100.0 |
| 2004-01-23 | TLT | ETF | 88.56 | 88.9 | 87.26 | 87.38 | 1021300.0 |
| 2004-01-23 | AAA | ETF | 59.25 | 59.25 | 58.67 | 58.7 | 5400.0 |
| 2004-01-23 | ADRE | ETF | 76.75 | 77.739 | 76.75 | 77.3 | 4980.0 |
| 2004-01-23 | AGG | ETF | 103.78 | 103.79 | 103.0 | 103.1 | 28700.0 |
| 2004-01-23 | ARB | ETF | 43.95 | 43.95 | 43.08 | 43.51 | 194300.0 |
| 2004-01-23 | BBH | ETF | 46.57 | 47.2 | 46.5667 | 47.1367 | 1848300.0 |
| 2004-01-23 | BITS | ETF | 14.28 | 14.4 | 13.6 | 13.88 | 1700.0 |
| 2004-01-23 | BNE | ETF | 14.76 | 15.0 | 14.68 | 14.88 | 125200.0 |
| 2004-01-23 | CEF | ETF | 5.35 | 5.35 | 5.3 | 5.33 | 166800.0 |
| 2004-01-23 | CHB | ETF | 7.4 | 7.76 | 7.06 | 7.29 | 698800.0 |
| 2004-01-23 | CNXT | ETF | 6.7448 | 6.7749 | 6.4336 | 6.5952 | 9713530.0 |
| 2004-01-23 | DGT | ETF | 63.4 | 63.4 | 62.81 | 62.82 | 2800.0 |
| 2004-01-23 | DVY | ETF | 55.17 | 55.28 | 54.72 | 54.88 | 602600.0 |
| 2004-01-23 | EEM | ETF | 19.2789 | 19.2889 | 19.1778 | 19.2222 | 811800.0 |
| 2004-01-23 | EFA | ETF | 47.1967 | 47.28 | 46.6033 | 46.8233 | 1104900.0 |
| 2004-01-23 | ELV | ETF | 40.425 | 40.425 | 39.345 | 39.735 | 1639800.0 |
| 2004-01-23 | EPP | ETF | 25.78 | 25.8633 | 25.4967 | 25.5967 | 182400.0 |
| 2004-01-23 | EWA | ETF | 13.79 | 13.85 | 13.7 | 13.74 | 83600.0 |
| 2004-01-23 | EWC | ETF | 14.73 | 14.79 | 14.6 | 14.6 | 79800.0 |
| 2004-01-23 | EWD | ETF | 16.65 | 16.65 | 16.35 | 16.35 | 10100.0 |
| 2004-01-23 | EWG | ETF | 17.09 | 17.13 | 16.76 | 16.92 | 165300.0 |
| 2004-01-23 | EWH | ETF | 11.45 | 11.48 | 11.32 | 11.39 | 496500.0 |
| 2004-01-23 | EWI | ETF | 41.76 | 41.76 | 41.32 | 41.32 | 3550.0 |
| 2004-01-23 | EWJ | ETF | 39.76 | 39.88 | 38.96 | 39.08 | 2324125.0 |
| 2004-01-23 | EWK | ETF | 14.15 | 14.15 | 13.78 | 13.78 | 6900.0 |
| 2004-01-23 | EWL | ETF | 15.49 | 15.53 | 15.23 | 15.38 | 40900.0 |
| 2004-01-23 | EWM | ETF | 27.12 | 27.24 | 27.0 | 27.08 | 86700.0 |
| 2004-01-23 | EWN | ETF | 17.0 | 17.09 | 16.85 | 16.93 | 7800.0 |
| 2004-01-23 | EWO | ETF | 15.04 | 15.08 | 14.75 | 14.78 | 80100.0 |
| 2004-01-23 | EWP | ETF | 29.5 | 29.5 | 28.97 | 28.97 | 19400.0 |
| 2004-01-23 | EWQ | ETF | 21.32 | 21.38 | 21.1 | 21.15 | 24600.0 |
| 2004-01-23 | EWS | ETF | 13.2 | 13.24 | 12.98 | 13.08 | 53650.0 |
| 2004-01-23 | EWT | ETF | 24.5 | 24.52 | 24.02 | 24.4 | 173750.0 |
| 2004-01-23 | EWU | ETF | 31.4 | 31.58 | 31.26 | 31.3 | 40500.0 |
| 2004-01-23 | EWW | ETF | 18.7 | 19.28 | 18.7 | 19.06 | 215900.0 |
| 2004-01-23 | EWY | ETF | 27.69 | 27.72 | 27.06 | 27.2 | 109400.0 |
| 2004-01-23 | EWZ | ETF | 17.4 | 17.67 | 17.39 | 17.62 | 840000.0 |
| 2004-01-23 | EZA | ETF | 27.925 | 27.96 | 27.645 | 27.705 | 26000.0 |
| 2004-01-23 | EZU | ETF | 32.27 | 32.335 | 31.8 | 31.8 | 107400.0 |
| 2004-01-23 | FCTR | ETF | 19.53 | 20.12 | 19.53 | 19.84 | 70597.0 |
| 2004-01-23 | FEZ | ETF | 36.8 | 36.85 | 36.34 | 36.45 | 210000.0 |
| 2004-01-23 | FMAR | ETF | 18.75 | 18.81 | 18.5 | 18.75 | 4480.0 |
| 2004-01-23 | FVD | ETF | 14.66 | 14.75 | 14.61 | 14.62 | 191800.0 |
| 2004-01-23 | GLDB | ETF | 14.34 | 14.4 | 14.2 | 14.37 | 109087.0 |
| 2004-01-23 | GRNB | ETF | 22.9708 | 23.4812 | 22.5192 | 23.226 | 3936.0 |
| 2004-01-23 | GSIG | ETF | 13.01 | 13.05 | 12.82 | 12.93 | 29100.0 |
> showing 50 of 141 rows — these rows as CSV