PREVIEW / etf_daily / 2000-03-10
file: by_date/etf_daily/2000/2000-03-10.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-10 | SPY | ETF | 140.1875 | 142.0 | 139.5312 | 140.125 | 7924600.0 |
| 2000-03-10 | QQQ | ETF | 57.4375 | 58.2188 | 56.7539 | 57.25 | 29750600.0 |
| 2000-03-10 | DIA | ETF | 99.9062 | 101.0625 | 98.9688 | 99.5625 | 1352600.0 |
| 2000-03-10 | BBH | ETF | 71.0 | 72.3333 | 68.75 | 68.9375 | 2721000.0 |
| 2000-03-10 | BITS | ETF | 44.5 | 45.5 | 40.5 | 42.25 | 81700.0 |
| 2000-03-10 | CEF | ETF | 3.5 | 3.5625 | 3.5 | 3.5 | 12100.0 |
| 2000-03-10 | CHB | ETF | 5.63 | 5.75 | 5.38 | 5.5 | 111400.0 |
| 2000-03-10 | CNXT | ETF | 93.34 | 93.34 | 86.84 | 88.09 | 5683430.0 |
| 2000-03-10 | CSB | ETF | 4.0 | 4.0 | 3.90000009536743 | 4.0 | 26000.0 |
| 2000-03-10 | EWA | ETF | 10.375 | 10.4375 | 10.1875 | 10.25 | 10800.0 |
| 2000-03-10 | EWC | ETF | 17.0 | 17.5625 | 17.0 | 17.375 | 14800.0 |
| 2000-03-10 | EWD | ETF | 36.4375 | 36.5625 | 36.3125 | 36.375 | 4500.0 |
| 2000-03-10 | EWG | ETF | 28.4375 | 28.5 | 28.25 | 28.25 | 24800.0 |
| 2000-03-10 | EWH | ETF | 14.0625 | 14.125 | 13.9375 | 14.0 | 101200.0 |
| 2000-03-10 | EWI | ETF | 54.0 | 54.25 | 54.0 | 54.0 | 3850.0 |
| 2000-03-10 | EWJ | ETF | 59.5 | 60.0 | 59.5 | 59.75 | 80425.0 |
| 2000-03-10 | EWK | ETF | 12.0 | 12.125 | 12.0 | 12.0 | 2400.0 |
| 2000-03-10 | EWL | ETF | 14.3125 | 14.6875 | 14.3125 | 14.5625 | 47300.0 |
| 2000-03-10 | EWM | ETF | 28.75 | 29.0 | 28.5 | 28.5 | 18650.0 |
| 2000-03-10 | EWN | ETF | 23.4375 | 23.875 | 23.4375 | 23.6875 | 4400.0 |
| 2000-03-10 | EWO | ETF | 7.5625 | 7.5625 | 7.3125 | 7.5625 | 1300.0 |
| 2000-03-10 | EWP | ETF | 28.75 | 29.0625 | 28.75 | 28.8125 | 900.0 |
| 2000-03-10 | EWQ | ETF | 28.875 | 29.25 | 28.875 | 29.25 | 20100.0 |
| 2000-03-10 | EWS | ETF | 14.625 | 14.625 | 14.25 | 14.375 | 32500.0 |
| 2000-03-10 | EWU | ETF | 40.0 | 40.25 | 39.75 | 40.0 | 15250.0 |
| 2000-03-10 | EWW | ETF | 20.75 | 20.75 | 20.125 | 20.125 | 28900.0 |
| 2000-03-10 | FCTR | ETF | 13.25 | 13.4375 | 13.125 | 13.4375 | 17000.0 |
| 2000-03-10 | FMAR | ETF | 6.0 | 6.0 | 5.62 | 5.7449 | 3500.0 |
| 2000-03-10 | GLDB | ETF | 7.1875 | 7.1875 | 6.875 | 7.0 | 32700.0 |
| 2000-03-10 | GSIG | ETF | 23.0 | 23.44 | 22.0 | 22.0 | 523500.0 |
| 2000-03-10 | IGLD | ETF | 2793.75 | 3200.0 | 2793.75 | 3000.0 | 5223.0 |
| 2000-03-10 | KTEC | ETF | 9.3125 | 9.3125 | 8.875 | 8.875 | 5100.0 |
| 2000-03-10 | MDY | ETF | 89.0 | 90.4375 | 88.875 | 89.375 | 1713000.0 |
| 2000-03-10 | MIG | ETF | 5.75 | 5.75 | 5.5 | 5.5 | 20300.0 |
| 2000-03-10 | PPH | ETF | 41.75 | 41.9375 | 40.3125 | 40.7812 | 679800.0 |
| 2000-03-10 | SFY | ETF | 12.8125 | 12.9375 | 12.5625 | 12.75 | 35300.0 |
| 2000-03-10 | TDSC | ETF | 5.47 | 5.5 | 5.28 | 5.39 | 72000.0 |
| 2000-03-10 | TINY | ETF | 28.88 | 30.69 | 28.56 | 29.62 | 292100.0 |
| 2000-03-10 | XLB | ETF | 10.0938 | 10.3672 | 10.0938 | 10.1875 | 55400.0 |
| 2000-03-10 | XLE | ETF | 14.0 | 14.3438 | 13.8594 | 13.875 | 1326200.0 |
| 2000-03-10 | XLF | ETF | 16.1962 | 16.45 | 16.1962 | 16.2851 | 183419.0 |
| 2000-03-10 | XLI | ETF | 25.9375 | 26.25 | 25.7344 | 25.7812 | 114200.0 |
| 2000-03-10 | XLK | ETF | 30.0 | 30.3281 | 29.75 | 29.875 | 530000.0 |
| 2000-03-10 | XLP | ETF | 19.8125 | 20.0 | 19.4375 | 19.5781 | 1967700.0 |
| 2000-03-10 | XLU | ETF | 12.7734 | 12.9297 | 12.6875 | 12.789 | 45200.0 |
| 2000-03-10 | XLV | ETF | 28.0 | 28.2031 | 27.8125 | 27.8281 | 165300.0 |
| 2000-03-10 | XLY | ETF | 12.5469 | 12.6484 | 12.4375 | 12.4844 | 880600.0 |
> showing 47 of 47 rows — these rows as CSV