PREVIEW / etf_daily / 2000-03-30
file: by_date/etf_daily/2000/2000-03-30.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-30 | SPY | ETF | 150.1562 | 151.9219 | 147.125 | 148.6875 | 9491900.0 |
| 2000-03-30 | QQQ | ETF | 107.25 | 112.75 | 103.5 | 107.25 | 42328700.0 |
| 2000-03-30 | DIA | ETF | 109.875 | 111.5 | 108.875 | 110.0625 | 3573300.0 |
| 2000-03-30 | BBH | ETF | 53.8958 | 55.625 | 51.0833 | 52.9167 | 2902200.0 |
| 2000-03-30 | BITS | ETF | 48.0 | 54.0 | 45.25 | 50.0 | 76025.0 |
| 2000-03-30 | CEF | ETF | 3.5 | 3.5625 | 3.5 | 3.5 | 11600.0 |
| 2000-03-30 | CHB | ETF | 6.06 | 6.25 | 6.0 | 6.19 | 148300.0 |
| 2000-03-30 | CNXT | ETF | 70.12 | 76.75 | 69.0 | 71.25 | 4988970.0 |
| 2000-03-30 | CSB | ETF | 4.09999990463257 | 4.09999990463257 | 4.09999990463257 | 4.09999990463257 | 3600.0 |
| 2000-03-30 | EWA | ETF | 10.25 | 10.5 | 10.25 | 10.3125 | 15300.0 |
| 2000-03-30 | EWC | ETF | 18.4375 | 18.4375 | 18.125 | 18.125 | 12500.0 |
| 2000-03-30 | EWD | ETF | 33.4375 | 34.125 | 33.4375 | 33.5 | 17700.0 |
| 2000-03-30 | EWG | ETF | 27.0 | 27.3125 | 26.875 | 27.125 | 63100.0 |
| 2000-03-30 | EWH | ETF | 13.5625 | 13.75 | 13.375 | 13.5 | 63900.0 |
| 2000-03-30 | EWI | ETF | 49.625 | 50.125 | 49.625 | 50.125 | 8450.0 |
| 2000-03-30 | EWJ | ETF | 63.5 | 64.0 | 63.0 | 63.5 | 101675.0 |
| 2000-03-30 | EWK | ETF | 12.5625 | 12.625 | 12.5625 | 12.625 | 13800.0 |
| 2000-03-30 | EWL | ETF | 15.0 | 15.3125 | 15.0 | 15.3125 | 11500.0 |
| 2000-03-30 | EWM | ETF | 28.0 | 28.0 | 27.5 | 27.75 | 22825.0 |
| 2000-03-30 | EWN | ETF | 24.125 | 24.125 | 24.0 | 24.0625 | 5000.0 |
| 2000-03-30 | EWO | ETF | 7.75 | 7.75 | 7.625 | 7.75 | 10700.0 |
| 2000-03-30 | EWP | ETF | 28.5 | 28.6875 | 28.375 | 28.625 | 6800.0 |
| 2000-03-30 | EWQ | ETF | 28.0 | 28.25 | 27.9375 | 28.1875 | 35000.0 |
| 2000-03-30 | EWS | ETF | 15.125 | 15.125 | 14.5 | 14.875 | 17450.0 |
| 2000-03-30 | EWU | ETF | 39.875 | 40.25 | 39.625 | 39.875 | 33850.0 |
| 2000-03-30 | EWW | ETF | 18.9375 | 19.0 | 18.25 | 18.5625 | 91800.0 |
| 2000-03-30 | FCTR | ETF | 12.625 | 12.75 | 12.5 | 12.5 | 6300.0 |
| 2000-03-30 | FMAR | ETF | 5.87 | 6.5 | 5.87 | 6.0 | 5500.0 |
| 2000-03-30 | GLDB | ETF | 7.125 | 7.125 | 6.75 | 6.9375 | 104400.0 |
| 2000-03-30 | GSIG | ETF | 17.75 | 18.0 | 14.5 | 15.5 | 628500.0 |
| 2000-03-30 | IGLD | ETF | 2025.0 | 2100.0 | 1650.0 | 1775.0 | 2777.0 |
| 2000-03-30 | KTEC | ETF | 8.875 | 9.125 | 8.875 | 9.125 | 13800.0 |
| 2000-03-30 | MDY | ETF | 89.25 | 90.4375 | 87.125 | 88.125 | 1116000.0 |
| 2000-03-30 | MIG | ETF | 5.8125 | 5.8125 | 5.125 | 5.125 | 10600.0 |
| 2000-03-30 | PPH | ETF | 42.625 | 43.375 | 42.5 | 42.5312 | 153200.0 |
| 2000-03-30 | SFY | ETF | 15.375 | 16.5 | 15.375 | 16.25 | 159900.0 |
| 2000-03-30 | TDSC | ETF | 5.19 | 5.375 | 4.25 | 5.0 | 279400.0 |
| 2000-03-30 | TINY | ETF | 17.88 | 18.94 | 17.0 | 18.5 | 213800.0 |
| 2000-03-30 | XLB | ETF | 11.2578 | 11.6484 | 11.1875 | 11.5312 | 207200.0 |
| 2000-03-30 | XLE | ETF | 14.8594 | 15.1094 | 14.6094 | 14.7344 | 355800.0 |
| 2000-03-30 | XLF | ETF | 19.7248 | 19.801 | 19.4202 | 19.5852 | 511727.0 |
| 2000-03-30 | XLI | ETF | 29.0 | 29.4531 | 28.9688 | 29.1562 | 9300.0 |
| 2000-03-30 | XLK | ETF | 30.3438 | 30.9219 | 28.875 | 29.7188 | 9271600.0 |
| 2000-03-30 | XLP | ETF | 20.9688 | 21.5 | 20.9688 | 21.3281 | 62200.0 |
| 2000-03-30 | XLU | ETF | 13.3125 | 13.4297 | 13.2734 | 13.289 | 67200.0 |
| 2000-03-30 | XLV | ETF | 30.5 | 30.625 | 29.9844 | 30.125 | 14000.0 |
| 2000-03-30 | XLY | ETF | 14.7656 | 14.9453 | 14.6875 | 14.789 | 45000.0 |
> showing 47 of 47 rows — these rows as CSV