PREVIEW / etf_daily / 2002-07-23
file: by_date/etf_daily/2002/2002-07-23.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-23 | SPY | ETF | 82.55 | 83.24 | 79.75 | 79.95 | 74484100.0 |
| 2002-07-23 | QQQ | ETF | 23.453 | 23.75 | 22.28 | 22.4 | 150796900.0 |
| 2002-07-23 | IWM | ETF | 38.075 | 38.075 | 35.875 | 35.875 | 3187000.0 |
| 2002-07-23 | DIA | ETF | 78.33 | 79.21 | 76.76 | 77.17 | 21734000.0 |
| 2002-07-23 | AAA | ETF | 45.5 | 45.5 | 45.5 | 45.5 | 100.0 |
| 2002-07-23 | ARB | ETF | 31.1 | 31.61 | 30.0 | 30.19 | 214400.0 |
| 2002-07-23 | BBH | ETF | 23.5833 | 23.85 | 22.8667 | 22.9667 | 5317200.0 |
| 2002-07-23 | BITS | ETF | 9.2 | 10.32 | 9.2 | 10.0 | 1350.0 |
| 2002-07-23 | BOSS | ETF | 12.5 | 12.5 | 11.5 | 11.5 | 200.0 |
| 2002-07-23 | CEF | ETF | 4.32 | 4.35 | 4.06 | 4.14 | 456100.0 |
| 2002-07-23 | CHB | ETF | 3.29 | 3.31 | 3.02 | 3.02 | 496900.0 |
| 2002-07-23 | CNXT | ETF | 1.93 | 2.0 | 1.66 | 1.69 | 6994640.0 |
| 2002-07-23 | CSB | ETF | 4.94999980926514 | 4.94999980926514 | 4.94999980926514 | 4.94999980926514 | 600.0 |
| 2002-07-23 | DGT | ETF | 45.4 | 45.48 | 45.25 | 45.25 | 600.0 |
| 2002-07-23 | EFA | ETF | 34.2333 | 34.4267 | 33.4367 | 33.6333 | 797100.0 |
| 2002-07-23 | ELV | ETF | 29.5 | 29.595 | 28.51 | 28.875 | 1444800.0 |
| 2002-07-23 | EPP | ETF | 17.7433 | 17.7433 | 17.4567 | 17.4567 | 45900.0 |
| 2002-07-23 | EWA | ETF | 9.08 | 9.17 | 9.01 | 9.08 | 17600.0 |
| 2002-07-23 | EWC | ETF | 9.05 | 9.25 | 8.8 | 9.0 | 93500.0 |
| 2002-07-23 | EWD | ETF | 9.54 | 9.54 | 9.11 | 9.11 | 7100.0 |
| 2002-07-23 | EWG | ETF | 12.06 | 12.06 | 11.4 | 11.45 | 59500.0 |
| 2002-07-23 | EWH | ETF | 8.46 | 8.61 | 8.26 | 8.49 | 77600.0 |
| 2002-07-23 | EWI | ETF | 28.3 | 28.3 | 27.42 | 27.42 | 1650.0 |
| 2002-07-23 | EWJ | ETF | 32.96 | 33.0 | 32.52 | 32.52 | 313500.0 |
| 2002-07-23 | EWK | ETF | 9.51 | 9.51 | 9.25 | 9.25 | 2200.0 |
| 2002-07-23 | EWL | ETF | 10.7 | 10.72 | 10.46 | 10.46 | 3500.0 |
| 2002-07-23 | EWM | ETF | 22.8 | 23.12 | 22.6 | 22.8 | 100925.0 |
| 2002-07-23 | EWN | ETF | 13.4 | 13.4 | 13.1 | 13.1 | 2400.0 |
| 2002-07-23 | EWO | ETF | 8.6 | 8.6 | 8.36 | 8.36 | 17700.0 |
| 2002-07-23 | EWP | ETF | 17.78 | 17.78 | 16.96 | 16.96 | 6100.0 |
| 2002-07-23 | EWQ | ETF | 14.57 | 14.65 | 14.26 | 14.26 | 8000.0 |
| 2002-07-23 | EWS | ETF | 10.42 | 10.58 | 10.06 | 10.08 | 37200.0 |
| 2002-07-23 | EWT | ETF | 20.0 | 20.0 | 19.0 | 19.24 | 32650.0 |
| 2002-07-23 | EWU | ETF | 23.8 | 24.14 | 23.06 | 23.2 | 34100.0 |
| 2002-07-23 | EWW | ETF | 14.04 | 14.05 | 13.4 | 13.49 | 267800.0 |
| 2002-07-23 | EWY | ETF | 22.18 | 22.18 | 21.55 | 21.7 | 106900.0 |
| 2002-07-23 | EWZ | ETF | 8.7 | 8.7 | 8.11 | 8.2 | 102100.0 |
| 2002-07-23 | EZU | ETF | 22.15 | 22.17 | 20.98 | 21.145 | 119000.0 |
| 2002-07-23 | FCTR | ETF | 17.58 | 17.58 | 15.35 | 16.3 | 32300.0 |
| 2002-07-23 | FMAR | ETF | 10.26 | 10.38 | 10.0 | 10.0 | 47000.0 |
| 2002-07-23 | GLDB | ETF | 9.99 | 9.991 | 9.55 | 9.65 | 169700.0 |
| 2002-07-23 | GRNB | ETF | 16.1974 | 16.1974 | 15.7065 | 16.1974 | 908.0 |
| 2002-07-23 | GSIG | ETF | 8.25 | 8.39 | 6.78 | 6.81 | 82800.0 |
| 2002-07-23 | IBB | ETF | 14.95 | 15.1333 | 14.3433 | 14.3433 | 3494400.0 |
| 2002-07-23 | ICF | ETF | 19.9875 | 20.1975 | 19.4 | 19.4 | 430800.0 |
| 2002-07-23 | IDU | ETF | 22.55 | 22.875 | 20.995 | 21.135 | 247200.0 |
| 2002-07-23 | IEV | ETF | 23.525 | 23.75 | 22.64 | 22.66 | 232600.0 |
| 2002-07-23 | IGE | ETF | 12.6 | 12.6 | 12.2667 | 12.2667 | 9000.0 |
| 2002-07-23 | IGLD | ETF | 99.0 | 106.1 | 99.0 | 106.0 | 34.0 |
| 2002-07-23 | IGM | ETF | 5.035 | 5.04 | 4.85 | 4.85 | 36600.0 |
> showing 50 of 122 rows — these rows as CSV