PREVIEW / etf_daily / 2000-01-31
file: by_date/etf_daily/2000/2000-01-31.parquet size: 6 KB rows: 45
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-01-31 | SPY | ETF | 135.8125 | 139.6719 | 135.0 | 139.5625 | 10768700.0 |
| 2000-01-31 | DIA | ETF | 107.1406 | 109.625 | 107.0 | 109.5 | 996600.0 |
| 2000-01-31 | BBH | ETF | 52.6667 | 53.5833 | 50.3333 | 53.5833 | 1815300.0 |
| 2000-01-31 | BITS | ETF | 24.125 | 27.0 | 23.75 | 26.0 | 46375.0 |
| 2000-01-31 | CEF | ETF | 3.4375 | 3.5 | 3.375 | 3.4375 | 146500.0 |
| 2000-01-31 | CHB | ETF | 7.88 | 8.0 | 7.56 | 7.69 | 301800.0 |
| 2000-01-31 | CNXT | ETF | 83.94 | 84.5 | 79.75 | 84.5 | 9343890.0 |
| 2000-01-31 | EWA | ETF | 10.625 | 10.625 | 10.375 | 10.625 | 14000.0 |
| 2000-01-31 | EWC | ETF | 16.5625 | 16.6875 | 16.5 | 16.6875 | 2500.0 |
| 2000-01-31 | EWD | ETF | 28.8125 | 29.0625 | 28.5625 | 28.5625 | 7000.0 |
| 2000-01-31 | EWG | ETF | 25.1875 | 25.25 | 24.9375 | 25.1875 | 45700.0 |
| 2000-01-31 | EWH | ETF | 12.8125 | 13.0 | 12.625 | 13.0 | 55000.0 |
| 2000-01-31 | EWI | ETF | 47.125 | 47.375 | 46.75 | 46.75 | 12150.0 |
| 2000-01-31 | EWJ | ETF | 61.0 | 61.5 | 60.75 | 61.5 | 111500.0 |
| 2000-01-31 | EWK | ETF | 13.375 | 13.375 | 13.0625 | 13.0625 | 5800.0 |
| 2000-01-31 | EWL | ETF | 14.5625 | 14.6875 | 14.25 | 14.25 | 5500.0 |
| 2000-01-31 | EWM | ETF | 27.5 | 28.5 | 27.5 | 28.5 | 33275.0 |
| 2000-01-31 | EWN | ETF | 22.375 | 22.375 | 21.875 | 21.9375 | 19800.0 |
| 2000-01-31 | EWO | ETF | 8.125 | 8.125 | 8.125 | 8.125 | 1100.0 |
| 2000-01-31 | EWP | ETF | 25.9375 | 25.9375 | 25.9375 | 25.9375 | 900.0 |
| 2000-01-31 | EWQ | ETF | 25.375 | 25.6875 | 24.9375 | 25.3125 | 37400.0 |
| 2000-01-31 | EWS | ETF | 16.375 | 16.375 | 15.5 | 16.125 | 99450.0 |
| 2000-01-31 | EWU | ETF | 38.875 | 39.125 | 38.125 | 39.0 | 155450.0 |
| 2000-01-31 | EWW | ETF | 16.375 | 16.375 | 15.8125 | 16.25 | 12400.0 |
| 2000-01-31 | FCTR | ETF | 14.0 | 14.0 | 13.625 | 13.8125 | 22600.0 |
| 2000-01-31 | FMAR | ETF | 6.79 | 7.35 | 6.7896 | 6.98 | 9010.0 |
| 2000-01-31 | GLDB | ETF | 9.0 | 9.0 | 8.5 | 8.875 | 85600.0 |
| 2000-01-31 | GRNB | ETF | 26.3084 | 26.3084 | 26.3084 | 26.3084 | 3028.0 |
| 2000-01-31 | GSIG | ETF | 10.53 | 11.69 | 10.5 | 11.44 | 148800.0 |
| 2000-01-31 | IGLD | ETF | 2043.75 | 2056.25 | 1900.0 | 1950.0 | 618.0 |
| 2000-01-31 | KTEC | ETF | 8.875 | 9.0625 | 8.75 | 8.875 | 20300.0 |
| 2000-01-31 | MDY | ETF | 79.1875 | 79.5312 | 77.4062 | 79.3125 | 706800.0 |
| 2000-01-31 | MIG | ETF | 6.0 | 6.0625 | 6.0 | 6.0625 | 3900.0 |
| 2000-01-31 | SFY | ETF | 11.125 | 11.3125 | 11.0 | 11.0625 | 170100.0 |
| 2000-01-31 | TDSC | ETF | 4.56 | 5.22 | 4.545 | 5.22 | 208000.0 |
| 2000-01-31 | TINY | ETF | 11.75 | 11.88 | 11.0 | 11.75 | 211500.0 |
| 2000-01-31 | XLB | ETF | 11.625 | 11.6875 | 11.5547 | 11.664 | 32600.0 |
| 2000-01-31 | XLE | ETF | 13.0938 | 13.6562 | 13.0625 | 13.6562 | 203200.0 |
| 2000-01-31 | XLF | ETF | 18.024 | 18.7348 | 18.024 | 18.7348 | 541763.0 |
| 2000-01-31 | XLI | ETF | 26.8594 | 27.2969 | 26.8594 | 27.1875 | 45700.0 |
| 2000-01-31 | XLK | ETF | 24.4688 | 25.2812 | 23.9375 | 25.2812 | 2624600.0 |
| 2000-01-31 | XLP | ETF | 22.4688 | 23.2344 | 22.25 | 23.2344 | 195800.0 |
| 2000-01-31 | XLU | ETF | 13.1328 | 13.8203 | 13.1172 | 13.8203 | 829600.0 |
| 2000-01-31 | XLV | ETF | 30.375 | 30.375 | 29.8594 | 30.1094 | 27500.0 |
| 2000-01-31 | XLY | ETF | 13.4375 | 13.6016 | 13.4375 | 13.6016 | 21600.0 |
> showing 45 of 45 rows — these rows as CSV