PREVIEW / etf_daily / 2003-01-27
file: by_date/etf_daily/2003/2003-01-27.parquet size: 10 KB rows: 128
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-27 | SPY | ETF | 85.73 | 86.8 | 84.5 | 85.2 | 57884400.0 |
| 2003-01-27 | QQQ | ETF | 24.45 | 25.03 | 24.37 | 24.53 | 76578000.0 |
| 2003-01-27 | IWM | ETF | 37.0 | 37.305 | 36.565 | 36.625 | 3477400.0 |
| 2003-01-27 | DIA | ETF | 80.8 | 81.8 | 79.61 | 80.15 | 10515700.0 |
| 2003-01-27 | TLT | ETF | 87.9 | 88.04 | 87.5 | 87.65 | 150500.0 |
| 2003-01-27 | AAA | ETF | 42.87 | 43.0 | 42.87 | 42.9 | 5500.0 |
| 2003-01-27 | ADRE | ETF | 49.0 | 49.0 | 48.5 | 48.5 | 1700.0 |
| 2003-01-27 | ARB | ETF | 31.8 | 32.6 | 31.79 | 31.79 | 134700.0 |
| 2003-01-27 | BBH | ETF | 29.55 | 29.75 | 28.9333 | 29.2 | 2705700.0 |
| 2003-01-27 | BITS | ETF | 7.204 | 7.204 | 7.2 | 7.2 | 275.0 |
| 2003-01-27 | CEF | ETF | 4.85 | 4.93 | 4.78 | 4.92 | 339600.0 |
| 2003-01-27 | CHB | ETF | 2.88 | 2.95 | 2.8 | 2.93 | 132500.0 |
| 2003-01-27 | CNXT | ETF | 1.44 | 1.5 | 1.3672 | 1.4 | 6053240.0 |
| 2003-01-27 | CSB | ETF | 9.19999980926514 | 9.60000038146973 | 9.19999980926514 | 9.30000019073486 | 19100.0 |
| 2003-01-27 | DGT | ETF | 47.88 | 47.88 | 47.04 | 47.04 | 300.0 |
| 2003-01-27 | EFA | ETF | 31.45 | 31.6833 | 31.17 | 31.2933 | 1155300.0 |
| 2003-01-27 | ELV | ETF | 30.55 | 30.575 | 29.9 | 30.045 | 732000.0 |
| 2003-01-27 | EPP | ETF | 17.4167 | 17.53 | 17.3333 | 17.4 | 357000.0 |
| 2003-01-27 | EWA | ETF | 9.67 | 9.69 | 9.55 | 9.56 | 129900.0 |
| 2003-01-27 | EWC | ETF | 9.77 | 9.9 | 9.6 | 9.61 | 1912600.0 |
| 2003-01-27 | EWD | ETF | 9.61 | 9.77 | 9.56 | 9.56 | 2200.0 |
| 2003-01-27 | EWG | ETF | 9.55 | 9.82 | 9.46 | 9.5 | 66200.0 |
| 2003-01-27 | EWH | ETF | 7.3 | 7.52 | 7.24 | 7.43 | 239000.0 |
| 2003-01-27 | EWI | ETF | 28.22 | 28.22 | 28.0 | 28.06 | 1850.0 |
| 2003-01-27 | EWJ | ETF | 28.0 | 28.24 | 27.88 | 28.08 | 324725.0 |
| 2003-01-27 | EWK | ETF | 9.46 | 9.46 | 9.2 | 9.21 | 326600.0 |
| 2003-01-27 | EWL | ETF | 10.93 | 10.93 | 10.61 | 10.61 | 11800.0 |
| 2003-01-27 | EWM | ETF | 21.16 | 21.36 | 21.0 | 21.16 | 4150.0 |
| 2003-01-27 | EWN | ETF | 12.21 | 12.28 | 12.08 | 12.08 | 4700.0 |
| 2003-01-27 | EWO | ETF | 9.17 | 9.17 | 8.95 | 8.95 | 390500.0 |
| 2003-01-27 | EWP | ETF | 18.3 | 18.6 | 18.3 | 18.41 | 7800.0 |
| 2003-01-27 | EWQ | ETF | 13.9 | 13.9 | 13.6 | 13.7 | 6200.0 |
| 2003-01-27 | EWS | ETF | 8.76 | 8.76 | 8.56 | 8.62 | 74550.0 |
| 2003-01-27 | EWT | ETF | 17.42 | 18.18 | 17.4 | 17.7 | 210450.0 |
| 2003-01-27 | EWU | ETF | 22.1 | 22.44 | 21.64 | 21.88 | 208350.0 |
| 2003-01-27 | EWW | ETF | 11.85 | 12.05 | 11.85 | 11.99 | 108800.0 |
| 2003-01-27 | EWY | ETF | 17.8 | 17.8 | 17.41 | 17.5 | 375700.0 |
| 2003-01-27 | EWZ | ETF | 7.01 | 7.28 | 7.01 | 7.23 | 183600.0 |
| 2003-01-27 | EZU | ETF | 20.875 | 20.875 | 20.085 | 20.28 | 76000.0 |
| 2003-01-27 | FCTR | ETF | 18.52 | 18.52 | 17.84 | 17.87 | 26715.0 |
| 2003-01-27 | FEZ | ETF | 23.74 | 23.74 | 23.17 | 23.35 | 57100.0 |
| 2003-01-27 | FMAR | ETF | 11.5 | 11.5 | 11.4 | 11.4 | 1400.0 |
| 2003-01-27 | GLDB | ETF | 9.95 | 10.0 | 9.85 | 9.86 | 56379.0 |
| 2003-01-27 | GRNB | ETF | 19.6331 | 20.1239 | 19.6331 | 20.1239 | 4340.0 |
| 2003-01-27 | GSIG | ETF | 5.45 | 5.51 | 5.37 | 5.37 | 18300.0 |
| 2003-01-27 | IBB | ETF | 16.55 | 16.6667 | 16.1833 | 16.25 | 600000.0 |
| 2003-01-27 | ICF | ETF | 19.2875 | 19.4125 | 19.25 | 19.2775 | 310800.0 |
| 2003-01-27 | IDU | ETF | 22.875 | 23.25 | 22.45 | 22.675 | 612800.0 |
| 2003-01-27 | IEF | ETF | 85.63 | 85.69 | 85.4 | 85.48 | 413800.0 |
| 2003-01-27 | IEV | ETF | 22.12 | 22.475 | 21.755 | 21.825 | 483800.0 |
> showing 50 of 128 rows — these rows as CSV