PREVIEW / etf_daily / 2000-03-03
file: by_date/etf_daily/2000/2000-03-03.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-03-03 | SPY | ETF | 140.4375 | 141.7188 | 139.7188 | 141.125 | 12770300.0 |
| 2000-03-03 | QQQ | ETF | 54.0 | 55.5625 | 53.5 | 55.5312 | 32017200.0 |
| 2000-03-03 | DIA | ETF | 103.3438 | 104.5469 | 103.0 | 103.875 | 1678200.0 |
| 2000-03-03 | BBH | ETF | 76.9583 | 81.1667 | 76.7083 | 80.9167 | 1995300.0 |
| 2000-03-03 | BITS | ETF | 32.0 | 42.5 | 32.0 | 36.5 | 257025.0 |
| 2000-03-03 | CEF | ETF | 3.5 | 3.5 | 3.4375 | 3.4375 | 11600.0 |
| 2000-03-03 | CHB | ETF | 6.19 | 6.44 | 5.94 | 6.19 | 115900.0 |
| 2000-03-03 | CNXT | ETF | 84.94 | 94.5 | 82.25 | 93.69 | 12752070.0 |
| 2000-03-03 | EWA | ETF | 10.6875 | 10.6875 | 10.4375 | 10.6875 | 18400.0 |
| 2000-03-03 | EWC | ETF | 18.125 | 18.125 | 17.875 | 17.875 | 12200.0 |
| 2000-03-03 | EWD | ETF | 36.75 | 37.1875 | 36.25 | 37.125 | 12900.0 |
| 2000-03-03 | EWG | ETF | 28.9375 | 29.3125 | 28.875 | 29.0625 | 43100.0 |
| 2000-03-03 | EWH | ETF | 13.3125 | 13.625 | 13.3125 | 13.5625 | 168700.0 |
| 2000-03-03 | EWI | ETF | 54.875 | 55.0 | 54.5 | 54.5 | 7550.0 |
| 2000-03-03 | EWJ | ETF | 60.75 | 61.5 | 60.75 | 61.25 | 73225.0 |
| 2000-03-03 | EWK | ETF | 12.5625 | 12.8125 | 12.5 | 12.6875 | 5900.0 |
| 2000-03-03 | EWL | ETF | 14.875 | 15.0 | 14.5625 | 14.6875 | 35400.0 |
| 2000-03-03 | EWM | ETF | 27.75 | 28.5 | 27.75 | 28.0 | 26900.0 |
| 2000-03-03 | EWN | ETF | 24.5 | 24.5625 | 24.0 | 24.1875 | 14400.0 |
| 2000-03-03 | EWO | ETF | 7.625 | 7.6875 | 7.4375 | 7.4375 | 25100.0 |
| 2000-03-03 | EWP | ETF | 29.5 | 29.6875 | 29.375 | 29.4375 | 12700.0 |
| 2000-03-03 | EWQ | ETF | 29.5 | 29.5 | 29.25 | 29.375 | 37200.0 |
| 2000-03-03 | EWS | ETF | 14.25 | 14.75 | 14.25 | 14.5 | 61800.0 |
| 2000-03-03 | EWU | ETF | 39.625 | 40.25 | 39.25 | 39.75 | 51950.0 |
| 2000-03-03 | EWW | ETF | 20.0 | 20.25 | 19.5625 | 19.9375 | 70100.0 |
| 2000-03-03 | FCTR | ETF | 13.0 | 13.5 | 13.0 | 13.0 | 19100.0 |
| 2000-03-03 | FMAR | ETF | 6.69 | 7.06 | 6.5 | 6.5 | 3600.0 |
| 2000-03-03 | GLDB | ETF | 7.8125 | 7.875 | 7.75 | 7.875 | 53000.0 |
| 2000-03-03 | GSIG | ETF | 25.5 | 25.75 | 24.37 | 25.62 | 893800.0 |
| 2000-03-03 | IGLD | ETF | 2343.75 | 3006.25 | 2318.75 | 2587.5 | 4295.0 |
| 2000-03-03 | KTEC | ETF | 9.0 | 9.125 | 8.9375 | 9.125 | 6600.0 |
| 2000-03-03 | MDY | ETF | 86.6875 | 88.25 | 86.4375 | 88.0938 | 658700.0 |
| 2000-03-03 | MIG | ETF | 5.9375 | 6.25 | 5.875 | 6.25 | 14200.0 |
| 2000-03-03 | PPH | ETF | 39.5312 | 39.9375 | 39.25 | 39.25 | 333000.0 |
| 2000-03-03 | SFY | ETF | 12.5625 | 12.625 | 12.0 | 12.5 | 70300.0 |
| 2000-03-03 | TDSC | ETF | 5.81 | 6.375 | 5.78 | 6.36 | 473800.0 |
| 2000-03-03 | TINY | ETF | 23.0 | 25.06 | 22.94 | 24.0 | 351700.0 |
| 2000-03-03 | XLB | ETF | 10.25 | 10.7656 | 10.25 | 10.4844 | 324800.0 |
| 2000-03-03 | XLE | ETF | 13.625 | 13.625 | 13.2969 | 13.4375 | 1223400.0 |
| 2000-03-03 | XLF | ETF | 17.2116 | 17.2116 | 16.8562 | 17.0085 | 418417.0 |
| 2000-03-03 | XLI | ETF | 26.0312 | 26.6094 | 26.0156 | 26.3438 | 41200.0 |
| 2000-03-03 | XLK | ETF | 29.0 | 29.4062 | 28.6875 | 29.289 | 803200.0 |
| 2000-03-03 | XLP | ETF | 20.4375 | 20.5 | 20.1875 | 20.2656 | 220900.0 |
| 2000-03-03 | XLU | ETF | 13.2578 | 13.3047 | 13.1172 | 13.1172 | 91200.0 |
| 2000-03-03 | XLV | ETF | 28.4688 | 28.7031 | 28.3438 | 28.6406 | 372700.0 |
| 2000-03-03 | XLY | ETF | 12.875 | 13.0 | 12.8203 | 12.914 | 416000.0 |
> showing 46 of 46 rows — these rows as CSV