PREVIEW / etf_daily / 2002-03-19
file: by_date/etf_daily/2002/2002-03-19.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-03-19 | SPY | ETF | 117.3 | 117.74 | 116.82 | 117.45 | 17912000.0 |
| 2002-03-19 | QQQ | ETF | 37.609 | 37.88 | 37.22 | 37.38 | 58960500.0 |
| 2002-03-19 | IWM | ETF | 50.15 | 50.325 | 49.95 | 50.225 | 621200.0 |
| 2002-03-19 | DIA | ETF | 106.4 | 106.85 | 106.0 | 106.69 | 9935600.0 |
| 2002-03-19 | ARB | ETF | 32.75 | 33.19 | 32.5 | 33.19 | 22100.0 |
| 2002-03-19 | BBH | ETF | 43.0 | 43.0033 | 42.1833 | 42.4633 | 3482100.0 |
| 2002-03-19 | BITS | ETF | 13.4 | 14.2 | 13.36 | 13.52 | 5975.0 |
| 2002-03-19 | BOSS | ETF | 23.2 | 23.4 | 23.2 | 23.4 | 100.0 |
| 2002-03-19 | CEF | ETF | 3.65 | 3.75 | 3.61 | 3.75 | 13500.0 |
| 2002-03-19 | CHB | ETF | 8.34 | 8.57 | 8.34 | 8.55 | 602400.0 |
| 2002-03-19 | CNXT | ETF | 12.56 | 12.73 | 11.96 | 12.2 | 2547000.0 |
| 2002-03-19 | DGT | ETF | 66.28 | 66.28 | 66.28 | 66.28 | 200.0 |
| 2002-03-19 | EFA | ETF | 40.8 | 40.85 | 40.6733 | 40.7633 | 202200.0 |
| 2002-03-19 | ELV | ETF | 29.05 | 29.2 | 28.2 | 28.2 | 495600.0 |
| 2002-03-19 | EPP | ETF | 19.01 | 19.01 | 18.92 | 18.92 | 69600.0 |
| 2002-03-19 | EWA | ETF | 9.85 | 9.86 | 9.66 | 9.84 | 56800.0 |
| 2002-03-19 | EWC | ETF | 11.3 | 11.35 | 11.21 | 11.29 | 329700.0 |
| 2002-03-19 | EWD | ETF | 13.55 | 13.55 | 13.41 | 13.41 | 4500.0 |
| 2002-03-19 | EWG | ETF | 15.71 | 15.74 | 15.56 | 15.74 | 35200.0 |
| 2002-03-19 | EWH | ETF | 9.15 | 9.29 | 9.12 | 9.29 | 75200.0 |
| 2002-03-19 | EWI | ETF | 33.2 | 33.5 | 33.2 | 33.5 | 3600.0 |
| 2002-03-19 | EWJ | ETF | 33.72 | 33.8 | 33.52 | 33.76 | 291350.0 |
| 2002-03-19 | EWK | ETF | 10.95 | 10.95 | 10.93 | 10.93 | 200.0 |
| 2002-03-19 | EWL | ETF | 13.07 | 13.24 | 13.05 | 13.21 | 18100.0 |
| 2002-03-19 | EWM | ETF | 23.36 | 23.76 | 23.36 | 23.72 | 53875.0 |
| 2002-03-19 | EWN | ETF | 18.05 | 18.16 | 18.01 | 18.16 | 10900.0 |
| 2002-03-19 | EWO | ETF | 7.95 | 7.96 | 7.93 | 7.94 | 2900.0 |
| 2002-03-19 | EWP | ETF | 21.05 | 21.19 | 21.04 | 21.19 | 1600.0 |
| 2002-03-19 | EWQ | ETF | 18.9 | 18.9 | 18.76 | 18.8 | 1100.0 |
| 2002-03-19 | EWS | ETF | 11.62 | 11.7 | 11.48 | 11.56 | 27100.0 |
| 2002-03-19 | EWT | ETF | 22.6 | 22.8 | 22.52 | 22.8 | 18550.0 |
| 2002-03-19 | EWU | ETF | 29.68 | 29.68 | 29.44 | 29.54 | 15450.0 |
| 2002-03-19 | EWW | ETF | 17.85 | 18.05 | 17.72 | 17.88 | 298500.0 |
| 2002-03-19 | EWY | ETF | 22.97 | 23.19 | 22.97 | 23.15 | 93400.0 |
| 2002-03-19 | EWZ | ETF | 13.69 | 13.7 | 13.5 | 13.6 | 492100.0 |
| 2002-03-19 | EZU | ETF | 28.125 | 28.325 | 28.105 | 28.27 | 39000.0 |
| 2002-03-19 | FCTR | ETF | 19.24 | 19.49 | 19.24 | 19.45 | 16800.0 |
| 2002-03-19 | FMAR | ETF | 10.3 | 10.49 | 9.25 | 9.66 | 20800.0 |
| 2002-03-19 | GLDB | ETF | 8.15 | 8.23 | 8.0 | 8.19 | 92000.0 |
| 2002-03-19 | GSIG | ETF | 9.74 | 9.74 | 9.42 | 9.58 | 24000.0 |
| 2002-03-19 | IBB | ETF | 27.4167 | 27.5167 | 27.1667 | 27.3333 | 935100.0 |
| 2002-03-19 | ICF | ETF | 22.325 | 22.385 | 22.325 | 22.335 | 20400.0 |
| 2002-03-19 | IDU | ETF | 32.2 | 32.375 | 32.18 | 32.25 | 39800.0 |
| 2002-03-19 | IEV | ETF | 30.075 | 30.085 | 29.85 | 29.99 | 48400.0 |
| 2002-03-19 | IGLD | ETF | 137.0 | 137.0 | 131.0 | 131.0 | 33.0 |
| 2002-03-19 | IGM | ETF | 7.9583 | 8.0 | 7.9183 | 7.9667 | 27000.0 |
| 2002-03-19 | IGN | ETF | 24.9 | 24.9 | 24.52 | 24.6 | 11800.0 |
| 2002-03-19 | IGV | ETF | 8.48 | 8.54 | 8.41 | 8.5 | 63500.0 |
| 2002-03-19 | IJH | ETF | 10.854 | 10.887 | 10.82 | 10.86 | 371000.0 |
| 2002-03-19 | IJJ | ETF | 24.6375 | 24.7125 | 24.5375 | 24.675 | 474000.0 |
> showing 50 of 119 rows — these rows as CSV