PREVIEW / etf_daily / 2000-07-11
file: by_date/etf_daily/2000/2000-07-11.parquet size: 7 KB rows: 71
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-07-11 | SPY | ETF | 147.4688 | 149.125 | 147.1562 | 148.1562 | 5431600.0 |
| 2000-07-11 | QQQ | ETF | 94.0625 | 95.75 | 92.8125 | 95.0 | 14374600.0 |
| 2000-07-11 | IWM | ETF | 53.0 | 53.2969 | 52.8438 | 53.0312 | 253200.0 |
| 2000-07-11 | DIA | ETF | 106.4688 | 108.2344 | 106.2812 | 107.25 | 1001400.0 |
| 2000-07-11 | BBH | ETF | 65.4583 | 67.1875 | 65.1042 | 65.5417 | 3057900.0 |
| 2000-07-11 | BITS | ETF | 22.0 | 23.0 | 20.875 | 21.5 | 18175.0 |
| 2000-07-11 | CEF | ETF | 3.375 | 3.375 | 3.375 | 3.375 | 12500.0 |
| 2000-07-11 | CHB | ETF | 5.56 | 5.56 | 5.44 | 5.5 | 9300.0 |
| 2000-07-11 | CNXT | ETF | 47.88 | 49.63 | 47.44 | 48.56 | 3482090.0 |
| 2000-07-11 | EWA | ETF | 10.5625 | 10.6875 | 10.5625 | 10.6875 | 2100.0 |
| 2000-07-11 | EWC | ETF | 20.0 | 20.1875 | 19.875 | 20.125 | 30400.0 |
| 2000-07-11 | EWD | ETF | 31.4375 | 31.5 | 31.1875 | 31.1875 | 1900.0 |
| 2000-07-11 | EWG | ETF | 24.4375 | 24.5 | 24.3125 | 24.5 | 22900.0 |
| 2000-07-11 | EWH | ETF | 13.25 | 13.5 | 13.25 | 13.4375 | 96300.0 |
| 2000-07-11 | EWI | ETF | 53.75 | 54.0 | 53.5 | 53.75 | 3050.0 |
| 2000-07-11 | EWJ | ETF | 60.5 | 61.0 | 60.25 | 60.75 | 40575.0 |
| 2000-07-11 | EWK | ETF | 14.0 | 14.1875 | 13.875 | 14.1875 | 7000.0 |
| 2000-07-11 | EWL | ETF | 16.25 | 16.5625 | 16.25 | 16.5625 | 10900.0 |
| 2000-07-11 | EWM | ETF | 25.25 | 25.5 | 25.0 | 25.25 | 4175.0 |
| 2000-07-11 | EWN | ETF | 24.8125 | 25.0 | 24.75 | 24.9375 | 4700.0 |
| 2000-07-11 | EWO | ETF | 7.9375 | 7.9375 | 7.75 | 7.75 | 1900.0 |
| 2000-07-11 | EWP | ETF | 26.875 | 26.875 | 26.625 | 26.875 | 13100.0 |
| 2000-07-11 | EWQ | ETF | 28.875 | 29.0 | 28.75 | 29.0 | 14300.0 |
| 2000-07-11 | EWS | ETF | 15.375 | 15.5 | 15.25 | 15.375 | 15600.0 |
| 2000-07-11 | EWT | ETF | 37.375 | 37.375 | 36.875 | 36.875 | 350.0 |
| 2000-07-11 | EWU | ETF | 39.375 | 39.625 | 39.125 | 39.625 | 16250.0 |
| 2000-07-11 | EWW | ETF | 18.25 | 18.3125 | 17.9375 | 18.0625 | 24600.0 |
| 2000-07-11 | EWY | ETF | 21.375 | 21.375 | 21.0 | 21.0 | 1700.0 |
| 2000-07-11 | FCTR | ETF | 15.4375 | 15.875 | 15.375 | 15.75 | 17200.0 |
| 2000-07-11 | FMAR | ETF | 5.56 | 5.62 | 5.4967 | 5.5 | 6100.0 |
| 2000-07-11 | GLDB | ETF | 5.0 | 5.0 | 4.4375 | 4.5625 | 490100.0 |
| 2000-07-11 | GSIG | ETF | 37.25 | 37.44 | 31.0 | 33.27 | 1045100.0 |
| 2000-07-11 | IDU | ETF | 34.7812 | 34.7969 | 34.7812 | 34.7969 | 1200.0 |
| 2000-07-11 | IGLD | ETF | 825.0 | 900.0 | 806.25 | 875.0 | 711.0 |
| 2000-07-11 | IJH | ETF | 10.0562 | 10.1781 | 10.0562 | 10.1406 | 1325000.0 |
| 2000-07-11 | IJR | ETF | 18.1094 | 18.1979 | 18.0521 | 18.0833 | 374400.0 |
| 2000-07-11 | IVE | ETF | 60.1562 | 60.7656 | 60.1562 | 60.5625 | 8400.0 |
| 2000-07-11 | IVV | ETF | 147.25 | 149.0 | 147.25 | 148.2812 | 40700.0 |
| 2000-07-11 | IVW | ETF | 22.8008 | 22.8125 | 22.5156 | 22.6328 | 136400.0 |
| 2000-07-11 | IWB | ETF | 78.8281 | 78.8594 | 78.8281 | 78.8594 | 1400.0 |
| 2000-07-11 | IWD | ETF | 55.4844 | 55.9688 | 55.3594 | 55.7344 | 33600.0 |
| 2000-07-11 | IWF | ETF | 21.855475 | 22.09375 | 21.703125 | 21.8164 | 123600.0 |
| 2000-07-11 | IWV | ETF | 80.8125 | 81.1719 | 80.7969 | 81.1719 | 1500.0 |
| 2000-07-11 | IYE | ETF | 16.0417 | 16.5104 | 16.0417 | 16.5104 | 10800.0 |
| 2000-07-11 | IYF | ETF | 37.2812 | 37.5938 | 37.2812 | 37.375 | 7200.0 |
| 2000-07-11 | IYG | ETF | 28.4115 | 28.7656 | 28.3542 | 28.7656 | 8100.0 |
| 2000-07-11 | IYH | ETF | 13.5562 | 13.7375 | 13.5125 | 13.6687 | 128500.0 |
| 2000-07-11 | IYK | ETF | 13.5 | 13.5 | 13.375 | 13.375 | 3000.0 |
| 2000-07-11 | IYM | ETF | 35.6875 | 35.6875 | 35.6875 | 35.6875 | 100.0 |
| 2000-07-11 | IYR | ETF | 36.2344 | 36.2344 | 36.2344 | 36.2344 | 200.0 |
> showing 50 of 71 rows — these rows as CSV