PREVIEW / etf_daily / 2002-01-07
file: by_date/etf_daily/2002/2002-01-07.parquet size: 9 KB rows: 119
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-01-07 | SPY | ETF | 117.7 | 117.99 | 116.56 | 116.79 | 13106500.0 |
| 2002-01-07 | QQQ | ETF | 42.118 | 42.22 | 40.11 | 41.21 | 75166200.0 |
| 2002-01-07 | IWM | ETF | 49.675 | 49.9 | 48.925 | 48.925 | 1661800.0 |
| 2002-01-07 | DIA | ETF | 102.87 | 103.14 | 101.89 | 102.14 | 2485200.0 |
| 2002-01-07 | ARB | ETF | 32.6 | 32.7 | 32.0 | 32.0 | 51900.0 |
| 2002-01-07 | BBH | ETF | 43.6 | 43.78 | 42.6767 | 42.6833 | 3132900.0 |
| 2002-01-07 | BITS | ETF | 26.2 | 26.2 | 24.0 | 25.52 | 6500.0 |
| 2002-01-07 | BOSS | ETF | 22.2 | 22.4 | 22.2 | 22.4 | 100.0 |
| 2002-01-07 | CEF | ETF | 3.42 | 3.45 | 3.4 | 3.45 | 18300.0 |
| 2002-01-07 | CHB | ETF | 11.8 | 12.85 | 11.8 | 12.62 | 598600.0 |
| 2002-01-07 | CNXT | ETF | 15.38 | 15.52 | 14.28 | 14.35 | 5418000.0 |
| 2002-01-07 | CSB | ETF | 4.30000019073486 | 4.59999990463257 | 4.30000019073486 | 4.59999990463257 | 5100.0 |
| 2002-01-07 | DGT | ETF | 67.9 | 67.9 | 67.38 | 67.38 | 6900.0 |
| 2002-01-07 | EFA | ETF | 40.2433 | 40.3833 | 40.0067 | 40.0733 | 387900.0 |
| 2002-01-07 | ELV | ETF | 23.93 | 23.97 | 23.5 | 23.51 | 958200.0 |
| 2002-01-07 | EPP | ETF | 18.6933 | 18.7667 | 18.6933 | 18.7433 | 92100.0 |
| 2002-01-07 | EWA | ETF | 9.65 | 9.75 | 9.64 | 9.75 | 37000.0 |
| 2002-01-07 | EWC | ETF | 11.0 | 11.35 | 11.0 | 11.35 | 18100.0 |
| 2002-01-07 | EWD | ETF | 14.72 | 14.72 | 14.5 | 14.54 | 8600.0 |
| 2002-01-07 | EWG | ETF | 15.38 | 15.41 | 15.18 | 15.25 | 20800.0 |
| 2002-01-07 | EWH | ETF | 9.82 | 9.82 | 9.66 | 9.69 | 56000.0 |
| 2002-01-07 | EWI | ETF | 32.5 | 32.78 | 32.5 | 32.5 | 5050.0 |
| 2002-01-07 | EWJ | ETF | 32.04 | 32.2 | 31.64 | 31.72 | 216550.0 |
| 2002-01-07 | EWL | ETF | 12.67 | 12.79 | 12.61 | 12.61 | 900.0 |
| 2002-01-07 | EWM | ETF | 20.32 | 20.64 | 20.2 | 20.24 | 23250.0 |
| 2002-01-07 | EWN | ETF | 17.0 | 17.04 | 17.0 | 17.04 | 700.0 |
| 2002-01-07 | EWO | ETF | 7.3 | 7.31 | 7.3 | 7.31 | 1000.0 |
| 2002-01-07 | EWP | ETF | 20.57 | 20.65 | 20.36 | 20.36 | 265300.0 |
| 2002-01-07 | EWQ | ETF | 18.88 | 18.99 | 18.68 | 18.7 | 19200.0 |
| 2002-01-07 | EWS | ETF | 10.8 | 10.82 | 10.6 | 10.74 | 32550.0 |
| 2002-01-07 | EWT | ETF | 22.76 | 23.16 | 22.76 | 22.82 | 104450.0 |
| 2002-01-07 | EWU | ETF | 29.66 | 29.66 | 29.24 | 29.24 | 3600.0 |
| 2002-01-07 | EWW | ETF | 15.55 | 15.85 | 15.51 | 15.65 | 30200.0 |
| 2002-01-07 | EWY | ETF | 19.2 | 19.6 | 19.2 | 19.32 | 88200.0 |
| 2002-01-07 | EWZ | ETF | 12.86 | 13.05 | 12.86 | 13.05 | 38400.0 |
| 2002-01-07 | EZU | ETF | 28.3 | 28.32 | 27.905 | 27.915 | 21200.0 |
| 2002-01-07 | FCTR | ETF | 17.61 | 17.91 | 17.5 | 17.5 | 23800.0 |
| 2002-01-07 | FMAR | ETF | 9.88 | 10.3 | 9.88 | 10.25 | 69700.0 |
| 2002-01-07 | GLDB | ETF | 7.35 | 7.35 | 7.11 | 7.11 | 73100.0 |
| 2002-01-07 | GSIG | ETF | 10.26 | 10.75 | 10.26 | 10.32 | 153000.0 |
| 2002-01-07 | IBB | ETF | 29.8 | 29.95 | 28.9833 | 28.9833 | 1851600.0 |
| 2002-01-07 | ICF | ETF | 21.25 | 21.3125 | 21.2025 | 21.2025 | 50800.0 |
| 2002-01-07 | IDU | ETF | 31.85 | 32.07 | 31.655 | 32.0 | 115800.0 |
| 2002-01-07 | IEV | ETF | 29.7 | 29.815 | 29.635 | 29.635 | 221200.0 |
| 2002-01-07 | IGE | ETF | 15.8167 | 15.8167 | 15.8167 | 15.8167 | 1800.0 |
| 2002-01-07 | IGLD | ETF | 99.0 | 102.0 | 97.0 | 102.0 | 297.0 |
| 2002-01-07 | IGM | ETF | 9.2083 | 9.2083 | 9.0033 | 9.0167 | 435600.0 |
| 2002-01-07 | IGN | ETF | 34.6 | 34.6 | 33.45 | 33.6 | 416600.0 |
| 2002-01-07 | IGV | ETF | 9.9 | 9.9 | 9.66 | 9.66 | 51500.0 |
| 2002-01-07 | IJH | ETF | 10.385 | 10.385 | 10.248 | 10.248 | 295000.0 |
> showing 50 of 119 rows — these rows as CSV