PREVIEW / etf_daily / 2000-01-05
file: by_date/etf_daily/2000/2000-01-05.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-05 | SPY | ETF | 139.9375 | 141.5312 | 137.25 | 140.0 | 12177900.0 |
| 2000-01-05 | DIA | ETF | 110.0 | 112.375 | 109.0312 | 111.1875 | 2007000.0 |
| 2000-01-05 | BBH | ETF | 44.25 | 44.9167 | 42.6667 | 44.4167 | 1130100.0 |
| 2000-01-05 | BITS | ETF | 22.125 | 27.0 | 21.5 | 23.0 | 129250.0 |
| 2000-01-05 | BOSS | ETF | 11.3 | 11.3 | 11.3 | 11.3 | 1000.0 |
| 2000-01-05 | CEF | ETF | 3.875 | 3.875 | 3.75 | 3.75 | 49300.0 |
| 2000-01-05 | CHB | ETF | 8.0 | 8.19 | 7.88 | 8.19 | 113900.0 |
| 2000-01-05 | CNXT | ETF | 62.63 | 63.06 | 59.81 | 62.31 | 3428070.0 |
| 2000-01-05 | EWA | ETF | 10.5625 | 10.8125 | 10.5625 | 10.8125 | 3600.0 |
| 2000-01-05 | EWC | ETF | 16.0 | 16.1875 | 16.0 | 16.1875 | 6500.0 |
| 2000-01-05 | EWD | ETF | 28.4375 | 28.5 | 28.0625 | 28.5 | 1900.0 |
| 2000-01-05 | EWG | ETF | 25.375 | 25.625 | 24.9375 | 25.625 | 158700.0 |
| 2000-01-05 | EWH | ETF | 12.9375 | 13.4375 | 12.9375 | 13.375 | 170200.0 |
| 2000-01-05 | EWI | ETF | 48.0 | 48.0 | 47.25 | 48.0 | 8350.0 |
| 2000-01-05 | EWJ | ETF | 60.75 | 62.0 | 60.5 | 61.25 | 207700.0 |
| 2000-01-05 | EWK | ETF | 15.375 | 15.375 | 15.375 | 15.375 | 800.0 |
| 2000-01-05 | EWL | ETF | 15.75 | 16.125 | 15.625 | 16.125 | 137400.0 |
| 2000-01-05 | EWM | ETF | 24.75 | 25.5 | 23.75 | 25.0 | 283450.0 |
| 2000-01-05 | EWN | ETF | 24.3125 | 24.5625 | 24.125 | 24.5625 | 2600.0 |
| 2000-01-05 | EWO | ETF | 8.8125 | 8.9375 | 8.8125 | 8.9375 | 4700.0 |
| 2000-01-05 | EWP | ETF | 27.625 | 27.8125 | 27.375 | 27.8125 | 16200.0 |
| 2000-01-05 | EWQ | ETF | 25.9375 | 26.125 | 25.625 | 26.0 | 156000.0 |
| 2000-01-05 | EWS | ETF | 17.75 | 18.375 | 17.625 | 18.25 | 29050.0 |
| 2000-01-05 | EWU | ETF | 41.25 | 42.25 | 41.0 | 42.25 | 127050.0 |
| 2000-01-05 | EWW | ETF | 16.5625 | 17.0625 | 16.25 | 17.0 | 22400.0 |
| 2000-01-05 | FCTR | ETF | 14.4375 | 15.125 | 14.0 | 14.3125 | 45900.0 |
| 2000-01-05 | FMAR | ETF | 8.23 | 8.23 | 7.48 | 8.23 | 8700.0 |
| 2000-01-05 | GLDB | ETF | 9.125 | 9.5 | 8.75 | 9.375 | 14400.0 |
| 2000-01-05 | GSIG | ETF | 8.53 | 9.31 | 8.25 | 9.25 | 106800.0 |
| 2000-01-05 | IGLD | ETF | 2212.5 | 2225.0 | 2000.0 | 2087.5 | 3995.0 |
| 2000-01-05 | KTEC | ETF | 8.875 | 9.0625 | 8.75 | 9.0625 | 27700.0 |
| 2000-01-05 | MDY | ETF | 77.4062 | 78.625 | 76.0 | 78.125 | 1249700.0 |
| 2000-01-05 | MIG | ETF | 6.875 | 7.25 | 6.75 | 7.25 | 12100.0 |
| 2000-01-05 | SFY | ETF | 9.875 | 9.875 | 9.75 | 9.8125 | 86700.0 |
| 2000-01-05 | TDSC | ETF | 3.905 | 4.22 | 3.905 | 4.155 | 79000.0 |
| 2000-01-05 | TINY | ETF | 10.75 | 13.0 | 10.38 | 12.0 | 412400.0 |
| 2000-01-05 | XLB | ETF | 13.0078 | 13.4062 | 12.875 | 13.3906 | 205400.0 |
| 2000-01-05 | XLE | ETF | 13.0625 | 13.375 | 13.0 | 13.375 | 675600.0 |
| 2000-01-05 | XLF | ETF | 17.7701 | 17.9605 | 17.44 | 17.6305 | 717181.0 |
| 2000-01-05 | XLI | ETF | 28.0 | 28.125 | 27.7188 | 27.9219 | 129200.0 |
| 2000-01-05 | XLK | ETF | 25.875 | 26.5312 | 25.0625 | 25.9219 | 3812000.0 |
| 2000-01-05 | XLP | ETF | 22.2656 | 22.6094 | 22.0938 | 22.5 | 343600.0 |
| 2000-01-05 | XLU | ETF | 13.6094 | 13.711 | 13.4297 | 13.6484 | 546800.0 |
| 2000-01-05 | XLV | ETF | 29.7812 | 29.7812 | 29.2188 | 29.3438 | 137600.0 |
| 2000-01-05 | XLY | ETF | 14.6719 | 14.6719 | 14.3594 | 14.4297 | 249200.0 |
> showing 45 of 45 rows — these rows as CSV