PREVIEW / etf_daily / 2000-08-16
file: by_date/etf_daily/2000/2000-08-16.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-08-16 | SPY | ETF | 149.3125 | 149.9375 | 147.8438 | 148.625 | 5191600.0 |
| 2000-08-16 | QQQ | ETF | 93.4375 | 94.6875 | 92.0 | 93.9375 | 15245300.0 |
| 2000-08-16 | IWM | ETF | 51.125 | 51.5312 | 50.9375 | 51.1562 | 219400.0 |
| 2000-08-16 | DIA | ETF | 111.0312 | 111.3125 | 109.7656 | 111.0625 | 1050000.0 |
| 2000-08-16 | BBH | ETF | 60.3333 | 60.3333 | 57.875 | 58.0833 | 2597100.0 |
| 2000-08-16 | BITS | ETF | 12.0 | 13.5 | 12.0 | 12.75 | 7725.0 |
| 2000-08-16 | CEF | ETF | 3.3125 | 3.3125 | 3.3125 | 3.3125 | 21500.0 |
| 2000-08-16 | CHB | ETF | 6.38 | 6.38 | 6.06 | 6.06 | 60000.0 |
| 2000-08-16 | CNXT | ETF | 34.63 | 35.5 | 33.5 | 34.25 | 7499000.0 |
| 2000-08-16 | CSB | ETF | 2.15000009536743 | 2.15000009536743 | 2.15000009536743 | 2.15000009536743 | 800.0 |
| 2000-08-16 | EWA | ETF | 10.5625 | 10.625 | 10.5 | 10.5625 | 1900.0 |
| 2000-08-16 | EWC | ETF | 21.375 | 21.6875 | 21.375 | 21.5 | 13700.0 |
| 2000-08-16 | EWD | ETF | 29.0625 | 29.25 | 29.0625 | 29.0625 | 9700.0 |
| 2000-08-16 | EWG | ETF | 24.0625 | 24.125 | 23.9375 | 24.0625 | 26900.0 |
| 2000-08-16 | EWH | ETF | 13.875 | 14.0625 | 13.875 | 13.875 | 28400.0 |
| 2000-08-16 | EWI | ETF | 51.25 | 51.375 | 51.0 | 51.375 | 44950.0 |
| 2000-08-16 | EWJ | ETF | 55.5 | 55.5 | 55.0 | 55.0 | 76200.0 |
| 2000-08-16 | EWK | ETF | 14.0625 | 14.125 | 14.0625 | 14.125 | 6500.0 |
| 2000-08-16 | EWL | ETF | 16.3125 | 16.4375 | 16.125 | 16.375 | 62100.0 |
| 2000-08-16 | EWM | ETF | 24.0 | 24.5 | 24.0 | 24.25 | 60600.0 |
| 2000-08-16 | EWN | ETF | 24.375 | 24.375 | 24.1875 | 24.375 | 7100.0 |
| 2000-08-16 | EWO | ETF | 8.0 | 8.0 | 8.0 | 8.0 | 100.0 |
| 2000-08-16 | EWP | ETF | 26.9375 | 27.125 | 26.875 | 26.875 | 22100.0 |
| 2000-08-16 | EWQ | ETF | 28.5 | 28.5625 | 28.375 | 28.5625 | 78800.0 |
| 2000-08-16 | EWS | ETF | 16.0 | 16.375 | 15.75 | 15.875 | 69200.0 |
| 2000-08-16 | EWT | ETF | 36.5 | 36.875 | 36.375 | 36.5 | 22450.0 |
| 2000-08-16 | EWU | ETF | 39.625 | 39.625 | 39.25 | 39.375 | 63050.0 |
| 2000-08-16 | EWW | ETF | 17.0 | 17.0 | 16.75 | 17.0 | 7100.0 |
| 2000-08-16 | EWY | ETF | 19.625 | 19.9375 | 19.625 | 19.9375 | 3500.0 |
| 2000-08-16 | EZU | ETF | 39.375 | 39.5938 | 39.375 | 39.4375 | 1000.0 |
| 2000-08-16 | FCTR | ETF | 14.5625 | 14.8125 | 14.0625 | 14.0625 | 7300.0 |
| 2000-08-16 | FMAR | ETF | 5.25 | 5.25 | 4.94 | 5.12 | 4400.0 |
| 2000-08-16 | GLDB | ETF | 4.9375 | 5.0625 | 4.875 | 4.9688 | 66400.0 |
| 2000-08-16 | GSIG | ETF | 24.22 | 25.37 | 24.19 | 24.44 | 710300.0 |
| 2000-08-16 | IDU | ETF | 38.8438 | 39.0234 | 38.8281 | 38.9062 | 10000.0 |
| 2000-08-16 | IEV | ETF | 39.1016 | 39.5859 | 39.1016 | 39.5859 | 67600.0 |
| 2000-08-16 | IGLD | ETF | 668.75 | 675.0 | 662.5 | 668.75 | 348.0 |
| 2000-08-16 | IJH | ETF | 10.3922 | 10.3922 | 10.3312 | 10.3312 | 43000.0 |
| 2000-08-16 | IJJ | ETF | 19.2422 | 19.2422 | 19.1875 | 19.1875 | 8400.0 |
| 2000-08-16 | IJK | ETF | 17.2852 | 17.2852 | 17.2012 | 17.2012 | 12800.0 |
| 2000-08-16 | IJR | ETF | 17.6667 | 17.7214 | 17.5755 | 17.6667 | 7200.0 |
| 2000-08-16 | IJS | ETF | 17.5625 | 17.5625 | 17.5312 | 17.5312 | 7600.0 |
| 2000-08-16 | IJT | ETF | 20.6094 | 20.6094 | 20.5625 | 20.5625 | 8800.0 |
| 2000-08-16 | IUSG | ETF | 33.9844 | 33.9844 | 33.9844 | 33.9844 | 200.0 |
| 2000-08-16 | IVE | ETF | 62.5625 | 62.5625 | 62.1406 | 62.25 | 8100.0 |
| 2000-08-16 | IVV | ETF | 149.2812 | 149.7344 | 147.9531 | 148.0 | 155000.0 |
| 2000-08-16 | IVW | ETF | 22.2969 | 22.3945 | 22.1133 | 22.1562 | 62400.0 |
| 2000-08-16 | IWB | ETF | 79.0 | 79.0 | 78.3594 | 78.3594 | 2000.0 |
| 2000-08-16 | IWD | ETF | 57.5 | 57.6562 | 57.0625 | 57.0625 | 51800.0 |
| 2000-08-16 | IWF | ETF | 21.72655 | 21.72655 | 21.390625 | 21.4414 | 168400.0 |
> showing 50 of 81 rows — these rows as CSV