PREVIEW / etf_daily / 2000-04-05
file: by_date/etf_daily/2000/2000-04-05.parquet size: 6 KB rows: 47
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-04-05 | SPY | ETF | 147.875 | 150.8125 | 147.625 | 149.1875 | 8387200.0 |
| 2000-04-05 | QQQ | ETF | 97.5 | 103.9375 | 96.25 | 100.125 | 37009800.0 |
| 2000-04-05 | DIA | ETF | 110.3125 | 112.3125 | 109.8906 | 110.375 | 3400700.0 |
| 2000-04-05 | BBH | ETF | 50.5 | 59.5833 | 50.5 | 56.4167 | 5545800.0 |
| 2000-04-05 | BITS | ETF | 39.0 | 42.0 | 36.25 | 38.75 | 73825.0 |
| 2000-04-05 | BOSS | ETF | 13.1 | 13.1 | 13.1 | 13.1 | 200.0 |
| 2000-04-05 | CEF | ETF | 3.5 | 3.5 | 3.4375 | 3.5 | 34800.0 |
| 2000-04-05 | CHB | ETF | 6.13 | 6.31 | 6.06 | 6.25 | 312500.0 |
| 2000-04-05 | CNXT | ETF | 58.0 | 71.37 | 56.81 | 63.19 | 9323160.0 |
| 2000-04-05 | EWA | ETF | 10.0625 | 10.25 | 10.0 | 10.0 | 5200.0 |
| 2000-04-05 | EWC | ETF | 17.75 | 18.0 | 17.75 | 18.0 | 21300.0 |
| 2000-04-05 | EWD | ETF | 32.25 | 33.0 | 32.25 | 32.75 | 1300.0 |
| 2000-04-05 | EWG | ETF | 25.6875 | 26.4375 | 25.6875 | 26.375 | 248800.0 |
| 2000-04-05 | EWH | ETF | 12.875 | 13.1875 | 12.875 | 13.0625 | 41200.0 |
| 2000-04-05 | EWI | ETF | 48.625 | 48.875 | 48.25 | 48.375 | 18700.0 |
| 2000-04-05 | EWJ | ETF | 63.25 | 64.0 | 63.25 | 63.75 | 50850.0 |
| 2000-04-05 | EWK | ETF | 12.8125 | 13.25 | 12.8125 | 13.25 | 1800.0 |
| 2000-04-05 | EWL | ETF | 15.6875 | 15.8125 | 15.4375 | 15.6875 | 10700.0 |
| 2000-04-05 | EWM | ETF | 26.0 | 26.5 | 26.0 | 26.25 | 9700.0 |
| 2000-04-05 | EWN | ETF | 23.4375 | 23.625 | 23.25 | 23.5 | 3700.0 |
| 2000-04-05 | EWO | ETF | 7.75 | 7.75 | 7.625 | 7.625 | 5900.0 |
| 2000-04-05 | EWP | ETF | 28.0 | 28.1875 | 27.75 | 28.0 | 3100.0 |
| 2000-04-05 | EWQ | ETF | 26.625 | 27.125 | 26.625 | 27.0625 | 41300.0 |
| 2000-04-05 | EWS | ETF | 14.125 | 14.5 | 14.125 | 14.125 | 51150.0 |
| 2000-04-05 | EWU | ETF | 39.875 | 40.5 | 39.875 | 40.375 | 13900.0 |
| 2000-04-05 | EWW | ETF | 17.5625 | 18.0625 | 17.4375 | 17.9375 | 16600.0 |
| 2000-04-05 | FCTR | ETF | 12.8125 | 14.0 | 12.75 | 13.4375 | 53200.0 |
| 2000-04-05 | FMAR | ETF | 6.5 | 6.5 | 6.06 | 6.06 | 1100.0 |
| 2000-04-05 | GLDB | ETF | 6.0 | 6.5 | 6.0 | 6.375 | 55600.0 |
| 2000-04-05 | GSIG | ETF | 15.56 | 16.5 | 14.5 | 15.81 | 291700.0 |
| 2000-04-05 | IGLD | ETF | 1700.0 | 1843.75 | 1656.25 | 1775.0 | 1789.0 |
| 2000-04-05 | KTEC | ETF | 9.0 | 9.5 | 9.0 | 9.5 | 13300.0 |
| 2000-04-05 | MDY | ETF | 86.3125 | 89.0 | 85.125 | 87.3438 | 522000.0 |
| 2000-04-05 | MIG | ETF | 5.25 | 5.875 | 5.25 | 5.8125 | 12800.0 |
| 2000-04-05 | PPH | ETF | 45.5625 | 46.1562 | 45.3125 | 46.0 | 276800.0 |
| 2000-04-05 | SFY | ETF | 15.375 | 16.625 | 15.0 | 16.625 | 125000.0 |
| 2000-04-05 | TDSC | ETF | 4.875 | 5.31 | 4.75 | 5.31 | 91400.0 |
| 2000-04-05 | TINY | ETF | 10.5 | 14.5 | 9.25 | 13.19 | 463300.0 |
| 2000-04-05 | XLB | ETF | 11.9297 | 11.9844 | 11.625 | 11.6953 | 65000.0 |
| 2000-04-05 | XLE | ETF | 14.7422 | 14.7812 | 14.2812 | 14.2812 | 102600.0 |
| 2000-04-05 | XLF | ETF | 19.7502 | 20.0548 | 19.6106 | 19.6868 | 346403.0 |
| 2000-04-05 | XLI | ETF | 29.1562 | 29.2656 | 28.75 | 28.8906 | 7600.0 |
| 2000-04-05 | XLK | ETF | 28.3125 | 29.5938 | 28.0625 | 28.9062 | 1200400.0 |
| 2000-04-05 | XLP | ETF | 22.75 | 22.75 | 22.3438 | 22.5 | 38800.0 |
| 2000-04-05 | XLU | ETF | 13.9688 | 14.0703 | 13.8203 | 13.8203 | 22000.0 |
| 2000-04-05 | XLV | ETF | 30.0 | 30.3438 | 29.9219 | 30.1094 | 7100.0 |
| 2000-04-05 | XLY | ETF | 14.8047 | 14.9688 | 14.75 | 14.9062 | 24000.0 |
> showing 47 of 47 rows — these rows as CSV