PREVIEW / etf_daily / 2000-09-06
file: by_date/etf_daily/2000/2000-09-06.parquet size: 8 KB rows: 81
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-09-06 | SPY | ETF | 151.1875 | 151.9531 | 149.5312 | 149.5625 | 4322200.0 |
| 2000-09-06 | QQQ | ETF | 99.25 | 99.4844 | 95.5 | 96.0 | 20964900.0 |
| 2000-09-06 | IWM | ETF | 54.0625 | 54.0625 | 53.5 | 53.5781 | 217800.0 |
| 2000-09-06 | DIA | ETF | 113.0312 | 114.0938 | 113.0312 | 113.1875 | 715300.0 |
| 2000-09-06 | BBH | ETF | 64.2083 | 64.4375 | 60.8958 | 61.0417 | 1592400.0 |
| 2000-09-06 | BITS | ETF | 19.875 | 20.5 | 18.5 | 19.75 | 9800.0 |
| 2000-09-06 | CEF | ETF | 3.375 | 3.375 | 3.3125 | 3.3125 | 900.0 |
| 2000-09-06 | CHB | ETF | 5.88 | 5.88 | 5.81 | 5.81 | 26700.0 |
| 2000-09-06 | CNXT | ETF | 35.75 | 36.19 | 33.81 | 34.19 | 4267070.0 |
| 2000-09-06 | CSB | ETF | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 50000.0 |
| 2000-09-06 | EWA | ETF | 9.9375 | 10.0 | 9.875 | 9.9375 | 35800.0 |
| 2000-09-06 | EWC | ETF | 17.1875 | 17.1875 | 16.9375 | 17.0 | 39500.0 |
| 2000-09-06 | EWD | ETF | 24.375 | 24.5 | 24.25 | 24.3125 | 3200.0 |
| 2000-09-06 | EWG | ETF | 20.875 | 20.875 | 20.4375 | 20.625 | 52700.0 |
| 2000-09-06 | EWH | ETF | 13.5625 | 13.625 | 13.4375 | 13.5625 | 83900.0 |
| 2000-09-06 | EWI | ETF | 44.625 | 44.75 | 44.125 | 44.25 | 15500.0 |
| 2000-09-06 | EWJ | ETF | 54.75 | 54.75 | 54.25 | 54.5 | 75225.0 |
| 2000-09-06 | EWK | ETF | 12.9375 | 13.1875 | 12.9375 | 13.1875 | 300.0 |
| 2000-09-06 | EWL | ETF | 15.25 | 15.375 | 15.25 | 15.3125 | 4300.0 |
| 2000-09-06 | EWM | ETF | 22.25 | 22.75 | 22.25 | 22.5 | 15950.0 |
| 2000-09-06 | EWN | ETF | 23.625 | 23.6875 | 23.3125 | 23.375 | 2800.0 |
| 2000-09-06 | EWO | ETF | 7.75 | 7.75 | 7.6875 | 7.6875 | 9100.0 |
| 2000-09-06 | EWP | ETF | 24.4375 | 24.75 | 24.375 | 24.375 | 5300.0 |
| 2000-09-06 | EWQ | ETF | 26.8125 | 26.9375 | 26.4375 | 26.625 | 28500.0 |
| 2000-09-06 | EWS | ETF | 15.0 | 15.125 | 14.875 | 14.875 | 24350.0 |
| 2000-09-06 | EWT | ETF | 33.5 | 33.5 | 33.5 | 33.5 | 100.0 |
| 2000-09-06 | EWU | ETF | 36.5 | 37.25 | 36.5 | 36.875 | 18050.0 |
| 2000-09-06 | EWW | ETF | 17.125 | 17.25 | 16.6875 | 16.6875 | 21600.0 |
| 2000-09-06 | EWY | ETF | 18.25 | 18.3125 | 17.875 | 17.875 | 1900.0 |
| 2000-09-06 | EWZ | ETF | 20.1875 | 20.25 | 20.125 | 20.25 | 2700.0 |
| 2000-09-06 | EZU | ETF | 38.5 | 38.5 | 38.0625 | 38.0625 | 1200.0 |
| 2000-09-06 | FCTR | ETF | 15.9063 | 16.0625 | 15.875 | 16.0 | 11800.0 |
| 2000-09-06 | FMAR | ETF | 5.39 | 5.39 | 5.0 | 5.0 | 29980.0 |
| 2000-09-06 | GLDB | ETF | 5.2969 | 5.3125 | 5.25 | 5.2813 | 152900.0 |
| 2000-09-06 | GSIG | ETF | 26.09 | 26.69 | 23.75 | 24.19 | 526100.0 |
| 2000-09-06 | IDU | ETF | 40.6562 | 40.8906 | 40.5625 | 40.8906 | 9400.0 |
| 2000-09-06 | IEV | ETF | 39.5 | 39.5625 | 39.0625 | 39.25 | 17400.0 |
| 2000-09-06 | IGLD | ETF | 687.5 | 687.5 | 625.0 | 646.875 | 825.0 |
| 2000-09-06 | IJH | ETF | 10.8344 | 10.8594 | 10.7953 | 10.8344 | 806000.0 |
| 2000-09-06 | IJJ | ETF | 19.8047 | 19.8125 | 19.8047 | 19.8125 | 2800.0 |
| 2000-09-06 | IJK | ETF | 18.4375 | 18.4648 | 18.2461 | 18.3809 | 4000.0 |
| 2000-09-06 | IJR | ETF | 18.5208 | 18.5208 | 18.3984 | 18.4948 | 44400.0 |
| 2000-09-06 | IJS | ETF | 18.0078 | 18.0078 | 18.0078 | 18.0078 | 41600.0 |
| 2000-09-06 | IUSV | ETF | 24.6823 | 24.6823 | 24.6406 | 24.6458 | 9600.0 |
| 2000-09-06 | IVE | ETF | 63.8438 | 63.875 | 63.7031 | 63.7031 | 57600.0 |
| 2000-09-06 | IVV | ETF | 151.2812 | 151.4688 | 149.8594 | 149.8594 | 153200.0 |
| 2000-09-06 | IVW | ETF | 22.5781 | 22.5781 | 22.1875 | 22.1875 | 20000.0 |
| 2000-09-06 | IWB | ETF | 80.9688 | 80.9688 | 80.0938 | 80.0938 | 2800.0 |
| 2000-09-06 | IWD | ETF | 58.3438 | 58.375 | 58.0938 | 58.0938 | 5700.0 |
| 2000-09-06 | IWF | ETF | 22.34375 | 22.34375 | 21.8672 | 21.8672 | 39600.0 |
> showing 50 of 81 rows — these rows as CSV