PREVIEW / etf_daily / 2000-08-15
file: by_date/etf_daily/2000/2000-08-15.parquet size: 8 KB rows: 77
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-08-15 | SPY | ETF | 149.3438 | 149.8125 | 148.5625 | 149.1562 | 5564600.0 |
| 2000-08-15 | QQQ | ETF | 92.75 | 93.9844 | 92.0 | 93.0 | 14090300.0 |
| 2000-08-15 | IWM | ETF | 51.5469 | 51.625 | 50.9062 | 50.9062 | 189200.0 |
| 2000-08-15 | DIA | ETF | 111.4844 | 111.5 | 110.625 | 110.9375 | 1258400.0 |
| 2000-08-15 | BBH | ETF | 60.8333 | 60.9792 | 59.125 | 59.4375 | 1115100.0 |
| 2000-08-15 | BITS | ETF | 11.625 | 13.0 | 11.625 | 12.0 | 19300.0 |
| 2000-08-15 | BOSS | ETF | 20.6 | 20.6 | 20.6 | 20.6 | 300.0 |
| 2000-08-15 | CEF | ETF | 3.3125 | 3.375 | 3.3125 | 3.3125 | 33300.0 |
| 2000-08-15 | CHB | ETF | 6.19 | 6.38 | 6.13 | 6.31 | 69300.0 |
| 2000-08-15 | CNXT | ETF | 28.94 | 34.38 | 28.88 | 33.69 | 10565450.0 |
| 2000-08-15 | CSB | ETF | 2.0 | 2.0 | 2.0 | 2.0 | 1000.0 |
| 2000-08-15 | EWA | ETF | 10.3125 | 10.5 | 10.3125 | 10.3125 | 54800.0 |
| 2000-08-15 | EWC | ETF | 21.375 | 21.4375 | 21.3125 | 21.4375 | 77000.0 |
| 2000-08-15 | EWD | ETF | 28.75 | 28.9375 | 28.75 | 28.9375 | 1300.0 |
| 2000-08-15 | EWG | ETF | 24.1875 | 24.1875 | 24.0 | 24.125 | 45900.0 |
| 2000-08-15 | EWH | ETF | 13.75 | 13.8125 | 13.6875 | 13.75 | 71000.0 |
| 2000-08-15 | EWI | ETF | 50.75 | 51.0 | 50.75 | 51.0 | 5800.0 |
| 2000-08-15 | EWJ | ETF | 55.25 | 55.75 | 55.0 | 55.75 | 229475.0 |
| 2000-08-15 | EWK | ETF | 14.3125 | 14.3125 | 14.0625 | 14.0625 | 3200.0 |
| 2000-08-15 | EWL | ETF | 16.0625 | 16.3125 | 16.0625 | 16.0625 | 8200.0 |
| 2000-08-15 | EWM | ETF | 24.0 | 24.25 | 23.75 | 23.75 | 17375.0 |
| 2000-08-15 | EWN | ETF | 24.125 | 24.375 | 24.125 | 24.375 | 12100.0 |
| 2000-08-15 | EWO | ETF | 8.0625 | 8.0625 | 8.0625 | 8.0625 | 500.0 |
| 2000-08-15 | EWP | ETF | 26.5625 | 26.8125 | 26.5625 | 26.8125 | 2500.0 |
| 2000-08-15 | EWQ | ETF | 28.4375 | 28.4375 | 28.25 | 28.4375 | 38600.0 |
| 2000-08-15 | EWS | ETF | 15.625 | 16.0 | 15.5 | 15.875 | 55750.0 |
| 2000-08-15 | EWT | ETF | 35.75 | 35.75 | 35.75 | 35.75 | 250.0 |
| 2000-08-15 | EWU | ETF | 39.5 | 39.5 | 39.0 | 39.25 | 27100.0 |
| 2000-08-15 | EWW | ETF | 16.5625 | 16.8125 | 16.5 | 16.625 | 41300.0 |
| 2000-08-15 | EWY | ETF | 19.3125 | 19.3125 | 19.1875 | 19.25 | 23200.0 |
| 2000-08-15 | EWZ | ETF | 20.25 | 20.25 | 20.0 | 20.0 | 5400.0 |
| 2000-08-15 | EZU | ETF | 39.375 | 39.375 | 39.3125 | 39.3438 | 76000.0 |
| 2000-08-15 | FCTR | ETF | 14.9063 | 15.0 | 14.6875 | 14.6875 | 9200.0 |
| 2000-08-15 | FMAR | ETF | 5.12 | 5.25 | 5.0 | 5.12 | 13300.0 |
| 2000-08-15 | GLDB | ETF | 4.9844 | 5.0625 | 4.875 | 4.9375 | 57900.0 |
| 2000-08-15 | GSIG | ETF | 23.59 | 24.75 | 23.19 | 24.12 | 714700.0 |
| 2000-08-15 | IDU | ETF | 38.8594 | 38.9219 | 38.6094 | 38.8906 | 3200.0 |
| 2000-08-15 | IEV | ETF | 39.3047 | 39.4062 | 39.25 | 39.3125 | 7600.0 |
| 2000-08-15 | IGLD | ETF | 662.5 | 662.5 | 637.5 | 643.75 | 444.0 |
| 2000-08-15 | IJH | ETF | 10.3203 | 10.3453 | 10.3094 | 10.3141 | 1545000.0 |
| 2000-08-15 | IJK | ETF | 17.25 | 17.25 | 17.0957 | 17.125 | 12000.0 |
| 2000-08-15 | IJR | ETF | 17.7761 | 17.7761 | 17.6224 | 17.6224 | 8400.0 |
| 2000-08-15 | IUSG | ETF | 33.7812 | 33.7812 | 33.7812 | 33.7812 | 800.0 |
| 2000-08-15 | IVE | ETF | 62.75 | 62.75 | 62.3906 | 62.5469 | 43000.0 |
| 2000-08-15 | IVV | ETF | 149.125 | 149.5312 | 148.6094 | 149.0312 | 343600.0 |
| 2000-08-15 | IVW | ETF | 22.2734 | 22.3984 | 22.2266 | 22.2578 | 13200.0 |
| 2000-08-15 | IWB | ETF | 78.9531 | 79.0 | 78.7344 | 79.0 | 600.0 |
| 2000-08-15 | IWD | ETF | 57.75 | 57.75 | 57.375 | 57.5625 | 243900.0 |
| 2000-08-15 | IWF | ETF | 21.46875 | 21.5625 | 21.453125 | 21.52345 | 6000.0 |
| 2000-08-15 | IWN | ETF | 36.0365 | 36.0365 | 35.75 | 35.75 | 5400.0 |
> showing 50 of 77 rows — these rows as CSV