PREVIEW / etf_daily / 2000-05-24
file: by_date/etf_daily/2000/2000-05-24.parquet size: 7 KB rows: 51
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-05-24 | SPY | ETF | 138.0 | 140.6875 | 136.5 | 140.25 | 11081500.0 |
| 2000-05-24 | QQQ | ETF | 75.0 | 79.875 | 72.25 | 79.5 | 49476000.0 |
| 2000-05-24 | DIA | ETF | 104.7344 | 105.6875 | 103.4688 | 105.4375 | 1256700.0 |
| 2000-05-24 | BBH | ETF | 40.375 | 41.0 | 37.75 | 41.0 | 3525300.0 |
| 2000-05-24 | BITS | ETF | 20.5 | 21.25 | 18.5 | 19.0 | 53550.0 |
| 2000-05-24 | BOSS | ETF | 14.2 | 14.5 | 14.2 | 14.5 | 100.0 |
| 2000-05-24 | CEF | ETF | 3.375 | 3.5 | 3.375 | 3.375 | 22600.0 |
| 2000-05-24 | CHB | ETF | 5.88 | 6.0 | 5.75 | 5.75 | 82500.0 |
| 2000-05-24 | CNXT | ETF | 34.56 | 35.63 | 31.25 | 34.94 | 7325630.0 |
| 2000-05-24 | EWA | ETF | 9.375 | 9.5 | 9.125 | 9.5 | 5100.0 |
| 2000-05-24 | EWC | ETF | 17.875 | 17.875 | 17.75 | 17.75 | 1400.0 |
| 2000-05-24 | EWD | ETF | 29.4375 | 29.75 | 29.3125 | 29.5 | 6000.0 |
| 2000-05-24 | EWG | ETF | 22.875 | 23.1875 | 22.875 | 23.125 | 80800.0 |
| 2000-05-24 | EWH | ETF | 11.3125 | 11.5 | 11.25 | 11.5 | 77300.0 |
| 2000-05-24 | EWI | ETF | 45.625 | 46.5 | 45.625 | 46.25 | 9850.0 |
| 2000-05-24 | EWJ | ETF | 56.75 | 57.5 | 56.75 | 57.5 | 73925.0 |
| 2000-05-24 | EWK | ETF | 12.8125 | 12.8125 | 12.5625 | 12.5625 | 3500.0 |
| 2000-05-24 | EWL | ETF | 15.5 | 15.5 | 15.25 | 15.375 | 4900.0 |
| 2000-05-24 | EWM | ETF | 27.0 | 27.0 | 26.75 | 27.0 | 59050.0 |
| 2000-05-24 | EWN | ETF | 22.875 | 23.5 | 22.75 | 23.5 | 4000.0 |
| 2000-05-24 | EWO | ETF | 7.625 | 7.6875 | 7.5 | 7.5 | 62600.0 |
| 2000-05-24 | EWP | ETF | 24.375 | 24.75 | 24.375 | 24.75 | 4400.0 |
| 2000-05-24 | EWQ | ETF | 25.6875 | 25.75 | 25.4375 | 25.5625 | 31000.0 |
| 2000-05-24 | EWS | ETF | 13.0 | 13.25 | 13.0 | 13.125 | 12500.0 |
| 2000-05-24 | EWU | ETF | 36.125 | 37.0 | 36.125 | 36.5 | 7500.0 |
| 2000-05-24 | EWW | ETF | 14.1875 | 14.6875 | 13.9375 | 14.6875 | 12400.0 |
| 2000-05-24 | EWY | ETF | 17.6875 | 17.6875 | 17.5625 | 17.6875 | 10600.0 |
| 2000-05-24 | FCTR | ETF | 14.75 | 15.25 | 14.75 | 15.25 | 32600.0 |
| 2000-05-24 | FMAR | ETF | 5.69 | 6.0 | 5.56 | 6.0 | 1400.0 |
| 2000-05-24 | GLDB | ETF | 5.9375 | 6.125 | 5.875 | 5.9688 | 22700.0 |
| 2000-05-24 | GSIG | ETF | 19.25 | 19.87 | 17.0 | 18.87 | 510100.0 |
| 2000-05-24 | IGLD | ETF | 875.0 | 900.0 | 850.0 | 862.5 | 703.0 |
| 2000-05-24 | IVV | ETF | 137.75 | 140.0625 | 136.6562 | 139.75 | 400300.0 |
| 2000-05-24 | IWB | ETF | 72.8906 | 73.4688 | 72.0 | 73.4688 | 17900.0 |
| 2000-05-24 | IYW | ETF | 25.7344 | 26.8125 | 24.875 | 26.8125 | 96400.0 |
| 2000-05-24 | KTEC | ETF | 8.3125 | 8.3125 | 8.25 | 8.25 | 4800.0 |
| 2000-05-24 | MDY | ETF | 83.875 | 85.1875 | 82.2188 | 85.0 | 1887000.0 |
| 2000-05-24 | MIG | ETF | 5.1875 | 5.1875 | 5.1875 | 5.1875 | 200.0 |
| 2000-05-24 | PPH | ETF | 49.5 | 50.4375 | 49.4688 | 50.1875 | 212400.0 |
| 2000-05-24 | SFY | ETF | 23.125 | 23.125 | 21.125 | 22.9375 | 465900.0 |
| 2000-05-24 | TDSC | ETF | 5.19 | 5.25 | 5.19 | 5.22 | 121600.0 |
| 2000-05-24 | TINY | ETF | 6.31 | 6.31 | 5.5 | 5.97 | 122600.0 |
| 2000-05-24 | XLB | ETF | 11.2812 | 11.4453 | 11.25 | 11.3516 | 89400.0 |
| 2000-05-24 | XLE | ETF | 15.6875 | 15.8047 | 15.5312 | 15.7266 | 129600.0 |
| 2000-05-24 | XLF | ETF | 19.9152 | 20.461 | 19.9152 | 20.2833 | 332616.0 |
| 2000-05-24 | XLI | ETF | 29.0 | 29.4688 | 29.0 | 29.4688 | 3800.0 |
| 2000-05-24 | XLK | ETF | 23.25 | 24.0 | 22.3438 | 23.9062 | 1427200.0 |
| 2000-05-24 | XLP | ETF | 24.0312 | 24.375 | 23.9062 | 24.2969 | 24700.0 |
| 2000-05-24 | XLU | ETF | 13.914 | 14.086 | 13.8984 | 13.9922 | 29400.0 |
| 2000-05-24 | XLV | ETF | 28.8125 | 28.8125 | 28.0781 | 28.4688 | 7800.0 |
> showing 50 of 51 rows — these rows as CSV