PREVIEW / etf_daily / 2000-05-25
file: by_date/etf_daily/2000/2000-05-25.parquet size: 7 KB rows: 50
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-25 | SPY | ETF | 140.6875 | 141.8125 | 137.7188 | 137.8438 | 8278900.0 |
| 2000-05-25 | QQQ | ETF | 80.25 | 82.25 | 76.5 | 77.75 | 29632700.0 |
| 2000-05-25 | DIA | ETF | 105.7188 | 105.8125 | 102.5625 | 103.5 | 1199600.0 |
| 2000-05-25 | BBH | ETF | 42.3333 | 43.3333 | 41.1667 | 41.375 | 2358600.0 |
| 2000-05-25 | BITS | ETF | 18.875 | 19.75 | 18.5 | 19.0 | 13425.0 |
| 2000-05-25 | CEF | ETF | 3.375 | 3.4375 | 3.375 | 3.4375 | 55200.0 |
| 2000-05-25 | CHB | ETF | 5.94 | 6.0 | 5.69 | 5.75 | 119400.0 |
| 2000-05-25 | CNXT | ETF | 35.31 | 37.44 | 34.0 | 34.44 | 6156330.0 |
| 2000-05-25 | EWA | ETF | 9.3125 | 9.375 | 9.1875 | 9.1875 | 30800.0 |
| 2000-05-25 | EWC | ETF | 18.125 | 18.3125 | 18.125 | 18.1875 | 20100.0 |
| 2000-05-25 | EWD | ETF | 30.1875 | 30.625 | 30.1875 | 30.5 | 3100.0 |
| 2000-05-25 | EWG | ETF | 23.1875 | 23.3125 | 23.0 | 23.0625 | 58700.0 |
| 2000-05-25 | EWH | ETF | 11.3125 | 11.375 | 11.0 | 11.0 | 55200.0 |
| 2000-05-25 | EWI | ETF | 46.5 | 47.25 | 46.5 | 46.875 | 6400.0 |
| 2000-05-25 | EWJ | ETF | 57.75 | 58.25 | 57.0 | 57.0 | 39875.0 |
| 2000-05-25 | EWK | ETF | 12.6875 | 12.8125 | 12.625 | 12.625 | 2400.0 |
| 2000-05-25 | EWL | ETF | 15.5625 | 15.75 | 15.5625 | 15.75 | 5200.0 |
| 2000-05-25 | EWM | ETF | 27.25 | 27.5 | 27.0 | 27.0 | 62550.0 |
| 2000-05-25 | EWN | ETF | 22.875 | 23.0625 | 22.8125 | 22.8125 | 3500.0 |
| 2000-05-25 | EWO | ETF | 7.5 | 7.625 | 7.4375 | 7.625 | 12300.0 |
| 2000-05-25 | EWP | ETF | 24.875 | 25.1875 | 24.625 | 24.9375 | 3100.0 |
| 2000-05-25 | EWQ | ETF | 25.75 | 25.9375 | 25.6875 | 25.75 | 26000.0 |
| 2000-05-25 | EWS | ETF | 12.875 | 13.375 | 12.875 | 13.0 | 42650.0 |
| 2000-05-25 | EWU | ETF | 36.25 | 36.875 | 36.25 | 36.75 | 16200.0 |
| 2000-05-25 | EWW | ETF | 14.875 | 14.875 | 14.375 | 14.375 | 4200.0 |
| 2000-05-25 | EWY | ETF | 18.125 | 18.3125 | 17.875 | 17.875 | 44300.0 |
| 2000-05-25 | FCTR | ETF | 15.0 | 15.25 | 14.875 | 14.875 | 22200.0 |
| 2000-05-25 | FMAR | ETF | 6.0 | 6.44 | 5.38 | 6.0 | 9100.0 |
| 2000-05-25 | GLDB | ETF | 6.0625 | 6.0625 | 5.875 | 5.9375 | 11600.0 |
| 2000-05-25 | GSIG | ETF | 19.37 | 19.5 | 17.81 | 18.12 | 447100.0 |
| 2000-05-25 | IGLD | ETF | 868.75 | 868.75 | 800.0 | 800.0 | 635.0 |
| 2000-05-25 | IVV | ETF | 140.0312 | 140.9375 | 137.875 | 138.4688 | 69600.0 |
| 2000-05-25 | IWB | ETF | 74.2656 | 74.3594 | 72.9219 | 72.9219 | 2100.0 |
| 2000-05-25 | IYW | ETF | 27.5938 | 27.6172 | 26.4375 | 26.4375 | 64800.0 |
| 2000-05-25 | KTEC | ETF | 8.25 | 8.5625 | 8.25 | 8.25 | 12300.0 |
| 2000-05-25 | MDY | ETF | 85.375 | 86.1875 | 84.0938 | 84.25 | 929000.0 |
| 2000-05-25 | MIG | ETF | 5.125 | 5.125 | 5.0625 | 5.0625 | 12400.0 |
| 2000-05-25 | PPH | ETF | 50.125 | 50.4688 | 49.5938 | 50.4375 | 86200.0 |
| 2000-05-25 | SFY | ETF | 23.0 | 23.1875 | 22.5 | 23.1875 | 128000.0 |
| 2000-05-25 | TDSC | ETF | 5.22 | 5.72 | 5.19 | 5.47 | 328200.0 |
| 2000-05-25 | TINY | ETF | 6.0 | 6.47 | 5.53 | 5.56 | 71600.0 |
| 2000-05-25 | XLB | ETF | 11.2266 | 11.2266 | 10.8594 | 10.9375 | 79400.0 |
| 2000-05-25 | XLE | ETF | 15.75 | 15.75 | 15.2969 | 15.4375 | 663600.0 |
| 2000-05-25 | XLF | ETF | 20.2452 | 20.3341 | 19.5725 | 19.7756 | 532777.0 |
| 2000-05-25 | XLI | ETF | 29.75 | 29.75 | 28.9375 | 28.9375 | 51700.0 |
| 2000-05-25 | XLK | ETF | 24.3438 | 24.5781 | 23.3438 | 23.5156 | 1212200.0 |
| 2000-05-25 | XLP | ETF | 24.0781 | 24.3438 | 23.9688 | 24.2344 | 85400.0 |
| 2000-05-25 | XLU | ETF | 14.0312 | 14.0312 | 13.7578 | 13.7578 | 50000.0 |
| 2000-05-25 | XLV | ETF | 28.5 | 28.6875 | 28.25 | 28.25 | 112100.0 |
| 2000-05-25 | XLY | ETF | 13.5938 | 13.6406 | 13.4219 | 13.4219 | 42000.0 |
> showing 50 of 50 rows — these rows as CSV