PREVIEW / etf_daily / 2000-05-01
file: by_date/etf_daily/2000/2000-05-01.parquet size: 6 KB rows: 46
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-01 | SPY | ETF | 146.5625 | 148.4844 | 145.8438 | 147.0625 | 7328300.0 |
| 2000-05-01 | QQQ | ETF | 95.75 | 96.875 | 94.25 | 95.625 | 23205700.0 |
| 2000-05-01 | DIA | ETF | 107.9688 | 109.3438 | 107.1562 | 108.125 | 1385800.0 |
| 2000-05-01 | BBH | ETF | 47.3333 | 48.9792 | 46.1667 | 48.5417 | 1914300.0 |
| 2000-05-01 | BITS | ETF | 24.25 | 24.5 | 23.25 | 23.75 | 28125.0 |
| 2000-05-01 | CEF | ETF | 3.375 | 3.5 | 3.375 | 3.4375 | 59400.0 |
| 2000-05-01 | CHB | ETF | 7.25 | 7.25 | 6.13 | 6.25 | 303500.0 |
| 2000-05-01 | CNXT | ETF | 60.25 | 62.31 | 59.38 | 60.19 | 2633680.0 |
| 2000-05-01 | EWA | ETF | 9.875 | 9.875 | 9.625 | 9.8125 | 6600.0 |
| 2000-05-01 | EWC | ETF | 18.125 | 18.1875 | 18.125 | 18.1875 | 1000.0 |
| 2000-05-01 | EWD | ETF | 32.9375 | 32.9375 | 32.9375 | 32.9375 | 300.0 |
| 2000-05-01 | EWG | ETF | 24.75 | 24.9375 | 24.5625 | 24.9375 | 45500.0 |
| 2000-05-01 | EWH | ETF | 12.5625 | 12.75 | 12.5625 | 12.75 | 20300.0 |
| 2000-05-01 | EWI | ETF | 46.875 | 47.0 | 46.75 | 47.0 | 5650.0 |
| 2000-05-01 | EWJ | ETF | 61.5 | 62.25 | 61.5 | 62.25 | 54575.0 |
| 2000-05-01 | EWK | ETF | 12.25 | 12.25 | 12.0625 | 12.0625 | 1400.0 |
| 2000-05-01 | EWL | ETF | 14.75 | 14.875 | 14.625 | 14.875 | 1100.0 |
| 2000-05-01 | EWM | ETF | 24.5 | 25.75 | 24.5 | 25.75 | 9625.0 |
| 2000-05-01 | EWN | ETF | 23.0625 | 23.375 | 23.0625 | 23.375 | 400.0 |
| 2000-05-01 | EWO | ETF | 7.375 | 7.5 | 7.375 | 7.5 | 4200.0 |
| 2000-05-01 | EWP | ETF | 26.625 | 26.875 | 26.5625 | 26.875 | 1100.0 |
| 2000-05-01 | EWQ | ETF | 27.125 | 27.25 | 27.0 | 27.25 | 3000.0 |
| 2000-05-01 | EWS | ETF | 15.0 | 15.5 | 15.0 | 15.125 | 9100.0 |
| 2000-05-01 | EWU | ETF | 39.25 | 39.375 | 38.75 | 39.0 | 3000.0 |
| 2000-05-01 | EWW | ETF | 16.3125 | 16.5625 | 16.3125 | 16.375 | 5100.0 |
| 2000-05-01 | FCTR | ETF | 13.9063 | 14.0 | 13.8125 | 14.0 | 80600.0 |
| 2000-05-01 | FMAR | ETF | 5.38 | 5.87 | 5.38 | 5.75 | 22900.0 |
| 2000-05-01 | GLDB | ETF | 6.25 | 6.375 | 6.0625 | 6.375 | 71400.0 |
| 2000-05-01 | GSIG | ETF | 19.12 | 20.62 | 19.12 | 20.0 | 352200.0 |
| 2000-05-01 | IGLD | ETF | 1150.0 | 1212.5 | 1100.0 | 1100.0 | 777.0 |
| 2000-05-01 | KTEC | ETF | 7.6875 | 7.9375 | 7.6875 | 7.9375 | 10500.0 |
| 2000-05-01 | MDY | ETF | 88.9375 | 90.25 | 88.5781 | 89.625 | 687700.0 |
| 2000-05-01 | MIG | ETF | 5.375 | 5.375 | 5.1875 | 5.25 | 2400.0 |
| 2000-05-01 | PPH | ETF | 46.4375 | 47.5 | 46.2188 | 46.5625 | 97800.0 |
| 2000-05-01 | SFY | ETF | 20.6875 | 21.3125 | 20.6875 | 21.0 | 107500.0 |
| 2000-05-01 | TDSC | ETF | 5.47 | 5.5 | 5.25 | 5.375 | 101600.0 |
| 2000-05-01 | TINY | ETF | 11.44 | 11.62 | 10.81 | 10.88 | 92100.0 |
| 2000-05-01 | XLB | ETF | 11.039 | 11.1875 | 11.0 | 11.125 | 42200.0 |
| 2000-05-01 | XLE | ETF | 14.5938 | 14.7812 | 14.5156 | 14.6719 | 69400.0 |
| 2000-05-01 | XLF | ETF | 18.9886 | 19.7248 | 18.9633 | 19.4582 | 117068.0 |
| 2000-05-01 | XLI | ETF | 29.7344 | 30.3125 | 29.6094 | 30.3125 | 2000.0 |
| 2000-05-01 | XLK | ETF | 27.9062 | 28.125 | 27.625 | 27.8906 | 391600.0 |
| 2000-05-01 | XLP | ETF | 22.5 | 22.8125 | 22.1562 | 22.625 | 21200.0 |
| 2000-05-01 | XLU | ETF | 14.1172 | 14.289 | 14.1172 | 14.2422 | 55000.0 |
| 2000-05-01 | XLV | ETF | 30.4062 | 30.5625 | 30.2812 | 30.4062 | 3500.0 |
| 2000-05-01 | XLY | ETF | 14.3906 | 14.7656 | 14.3906 | 14.7656 | 13400.0 |
> showing 46 of 46 rows — these rows as CSV