PREVIEW / etf_daily / 2000-03-16
file: by_date/etf_daily/2000/2000-03-16.parquet size: 6 KB rows: 47
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-16 | SPY | ETF | 141.625 | 146.8438 | 140.875 | 146.3438 | 25601400.0 |
| 2000-03-16 | QQQ | ETF | 52.6875 | 54.625 | 50.5 | 54.375 | 55282200.0 |
| 2000-03-16 | DIA | ETF | 102.5625 | 106.875 | 102.4062 | 106.7812 | 4857700.0 |
| 2000-03-16 | BBH | ETF | 61.6458 | 62.9583 | 59.0208 | 62.6458 | 2707500.0 |
| 2000-03-16 | BITS | ETF | 48.0 | 49.0 | 42.0 | 42.25 | 159500.0 |
| 2000-03-16 | CEF | ETF | 3.625 | 3.625 | 3.5 | 3.5 | 29500.0 |
| 2000-03-16 | CHB | ETF | 6.0 | 6.5 | 6.0 | 6.38 | 300100.0 |
| 2000-03-16 | CNXT | ETF | 85.0 | 85.25 | 78.0 | 80.19 | 8548000.0 |
| 2000-03-16 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 10000.0 |
| 2000-03-16 | EWA | ETF | 10.375 | 10.375 | 10.125 | 10.375 | 11100.0 |
| 2000-03-16 | EWC | ETF | 17.5 | 17.625 | 17.25 | 17.625 | 16600.0 |
| 2000-03-16 | EWD | ETF | 34.75 | 35.0625 | 34.3125 | 35.0625 | 47400.0 |
| 2000-03-16 | EWG | ETF | 27.4375 | 27.75 | 27.1875 | 27.75 | 63300.0 |
| 2000-03-16 | EWH | ETF | 13.125 | 13.5625 | 13.125 | 13.375 | 37700.0 |
| 2000-03-16 | EWI | ETF | 51.625 | 52.0 | 51.5 | 52.0 | 13150.0 |
| 2000-03-16 | EWJ | ETF | 60.0 | 60.75 | 59.75 | 60.75 | 197150.0 |
| 2000-03-16 | EWK | ETF | 13.875 | 14.0625 | 13.5625 | 14.0625 | 14400.0 |
| 2000-03-16 | EWL | ETF | 14.75 | 15.25 | 14.5625 | 15.25 | 25100.0 |
| 2000-03-16 | EWM | ETF | 27.5 | 28.0 | 26.75 | 28.0 | 24700.0 |
| 2000-03-16 | EWN | ETF | 23.6875 | 23.875 | 23.5625 | 23.875 | 7600.0 |
| 2000-03-16 | EWO | ETF | 7.75 | 7.875 | 7.75 | 7.875 | 500.0 |
| 2000-03-16 | EWP | ETF | 29.1875 | 29.75 | 28.9375 | 29.75 | 7700.0 |
| 2000-03-16 | EWQ | ETF | 28.4375 | 28.5625 | 28.1875 | 28.5625 | 28000.0 |
| 2000-03-16 | EWS | ETF | 13.875 | 14.25 | 13.75 | 13.875 | 83450.0 |
| 2000-03-16 | EWU | ETF | 40.5 | 41.75 | 40.0 | 41.5 | 230900.0 |
| 2000-03-16 | EWW | ETF | 19.8125 | 19.8125 | 19.3125 | 19.4375 | 12400.0 |
| 2000-03-16 | FCTR | ETF | 12.75 | 13.75 | 12.75 | 13.5 | 49200.0 |
| 2000-03-16 | FMAR | ETF | 6.34 | 6.3435 | 5.9984 | 6.31 | 10500.0 |
| 2000-03-16 | GLDB | ETF | 6.5 | 6.5 | 6.125 | 6.125 | 122400.0 |
| 2000-03-16 | GSIG | ETF | 17.5 | 18.12 | 17.06 | 17.62 | 1121300.0 |
| 2000-03-16 | IGLD | ETF | 2759.375 | 2775.0 | 2487.5 | 2656.25 | 808.0 |
| 2000-03-16 | KTEC | ETF | 8.875 | 9.1875 | 8.875 | 9.0 | 7000.0 |
| 2000-03-16 | MDY | ETF | 85.2188 | 89.625 | 84.375 | 89.1562 | 1220900.0 |
| 2000-03-16 | MIG | ETF | 5.125 | 5.25 | 5.0625 | 5.25 | 7100.0 |
| 2000-03-16 | PPH | ETF | 42.625 | 43.9375 | 42.3125 | 43.7188 | 899600.0 |
| 2000-03-16 | SFY | ETF | 12.0 | 13.3125 | 11.8125 | 13.1875 | 143000.0 |
| 2000-03-16 | TDSC | ETF | 5.155 | 5.67 | 5.155 | 5.455 | 144800.0 |
| 2000-03-16 | TINY | ETF | 28.88 | 29.12 | 25.06 | 27.25 | 396000.0 |
| 2000-03-16 | XLB | ETF | 10.8125 | 11.4688 | 10.8125 | 11.4062 | 467800.0 |
| 2000-03-16 | XLE | ETF | 13.6875 | 14.3906 | 13.375 | 14.375 | 1132600.0 |
| 2000-03-16 | XLF | ETF | 17.8716 | 18.8871 | 17.7701 | 18.8871 | 2141694.0 |
| 2000-03-16 | XLI | ETF | 26.3125 | 27.7344 | 26.3125 | 27.6875 | 281000.0 |
| 2000-03-16 | XLK | ETF | 28.625 | 29.25 | 27.9375 | 29.25 | 5453200.0 |
| 2000-03-16 | XLP | ETF | 21.0 | 21.625 | 20.75 | 21.25 | 580200.0 |
| 2000-03-16 | XLU | ETF | 13.0469 | 13.5469 | 13.0234 | 13.3125 | 106000.0 |
| 2000-03-16 | XLV | ETF | 28.125 | 29.2812 | 28.125 | 29.2812 | 168500.0 |
| 2000-03-16 | XLY | ETF | 13.4219 | 14.1562 | 13.3594 | 14.125 | 302800.0 |
> showing 47 of 47 rows — these rows as CSV