PREVIEW / etf_daily / 2000-01-26
file: by_date/etf_daily/2000/2000-01-26.parquet size: 6 KB rows: 44
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-26 | SPY | ETF | 141.0 | 141.5469 | 140.0938 | 140.8125 | 5158100.0 |
| 2000-01-26 | DIA | ETF | 110.2188 | 111.375 | 110.125 | 110.4688 | 1001400.0 |
| 2000-01-26 | BBH | ETF | 56.9792 | 57.5 | 56.0833 | 56.5 | 1008000.0 |
| 2000-01-26 | BITS | ETF | 20.75 | 22.0 | 20.5 | 21.5 | 24725.0 |
| 2000-01-26 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.5 | 32000.0 |
| 2000-01-26 | CHB | ETF | 8.13 | 8.25 | 8.13 | 8.19 | 89200.0 |
| 2000-01-26 | CNXT | ETF | 73.81 | 77.25 | 73.62 | 74.31 | 2522610.0 |
| 2000-01-26 | EWA | ETF | 10.625 | 10.8125 | 10.625 | 10.75 | 6100.0 |
| 2000-01-26 | EWC | ETF | 16.625 | 17.0625 | 16.625 | 17.0625 | 4600.0 |
| 2000-01-26 | EWD | ETF | 30.75 | 30.75 | 30.375 | 30.625 | 3100.0 |
| 2000-01-26 | EWG | ETF | 25.9375 | 26.125 | 25.875 | 26.125 | 30100.0 |
| 2000-01-26 | EWH | ETF | 12.9375 | 13.125 | 12.9375 | 13.125 | 57000.0 |
| 2000-01-26 | EWI | ETF | 48.25 | 48.375 | 47.875 | 48.375 | 20150.0 |
| 2000-01-26 | EWJ | ETF | 60.75 | 61.25 | 60.5 | 61.0 | 79825.0 |
| 2000-01-26 | EWK | ETF | 14.0625 | 14.125 | 13.875 | 14.125 | 9400.0 |
| 2000-01-26 | EWL | ETF | 14.9375 | 15.125 | 14.875 | 15.0625 | 11500.0 |
| 2000-01-26 | EWM | ETF | 29.0 | 30.0 | 29.0 | 29.5 | 38875.0 |
| 2000-01-26 | EWN | ETF | 23.875 | 23.875 | 23.8125 | 23.8125 | 15600.0 |
| 2000-01-26 | EWO | ETF | 8.3125 | 8.375 | 8.3125 | 8.375 | 10900.0 |
| 2000-01-26 | EWP | ETF | 26.5625 | 27.0 | 26.5625 | 26.75 | 9600.0 |
| 2000-01-26 | EWQ | ETF | 26.1875 | 26.4375 | 26.125 | 26.25 | 12800.0 |
| 2000-01-26 | EWS | ETF | 16.75 | 16.875 | 16.625 | 16.625 | 39500.0 |
| 2000-01-26 | EWU | ETF | 39.625 | 40.125 | 39.625 | 39.875 | 48450.0 |
| 2000-01-26 | EWW | ETF | 17.125 | 17.125 | 16.875 | 17.125 | 10200.0 |
| 2000-01-26 | FCTR | ETF | 14.125 | 14.375 | 13.8125 | 14.375 | 21300.0 |
| 2000-01-26 | FMAR | ETF | 7.48 | 7.48 | 6.73 | 6.73 | 2310.0 |
| 2000-01-26 | GLDB | ETF | 8.75 | 9.1875 | 8.75 | 9.125 | 54200.0 |
| 2000-01-26 | GSIG | ETF | 13.12 | 13.19 | 12.5 | 12.62 | 117300.0 |
| 2000-01-26 | IGLD | ETF | 1987.5 | 2025.0 | 1937.5 | 2012.5 | 607.0 |
| 2000-01-26 | KTEC | ETF | 9.90625 | 10.0 | 9.75 | 9.75 | 4300.0 |
| 2000-01-26 | MDY | ETF | 81.5625 | 82.375 | 80.875 | 80.875 | 1013400.0 |
| 2000-01-26 | MIG | ETF | 6.0625 | 6.25 | 6.0 | 6.0625 | 5100.0 |
| 2000-01-26 | SFY | ETF | 12.4375 | 12.4375 | 11.4375 | 11.625 | 72500.0 |
| 2000-01-26 | TDSC | ETF | 5.06 | 5.095 | 4.94 | 5.095 | 148800.0 |
| 2000-01-26 | TINY | ETF | 10.94 | 12.0 | 10.88 | 11.88 | 222000.0 |
| 2000-01-26 | XLB | ETF | 11.9844 | 12.1953 | 11.875 | 11.875 | 601400.0 |
| 2000-01-26 | XLE | ETF | 13.9062 | 14.1406 | 13.7812 | 13.7812 | 93800.0 |
| 2000-01-26 | XLF | ETF | 18.1509 | 18.7094 | 18.1255 | 18.684 | 630518.0 |
| 2000-01-26 | XLI | ETF | 27.2656 | 27.75 | 26.2656 | 27.5781 | 93400.0 |
| 2000-01-26 | XLK | ETF | 26.3438 | 26.375 | 25.4688 | 25.625 | 1678600.0 |
| 2000-01-26 | XLP | ETF | 22.5156 | 22.7812 | 22.4219 | 22.5781 | 385500.0 |
| 2000-01-26 | XLU | ETF | 13.3984 | 13.4766 | 13.3281 | 13.3672 | 62800.0 |
| 2000-01-26 | XLV | ETF | 31.1875 | 31.2969 | 31.0 | 31.0625 | 10500.0 |
| 2000-01-26 | XLY | ETF | 13.8594 | 14.1016 | 13.8594 | 14.0938 | 76200.0 |
> showing 44 of 44 rows — these rows as CSV