PREVIEW / etf_daily / 2000-11-17
file: by_date/etf_daily/2000/2000-11-17.parquet size: 8 KB rows: 89
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 |
|---|---|---|---|---|---|---|---|
| 2000-11-17 | SPY | ETF | 137.3125 | 139.0 | 135.75 | 136.6406 | 6551100.0 |
| 2000-11-17 | QQQ | ETF | 73.1875 | 75.1875 | 71.0 | 72.8281 | 49913800.0 |
| 2000-11-17 | IWM | ETF | 48.5 | 48.8984 | 48.0312 | 48.1562 | 215400.0 |
| 2000-11-17 | DIA | ETF | 106.4531 | 108.0625 | 105.5312 | 106.2344 | 1289700.0 |
| 2000-11-17 | BBH | ETF | 55.9583 | 57.3542 | 53.3333 | 54.5833 | 4166400.0 |
| 2000-11-17 | BITS | ETF | 10.5 | 11.0 | 10.0 | 11.0 | 3350.0 |
| 2000-11-17 | BOSS | ETF | 25.9 | 26.5 | 25.9 | 26.5 | 200.0 |
| 2000-11-17 | CEF | ETF | 3.0 | 3.0 | 2.9375 | 2.9375 | 17800.0 |
| 2000-11-17 | CHB | ETF | 3.5 | 3.5 | 3.19 | 3.38 | 35000.0 |
| 2000-11-17 | CNXT | ETF | 28.44 | 30.25 | 27.94 | 29.31 | 3444120.0 |
| 2000-11-17 | DGT | ETF | 81.3438 | 81.3438 | 81.3438 | 81.3438 | 100.0 |
| 2000-11-17 | EWA | ETF | 9.0625 | 9.25 | 9.0 | 9.25 | 10000.0 |
| 2000-11-17 | EWC | ETF | 13.5 | 13.5 | 13.25 | 13.4375 | 13000.0 |
| 2000-11-17 | EWD | ETF | 18.375 | 18.4375 | 18.125 | 18.125 | 6200.0 |
| 2000-11-17 | EWG | ETF | 18.8125 | 18.9375 | 18.5 | 18.5625 | 36800.0 |
| 2000-11-17 | EWH | ETF | 11.125 | 11.3125 | 11.125 | 11.1875 | 25800.0 |
| 2000-11-17 | EWI | ETF | 44.25 | 44.25 | 44.0 | 44.0 | 2350.0 |
| 2000-11-17 | EWJ | ETF | 49.0 | 49.5 | 48.75 | 49.0 | 80025.0 |
| 2000-11-17 | EWK | ETF | 12.25 | 12.25 | 12.25 | 12.25 | 300.0 |
| 2000-11-17 | EWL | ETF | 15.25 | 15.3125 | 15.0 | 15.125 | 115200.0 |
| 2000-11-17 | EWM | ETF | 21.75 | 22.0 | 21.75 | 21.75 | 43275.0 |
| 2000-11-17 | EWN | ETF | 22.3125 | 22.5 | 22.1875 | 22.1875 | 3400.0 |
| 2000-11-17 | EWP | ETF | 22.4375 | 22.625 | 22.0 | 22.0 | 3600.0 |
| 2000-11-17 | EWQ | ETF | 23.6875 | 23.6875 | 23.25 | 23.375 | 25200.0 |
| 2000-11-17 | EWS | ETF | 13.125 | 13.25 | 13.0 | 13.25 | 14050.0 |
| 2000-11-17 | EWT | ETF | 23.875 | 23.875 | 23.875 | 23.875 | 1950.0 |
| 2000-11-17 | EWU | ETF | 35.25 | 35.75 | 35.125 | 35.25 | 16550.0 |
| 2000-11-17 | EWW | ETF | 15.125 | 15.3125 | 15.0 | 15.3125 | 9000.0 |
| 2000-11-17 | EWY | ETF | 14.5 | 14.75 | 14.5 | 14.75 | 3200.0 |
| 2000-11-17 | EWZ | ETF | 15.25 | 15.4375 | 15.25 | 15.375 | 2800.0 |
| 2000-11-17 | EZU | ETF | 35.3438 | 35.3438 | 34.9688 | 35.0 | 7200.0 |
| 2000-11-17 | FCTR | ETF | 15.1875 | 15.1875 | 14.625 | 14.6875 | 15400.0 |
| 2000-11-17 | FMAR | ETF | 4.38 | 4.88 | 4.31 | 4.31 | 4800.0 |
| 2000-11-17 | GLDB | ETF | 4.5 | 4.5313 | 4.4375 | 4.5313 | 66200.0 |
| 2000-11-17 | GSIG | ETF | 10.61 | 10.81 | 10.37 | 10.75 | 699000.0 |
| 2000-11-17 | IDU | ETF | 42.0781 | 42.3281 | 41.8594 | 42.3281 | 17600.0 |
| 2000-11-17 | IEV | ETF | 37.4375 | 37.4688 | 37.125 | 37.3125 | 30800.0 |
| 2000-11-17 | IGLD | ETF | 275.0 | 278.125 | 275.0 | 275.0 | 50.0 |
| 2000-11-17 | IJH | ETF | 10.1344 | 10.2563 | 10.0859 | 10.1063 | 202000.0 |
| 2000-11-17 | IJJ | ETF | 19.6641 | 19.6641 | 19.4766 | 19.5117 | 4800.0 |
| 2000-11-17 | IJK | ETF | 16.4062 | 16.5117 | 16.125 | 16.2461 | 5600.0 |
| 2000-11-17 | IJR | ETF | 17.7917 | 17.8698 | 17.6615 | 17.7552 | 207600.0 |
| 2000-11-17 | IJS | ETF | 18.0 | 18.1016 | 17.957 | 17.961 | 6400.0 |
| 2000-11-17 | IJT | ETF | 20.1328 | 20.3789 | 20.1328 | 20.1367 | 6000.0 |
| 2000-11-17 | IUSG | ETF | 29.0547 | 29.0547 | 28.9062 | 28.9062 | 800.0 |
| 2000-11-17 | IUSV | ETF | 24.6667 | 24.6667 | 24.3333 | 24.3333 | 125700.0 |
| 2000-11-17 | IVE | ETF | 62.4375 | 62.625 | 61.8125 | 61.9531 | 490200.0 |
| 2000-11-17 | IVV | ETF | 137.5625 | 138.8906 | 136.25 | 136.7188 | 218300.0 |
| 2000-11-17 | IVW | ETF | 19.0312 | 19.3594 | 18.9062 | 19.086 | 109200.0 |
| 2000-11-17 | IWB | ETF | 73.28 | 73.84 | 72.42 | 72.42 | 36800.0 |
> showing 50 of 89 rows — these rows as CSV