PREVIEW / etf_daily / 2001-06-12
file: by_date/etf_daily/2001/2001-06-12.parquet size: 8 KB rows: 100
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-12 | SPY | ETF | 124.86 | 126.74 | 124.04 | 125.88 | 9364400.0 |
| 2001-06-12 | QQQ | ETF | 44.87 | 46.8 | 44.23 | 45.8 | 78450500.0 |
| 2001-06-12 | IWM | ETF | 50.0 | 50.75 | 49.73 | 50.4 | 690200.0 |
| 2001-06-12 | DIA | ETF | 108.69 | 110.0 | 107.95 | 109.53 | 2369500.0 |
| 2001-06-12 | BBH | ETF | 42.6667 | 44.4867 | 42.25 | 44.1633 | 5895600.0 |
| 2001-06-12 | BITS | ETF | 9.96 | 10.48 | 9.64 | 10.16 | 2850.0 |
| 2001-06-12 | BOSS | ETF | 33.4 | 33.4 | 33.4 | 33.4 | 200.0 |
| 2001-06-12 | CEF | ETF | 3.25 | 3.33 | 3.25 | 3.33 | 27300.0 |
| 2001-06-12 | CHB | ETF | 10.67 | 10.69 | 10.42 | 10.61 | 119800.0 |
| 2001-06-12 | CNXT | ETF | 8.85 | 8.906 | 8.13 | 8.7 | 4238120.0 |
| 2001-06-12 | CSB | ETF | 2.09999990463257 | 2.09999990463257 | 2.09999990463257 | 2.09999990463257 | 15000.0 |
| 2001-06-12 | DGT | ETF | 71.44 | 71.44 | 71.44 | 71.44 | 500.0 |
| 2001-06-12 | EWA | ETF | 9.9 | 9.9 | 9.8 | 9.9 | 6500.0 |
| 2001-06-12 | EWC | ETF | 12.0 | 12.0 | 11.82 | 12.0 | 1400.0 |
| 2001-06-12 | EWD | ETF | 13.25 | 13.4 | 13.25 | 13.4 | 4300.0 |
| 2001-06-12 | EWG | ETF | 16.56 | 16.65 | 16.5 | 16.61 | 122600.0 |
| 2001-06-12 | EWH | ETF | 10.69 | 10.69 | 10.49 | 10.66 | 26100.0 |
| 2001-06-12 | EWI | ETF | 36.9 | 37.0 | 36.78 | 37.0 | 2450.0 |
| 2001-06-12 | EWJ | ETF | 41.2 | 41.48 | 40.64 | 41.44 | 391400.0 |
| 2001-06-12 | EWK | ETF | 11.22 | 11.22 | 11.22 | 11.22 | 600.0 |
| 2001-06-12 | EWL | ETF | 13.85 | 13.92 | 13.78 | 13.78 | 123700.0 |
| 2001-06-12 | EWM | ETF | 16.8 | 16.96 | 16.76 | 16.8 | 26625.0 |
| 2001-06-12 | EWN | ETF | 19.75 | 19.75 | 19.59 | 19.6 | 84300.0 |
| 2001-06-12 | EWO | ETF | 8.02 | 8.02 | 7.93 | 8.02 | 1300.0 |
| 2001-06-12 | EWP | ETF | 22.5 | 22.75 | 22.5 | 22.65 | 23000.0 |
| 2001-06-12 | EWQ | ETF | 20.41 | 20.64 | 20.36 | 20.64 | 132900.0 |
| 2001-06-12 | EWS | ETF | 10.82 | 10.84 | 10.64 | 10.84 | 4500.0 |
| 2001-06-12 | EWT | ETF | 22.14 | 22.14 | 21.8 | 21.94 | 42750.0 |
| 2001-06-12 | EWU | ETF | 31.32 | 31.82 | 31.28 | 31.36 | 214150.0 |
| 2001-06-12 | EWW | ETF | 16.69 | 16.95 | 16.5 | 16.95 | 31100.0 |
| 2001-06-12 | EWY | ETF | 14.56 | 14.56 | 14.56 | 14.56 | 400.0 |
| 2001-06-12 | EWZ | ETF | 14.4 | 14.4 | 14.35 | 14.4 | 9700.0 |
| 2001-06-12 | EZU | ETF | 30.65 | 30.8 | 30.425 | 30.8 | 24600.0 |
| 2001-06-12 | FCTR | ETF | 16.62 | 16.76 | 16.55 | 16.75 | 15600.0 |
| 2001-06-12 | FMAR | ETF | 7.005 | 7.005 | 6.995 | 6.995 | 1400.0 |
| 2001-06-12 | GLDB | ETF | 7.05 | 7.25 | 7.05 | 7.14 | 69400.0 |
| 2001-06-12 | GRNB | ETF | 26.5047 | 26.5047 | 26.5047 | 26.5047 | 101.0 |
| 2001-06-12 | GSIG | ETF | 9.08 | 9.36 | 9.08 | 9.25 | 104100.0 |
| 2001-06-12 | IBB | ETF | 32.2667 | 33.5567 | 31.9833 | 33.2333 | 898500.0 |
| 2001-06-12 | ICF | ETF | 20.7325 | 20.785 | 20.7325 | 20.785 | 100400.0 |
| 2001-06-12 | IDU | ETF | 41.0 | 41.0 | 40.63 | 40.85 | 5600.0 |
| 2001-06-12 | IEV | ETF | 32.15 | 32.15 | 31.51 | 32.1 | 33000.0 |
| 2001-06-12 | IGLD | ETF | 76.0 | 77.0 | 74.0 | 74.0 | 12.0 |
| 2001-06-12 | IGM | ETF | 9.8833 | 10.1433 | 9.76 | 10.05 | 723000.0 |
| 2001-06-12 | IJH | ETF | 10.355 | 10.499 | 10.293 | 10.495 | 308000.0 |
| 2001-06-12 | IJJ | ETF | 22.675 | 22.8975 | 22.5375 | 22.81 | 62800.0 |
| 2001-06-12 | IJK | ETF | 14.725 | 14.9488 | 14.565 | 14.9488 | 336800.0 |
| 2001-06-12 | IJR | ETF | 18.7917 | 18.9967 | 18.66 | 18.9467 | 618000.0 |
| 2001-06-12 | IJS | ETF | 20.9125 | 21.225 | 20.8525 | 21.1425 | 133600.0 |
| 2001-06-12 | IJT | ETF | 18.9875 | 19.1025 | 18.83 | 19.09 | 14000.0 |
> showing 50 of 100 rows — these rows as CSV