PREVIEW / etf_daily / 2001-03-16
file: by_date/etf_daily/2001/2001-03-16.parquet size: 8 KB rows: 95
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-16 | SPY | ETF | 117.13 | 117.4 | 114.81 | 115.01 | 58514600.0 |
| 2001-03-16 | QQQ | ETF | 41.88 | 42.8 | 40.56 | 41.1 | 77790400.0 |
| 2001-03-16 | IWM | ETF | 44.925 | 45.175 | 43.825 | 44.0 | 301400.0 |
| 2001-03-16 | DIA | ETF | 99.65 | 100.61 | 98.15 | 98.38 | 4029600.0 |
| 2001-03-16 | BBH | ETF | 41.5 | 41.5 | 38.9267 | 39.08 | 4595700.0 |
| 2001-03-16 | BITS | ETF | 8.5 | 9.25 | 8.0 | 8.125 | 1500.0 |
| 2001-03-16 | BOSS | ETF | 27.0 | 27.7 | 27.0 | 27.45 | 300.0 |
| 2001-03-16 | CEF | ETF | 3.06 | 3.1 | 3.04 | 3.04 | 37900.0 |
| 2001-03-16 | CHB | ETF | 4.98 | 5.15 | 4.85 | 5.0 | 126200.0 |
| 2001-03-16 | CNXT | ETF | 11.38 | 11.44 | 9.44 | 9.75 | 5524540.0 |
| 2001-03-16 | CSB | ETF | 1.5 | 1.51999998092651 | 1.5 | 1.51999998092651 | 10000.0 |
| 2001-03-16 | DGT | ETF | 68.2 | 68.5 | 67.8 | 67.8 | 800.0 |
| 2001-03-16 | EWA | ETF | 8.73 | 8.73 | 8.65 | 8.65 | 3000.0 |
| 2001-03-16 | EWC | ETF | 11.0 | 11.2 | 11.0 | 11.2 | 2100.0 |
| 2001-03-16 | EWD | ETF | 14.3 | 14.35 | 14.05 | 14.35 | 5900.0 |
| 2001-03-16 | EWG | ETF | 16.85 | 16.85 | 16.55 | 16.58 | 30800.0 |
| 2001-03-16 | EWH | ETF | 11.21 | 11.21 | 10.8 | 10.88 | 34300.0 |
| 2001-03-16 | EWI | ETF | 38.1 | 38.1 | 37.6 | 37.6 | 6850.0 |
| 2001-03-16 | EWJ | ETF | 38.72 | 38.92 | 38.0 | 38.4 | 84900.0 |
| 2001-03-16 | EWK | ETF | 11.25 | 11.25 | 11.25 | 11.25 | 900.0 |
| 2001-03-16 | EWL | ETF | 14.25 | 14.25 | 13.85 | 13.85 | 4300.0 |
| 2001-03-16 | EWM | ETF | 19.4 | 19.6 | 19.4 | 19.6 | 6350.0 |
| 2001-03-16 | EWN | ETF | 19.8 | 19.8 | 19.55 | 19.55 | 6100.0 |
| 2001-03-16 | EWO | ETF | 8.05 | 8.05 | 7.9 | 7.95 | 23500.0 |
| 2001-03-16 | EWP | ETF | 23.1 | 23.12 | 23.1 | 23.12 | 8300.0 |
| 2001-03-16 | EWQ | ETF | 20.47 | 20.47 | 20.2 | 20.2 | 11900.0 |
| 2001-03-16 | EWS | ETF | 11.62 | 11.62 | 11.38 | 11.4 | 10750.0 |
| 2001-03-16 | EWT | ETF | 24.5 | 24.5 | 23.74 | 23.9 | 97900.0 |
| 2001-03-16 | EWU | ETF | 31.2 | 31.38 | 30.74 | 31.08 | 13600.0 |
| 2001-03-16 | EWW | ETF | 14.0 | 14.15 | 13.8 | 13.95 | 5700.0 |
| 2001-03-16 | EWZ | ETF | 15.55 | 15.7 | 15.21 | 15.7 | 1700.0 |
| 2001-03-16 | EZU | ETF | 30.8985 | 30.8985 | 30.3985 | 30.3985 | 11800.0 |
| 2001-03-16 | FCTR | ETF | 14.5313 | 14.5313 | 14.0625 | 14.375 | 44600.0 |
| 2001-03-16 | FMAR | ETF | 5.34 | 5.34 | 5.34 | 5.34 | 700.0 |
| 2001-03-16 | GLDB | ETF | 7.25 | 7.375 | 7.125 | 7.1875 | 134900.0 |
| 2001-03-16 | GSIG | ETF | 8.62 | 8.91 | 8.44 | 8.75 | 175800.0 |
| 2001-03-16 | IBB | ETF | 26.8021 | 26.8021 | 25.3177 | 25.3177 | 24000.0 |
| 2001-03-16 | ICF | ETF | 19.5391 | 19.5391 | 19.4102 | 19.4844 | 46400.0 |
| 2001-03-16 | IDU | ETF | 39.69 | 39.715 | 39.5 | 39.5 | 3600.0 |
| 2001-03-16 | IEV | ETF | 32.4 | 32.4 | 31.575 | 31.595 | 31000.0 |
| 2001-03-16 | IGLD | ETF | 146.875 | 146.875 | 143.75 | 143.75 | 129.0 |
| 2001-03-16 | IJH | ETF | 9.375 | 9.375 | 9.168 | 9.168 | 417000.0 |
| 2001-03-16 | IJJ | ETF | 20.455 | 20.455 | 20.455 | 20.455 | 69200.0 |
| 2001-03-16 | IJK | ETF | 13.105 | 13.105 | 12.75 | 12.7812 | 46400.0 |
| 2001-03-16 | IJR | ETF | 16.9883 | 17.0783 | 16.5917 | 16.5983 | 1276200.0 |
| 2001-03-16 | IJS | ETF | 19.175 | 19.2875 | 18.7 | 18.7875 | 95600.0 |
| 2001-03-16 | IJT | ETF | 17.0175 | 17.0175 | 16.5875 | 16.5875 | 80400.0 |
| 2001-03-16 | IOO | ETF | 30.4766 | 30.4766 | 30.3438 | 30.3516 | 1800.0 |
| 2001-03-16 | IUSG | ETF | 20.375 | 20.39 | 20.375 | 20.39 | 400.0 |
| 2001-03-16 | IUSV | ETF | 23.7067 | 23.7267 | 23.5867 | 23.5867 | 6000.0 |
> showing 50 of 95 rows — these rows as CSV