PREVIEW / etf_daily / 2000-03-21
file: by_date/etf_daily/2000/2000-03-21.parquet size: 6 KB rows: 46
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-03-21 | SPY | ETF | 145.5312 | 149.75 | 144.5 | 149.1875 | 13612600.0 |
| 2000-03-21 | QQQ | ETF | 106.125 | 111.875 | 103.5625 | 111.5 | 16714300.0 |
| 2000-03-21 | DIA | ETF | 106.5625 | 109.1875 | 105.9375 | 109.125 | 2310300.0 |
| 2000-03-21 | BBH | ETF | 55.5 | 57.8333 | 51.0 | 56.9375 | 5481300.0 |
| 2000-03-21 | BITS | ETF | 39.5 | 41.0 | 36.0 | 39.0 | 44125.0 |
| 2000-03-21 | CEF | ETF | 3.5 | 3.5625 | 3.5 | 3.5 | 9200.0 |
| 2000-03-21 | CHB | ETF | 6.63 | 6.69 | 6.44 | 6.69 | 92200.0 |
| 2000-03-21 | CNXT | ETF | 79.0 | 80.94 | 74.5 | 77.94 | 4235720.0 |
| 2000-03-21 | EWA | ETF | 10.625 | 10.625 | 10.375 | 10.625 | 5800.0 |
| 2000-03-21 | EWC | ETF | 17.75 | 18.0 | 17.75 | 18.0 | 8400.0 |
| 2000-03-21 | EWD | ETF | 35.8125 | 35.875 | 35.5 | 35.8125 | 12300.0 |
| 2000-03-21 | EWG | ETF | 28.1875 | 28.4375 | 27.9375 | 28.2969 | 138800.0 |
| 2000-03-21 | EWH | ETF | 13.25 | 13.4375 | 13.25 | 13.4375 | 20700.0 |
| 2000-03-21 | EWI | ETF | 51.375 | 51.625 | 51.0 | 51.1562 | 15250.0 |
| 2000-03-21 | EWJ | ETF | 59.75 | 60.75 | 59.75 | 60.25 | 131175.0 |
| 2000-03-21 | EWK | ETF | 13.0 | 13.125 | 12.875 | 13.125 | 2100.0 |
| 2000-03-21 | EWL | ETF | 14.875 | 15.125 | 14.875 | 15.0469 | 15500.0 |
| 2000-03-21 | EWM | ETF | 27.5 | 27.75 | 27.25 | 27.5 | 15725.0 |
| 2000-03-21 | EWN | ETF | 23.625 | 24.1875 | 23.625 | 24.0 | 3900.0 |
| 2000-03-21 | EWO | ETF | 7.5 | 7.5 | 7.4375 | 7.4375 | 6700.0 |
| 2000-03-21 | EWP | ETF | 29.5 | 29.5625 | 29.3125 | 29.5625 | 5200.0 |
| 2000-03-21 | EWQ | ETF | 28.25 | 28.5 | 28.25 | 28.4062 | 23600.0 |
| 2000-03-21 | EWS | ETF | 14.5 | 14.75 | 14.375 | 14.75 | 42300.0 |
| 2000-03-21 | EWU | ETF | 40.875 | 41.25 | 40.25 | 40.875 | 59400.0 |
| 2000-03-21 | EWW | ETF | 19.625 | 19.75 | 19.4375 | 19.75 | 9200.0 |
| 2000-03-21 | FCTR | ETF | 13.25 | 13.8125 | 13.0625 | 13.5 | 16800.0 |
| 2000-03-21 | FMAR | ETF | 6.3506 | 6.3506 | 6.3194 | 6.3194 | 2100.0 |
| 2000-03-21 | GLDB | ETF | 6.6875 | 6.9375 | 6.625 | 6.875 | 103600.0 |
| 2000-03-21 | GSIG | ETF | 18.44 | 19.69 | 17.5 | 19.12 | 630100.0 |
| 2000-03-21 | IGLD | ETF | 2565.625 | 2593.75 | 2393.75 | 2475.0 | 813.0 |
| 2000-03-21 | KTEC | ETF | 9.03125 | 9.1875 | 8.875 | 8.9375 | 6400.0 |
| 2000-03-21 | MDY | ETF | 86.8438 | 88.75 | 85.1875 | 88.5 | 732900.0 |
| 2000-03-21 | MIG | ETF | 5.0625 | 5.125 | 5.0625 | 5.125 | 2400.0 |
| 2000-03-21 | PPH | ETF | 42.625 | 43.375 | 42.25 | 43.375 | 332000.0 |
| 2000-03-21 | SFY | ETF | 12.9375 | 13.1875 | 12.75 | 12.9375 | 99600.0 |
| 2000-03-21 | TDSC | ETF | 5.44 | 5.44 | 5.03 | 5.155 | 79000.0 |
| 2000-03-21 | TINY | ETF | 21.88 | 22.25 | 18.5 | 21.5 | 373700.0 |
| 2000-03-21 | XLB | ETF | 11.1016 | 11.375 | 11.0625 | 11.2656 | 89800.0 |
| 2000-03-21 | XLE | ETF | 13.0 | 14.1094 | 13.0 | 14.1094 | 353000.0 |
| 2000-03-21 | XLF | ETF | 18.2652 | 19.1663 | 18.2525 | 19.1409 | 932359.0 |
| 2000-03-21 | XLI | ETF | 27.4375 | 28.3438 | 27.4375 | 28.3438 | 11100.0 |
| 2000-03-21 | XLK | ETF | 29.7344 | 30.8125 | 29.3203 | 30.5938 | 1298400.0 |
| 2000-03-21 | XLP | ETF | 20.9531 | 21.2969 | 20.7656 | 21.2969 | 32600.0 |
| 2000-03-21 | XLU | ETF | 13.1562 | 13.2969 | 13.1016 | 13.1797 | 179400.0 |
| 2000-03-21 | XLV | ETF | 30.0 | 30.125 | 29.7188 | 30.0625 | 18100.0 |
| 2000-03-21 | XLY | ETF | 13.9688 | 14.1875 | 13.875 | 14.1562 | 314400.0 |
> showing 46 of 46 rows — these rows as CSV