PREVIEW / etf_daily / 2000-01-24
file: by_date/etf_daily/2000/2000-01-24.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-24 | SPY | ETF | 145.6562 | 145.8438 | 139.4062 | 140.3438 | 7896900.0 |
| 2000-01-24 | DIA | ETF | 113.25 | 113.625 | 109.0625 | 110.0 | 2066100.0 |
| 2000-01-24 | BBH | ETF | 61.6667 | 61.9167 | 56.0 | 56.1667 | 2711700.0 |
| 2000-01-24 | BITS | ETF | 22.75 | 23.125 | 21.0 | 22.0 | 53425.0 |
| 2000-01-24 | CEF | ETF | 3.625 | 3.625 | 3.5 | 3.625 | 27000.0 |
| 2000-01-24 | CHB | ETF | 8.13 | 8.31 | 8.13 | 8.13 | 71100.0 |
| 2000-01-24 | CNXT | ETF | 80.19 | 80.75 | 74.44 | 75.0 | 4399170.0 |
| 2000-01-24 | EWA | ETF | 10.75 | 10.875 | 10.625 | 10.625 | 27500.0 |
| 2000-01-24 | EWC | ETF | 16.8125 | 16.875 | 16.6875 | 16.6875 | 16600.0 |
| 2000-01-24 | EWD | ETF | 30.8125 | 30.8125 | 30.3125 | 30.3125 | 4000.0 |
| 2000-01-24 | EWG | ETF | 26.625 | 26.6875 | 26.0 | 26.0625 | 64300.0 |
| 2000-01-24 | EWH | ETF | 12.9375 | 13.0 | 12.375 | 12.375 | 93800.0 |
| 2000-01-24 | EWI | ETF | 50.0 | 50.0 | 48.5 | 48.625 | 9850.0 |
| 2000-01-24 | EWJ | ETF | 60.75 | 61.0 | 59.0 | 59.5 | 154575.0 |
| 2000-01-24 | EWK | ETF | 14.5 | 14.5 | 14.0625 | 14.0625 | 3500.0 |
| 2000-01-24 | EWL | ETF | 15.375 | 15.5 | 15.1875 | 15.3125 | 26100.0 |
| 2000-01-24 | EWM | ETF | 31.75 | 32.0 | 30.0 | 30.5 | 50800.0 |
| 2000-01-24 | EWN | ETF | 24.25 | 24.375 | 24.0 | 24.0 | 14500.0 |
| 2000-01-24 | EWO | ETF | 8.4375 | 8.625 | 8.4375 | 8.5625 | 7100.0 |
| 2000-01-24 | EWP | ETF | 27.125 | 27.125 | 26.5 | 26.5 | 7700.0 |
| 2000-01-24 | EWQ | ETF | 26.375 | 26.5 | 25.8125 | 25.8125 | 29300.0 |
| 2000-01-24 | EWS | ETF | 16.75 | 17.0 | 16.5 | 16.75 | 81850.0 |
| 2000-01-24 | EWU | ETF | 40.625 | 40.875 | 39.875 | 40.0 | 59850.0 |
| 2000-01-24 | EWW | ETF | 17.5 | 17.625 | 16.875 | 16.875 | 21400.0 |
| 2000-01-24 | FCTR | ETF | 14.0 | 14.375 | 13.9531 | 14.125 | 11500.0 |
| 2000-01-24 | FMAR | ETF | 6.73 | 6.98 | 6.48 | 6.48 | 21240.0 |
| 2000-01-24 | GLDB | ETF | 8.6875 | 8.6875 | 8.1875 | 8.1875 | 14000.0 |
| 2000-01-24 | GSIG | ETF | 13.44 | 14.44 | 13.0 | 13.0 | 822900.0 |
| 2000-01-24 | IGLD | ETF | 2200.0 | 2250.0 | 1943.75 | 2012.5 | 1785.0 |
| 2000-01-24 | KTEC | ETF | 10.9375 | 11.0 | 10.125 | 10.25 | 4100.0 |
| 2000-01-24 | MDY | ETF | 84.4375 | 84.4375 | 80.875 | 81.0 | 1189600.0 |
| 2000-01-24 | MIG | ETF | 6.375 | 6.375 | 6.25 | 6.375 | 1000.0 |
| 2000-01-24 | SFY | ETF | 12.5 | 12.625 | 12.25 | 12.25 | 137300.0 |
| 2000-01-24 | TDSC | ETF | 4.19 | 5.19 | 4.095 | 4.94 | 927800.0 |
| 2000-01-24 | TINY | ETF | 11.22 | 11.88 | 10.88 | 11.25 | 291700.0 |
| 2000-01-24 | XLB | ETF | 12.3828 | 12.3828 | 11.9297 | 12.1016 | 381800.0 |
| 2000-01-24 | XLE | ETF | 14.6406 | 14.6875 | 14.0156 | 14.0312 | 593000.0 |
| 2000-01-24 | XLF | ETF | 18.3286 | 18.3286 | 17.6686 | 17.8209 | 346773.0 |
| 2000-01-24 | XLI | ETF | 28.5156 | 28.5469 | 27.5 | 27.5156 | 51600.0 |
| 2000-01-24 | XLK | ETF | 26.9688 | 27.1719 | 25.7969 | 25.9375 | 1137800.0 |
| 2000-01-24 | XLP | ETF | 23.5156 | 23.5156 | 22.2656 | 22.6562 | 278200.0 |
| 2000-01-24 | XLU | ETF | 13.9688 | 13.9688 | 13.75 | 13.75 | 128600.0 |
| 2000-01-24 | XLV | ETF | 32.0312 | 32.1875 | 30.9844 | 30.9844 | 72100.0 |
| 2000-01-24 | XLY | ETF | 14.5469 | 14.5625 | 13.9062 | 13.9062 | 10200.0 |
> showing 44 of 44 rows — these rows as CSV