PREVIEW / etf_daily / 2000-02-24
file: by_date/etf_daily/2000/2000-02-24.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-02-24 | SPY | ETF | 136.6875 | 137.0312 | 133.0938 | 133.8125 | 17375000.0 |
| 2000-02-24 | DIA | ETF | 102.5625 | 102.6875 | 99.5625 | 102.0 | 4518700.0 |
| 2000-02-24 | BBH | ETF | 69.3333 | 70.1667 | 67.0 | 69.75 | 2063100.0 |
| 2000-02-24 | BITS | ETF | 34.0 | 35.875 | 31.5 | 33.25 | 52350.0 |
| 2000-02-24 | BOSS | ETF | 11.5 | 11.7 | 11.5 | 11.5 | 600.0 |
| 2000-02-24 | CEF | ETF | 3.625 | 3.6875 | 3.5625 | 3.5625 | 24600.0 |
| 2000-02-24 | CHB | ETF | 7.19 | 7.25 | 7.06 | 7.25 | 103900.0 |
| 2000-02-24 | CNXT | ETF | 125.25 | 132.13 | 122.37 | 122.99 | 4031900.0 |
| 2000-02-24 | CSB | ETF | 3.59999990463257 | 3.79999995231628 | 3.29999995231628 | 3.79999995231628 | 21200.0 |
| 2000-02-24 | EWA | ETF | 10.1875 | 10.1875 | 10.0 | 10.0 | 56100.0 |
| 2000-02-24 | EWC | ETF | 17.375 | 17.625 | 17.375 | 17.5 | 32500.0 |
| 2000-02-24 | EWD | ETF | 34.625 | 34.625 | 34.0 | 34.125 | 6700.0 |
| 2000-02-24 | EWG | ETF | 28.9375 | 29.0 | 28.125 | 28.5625 | 115800.0 |
| 2000-02-24 | EWH | ETF | 13.5625 | 13.6875 | 13.1875 | 13.5625 | 105800.0 |
| 2000-02-24 | EWI | ETF | 54.75 | 54.75 | 53.75 | 53.75 | 12550.0 |
| 2000-02-24 | EWJ | ETF | 59.0 | 59.5 | 58.5 | 58.5 | 187925.0 |
| 2000-02-24 | EWK | ETF | 13.5 | 13.5 | 12.8125 | 13.0 | 2800.0 |
| 2000-02-24 | EWL | ETF | 14.875 | 15.125 | 14.625 | 14.9375 | 36700.0 |
| 2000-02-24 | EWM | ETF | 30.75 | 30.75 | 30.25 | 30.25 | 23550.0 |
| 2000-02-24 | EWN | ETF | 24.125 | 24.125 | 23.5 | 23.625 | 38000.0 |
| 2000-02-24 | EWO | ETF | 7.625 | 7.625 | 7.625 | 7.625 | 1200.0 |
| 2000-02-24 | EWP | ETF | 28.9375 | 28.9375 | 28.25 | 28.375 | 32900.0 |
| 2000-02-24 | EWQ | ETF | 28.25 | 28.25 | 27.6875 | 27.9375 | 42300.0 |
| 2000-02-24 | EWS | ETF | 14.875 | 14.875 | 14.125 | 14.5 | 74450.0 |
| 2000-02-24 | EWU | ETF | 38.375 | 38.375 | 37.0 | 37.5 | 68750.0 |
| 2000-02-24 | EWW | ETF | 18.125 | 18.4375 | 17.875 | 17.9375 | 15100.0 |
| 2000-02-24 | FCTR | ETF | 13.0 | 13.625 | 13.0 | 13.3125 | 58100.0 |
| 2000-02-24 | FMAR | ETF | 7.0 | 7.061 | 6.62 | 7.0 | 6000.0 |
| 2000-02-24 | GLDB | ETF | 8.125 | 8.3125 | 7.9375 | 7.9375 | 101600.0 |
| 2000-02-24 | GSIG | ETF | 16.81 | 17.12 | 15.62 | 17.12 | 370300.0 |
| 2000-02-24 | IGLD | ETF | 2193.75 | 2362.5 | 2100.0 | 2275.0 | 1530.0 |
| 2000-02-24 | KTEC | ETF | 9.0 | 9.5 | 8.875 | 8.875 | 14000.0 |
| 2000-02-24 | MDY | ETF | 82.5 | 83.0625 | 81.25 | 83.0 | 638500.0 |
| 2000-02-24 | MIG | ETF | 5.125 | 5.125 | 4.9375 | 4.9375 | 49600.0 |
| 2000-02-24 | PPH | ETF | 41.375 | 41.4688 | 40.2812 | 40.6875 | 293200.0 |
| 2000-02-24 | SFY | ETF | 10.8125 | 11.125 | 10.8125 | 11.125 | 61900.0 |
| 2000-02-24 | TDSC | ETF | 4.69 | 4.75 | 4.25 | 4.405 | 130600.0 |
| 2000-02-24 | TINY | ETF | 18.0 | 18.12 | 16.25 | 17.25 | 225700.0 |
| 2000-02-24 | XLB | ETF | 10.9844 | 10.9844 | 10.5625 | 10.7031 | 37600.0 |
| 2000-02-24 | XLE | ETF | 12.625 | 12.7188 | 12.4688 | 12.6562 | 632000.0 |
| 2000-02-24 | XLF | ETF | 16.3738 | 16.5008 | 16.0184 | 16.1962 | 435774.0 |
| 2000-02-24 | XLI | ETF | 26.0 | 26.0 | 25.4219 | 25.7812 | 19500.0 |
| 2000-02-24 | XLK | ETF | 27.7422 | 28.0312 | 27.25 | 27.9062 | 639800.0 |
| 2000-02-24 | XLP | ETF | 21.1719 | 21.1719 | 20.4531 | 20.7188 | 166100.0 |
| 2000-02-24 | XLU | ETF | 12.2734 | 12.75 | 11.6875 | 11.7812 | 209400.0 |
| 2000-02-24 | XLV | ETF | 28.4688 | 28.5938 | 27.75 | 28.2188 | 172800.0 |
| 2000-02-24 | XLY | ETF | 12.3906 | 12.3906 | 11.9453 | 12.0938 | 217800.0 |
> showing 47 of 47 rows — these rows as CSV