PREVIEW / etf_daily / 2002-11-27
file: by_date/etf_daily/2002/2002-11-27.parquet size: 10 KB rows: 127
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-27 | SPY | ETF | 92.52 | 94.65 | 92.43 | 94.28 | 37764000.0 |
| 2002-11-27 | QQQ | ETF | 27.53 | 28.2 | 27.487 | 27.91 | 73686600.0 |
| 2002-11-27 | IWM | ETF | 40.2 | 40.975 | 40.08 | 40.91 | 2574600.0 |
| 2002-11-27 | DIA | ETF | 87.65 | 89.65 | 87.59 | 89.53 | 8264700.0 |
| 2002-11-27 | TLT | ETF | 86.25 | 86.33 | 84.96 | 85.0 | 325600.0 |
| 2002-11-27 | AAA | ETF | 45.51 | 46.74 | 45.25 | 46.51 | 4700.0 |
| 2002-11-27 | ADRE | ETF | 51.48 | 52.35 | 51.48 | 52.1 | 500.0 |
| 2002-11-27 | ARB | ETF | 31.15 | 31.73 | 31.09 | 31.73 | 57400.0 |
| 2002-11-27 | BBH | ETF | 29.3333 | 29.9133 | 29.1833 | 29.8333 | 2236200.0 |
| 2002-11-27 | BITS | ETF | 7.64 | 7.68 | 7.62 | 7.64 | 625.0 |
| 2002-11-27 | CEF | ETF | 4.22 | 4.23 | 4.13 | 4.19 | 74500.0 |
| 2002-11-27 | CHB | ETF | 3.51 | 3.87 | 3.51 | 3.8 | 222700.0 |
| 2002-11-27 | CNXT | ETF | 2.3651 | 2.4353 | 2.2549 | 2.2549 | 4179420.0 |
| 2002-11-27 | CSB | ETF | 9.01000022888184 | 9.01000022888184 | 8.94999980926514 | 8.94999980926514 | 5700.0 |
| 2002-11-27 | DGT | ETF | 53.11 | 53.92 | 53.11 | 53.92 | 4000.0 |
| 2002-11-27 | EFA | ETF | 34.1833 | 34.6267 | 34.1367 | 34.6233 | 1091700.0 |
| 2002-11-27 | ELV | ETF | 28.625 | 29.12 | 28.375 | 29.105 | 2875000.0 |
| 2002-11-27 | EPP | ETF | 17.6033 | 17.7333 | 17.6033 | 17.73 | 20400.0 |
| 2002-11-27 | EWA | ETF | 9.47 | 9.55 | 9.31 | 9.55 | 13000.0 |
| 2002-11-27 | EWC | ETF | 9.4 | 9.65 | 9.4 | 9.65 | 39700.0 |
| 2002-11-27 | EWD | ETF | 10.65 | 11.05 | 10.65 | 11.05 | 7200.0 |
| 2002-11-27 | EWG | ETF | 10.68 | 11.1 | 10.68 | 10.95 | 60600.0 |
| 2002-11-27 | EWH | ETF | 8.04 | 8.15 | 7.98 | 8.13 | 20700.0 |
| 2002-11-27 | EWI | ETF | 29.92 | 30.7 | 29.92 | 30.7 | 1150.0 |
| 2002-11-27 | EWJ | ETF | 28.4 | 28.56 | 28.28 | 28.44 | 225750.0 |
| 2002-11-27 | EWL | ETF | 11.53 | 11.65 | 11.37 | 11.5 | 3100.0 |
| 2002-11-27 | EWM | ETF | 20.56 | 20.64 | 20.48 | 20.64 | 6300.0 |
| 2002-11-27 | EWN | ETF | 14.14 | 14.35 | 14.02 | 14.35 | 70200.0 |
| 2002-11-27 | EWO | ETF | 7.95 | 8.02 | 7.91 | 7.91 | 15200.0 |
| 2002-11-27 | EWP | ETF | 18.88 | 18.89 | 18.85 | 18.85 | 6800.0 |
| 2002-11-27 | EWQ | ETF | 14.94 | 15.42 | 14.94 | 15.42 | 24500.0 |
| 2002-11-27 | EWS | ETF | 9.2 | 9.38 | 9.12 | 9.12 | 20200.0 |
| 2002-11-27 | EWT | ETF | 17.38 | 17.56 | 17.22 | 17.56 | 84950.0 |
| 2002-11-27 | EWU | ETF | 25.28 | 25.3 | 24.94 | 25.14 | 53550.0 |
| 2002-11-27 | EWW | ETF | 13.1 | 13.44 | 13.1 | 13.44 | 176100.0 |
| 2002-11-27 | EWY | ETF | 20.92 | 21.39 | 20.92 | 21.3 | 344800.0 |
| 2002-11-27 | EWZ | ETF | 7.35 | 7.53 | 7.21 | 7.53 | 24300.0 |
| 2002-11-27 | EZU | ETF | 22.65 | 23.195 | 22.575 | 23.195 | 309800.0 |
| 2002-11-27 | FCTR | ETF | 17.54 | 18.5 | 17.5 | 18.5 | 57445.0 |
| 2002-11-27 | FEZ | ETF | 26.14 | 26.42 | 26.14 | 26.38 | 48500.0 |
| 2002-11-27 | FMAR | ETF | 10.721 | 10.819 | 10.719 | 10.819 | 7200.0 |
| 2002-11-27 | GLDB | ETF | 9.68 | 9.9 | 9.5 | 9.9 | 84510.0 |
| 2002-11-27 | GSIG | ETF | 6.41 | 6.55 | 6.39 | 6.55 | 19200.0 |
| 2002-11-27 | IBB | ETF | 18.25 | 18.7 | 18.25 | 18.6933 | 1194600.0 |
| 2002-11-27 | ICF | ETF | 20.6225 | 20.6875 | 20.56 | 20.6875 | 157600.0 |
| 2002-11-27 | IDU | ETF | 23.4 | 23.55 | 23.24 | 23.55 | 203600.0 |
| 2002-11-27 | IEF | ETF | 84.57 | 84.61 | 83.75 | 84.0 | 324900.0 |
| 2002-11-27 | IEV | ETF | 24.77 | 25.07 | 24.705 | 25.07 | 267200.0 |
| 2002-11-27 | IGE | ETF | 13.4583 | 13.4733 | 13.4583 | 13.4733 | 131400.0 |
| 2002-11-27 | IGLD | ETF | 112.0 | 112.0 | 104.0 | 108.9 | 181.0 |
> showing 50 of 127 rows — these rows as CSV