PREVIEW / etf_daily / 2000-03-13
file: by_date/etf_daily/2000/2000-03-13.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-13 | SPY | ETF | 136.6875 | 140.4688 | 135.6875 | 138.5938 | 10540500.0 |
| 2000-03-13 | QQQ | ETF | 55.0 | 57.0625 | 54.7656 | 55.75 | 37544200.0 |
| 2000-03-13 | DIA | ETF | 96.8438 | 100.1875 | 96.8438 | 99.625 | 1506500.0 |
| 2000-03-13 | BBH | ETF | 64.3333 | 67.3333 | 64.0208 | 64.3333 | 3547200.0 |
| 2000-03-13 | BITS | ETF | 40.0 | 50.0 | 39.0 | 48.25 | 182375.0 |
| 2000-03-13 | CEF | ETF | 3.625 | 3.6875 | 3.4375 | 3.6875 | 33300.0 |
| 2000-03-13 | CHB | ETF | 5.63 | 5.81 | 5.38 | 5.75 | 107800.0 |
| 2000-03-13 | CNXT | ETF | 83.5 | 88.0 | 81.5 | 84.31 | 5223260.0 |
| 2000-03-13 | CSB | ETF | 3.95000004768372 | 4.0 | 3.95000004768372 | 4.0 | 2000.0 |
| 2000-03-13 | EWA | ETF | 10.5 | 10.5 | 10.25 | 10.25 | 7800.0 |
| 2000-03-13 | EWC | ETF | 17.125 | 17.25 | 17.0 | 17.125 | 9900.0 |
| 2000-03-13 | EWD | ETF | 35.0 | 35.25 | 34.875 | 35.0625 | 6100.0 |
| 2000-03-13 | EWG | ETF | 27.1875 | 27.75 | 27.125 | 27.5 | 231000.0 |
| 2000-03-13 | EWH | ETF | 13.4375 | 13.6875 | 13.375 | 13.4375 | 130800.0 |
| 2000-03-13 | EWI | ETF | 53.0 | 53.125 | 52.5 | 53.125 | 2500.0 |
| 2000-03-13 | EWJ | ETF | 57.5 | 57.75 | 56.75 | 56.75 | 244975.0 |
| 2000-03-13 | EWK | ETF | 11.625 | 11.625 | 11.3125 | 11.5 | 4000.0 |
| 2000-03-13 | EWL | ETF | 13.875 | 14.125 | 13.875 | 14.0625 | 309100.0 |
| 2000-03-13 | EWM | ETF | 27.5 | 28.0 | 27.25 | 27.75 | 46400.0 |
| 2000-03-13 | EWN | ETF | 23.125 | 23.25 | 23.0 | 23.1875 | 6000.0 |
| 2000-03-13 | EWO | ETF | 7.625 | 7.625 | 7.4375 | 7.4375 | 1200.0 |
| 2000-03-13 | EWP | ETF | 28.3125 | 28.8125 | 28.3125 | 28.625 | 2600.0 |
| 2000-03-13 | EWQ | ETF | 28.3125 | 28.375 | 28.125 | 28.3125 | 210300.0 |
| 2000-03-13 | EWS | ETF | 13.75 | 13.875 | 13.5 | 13.5 | 95950.0 |
| 2000-03-13 | EWU | ETF | 39.0 | 39.75 | 38.5 | 38.75 | 13750.0 |
| 2000-03-13 | EWW | ETF | 19.875 | 19.875 | 19.1875 | 19.375 | 19400.0 |
| 2000-03-13 | FCTR | ETF | 13.375 | 13.4375 | 13.0 | 13.0625 | 12800.0 |
| 2000-03-13 | FMAR | ETF | 6.0 | 6.25 | 5.75 | 5.87 | 8800.0 |
| 2000-03-13 | GLDB | ETF | 7.125 | 7.125 | 6.875 | 6.9375 | 25600.0 |
| 2000-03-13 | GSIG | ETF | 21.5 | 22.75 | 20.0 | 20.81 | 509200.0 |
| 2000-03-13 | IGLD | ETF | 2875.0 | 3050.0 | 2750.0 | 2800.0 | 1580.0 |
| 2000-03-13 | KTEC | ETF | 8.875 | 9.0 | 8.875 | 8.875 | 5300.0 |
| 2000-03-13 | MDY | ETF | 86.25 | 88.4375 | 85.75 | 86.25 | 252700.0 |
| 2000-03-13 | MIG | ETF | 5.5 | 5.5 | 5.25 | 5.25 | 10000.0 |
| 2000-03-13 | PPH | ETF | 39.375 | 40.4688 | 39.1562 | 39.5 | 246400.0 |
| 2000-03-13 | SFY | ETF | 12.3125 | 12.8125 | 12.1875 | 12.25 | 70100.0 |
| 2000-03-13 | TDSC | ETF | 5.28 | 6.125 | 5.155 | 6.0 | 413800.0 |
| 2000-03-13 | TINY | ETF | 28.88 | 32.12 | 26.5 | 29.56 | 376300.0 |
| 2000-03-13 | XLB | ETF | 10.0 | 10.3672 | 9.9844 | 10.3438 | 94000.0 |
| 2000-03-13 | XLE | ETF | 13.875 | 14.1094 | 13.6094 | 13.6719 | 701200.0 |
| 2000-03-13 | XLF | ETF | 15.8154 | 16.6278 | 15.8154 | 16.45 | 411646.0 |
| 2000-03-13 | XLI | ETF | 25.1719 | 25.7031 | 25.1719 | 25.3906 | 86600.0 |
| 2000-03-13 | XLK | ETF | 29.25 | 30.125 | 29.0 | 29.4375 | 4022400.0 |
| 2000-03-13 | XLP | ETF | 19.1562 | 19.5781 | 19.125 | 19.2656 | 1061900.0 |
| 2000-03-13 | XLU | ETF | 12.5781 | 12.875 | 12.5781 | 12.8281 | 372400.0 |
| 2000-03-13 | XLV | ETF | 27.2188 | 27.8438 | 27.2188 | 27.625 | 64200.0 |
| 2000-03-13 | XLY | ETF | 12.1172 | 12.4688 | 12.1172 | 12.3828 | 885800.0 |
> showing 47 of 47 rows — these rows as CSV