PREVIEW / etf_daily / 2001-06-14
file: by_date/etf_daily/2001/2001-06-14.parquet size: 8 KB rows: 99
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-14 | SPY | ETF | 124.18 | 124.3 | 121.75 | 122.0 | 12603000.0 |
| 2001-06-14 | QQQ | ETF | 44.025 | 44.4 | 42.0 | 42.25 | 91050300.0 |
| 2001-06-14 | IWM | ETF | 49.875 | 50.025 | 49.075 | 49.075 | 865200.0 |
| 2001-06-14 | DIA | ETF | 108.35 | 108.35 | 106.53 | 106.6 | 3475600.0 |
| 2001-06-14 | BBH | ETF | 43.8667 | 44.3 | 43.2 | 43.4167 | 2874600.0 |
| 2001-06-14 | BITS | ETF | 10.92 | 13.88 | 9.72 | 12.92 | 68900.0 |
| 2001-06-14 | BOSS | ETF | 32.6 | 32.75 | 32.5 | 32.5 | 300.0 |
| 2001-06-14 | CEF | ETF | 3.31 | 3.32 | 3.28 | 3.29 | 12800.0 |
| 2001-06-14 | CHB | ETF | 9.4 | 9.54 | 9.35 | 9.45 | 244400.0 |
| 2001-06-14 | CNXT | ETF | 8.48 | 8.6 | 8.18 | 8.19 | 2476100.0 |
| 2001-06-14 | CSB | ETF | 2.09999990463257 | 2.09999990463257 | 2.09999990463257 | 2.09999990463257 | 200.0 |
| 2001-06-14 | DGT | ETF | 71.3 | 71.3 | 70.85 | 70.85 | 800.0 |
| 2001-06-14 | EWA | ETF | 9.86 | 9.95 | 9.86 | 9.95 | 4200.0 |
| 2001-06-14 | EWC | ETF | 11.7 | 11.95 | 11.7 | 11.81 | 4100.0 |
| 2001-06-14 | EWD | ETF | 13.2 | 13.2 | 13.2 | 13.2 | 300.0 |
| 2001-06-14 | EWG | ETF | 16.69 | 16.79 | 16.55 | 16.77 | 22300.0 |
| 2001-06-14 | EWH | ETF | 10.4 | 10.43 | 10.07 | 10.08 | 19100.0 |
| 2001-06-14 | EWI | ETF | 36.8 | 36.9 | 36.4 | 36.9 | 14550.0 |
| 2001-06-14 | EWJ | ETF | 41.12 | 41.12 | 40.88 | 40.96 | 54875.0 |
| 2001-06-14 | EWK | ETF | 10.95 | 10.95 | 10.95 | 10.95 | 200.0 |
| 2001-06-14 | EWL | ETF | 13.66 | 13.66 | 13.6 | 13.6 | 1600.0 |
| 2001-06-14 | EWM | ETF | 16.96 | 17.2 | 16.96 | 17.0 | 27450.0 |
| 2001-06-14 | EWN | ETF | 19.6 | 19.6 | 19.45 | 19.45 | 1000.0 |
| 2001-06-14 | EWP | ETF | 22.5 | 22.94 | 22.5 | 22.9 | 900.0 |
| 2001-06-14 | EWQ | ETF | 20.3 | 20.68 | 20.3 | 20.5 | 109000.0 |
| 2001-06-14 | EWS | ETF | 10.64 | 10.76 | 10.64 | 10.64 | 5000.0 |
| 2001-06-14 | EWT | ETF | 21.26 | 21.26 | 20.46 | 20.46 | 2250.0 |
| 2001-06-14 | EWU | ETF | 31.8 | 31.88 | 31.46 | 31.74 | 39600.0 |
| 2001-06-14 | EWW | ETF | 16.85 | 16.9 | 16.5 | 16.6 | 32900.0 |
| 2001-06-14 | EWY | ETF | 14.8 | 14.8 | 14.45 | 14.45 | 1500.0 |
| 2001-06-14 | EWZ | ETF | 14.68 | 14.68 | 14.54 | 14.58 | 1200.0 |
| 2001-06-14 | EZU | ETF | 30.6 | 30.99 | 30.6 | 30.95 | 4600.0 |
| 2001-06-14 | FCTR | ETF | 16.62 | 16.68 | 16.42 | 16.42 | 22100.0 |
| 2001-06-14 | FMAR | ETF | 7.0 | 7.0 | 6.66 | 6.66 | 2000.0 |
| 2001-06-14 | GLDB | ETF | 7.1 | 7.1 | 7.0 | 7.05 | 51200.0 |
| 2001-06-14 | GSIG | ETF | 9.11 | 9.35 | 9.11 | 9.24 | 126000.0 |
| 2001-06-14 | IBB | ETF | 32.7833 | 33.15 | 32.4667 | 32.5 | 78300.0 |
| 2001-06-14 | ICF | ETF | 20.7875 | 20.8375 | 20.7875 | 20.8375 | 2000.0 |
| 2001-06-14 | IDU | ETF | 39.6 | 39.6 | 38.85 | 38.85 | 8800.0 |
| 2001-06-14 | IEV | ETF | 31.55 | 32.29 | 31.55 | 31.95 | 49600.0 |
| 2001-06-14 | IGLD | ETF | 74.0 | 75.0 | 73.0 | 73.0 | 79.0 |
| 2001-06-14 | IGM | ETF | 9.5833 | 9.6233 | 9.32 | 9.3317 | 622200.0 |
| 2001-06-14 | IJH | ETF | 10.3 | 10.3 | 10.155 | 10.155 | 445000.0 |
| 2001-06-14 | IJJ | ETF | 22.6225 | 22.6225 | 22.285 | 22.305 | 101600.0 |
| 2001-06-14 | IJK | ETF | 14.4875 | 14.575 | 14.3712 | 14.3712 | 538400.0 |
| 2001-06-14 | IJR | ETF | 18.7333 | 18.7333 | 18.435 | 18.4533 | 251400.0 |
| 2001-06-14 | IJS | ETF | 21.04 | 21.04 | 20.6625 | 20.76 | 84400.0 |
| 2001-06-14 | IJT | ETF | 18.6875 | 18.6875 | 18.5175 | 18.5175 | 12000.0 |
| 2001-06-14 | IOO | ETF | 31.87 | 31.915 | 31.745 | 31.745 | 181200.0 |
| 2001-06-14 | IUSG | ETF | 22.285 | 22.455 | 21.95 | 21.95 | 326000.0 |
> showing 50 of 99 rows — these rows as CSV