PREVIEW / etf_daily / 2001-06-15
file: by_date/etf_daily/2001/2001-06-15.parquet size: 9 KB rows: 101
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-15 | SPY | ETF | 120.91 | 122.4 | 120.4 | 121.85 | 16821100.0 |
| 2001-06-15 | QQQ | ETF | 41.8 | 43.1 | 41.281 | 42.6 | 84589400.0 |
| 2001-06-15 | IWM | ETF | 49.0 | 49.575 | 48.925 | 49.375 | 817800.0 |
| 2001-06-15 | DIA | ETF | 106.4 | 107.29 | 105.65 | 106.7 | 4091800.0 |
| 2001-06-15 | BBH | ETF | 42.9 | 44.25 | 42.6667 | 44.1633 | 5199300.0 |
| 2001-06-15 | BITS | ETF | 13.48 | 14.8 | 12.64 | 14.2 | 47925.0 |
| 2001-06-15 | BOSS | ETF | 32.3 | 32.3 | 31.56 | 31.56 | 1000.0 |
| 2001-06-15 | CEF | ETF | 3.27 | 3.32 | 3.27 | 3.27 | 6900.0 |
| 2001-06-15 | CHB | ETF | 9.3 | 9.49 | 9.26 | 9.49 | 97500.0 |
| 2001-06-15 | CNXT | ETF | 8.24 | 8.74 | 7.89 | 8.5 | 3457470.0 |
| 2001-06-15 | CSB | ETF | 2.09999990463257 | 2.09999990463257 | 2.09999990463257 | 2.09999990463257 | 157400.0 |
| 2001-06-15 | DGT | ETF | 70.05 | 70.5 | 70.03 | 70.33 | 600.0 |
| 2001-06-15 | EWA | ETF | 10.05 | 10.05 | 9.85 | 9.95 | 13800.0 |
| 2001-06-15 | EWC | ETF | 11.65 | 11.65 | 11.43 | 11.62 | 8400.0 |
| 2001-06-15 | EWD | ETF | 13.6 | 13.6 | 13.6 | 13.6 | 300.0 |
| 2001-06-15 | EWG | ETF | 16.47 | 16.7 | 16.35 | 16.63 | 28000.0 |
| 2001-06-15 | EWH | ETF | 10.01 | 10.21 | 10.01 | 10.17 | 19100.0 |
| 2001-06-15 | EWI | ETF | 37.0 | 37.0 | 36.8 | 36.8 | 500.0 |
| 2001-06-15 | EWJ | ETF | 40.84 | 41.08 | 40.2 | 40.44 | 77450.0 |
| 2001-06-15 | EWK | ETF | 10.95 | 10.95 | 10.95 | 10.95 | 800.0 |
| 2001-06-15 | EWL | ETF | 13.95 | 13.95 | 13.8 | 13.92 | 16000.0 |
| 2001-06-15 | EWM | ETF | 16.4 | 16.72 | 16.4 | 16.64 | 55225.0 |
| 2001-06-15 | EWN | ETF | 19.53 | 19.68 | 19.36 | 19.55 | 1500.0 |
| 2001-06-15 | EWO | ETF | 8.1 | 8.1 | 8.1 | 8.1 | 1700.0 |
| 2001-06-15 | EWP | ETF | 22.85 | 22.86 | 22.65 | 22.86 | 600.0 |
| 2001-06-15 | EWQ | ETF | 20.5 | 20.55 | 20.35 | 20.53 | 22300.0 |
| 2001-06-15 | EWS | ETF | 10.8 | 11.0 | 10.72 | 10.84 | 16750.0 |
| 2001-06-15 | EWT | ETF | 21.0 | 21.16 | 21.0 | 21.16 | 1650.0 |
| 2001-06-15 | EWU | ETF | 31.62 | 32.1 | 31.26 | 31.8 | 24700.0 |
| 2001-06-15 | EWW | ETF | 16.89 | 16.89 | 16.4 | 16.69 | 20800.0 |
| 2001-06-15 | EWY | ETF | 14.7 | 14.85 | 14.7 | 14.82 | 4400.0 |
| 2001-06-15 | EWZ | ETF | 14.6 | 14.6 | 14.6 | 14.6 | 1500.0 |
| 2001-06-15 | EZU | ETF | 30.125 | 30.54 | 30.125 | 30.54 | 16800.0 |
| 2001-06-15 | FCTR | ETF | 16.3 | 16.67 | 16.26 | 16.65 | 81300.0 |
| 2001-06-15 | FMAR | ETF | 6.83 | 7.0 | 6.66 | 6.66 | 2500.0 |
| 2001-06-15 | GLDB | ETF | 7.05 | 7.13 | 7.04 | 7.09 | 87700.0 |
| 2001-06-15 | GSIG | ETF | 9.06 | 9.17 | 9.05 | 9.13 | 60000.0 |
| 2001-06-15 | IBB | ETF | 32.0833 | 33.13 | 31.9667 | 33.13 | 838200.0 |
| 2001-06-15 | ICF | ETF | 20.805 | 20.805 | 20.805 | 20.805 | 800.0 |
| 2001-06-15 | IDU | ETF | 38.85 | 39.96 | 38.85 | 39.59 | 11400.0 |
| 2001-06-15 | IEV | ETF | 32.25 | 32.25 | 31.3 | 31.74 | 89800.0 |
| 2001-06-15 | IGLD | ETF | 75.0 | 77.0 | 73.0 | 75.0 | 119.0 |
| 2001-06-15 | IGM | ETF | 9.1767 | 9.2133 | 9.1417 | 9.2133 | 4200.0 |
| 2001-06-15 | IJH | ETF | 10.11 | 10.223 | 10.075 | 10.16 | 425000.0 |
| 2001-06-15 | IJJ | ETF | 22.2125 | 22.325 | 22.08 | 22.24 | 77600.0 |
| 2001-06-15 | IJK | ETF | 14.3162 | 14.53 | 14.2525 | 14.4662 | 51200.0 |
| 2001-06-15 | IJR | ETF | 18.3333 | 18.4967 | 18.2667 | 18.3583 | 672600.0 |
| 2001-06-15 | IJS | ETF | 20.5875 | 20.695 | 20.53 | 20.6375 | 24400.0 |
| 2001-06-15 | IJT | ETF | 18.425 | 18.545 | 18.2875 | 18.435 | 24000.0 |
| 2001-06-15 | IOO | ETF | 31.605 | 31.755 | 31.45 | 31.705 | 11400.0 |
> showing 50 of 101 rows — these rows as CSV