PREVIEW / etf_daily / 2001-08-02
file: by_date/etf_daily/2001/2001-08-02.parquet size: 9 KB rows: 102
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-08-02 | SPY | ETF | 123.23 | 123.25 | 121.89 | 122.61 | 11070100.0 |
| 2001-08-02 | QQQ | ETF | 43.799 | 44.004 | 42.82 | 43.91 | 53187300.0 |
| 2001-08-02 | IWM | ETF | 49.225 | 49.25 | 48.45 | 48.7 | 553000.0 |
| 2001-08-02 | DIA | ETF | 106.25 | 106.25 | 105.23 | 105.6 | 1675000.0 |
| 2001-08-02 | BBH | ETF | 40.3367 | 40.6167 | 39.2367 | 39.7 | 2759100.0 |
| 2001-08-02 | BITS | ETF | 14.8 | 16.08 | 14.8 | 15.72 | 4000.0 |
| 2001-08-02 | BOSS | ETF | 26.0 | 26.0 | 26.0 | 26.0 | 100.0 |
| 2001-08-02 | CEF | ETF | 3.06 | 3.1 | 3.06 | 3.09 | 10300.0 |
| 2001-08-02 | CHB | ETF | 11.3 | 11.53 | 11.2 | 11.24 | 184000.0 |
| 2001-08-02 | CNXT | ETF | 10.65 | 10.9 | 9.86 | 10.03 | 4369500.0 |
| 2001-08-02 | CSB | ETF | 2.45000004768372 | 2.45000004768372 | 2.45000004768372 | 2.45000004768372 | 4000.0 |
| 2001-08-02 | EWA | ETF | 9.68 | 9.74 | 9.61 | 9.61 | 8200.0 |
| 2001-08-02 | EWC | ETF | 11.5 | 11.59 | 11.45 | 11.45 | 10900.0 |
| 2001-08-02 | EWD | ETF | 14.2 | 14.2 | 14.09 | 14.13 | 2400.0 |
| 2001-08-02 | EWG | ETF | 16.83 | 16.83 | 16.48 | 16.64 | 33800.0 |
| 2001-08-02 | EWH | ETF | 9.84 | 9.87 | 9.68 | 9.86 | 88300.0 |
| 2001-08-02 | EWI | ETF | 37.12 | 37.12 | 36.6 | 36.7 | 750.0 |
| 2001-08-02 | EWJ | ETF | 39.16 | 39.24 | 38.92 | 39.16 | 70350.0 |
| 2001-08-02 | EWL | ETF | 13.65 | 13.67 | 13.35 | 13.35 | 58000.0 |
| 2001-08-02 | EWM | ETF | 19.4 | 19.64 | 19.2 | 19.64 | 16025.0 |
| 2001-08-02 | EWN | ETF | 19.47 | 19.47 | 19.15 | 19.15 | 1200.0 |
| 2001-08-02 | EWO | ETF | 8.3 | 8.3 | 8.25 | 8.25 | 11800.0 |
| 2001-08-02 | EWP | ETF | 21.75 | 21.75 | 21.49 | 21.7 | 18600.0 |
| 2001-08-02 | EWQ | ETF | 20.54 | 20.54 | 20.21 | 20.23 | 6100.0 |
| 2001-08-02 | EWS | ETF | 10.66 | 10.74 | 10.5 | 10.58 | 15150.0 |
| 2001-08-02 | EWT | ETF | 18.22 | 18.68 | 18.22 | 18.66 | 93200.0 |
| 2001-08-02 | EWU | ETF | 32.0 | 32.0 | 31.4 | 31.78 | 10250.0 |
| 2001-08-02 | EWW | ETF | 15.95 | 16.24 | 15.95 | 16.1 | 2800.0 |
| 2001-08-02 | EWY | ETF | 14.0 | 14.03 | 13.86 | 14.03 | 732700.0 |
| 2001-08-02 | EWZ | ETF | 12.5 | 12.8 | 12.5 | 12.8 | 22000.0 |
| 2001-08-02 | EZU | ETF | 30.34 | 30.645 | 30.34 | 30.37 | 23000.0 |
| 2001-08-02 | FCTR | ETF | 17.7031 | 18.28 | 17.7 | 18.01 | 26800.0 |
| 2001-08-02 | FMAR | ETF | 9.2 | 10.23 | 9.2 | 10.15 | 15300.0 |
| 2001-08-02 | GLDB | ETF | 8.0 | 8.05 | 7.78 | 7.86 | 101400.0 |
| 2001-08-02 | GRNB | ETF | 24.5414 | 24.5414 | 24.5414 | 24.5414 | 101.0 |
| 2001-08-02 | GSIG | ETF | 8.5 | 8.7 | 8.3 | 8.53 | 164100.0 |
| 2001-08-02 | IBB | ETF | 29.25 | 29.35 | 28.5333 | 28.8 | 320400.0 |
| 2001-08-02 | ICF | ETF | 20.975 | 21.0975 | 20.975 | 21.0975 | 16400.0 |
| 2001-08-02 | IDU | ETF | 37.875 | 38.12 | 37.845 | 38.12 | 3600.0 |
| 2001-08-02 | IEV | ETF | 31.52 | 31.675 | 31.425 | 31.675 | 21600.0 |
| 2001-08-02 | IGLD | ETF | 65.0 | 72.0 | 65.0 | 72.0 | 6.0 |
| 2001-08-02 | IGM | ETF | 9.5167 | 9.5167 | 9.4083 | 9.4333 | 116400.0 |
| 2001-08-02 | IGV | ETF | 10.07 | 10.078 | 9.94 | 9.94 | 257000.0 |
| 2001-08-02 | IJH | ETF | 10.337 | 10.337 | 10.203 | 10.259 | 258000.0 |
| 2001-08-02 | IJJ | ETF | 23.125 | 23.125 | 22.9125 | 23.0 | 48000.0 |
| 2001-08-02 | IJK | ETF | 14.3412 | 14.3412 | 14.0688 | 14.0925 | 236800.0 |
| 2001-08-02 | IJR | ETF | 19.0917 | 19.0917 | 18.86 | 18.9817 | 434400.0 |
| 2001-08-02 | IJS | ETF | 21.4 | 21.4025 | 21.2375 | 21.33 | 145200.0 |
| 2001-08-02 | IJT | ETF | 19.125 | 19.125 | 18.87 | 18.9425 | 82800.0 |
| 2001-08-02 | IOO | ETF | 31.055 | 31.095 | 30.875 | 30.95 | 22400.0 |
> showing 50 of 102 rows — these rows as CSV