PREVIEW / etf_daily / 2002-01-18
file: by_date/etf_daily/2002/2002-01-18.parquet size: 9 KB rows: 116
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-18 | SPY | ETF | 113.0 | 113.85 | 112.67 | 113.15 | 17028000.0 |
| 2002-01-18 | QQQ | ETF | 38.83 | 39.45 | 38.22 | 38.59 | 81985600.0 |
| 2002-01-18 | IWM | ETF | 47.55 | 47.83 | 46.9 | 46.95 | 991000.0 |
| 2002-01-18 | DIA | ETF | 97.48 | 98.38 | 97.0 | 97.9 | 3446800.0 |
| 2002-01-18 | ARB | ETF | 32.15 | 32.25 | 32.01 | 32.07 | 56500.0 |
| 2002-01-18 | BBH | ETF | 41.0833 | 42.0633 | 40.0833 | 40.3667 | 6595500.0 |
| 2002-01-18 | BITS | ETF | 20.24 | 21.2 | 19.6 | 19.68 | 13325.0 |
| 2002-01-18 | CEF | ETF | 3.55 | 3.55 | 3.49 | 3.54 | 25300.0 |
| 2002-01-18 | CHB | ETF | 11.1 | 11.38 | 11.0 | 11.33 | 487800.0 |
| 2002-01-18 | CNXT | ETF | 13.1 | 13.49 | 12.85 | 13.0 | 4172300.0 |
| 2002-01-18 | CSB | ETF | 4.80000019073486 | 4.80000019073486 | 4.80000019073486 | 4.80000019073486 | 6500.0 |
| 2002-01-18 | DGT | ETF | 65.12 | 65.15 | 64.87 | 64.87 | 600.0 |
| 2002-01-18 | EFA | ETF | 38.4 | 38.5 | 38.25 | 38.5 | 580800.0 |
| 2002-01-18 | ELV | ETF | 25.025 | 25.5 | 24.91 | 25.49 | 703000.0 |
| 2002-01-18 | EPP | ETF | 18.1733 | 18.1767 | 18.1633 | 18.1633 | 6000.0 |
| 2002-01-18 | EWA | ETF | 9.39 | 9.4 | 9.31 | 9.31 | 2800.0 |
| 2002-01-18 | EWC | ETF | 10.65 | 10.65 | 10.55 | 10.6 | 1300.0 |
| 2002-01-18 | EWD | ETF | 12.99 | 12.99 | 12.87 | 12.96 | 2600.0 |
| 2002-01-18 | EWG | ETF | 14.6 | 14.83 | 14.6 | 14.74 | 36800.0 |
| 2002-01-18 | EWH | ETF | 9.15 | 9.24 | 9.14 | 9.16 | 16300.0 |
| 2002-01-18 | EWI | ETF | 31.4 | 31.56 | 31.4 | 31.56 | 1350.0 |
| 2002-01-18 | EWJ | ETF | 30.08 | 30.08 | 29.88 | 30.04 | 45125.0 |
| 2002-01-18 | EWK | ETF | 10.88 | 10.88 | 10.7 | 10.7 | 700.0 |
| 2002-01-18 | EWL | ETF | 12.47 | 12.49 | 12.32 | 12.49 | 3200.0 |
| 2002-01-18 | EWM | ETF | 20.8 | 21.0 | 20.8 | 20.8 | 9200.0 |
| 2002-01-18 | EWN | ETF | 16.42 | 16.63 | 16.42 | 16.63 | 2700.0 |
| 2002-01-18 | EWO | ETF | 7.27 | 7.39 | 7.27 | 7.39 | 1900.0 |
| 2002-01-18 | EWP | ETF | 19.86 | 19.86 | 19.86 | 19.86 | 100.0 |
| 2002-01-18 | EWQ | ETF | 17.9 | 18.09 | 17.9 | 18.08 | 10600.0 |
| 2002-01-18 | EWS | ETF | 10.68 | 10.68 | 10.48 | 10.66 | 7850.0 |
| 2002-01-18 | EWT | ETF | 20.8 | 21.08 | 20.8 | 20.9 | 3650.0 |
| 2002-01-18 | EWU | ETF | 28.32 | 28.54 | 28.3 | 28.44 | 14450.0 |
| 2002-01-18 | EWW | ETF | 15.7 | 15.72 | 15.65 | 15.66 | 6400.0 |
| 2002-01-18 | EWY | ETF | 18.25 | 18.25 | 18.04 | 18.1 | 107100.0 |
| 2002-01-18 | EWZ | ETF | 12.21 | 12.3 | 12.21 | 12.29 | 4600.0 |
| 2002-01-18 | EZU | ETF | 26.7 | 26.965 | 26.7 | 26.8 | 21200.0 |
| 2002-01-18 | FCTR | ETF | 17.51 | 17.79 | 17.23 | 17.25 | 67300.0 |
| 2002-01-18 | GLDB | ETF | 7.04 | 7.04 | 6.97 | 7.01 | 41100.0 |
| 2002-01-18 | GRNB | ETF | 17.6698 | 17.6698 | 17.6698 | 17.6698 | 2725.0 |
| 2002-01-18 | GSIG | ETF | 9.75 | 10.02 | 9.73 | 9.85 | 127500.0 |
| 2002-01-18 | IBB | ETF | 27.1667 | 27.8167 | 26.4 | 26.6333 | 1152600.0 |
| 2002-01-18 | ICF | ETF | 21.025 | 21.085 | 20.8725 | 20.975 | 56800.0 |
| 2002-01-18 | IDU | ETF | 31.35 | 31.37 | 31.14 | 31.325 | 60400.0 |
| 2002-01-18 | IEV | ETF | 28.5 | 28.67 | 28.39 | 28.5 | 103600.0 |
| 2002-01-18 | IGLD | ETF | 112.0 | 118.0 | 110.0 | 115.0 | 651.0 |
| 2002-01-18 | IGM | ETF | 8.4333 | 8.4683 | 8.3867 | 8.4117 | 775800.0 |
| 2002-01-18 | IGN | ETF | 30.3 | 30.45 | 29.9 | 29.9 | 616000.0 |
| 2002-01-18 | IGV | ETF | 9.2 | 9.328 | 9.2 | 9.21 | 74000.0 |
| 2002-01-18 | IJH | ETF | 9.96 | 10.04 | 9.945 | 9.945 | 142000.0 |
| 2002-01-18 | IJJ | ETF | 22.25 | 22.3725 | 22.125 | 22.17 | 97200.0 |
> showing 50 of 116 rows — these rows as CSV