PREVIEW / etf_daily / 2000-01-28
file: by_date/etf_daily/2000/2000-01-28.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-28 | SPY | ETF | 139.4375 | 140.0625 | 135.5312 | 135.875 | 11916200.0 |
| 2000-01-28 | DIA | ETF | 109.8438 | 110.0625 | 107.1406 | 107.4062 | 1253300.0 |
| 2000-01-28 | BBH | ETF | 54.3333 | 55.7917 | 52.3333 | 52.8333 | 805800.0 |
| 2000-01-28 | BITS | ETF | 27.5 | 29.5 | 23.0 | 23.75 | 153675.0 |
| 2000-01-28 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.5 | 17500.0 |
| 2000-01-28 | CHB | ETF | 8.19 | 8.19 | 7.75 | 7.81 | 140300.0 |
| 2000-01-28 | CNXT | ETF | 87.31 | 90.25 | 77.94 | 86.5 | 22878530.0 |
| 2000-01-28 | CSB | ETF | 2.79999995231628 | 2.90000009536743 | 2.79999995231628 | 2.90000009536743 | 77000.0 |
| 2000-01-28 | EWA | ETF | 10.875 | 10.875 | 10.125 | 10.375 | 32900.0 |
| 2000-01-28 | EWC | ETF | 17.0 | 17.0 | 16.5 | 16.75 | 1900.0 |
| 2000-01-28 | EWD | ETF | 29.9375 | 29.9375 | 29.3125 | 29.3125 | 7100.0 |
| 2000-01-28 | EWG | ETF | 26.3125 | 26.3125 | 25.375 | 25.375 | 171600.0 |
| 2000-01-28 | EWH | ETF | 13.3125 | 13.375 | 12.875 | 13.125 | 71700.0 |
| 2000-01-28 | EWI | ETF | 48.0 | 48.25 | 47.125 | 47.125 | 10950.0 |
| 2000-01-28 | EWJ | ETF | 62.25 | 62.25 | 59.75 | 60.0 | 77500.0 |
| 2000-01-28 | EWK | ETF | 13.5625 | 13.8125 | 13.5 | 13.5625 | 2700.0 |
| 2000-01-28 | EWL | ETF | 15.0 | 15.0 | 14.625 | 14.625 | 33600.0 |
| 2000-01-28 | EWM | ETF | 29.5 | 29.5 | 28.0 | 28.0 | 30600.0 |
| 2000-01-28 | EWN | ETF | 22.6875 | 22.9375 | 22.625 | 22.8125 | 18600.0 |
| 2000-01-28 | EWO | ETF | 8.1875 | 8.1875 | 8.0 | 8.0 | 13100.0 |
| 2000-01-28 | EWP | ETF | 26.25 | 26.4375 | 26.0 | 26.25 | 6300.0 |
| 2000-01-28 | EWQ | ETF | 25.8125 | 25.875 | 25.0 | 25.0 | 56300.0 |
| 2000-01-28 | EWS | ETF | 16.625 | 16.625 | 16.375 | 16.5 | 34950.0 |
| 2000-01-28 | EWU | ETF | 40.125 | 40.125 | 38.875 | 38.875 | 52100.0 |
| 2000-01-28 | EWW | ETF | 16.6875 | 16.9375 | 16.5 | 16.5625 | 12900.0 |
| 2000-01-28 | FCTR | ETF | 13.875 | 14.0 | 13.75 | 13.875 | 8300.0 |
| 2000-01-28 | FMAR | ETF | 6.79 | 7.73 | 6.79 | 6.98 | 1200.0 |
| 2000-01-28 | GLDB | ETF | 8.75 | 9.0 | 8.75 | 8.75 | 71600.0 |
| 2000-01-28 | GSIG | ETF | 12.31 | 12.37 | 10.75 | 10.87 | 160200.0 |
| 2000-01-28 | IGLD | ETF | 2025.0 | 2093.75 | 1975.0 | 2050.0 | 937.0 |
| 2000-01-28 | KTEC | ETF | 8.875 | 8.96875 | 8.5 | 8.75 | 11000.0 |
| 2000-01-28 | MDY | ETF | 80.625 | 81.25 | 78.4375 | 78.6875 | 1011400.0 |
| 2000-01-28 | MIG | ETF | 6.0 | 6.0 | 6.0 | 6.0 | 1100.0 |
| 2000-01-28 | SFY | ETF | 10.875 | 11.375 | 10.8125 | 11.1875 | 54200.0 |
| 2000-01-28 | TDSC | ETF | 4.625 | 5.0 | 4.625 | 5.0 | 109400.0 |
| 2000-01-28 | TINY | ETF | 11.5 | 11.88 | 11.06 | 11.25 | 294700.0 |
| 2000-01-28 | XLB | ETF | 11.9219 | 11.9297 | 11.4219 | 11.7344 | 58800.0 |
| 2000-01-28 | XLE | ETF | 13.4688 | 13.4844 | 13.25 | 13.3438 | 66200.0 |
| 2000-01-28 | XLF | ETF | 18.3794 | 18.5825 | 18.0747 | 18.2271 | 170986.0 |
| 2000-01-28 | XLI | ETF | 27.625 | 27.7344 | 27.0 | 27.0 | 17600.0 |
| 2000-01-28 | XLK | ETF | 25.0625 | 25.5625 | 24.0625 | 24.4688 | 4914000.0 |
| 2000-01-28 | XLP | ETF | 22.5469 | 23.0312 | 22.5469 | 22.8125 | 37100.0 |
| 2000-01-28 | XLU | ETF | 13.2656 | 13.3125 | 13.1172 | 13.211 | 56800.0 |
| 2000-01-28 | XLV | ETF | 30.9375 | 31.0312 | 30.25 | 30.25 | 18100.0 |
| 2000-01-28 | XLY | ETF | 13.8281 | 13.8828 | 13.4531 | 13.5 | 24800.0 |
> showing 45 of 45 rows — these rows as CSV