PREVIEW / etf_daily / 2002-09-20
file: by_date/etf_daily/2002/2002-09-20.parquet size: 9 KB rows: 124
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-09-20 | SPY | ETF | 84.92 | 85.2 | 84.05 | 84.35 | 46325600.0 |
| 2002-09-20 | QQQ | ETF | 21.831 | 21.9 | 21.48 | 21.67 | 78200300.0 |
| 2002-09-20 | IWM | ETF | 36.875 | 36.965 | 36.4 | 36.55 | 1485600.0 |
| 2002-09-20 | DIA | ETF | 79.88 | 81.25 | 79.2 | 79.67 | 9374000.0 |
| 2002-09-20 | TLT | ETF | 89.45 | 89.52 | 89.06 | 89.3 | 113500.0 |
| 2002-09-20 | AAA | ETF | 40.9 | 41.29 | 40.65 | 40.65 | 1700.0 |
| 2002-09-20 | ARB | ETF | 31.5 | 32.2 | 31.2 | 32.19 | 171800.0 |
| 2002-09-20 | BBH | ETF | 25.75 | 25.9333 | 25.04 | 25.6867 | 4243200.0 |
| 2002-09-20 | BITS | ETF | 8.76 | 9.92 | 8.72 | 9.92 | 1475.0 |
| 2002-09-20 | CEF | ETF | 4.33 | 4.35 | 4.25 | 4.25 | 115800.0 |
| 2002-09-20 | CHB | ETF | 2.21 | 2.92 | 2.21 | 2.83 | 382900.0 |
| 2002-09-20 | CNXT | ETF | 1.1584 | 1.2702 | 1.0771 | 1.26 | 9197570.0 |
| 2002-09-20 | DGT | ETF | 46.35 | 47.35 | 46.35 | 47.35 | 600.0 |
| 2002-09-20 | EFA | ETF | 32.4667 | 32.5967 | 31.8833 | 32.0733 | 771300.0 |
| 2002-09-20 | ELV | ETF | 32.85 | 33.46 | 32.55 | 32.655 | 950000.0 |
| 2002-09-20 | EPP | ETF | 17.13 | 17.13 | 17.02 | 17.0633 | 2400.0 |
| 2002-09-20 | EWA | ETF | 9.24 | 9.24 | 9.0 | 9.13 | 177500.0 |
| 2002-09-20 | EWC | ETF | 8.71 | 8.75 | 8.66 | 8.75 | 10500.0 |
| 2002-09-20 | EWD | ETF | 8.81 | 8.99 | 8.81 | 8.99 | 1800.0 |
| 2002-09-20 | EWG | ETF | 9.95 | 10.05 | 9.8 | 9.97 | 34500.0 |
| 2002-09-20 | EWH | ETF | 7.37 | 7.54 | 7.3 | 7.4 | 22200.0 |
| 2002-09-20 | EWI | ETF | 26.92 | 27.28 | 26.92 | 27.28 | 200.0 |
| 2002-09-20 | EWJ | ETF | 29.56 | 29.8 | 29.4 | 29.72 | 212325.0 |
| 2002-09-20 | EWK | ETF | 9.1 | 9.15 | 9.01 | 9.01 | 900.0 |
| 2002-09-20 | EWL | ETF | 10.84 | 10.85 | 10.46 | 10.59 | 17700.0 |
| 2002-09-20 | EWM | ETF | 21.28 | 21.28 | 20.6 | 20.84 | 49450.0 |
| 2002-09-20 | EWN | ETF | 12.64 | 12.64 | 12.31 | 12.31 | 5100.0 |
| 2002-09-20 | EWO | ETF | 7.75 | 7.75 | 7.75 | 7.75 | 200.0 |
| 2002-09-20 | EWP | ETF | 16.0 | 16.05 | 16.0 | 16.05 | 3500.0 |
| 2002-09-20 | EWQ | ETF | 13.6 | 13.83 | 13.4 | 13.4 | 36500.0 |
| 2002-09-20 | EWS | ETF | 9.02 | 9.18 | 8.96 | 9.1 | 28300.0 |
| 2002-09-20 | EWT | ETF | 16.2 | 16.2 | 15.42 | 15.6 | 2850.0 |
| 2002-09-20 | EWU | ETF | 23.48 | 24.0 | 23.32 | 23.88 | 47600.0 |
| 2002-09-20 | EWW | ETF | 12.2 | 12.49 | 12.15 | 12.35 | 97000.0 |
| 2002-09-20 | EWY | ETF | 19.97 | 20.2 | 19.78 | 19.96 | 63500.0 |
| 2002-09-20 | EWZ | ETF | 6.91 | 7.13 | 6.76 | 7.09 | 125100.0 |
| 2002-09-20 | EZU | ETF | 20.05 | 20.145 | 19.75 | 20.14 | 177400.0 |
| 2002-09-20 | FCTR | ETF | 16.4 | 16.94 | 16.24 | 16.85 | 113600.0 |
| 2002-09-20 | FMAR | ETF | 10.3 | 10.4 | 10.28 | 10.28 | 4200.0 |
| 2002-09-20 | GLDB | ETF | 9.84 | 10.04 | 9.75 | 9.86 | 127300.0 |
| 2002-09-20 | GRNB | ETF | 15.7065 | 15.7065 | 15.7065 | 15.7065 | 1009.0 |
| 2002-09-20 | GSIG | ETF | 5.13 | 5.19 | 5.01 | 5.11 | 6300.0 |
| 2002-09-20 | IBB | ETF | 15.3333 | 15.4667 | 14.9833 | 15.3333 | 1941600.0 |
| 2002-09-20 | ICF | ETF | 21.0875 | 21.2625 | 21.0875 | 21.2625 | 82800.0 |
| 2002-09-20 | IDU | ETF | 23.515 | 23.515 | 22.875 | 23.225 | 405000.0 |
| 2002-09-20 | IEF | ETF | 86.3 | 86.48 | 86.2 | 86.4 | 128600.0 |
| 2002-09-20 | IEV | ETF | 22.515 | 22.645 | 22.23 | 22.425 | 65200.0 |
| 2002-09-20 | IGE | ETF | 12.9167 | 12.965 | 12.875 | 12.9283 | 214200.0 |
| 2002-09-20 | IGLD | ETF | 97.0 | 98.0 | 97.0 | 98.0 | 3.0 |
| 2002-09-20 | IGM | ETF | 4.4167 | 4.4633 | 4.3683 | 4.3683 | 202800.0 |
> showing 50 of 124 rows — these rows as CSV