PREVIEW / etf_daily / 2001-03-20
file: by_date/etf_daily/2001/2001-03-20.parquet size: 8 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-20 | SPY | ETF | 117.9 | 118.46 | 114.11 | 114.2 | 15083900.0 |
| 2001-03-20 | QQQ | ETF | 43.44 | 43.81 | 40.2 | 40.35 | 104996700.0 |
| 2001-03-20 | IWM | ETF | 45.05 | 45.58 | 44.1 | 44.1 | 625200.0 |
| 2001-03-20 | DIA | ETF | 100.05 | 100.7 | 96.95 | 96.96 | 4743300.0 |
| 2001-03-20 | BBH | ETF | 41.0 | 41.2167 | 38.6833 | 38.8667 | 2940900.0 |
| 2001-03-20 | BITS | ETF | 8.25 | 8.25 | 7.75 | 7.75 | 1675.0 |
| 2001-03-20 | CEF | ETF | 3.12 | 3.13 | 3.06 | 3.06 | 15300.0 |
| 2001-03-20 | CHB | ETF | 5.2 | 5.35 | 4.82 | 4.82 | 57200.0 |
| 2001-03-20 | CNXT | ETF | 10.485 | 10.922 | 9.674 | 9.705 | 2578150.0 |
| 2001-03-20 | CSB | ETF | 1.51999998092651 | 1.51999998092651 | 1.51999998092651 | 1.51999998092651 | 30300.0 |
| 2001-03-20 | DGT | ETF | 69.05 | 69.25 | 69.05 | 69.15 | 1700.0 |
| 2001-03-20 | EWA | ETF | 8.8 | 8.8 | 8.7 | 8.8 | 11700.0 |
| 2001-03-20 | EWC | ETF | 11.3 | 11.4 | 11.1 | 11.1 | 5000.0 |
| 2001-03-20 | EWD | ETF | 14.6 | 14.6 | 14.1 | 14.1 | 25700.0 |
| 2001-03-20 | EWG | ETF | 16.86 | 16.95 | 16.7 | 16.7 | 77000.0 |
| 2001-03-20 | EWH | ETF | 11.17 | 11.2 | 10.63 | 10.65 | 60300.0 |
| 2001-03-20 | EWI | ETF | 38.5 | 38.68 | 38.3 | 38.3 | 10300.0 |
| 2001-03-20 | EWJ | ETF | 39.28 | 39.4 | 38.6 | 38.6 | 155675.0 |
| 2001-03-20 | EWK | ETF | 11.45 | 11.45 | 11.45 | 11.45 | 200.0 |
| 2001-03-20 | EWL | ETF | 14.2 | 14.2 | 14.0 | 14.15 | 5200.0 |
| 2001-03-20 | EWM | ETF | 19.24 | 19.6 | 19.2 | 19.2 | 3700.0 |
| 2001-03-20 | EWN | ETF | 19.7 | 19.9 | 19.7 | 19.9 | 6100.0 |
| 2001-03-20 | EWO | ETF | 7.9 | 8.08 | 7.9 | 8.08 | 8000.0 |
| 2001-03-20 | EWP | ETF | 23.15 | 23.4 | 22.9 | 22.9 | 35000.0 |
| 2001-03-20 | EWQ | ETF | 20.5 | 20.84 | 20.5 | 20.5 | 48600.0 |
| 2001-03-20 | EWS | ETF | 11.08 | 11.46 | 11.08 | 11.08 | 13650.0 |
| 2001-03-20 | EWT | ETF | 23.22 | 23.6 | 22.32 | 22.32 | 32850.0 |
| 2001-03-20 | EWU | ETF | 31.5 | 31.8 | 31.3 | 31.3 | 33950.0 |
| 2001-03-20 | EWW | ETF | 14.25 | 14.5 | 13.8 | 13.8 | 35700.0 |
| 2001-03-20 | EWY | ETF | 12.55 | 12.55 | 12.0 | 12.0 | 29800.0 |
| 2001-03-20 | EWZ | ETF | 15.84 | 15.84 | 15.45 | 15.45 | 19600.0 |
| 2001-03-20 | EZU | ETF | 31.0781 | 31.2812 | 30.7265 | 30.7265 | 32000.0 |
| 2001-03-20 | FCTR | ETF | 14.375 | 14.75 | 14.0 | 14.0 | 15500.0 |
| 2001-03-20 | FMAR | ETF | 5.75 | 5.75 | 5.06 | 5.5 | 7800.0 |
| 2001-03-20 | GLDB | ETF | 6.875 | 7.0 | 6.8125 | 6.9375 | 62100.0 |
| 2001-03-20 | GSIG | ETF | 9.23 | 9.31 | 8.5 | 8.5 | 610500.0 |
| 2001-03-20 | IBB | ETF | 26.6667 | 26.6667 | 25.0677 | 25.0677 | 32400.0 |
| 2001-03-20 | ICF | ETF | 19.793 | 19.793 | 19.7188 | 19.7188 | 6000.0 |
| 2001-03-20 | IDU | ETF | 39.15 | 39.71 | 39.15 | 39.235 | 6600.0 |
| 2001-03-20 | IEV | ETF | 31.825 | 32.25 | 31.65 | 31.89 | 39800.0 |
| 2001-03-20 | IGLD | ETF | 143.75 | 150.0 | 140.625 | 143.75 | 75.0 |
| 2001-03-20 | IGM | ETF | 9.25 | 9.255 | 8.6817 | 8.6817 | 301800.0 |
| 2001-03-20 | IJH | ETF | 9.423 | 9.502 | 9.188 | 9.218 | 495000.0 |
| 2001-03-20 | IJJ | ETF | 20.8525 | 21.1 | 20.6 | 20.6 | 68000.0 |
| 2001-03-20 | IJK | ETF | 13.1675 | 13.2688 | 12.7975 | 12.7975 | 1074400.0 |
| 2001-03-20 | IJR | ETF | 17.025 | 17.215 | 16.7 | 16.7 | 424800.0 |
| 2001-03-20 | IJS | ETF | 19.1375 | 19.355 | 18.8 | 18.8 | 284400.0 |
| 2001-03-20 | IJT | ETF | 16.9875 | 17.2075 | 16.7125 | 16.7125 | 22800.0 |
| 2001-03-20 | IOO | ETF | 30.8281 | 30.9531 | 29.8281 | 29.8281 | 9600.0 |
| 2001-03-20 | IUSG | ETF | 21.025 | 21.12 | 20.75 | 20.75 | 3400.0 |
> showing 50 of 98 rows — these rows as CSV