PREVIEW / etf_daily / 2000-03-08
file: by_date/etf_daily/2000/2000-03-08.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-03-08 | SPY | ETF | 136.4688 | 137.8438 | 135.0312 | 136.875 | 11808500.0 |
| 2000-03-08 | QQQ | ETF | 55.5 | 56.0 | 53.1406 | 55.625 | 43512600.0 |
| 2000-03-08 | DIA | ETF | 98.75 | 99.375 | 97.1562 | 98.4688 | 2618900.0 |
| 2000-03-08 | BBH | ETF | 75.6667 | 75.9167 | 70.8958 | 73.0833 | 2617200.0 |
| 2000-03-08 | BITS | ETF | 37.75 | 38.5 | 32.125 | 34.75 | 79750.0 |
| 2000-03-08 | BOSS | ETF | 11.1 | 11.1 | 11.1 | 11.1 | 200.0 |
| 2000-03-08 | CEF | ETF | 3.625 | 3.6875 | 3.5 | 3.5 | 42400.0 |
| 2000-03-08 | CHB | ETF | 6.0 | 6.0 | 5.75 | 5.75 | 50400.0 |
| 2000-03-08 | CNXT | ETF | 99.25 | 99.38 | 88.87 | 92.06 | 5127880.0 |
| 2000-03-08 | CSB | ETF | 3.90000009536743 | 4.0 | 3.90000009536743 | 4.0 | 3500.0 |
| 2000-03-08 | EWA | ETF | 10.375 | 10.375 | 10.1875 | 10.375 | 11500.0 |
| 2000-03-08 | EWC | ETF | 17.375 | 17.625 | 17.375 | 17.625 | 11600.0 |
| 2000-03-08 | EWD | ETF | 36.0 | 36.0 | 35.25 | 35.8125 | 6000.0 |
| 2000-03-08 | EWG | ETF | 28.625 | 28.875 | 28.3125 | 28.875 | 34400.0 |
| 2000-03-08 | EWH | ETF | 14.0 | 14.125 | 13.875 | 14.0625 | 68900.0 |
| 2000-03-08 | EWI | ETF | 53.25 | 53.875 | 53.25 | 53.375 | 3100.0 |
| 2000-03-08 | EWJ | ETF | 60.25 | 60.75 | 60.0 | 60.75 | 61925.0 |
| 2000-03-08 | EWK | ETF | 12.1875 | 12.5 | 12.1875 | 12.5 | 5300.0 |
| 2000-03-08 | EWL | ETF | 14.625 | 14.6875 | 14.3125 | 14.6875 | 17900.0 |
| 2000-03-08 | EWM | ETF | 28.0 | 28.5 | 28.0 | 28.25 | 17075.0 |
| 2000-03-08 | EWO | ETF | 7.0625 | 7.25 | 7.0625 | 7.25 | 23800.0 |
| 2000-03-08 | EWP | ETF | 29.0 | 29.3125 | 28.75 | 29.1875 | 3300.0 |
| 2000-03-08 | EWQ | ETF | 28.5 | 28.625 | 28.1875 | 28.625 | 60100.0 |
| 2000-03-08 | EWS | ETF | 14.125 | 14.5 | 14.0 | 14.125 | 84700.0 |
| 2000-03-08 | EWU | ETF | 39.25 | 39.25 | 38.375 | 38.875 | 115550.0 |
| 2000-03-08 | EWW | ETF | 20.0 | 20.5625 | 20.0 | 20.25 | 32700.0 |
| 2000-03-08 | FCTR | ETF | 13.0 | 13.4375 | 12.875 | 13.125 | 11700.0 |
| 2000-03-08 | FMAR | ETF | 6.5 | 6.66 | 6.5 | 6.66 | 900.0 |
| 2000-03-08 | GLDB | ETF | 7.5 | 7.5 | 7.125 | 7.25 | 67200.0 |
| 2000-03-08 | GSIG | ETF | 22.28 | 22.87 | 19.75 | 22.5 | 1152000.0 |
| 2000-03-08 | IGLD | ETF | 2525.0 | 2562.5 | 2300.0 | 2350.0 | 834.0 |
| 2000-03-08 | KTEC | ETF | 8.875 | 9.5 | 8.875 | 8.875 | 14100.0 |
| 2000-03-08 | MDY | ETF | 88.0 | 88.4375 | 85.4375 | 87.25 | 888600.0 |
| 2000-03-08 | MIG | ETF | 5.875 | 6.0 | 5.75 | 6.0 | 8800.0 |
| 2000-03-08 | PPH | ETF | 37.1875 | 39.2188 | 36.9375 | 38.625 | 848800.0 |
| 2000-03-08 | SFY | ETF | 13.375 | 13.4375 | 12.9375 | 13.25 | 160600.0 |
| 2000-03-08 | TDSC | ETF | 6.0 | 6.44 | 5.0 | 5.69 | 543600.0 |
| 2000-03-08 | TINY | ETF | 33.88 | 34.12 | 28.56 | 30.25 | 493600.0 |
| 2000-03-08 | XLB | ETF | 9.9062 | 10.1484 | 9.8438 | 10.1172 | 225200.0 |
| 2000-03-08 | XLE | ETF | 13.875 | 14.4219 | 13.875 | 14.0469 | 2178800.0 |
| 2000-03-08 | XLF | ETF | 16.0693 | 16.247 | 15.8408 | 16.1454 | 649229.0 |
| 2000-03-08 | XLI | ETF | 25.1406 | 25.4531 | 25.0 | 25.4531 | 350700.0 |
| 2000-03-08 | XLK | ETF | 28.7812 | 29.0625 | 28.25 | 28.9375 | 2179200.0 |
| 2000-03-08 | XLP | ETF | 18.9375 | 19.5 | 18.6094 | 19.2969 | 309900.0 |
| 2000-03-08 | XLU | ETF | 12.461 | 12.961 | 12.461 | 12.6875 | 49800.0 |
| 2000-03-08 | XLV | ETF | 27.3125 | 27.6875 | 27.3125 | 27.4219 | 184000.0 |
| 2000-03-08 | XLY | ETF | 12.0469 | 12.4531 | 12.0156 | 12.4062 | 344400.0 |
> showing 47 of 47 rows — these rows as CSV