PREVIEW / etf_daily / 2002-07-17
file: by_date/etf_daily/2002/2002-07-17.parquet size: 9 KB rows: 122
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-07-17 | SPY | ETF | 92.46 | 93.3 | 89.75 | 90.74 | 48880600.0 |
| 2002-07-17 | QQQ | ETF | 26.077 | 26.44 | 24.89 | 25.65 | 158228200.0 |
| 2002-07-17 | IWM | ETF | 41.495 | 41.5 | 40.06 | 40.875 | 2669000.0 |
| 2002-07-17 | DIA | ETF | 86.62 | 87.5 | 84.55 | 85.46 | 9671900.0 |
| 2002-07-17 | AAA | ETF | 50.7 | 51.25 | 50.0 | 50.1 | 13800.0 |
| 2002-07-17 | ARB | ETF | 30.31 | 31.05 | 30.31 | 31.05 | 117200.0 |
| 2002-07-17 | BBH | ETF | 24.65 | 25.31 | 24.5 | 25.2267 | 8018400.0 |
| 2002-07-17 | BITS | ETF | 8.2 | 8.756 | 7.64 | 8.68 | 6050.0 |
| 2002-07-17 | CEF | ETF | 4.35 | 4.37 | 4.25 | 4.37 | 156400.0 |
| 2002-07-17 | CHB | ETF | 3.51 | 3.6 | 3.2 | 3.26 | 292200.0 |
| 2002-07-17 | CNXT | ETF | 2.68 | 2.71 | 2.45 | 2.59 | 10763800.0 |
| 2002-07-17 | CSB | ETF | 4.94999980926514 | 4.94999980926514 | 4.94999980926514 | 4.94999980926514 | 2000.0 |
| 2002-07-17 | DGT | ETF | 51.65 | 51.65 | 51.05 | 51.05 | 600.0 |
| 2002-07-17 | EFA | ETF | 37.05 | 37.35 | 36.8867 | 37.0833 | 658800.0 |
| 2002-07-17 | ELV | ETF | 31.75 | 32.675 | 31.3 | 32.425 | 1273500.0 |
| 2002-07-17 | EPP | ETF | 18.6 | 18.6167 | 18.1533 | 18.1533 | 72300.0 |
| 2002-07-17 | EWA | ETF | 9.4 | 9.46 | 9.28 | 9.35 | 143400.0 |
| 2002-07-17 | EWC | ETF | 10.0 | 10.0 | 9.8 | 9.8 | 33300.0 |
| 2002-07-17 | EWD | ETF | 10.72 | 10.99 | 10.72 | 10.99 | 68300.0 |
| 2002-07-17 | EWG | ETF | 13.51 | 13.71 | 13.1 | 13.25 | 380500.0 |
| 2002-07-17 | EWH | ETF | 8.47 | 8.75 | 8.46 | 8.51 | 139800.0 |
| 2002-07-17 | EWI | ETF | 30.9 | 31.12 | 30.64 | 31.12 | 3400.0 |
| 2002-07-17 | EWJ | ETF | 33.56 | 33.92 | 33.48 | 33.68 | 256925.0 |
| 2002-07-17 | EWK | ETF | 10.94 | 10.94 | 10.94 | 10.94 | 500.0 |
| 2002-07-17 | EWL | ETF | 12.2 | 12.34 | 12.05 | 12.06 | 11200.0 |
| 2002-07-17 | EWM | ETF | 23.4 | 23.52 | 23.2 | 23.2 | 68925.0 |
| 2002-07-17 | EWN | ETF | 15.36 | 15.36 | 15.26 | 15.3 | 5400.0 |
| 2002-07-17 | EWO | ETF | 8.99 | 9.0 | 8.99 | 8.99 | 8100.0 |
| 2002-07-17 | EWP | ETF | 19.17 | 19.19 | 19.06 | 19.18 | 3200.0 |
| 2002-07-17 | EWQ | ETF | 16.29 | 16.52 | 16.12 | 16.46 | 56300.0 |
| 2002-07-17 | EWS | ETF | 10.9 | 11.1 | 10.6 | 10.62 | 145350.0 |
| 2002-07-17 | EWT | ETF | 20.96 | 21.24 | 20.62 | 21.24 | 48800.0 |
| 2002-07-17 | EWU | ETF | 25.1 | 25.88 | 25.1 | 25.58 | 16050.0 |
| 2002-07-17 | EWW | ETF | 14.58 | 14.58 | 14.3 | 14.48 | 103000.0 |
| 2002-07-17 | EWY | ETF | 22.75 | 23.19 | 22.6 | 22.85 | 43300.0 |
| 2002-07-17 | EWZ | ETF | 9.0 | 9.15 | 8.95 | 9.03 | 119300.0 |
| 2002-07-17 | EZU | ETF | 24.815 | 24.85 | 24.44 | 24.665 | 306800.0 |
| 2002-07-17 | FCTR | ETF | 17.35 | 17.99 | 17.35 | 17.99 | 13500.0 |
| 2002-07-17 | FMAR | ETF | 11.87 | 11.9 | 11.1 | 11.4 | 11000.0 |
| 2002-07-17 | GLDB | ETF | 10.66 | 10.95 | 10.65 | 10.91 | 106200.0 |
| 2002-07-17 | GRNB | ETF | 15.5592 | 15.5592 | 15.5592 | 15.5592 | 1211.0 |
| 2002-07-17 | GSIG | ETF | 7.67 | 8.34 | 7.66 | 8.26 | 84900.0 |
| 2002-07-17 | IBB | ETF | 15.75 | 16.1333 | 15.5 | 15.9667 | 5303700.0 |
| 2002-07-17 | ICF | ETF | 21.7125 | 21.7125 | 21.0675 | 21.225 | 164000.0 |
| 2002-07-17 | IDU | ETF | 25.675 | 25.9 | 24.855 | 24.915 | 83000.0 |
| 2002-07-17 | IEV | ETF | 26.325 | 26.45 | 25.88 | 26.1 | 398600.0 |
| 2002-07-17 | IGE | ETF | 14.3833 | 14.3833 | 14.175 | 14.175 | 1800.0 |
| 2002-07-17 | IGLD | ETF | 108.0 | 108.0 | 108.0 | 108.0 | 45.0 |
| 2002-07-17 | IGM | ETF | 5.7083 | 5.75 | 5.4833 | 5.49 | 41400.0 |
| 2002-07-17 | IGN | ETF | 17.05 | 17.4 | 16.16 | 16.44 | 13100.0 |
> showing 50 of 122 rows — these rows as CSV