PREVIEW / etf_daily / 2000-03-24
file: by_date/etf_daily/2000/2000-03-24.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-24 | SPY | ETF | 152.875 | 155.75 | 151.7188 | 153.5625 | 11462900.0 |
| 2000-03-24 | QQQ | ETF | 117.4844 | 120.5 | 115.0156 | 117.5625 | 22063000.0 |
| 2000-03-24 | DIA | ETF | 110.5312 | 112.4688 | 110.2812 | 111.125 | 1903400.0 |
| 2000-03-24 | BBH | ETF | 59.5208 | 60.9792 | 57.3333 | 58.5625 | 1992900.0 |
| 2000-03-24 | BITS | ETF | 41.5 | 43.5 | 40.25 | 40.75 | 27425.0 |
| 2000-03-24 | CEF | ETF | 3.5 | 3.5 | 3.5 | 3.5 | 10000.0 |
| 2000-03-24 | CHB | ETF | 6.5 | 6.75 | 6.44 | 6.5 | 209100.0 |
| 2000-03-24 | CNXT | ETF | 82.5 | 87.31 | 77.0 | 79.31 | 9400750.0 |
| 2000-03-24 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 200.0 |
| 2000-03-24 | EWA | ETF | 10.5 | 10.5 | 10.25 | 10.25 | 5200.0 |
| 2000-03-24 | EWC | ETF | 19.0625 | 19.0625 | 18.875 | 19.0625 | 2400.0 |
| 2000-03-24 | EWD | ETF | 35.4375 | 35.625 | 35.3125 | 35.5625 | 2600.0 |
| 2000-03-24 | EWG | ETF | 28.125 | 28.75 | 28.125 | 28.4375 | 382200.0 |
| 2000-03-24 | EWH | ETF | 13.9375 | 13.9375 | 13.75 | 13.8125 | 59800.0 |
| 2000-03-24 | EWI | ETF | 52.0 | 52.25 | 51.875 | 52.0 | 147800.0 |
| 2000-03-24 | EWJ | ETF | 60.25 | 60.25 | 59.5 | 59.75 | 197475.0 |
| 2000-03-24 | EWK | ETF | 13.75 | 13.75 | 13.25 | 13.375 | 7800.0 |
| 2000-03-24 | EWL | ETF | 15.25 | 15.75 | 15.25 | 15.5625 | 9900.0 |
| 2000-03-24 | EWM | ETF | 28.0 | 28.25 | 27.75 | 28.0 | 23900.0 |
| 2000-03-24 | EWN | ETF | 24.5 | 24.6875 | 24.375 | 24.5 | 4200.0 |
| 2000-03-24 | EWO | ETF | 7.8125 | 7.8125 | 7.6875 | 7.8125 | 10600.0 |
| 2000-03-24 | EWP | ETF | 29.25 | 29.4375 | 29.25 | 29.25 | 194700.0 |
| 2000-03-24 | EWQ | ETF | 28.5 | 28.875 | 28.5 | 28.875 | 24100.0 |
| 2000-03-24 | EWS | ETF | 15.25 | 15.375 | 15.0 | 15.0 | 27450.0 |
| 2000-03-24 | EWU | ETF | 42.0 | 42.25 | 41.75 | 42.0 | 35750.0 |
| 2000-03-24 | EWW | ETF | 19.6875 | 20.0625 | 19.6875 | 20.0 | 15300.0 |
| 2000-03-24 | FCTR | ETF | 13.25 | 13.75 | 13.0 | 13.6875 | 40300.0 |
| 2000-03-24 | FMAR | ETF | 5.62 | 6.0 | 5.5 | 6.0 | 4700.0 |
| 2000-03-24 | GLDB | ETF | 6.8125 | 7.125 | 6.75 | 7.0 | 125800.0 |
| 2000-03-24 | GSIG | ETF | 21.31 | 21.37 | 19.5 | 19.62 | 367300.0 |
| 2000-03-24 | IGLD | ETF | 2425.0 | 2425.0 | 2275.0 | 2331.25 | 1096.0 |
| 2000-03-24 | KTEC | ETF | 8.875 | 9.0 | 8.875 | 9.0 | 19900.0 |
| 2000-03-24 | MDY | ETF | 91.625 | 93.0312 | 90.6875 | 91.8125 | 437600.0 |
| 2000-03-24 | MIG | ETF | 5.125 | 6.125 | 5.125 | 6.0625 | 23800.0 |
| 2000-03-24 | PPH | ETF | 42.125 | 42.8125 | 41.5 | 41.75 | 266000.0 |
| 2000-03-24 | SFY | ETF | 13.75 | 15.5 | 13.75 | 15.125 | 400000.0 |
| 2000-03-24 | TDSC | ETF | 5.125 | 5.405 | 5.125 | 5.375 | 83600.0 |
| 2000-03-24 | TINY | ETF | 23.0 | 23.25 | 21.75 | 21.75 | 165700.0 |
| 2000-03-24 | XLB | ETF | 11.3047 | 11.3828 | 11.2266 | 11.2578 | 24000.0 |
| 2000-03-24 | XLE | ETF | 14.0938 | 14.1875 | 13.9688 | 14.0156 | 322800.0 |
| 2000-03-24 | XLF | ETF | 20.2325 | 20.461 | 19.8771 | 20.2071 | 660185.0 |
| 2000-03-24 | XLI | ETF | 28.9844 | 29.375 | 28.9844 | 29.0469 | 6200.0 |
| 2000-03-24 | XLK | ETF | 32.0312 | 32.7188 | 31.5 | 31.9922 | 2206200.0 |
| 2000-03-24 | XLP | ETF | 21.0 | 21.1562 | 20.5156 | 20.5781 | 231100.0 |
| 2000-03-24 | XLU | ETF | 13.1953 | 13.1953 | 12.9375 | 12.9688 | 48600.0 |
| 2000-03-24 | XLV | ETF | 31.0 | 31.3594 | 31.0 | 31.2188 | 9200.0 |
| 2000-03-24 | XLY | ETF | 14.25 | 14.4219 | 14.1797 | 14.1797 | 39200.0 |
> showing 47 of 47 rows — these rows as CSV