PREVIEW / etf_daily / 2000-09-01
file: by_date/etf_daily/2000/2000-09-01.parquet size: 8 KB rows: 82
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-01 | SPY | ETF | 153.25 | 153.5938 | 152.0 | 152.5 | 3191200.0 |
| 2000-09-01 | QQQ | ETF | 103.0 | 103.5156 | 101.1875 | 102.625 | 14071900.0 |
| 2000-09-01 | IWM | ETF | 54.0 | 54.2812 | 53.7422 | 54.1875 | 186800.0 |
| 2000-09-01 | DIA | ETF | 112.9375 | 113.25 | 112.3281 | 112.5312 | 302000.0 |
| 2000-09-01 | BBH | ETF | 68.3125 | 68.6667 | 66.9167 | 67.4167 | 1394100.0 |
| 2000-09-01 | BITS | ETF | 16.5 | 20.5 | 15.0 | 20.0 | 35775.0 |
| 2000-09-01 | BOSS | ETF | 20.1 | 20.35 | 20.1 | 20.35 | 100.0 |
| 2000-09-01 | CEF | ETF | 3.3125 | 3.375 | 3.3125 | 3.3125 | 5300.0 |
| 2000-09-01 | CHB | ETF | 6.38 | 6.38 | 6.06 | 6.06 | 47700.0 |
| 2000-09-01 | CNXT | ETF | 38.12 | 39.47 | 37.59 | 38.16 | 3166530.0 |
| 2000-09-01 | CSB | ETF | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 10000.0 |
| 2000-09-01 | EWA | ETF | 10.0625 | 10.1875 | 10.0625 | 10.0625 | 18500.0 |
| 2000-09-01 | EWC | ETF | 17.0625 | 17.25 | 17.0625 | 17.25 | 28700.0 |
| 2000-09-01 | EWD | ETF | 24.75 | 25.125 | 24.6875 | 25.0 | 42300.0 |
| 2000-09-01 | EWG | ETF | 21.125 | 21.3125 | 20.9375 | 21.0625 | 70100.0 |
| 2000-09-01 | EWH | ETF | 13.4375 | 13.625 | 13.375 | 13.5 | 56200.0 |
| 2000-09-01 | EWI | ETF | 45.5 | 46.0 | 45.5 | 46.0 | 28700.0 |
| 2000-09-01 | EWJ | ETF | 55.75 | 56.5 | 55.75 | 56.25 | 80850.0 |
| 2000-09-01 | EWK | ETF | 13.5 | 13.5 | 13.25 | 13.3125 | 2900.0 |
| 2000-09-01 | EWL | ETF | 15.625 | 16.0 | 15.625 | 15.9375 | 32200.0 |
| 2000-09-01 | EWM | ETF | 23.0 | 23.5 | 22.75 | 23.0 | 23950.0 |
| 2000-09-01 | EWN | ETF | 24.125 | 24.1875 | 23.875 | 24.0 | 24600.0 |
| 2000-09-01 | EWO | ETF | 7.6875 | 7.875 | 7.6875 | 7.875 | 18700.0 |
| 2000-09-01 | EWP | ETF | 24.625 | 25.1875 | 24.625 | 25.1875 | 22400.0 |
| 2000-09-01 | EWQ | ETF | 27.375 | 27.5625 | 27.25 | 27.5625 | 42200.0 |
| 2000-09-01 | EWS | ETF | 15.125 | 15.25 | 15.125 | 15.125 | 62100.0 |
| 2000-09-01 | EWT | ETF | 33.0 | 33.0 | 32.75 | 32.75 | 1900.0 |
| 2000-09-01 | EWU | ETF | 37.5 | 38.0 | 37.5 | 38.0 | 27300.0 |
| 2000-09-01 | EWW | ETF | 16.5625 | 17.0 | 16.5625 | 17.0 | 154100.0 |
| 2000-09-01 | EWY | ETF | 18.875 | 18.875 | 18.8125 | 18.8125 | 11100.0 |
| 2000-09-01 | EWZ | ETF | 19.75 | 19.75 | 19.75 | 19.75 | 4900.0 |
| 2000-09-01 | FCTR | ETF | 16.125 | 16.125 | 15.875 | 16.0625 | 57000.0 |
| 2000-09-01 | FMAR | ETF | 5.31 | 5.38 | 5.25 | 5.25 | 3500.0 |
| 2000-09-01 | GLDB | ETF | 5.375 | 5.375 | 5.25 | 5.3125 | 32200.0 |
| 2000-09-01 | GSIG | ETF | 26.75 | 28.0 | 26.75 | 27.37 | 428200.0 |
| 2000-09-01 | IDU | ETF | 39.9375 | 40.0859 | 39.8281 | 40.0625 | 5200.0 |
| 2000-09-01 | IEV | ETF | 40.3438 | 40.375 | 40.3438 | 40.375 | 4800.0 |
| 2000-09-01 | IGLD | ETF | 550.0 | 587.5 | 537.5 | 587.5 | 1448.0 |
| 2000-09-01 | IJH | ETF | 10.9688 | 10.9922 | 10.9344 | 10.9875 | 253000.0 |
| 2000-09-01 | IJJ | ETF | 19.5273 | 19.5664 | 19.4648 | 19.5664 | 10800.0 |
| 2000-09-01 | IJK | ETF | 18.9375 | 18.9375 | 18.752 | 18.9336 | 86400.0 |
| 2000-09-01 | IJR | ETF | 18.7292 | 18.7344 | 18.5938 | 18.7136 | 601800.0 |
| 2000-09-01 | IJS | ETF | 18.1094 | 18.125 | 18.1094 | 18.125 | 43200.0 |
| 2000-09-01 | IJT | ETF | 22.4375 | 22.4375 | 22.336 | 22.4062 | 52800.0 |
| 2000-09-01 | IUSG | ETF | 35.9844 | 35.9844 | 35.9844 | 35.9844 | 400.0 |
| 2000-09-01 | IVE | ETF | 63.375 | 63.4844 | 63.375 | 63.4062 | 90700.0 |
| 2000-09-01 | IVV | ETF | 153.0312 | 153.4688 | 152.1875 | 152.2969 | 278000.0 |
| 2000-09-01 | IVW | ETF | 23.0586 | 23.0586 | 22.9375 | 22.961 | 315200.0 |
| 2000-09-01 | IWB | ETF | 81.625 | 81.6406 | 81.25 | 81.5469 | 1000.0 |
| 2000-09-01 | IWD | ETF | 57.9375 | 58.0 | 57.625 | 57.875 | 28600.0 |
> showing 50 of 82 rows — these rows as CSV