PREVIEW / etf_daily / 2001-04-17
file: by_date/etf_daily/2001/2001-04-17.parquet size: 8 KB rows: 96
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-04-17 | SPY | ETF | 117.31 | 119.66 | 117.02 | 119.26 | 10924700.0 |
| 2001-04-17 | QQQ | ETF | 39.951 | 42.7 | 39.9 | 41.25 | 94694300.0 |
| 2001-04-17 | IWM | ETF | 44.375 | 45.55 | 44.375 | 45.35 | 295400.0 |
| 2001-04-17 | DIA | ETF | 100.77 | 102.45 | 100.71 | 102.25 | 3424200.0 |
| 2001-04-17 | BBH | ETF | 37.7667 | 39.9167 | 37.7667 | 39.9 | 3654900.0 |
| 2001-04-17 | BITS | ETF | 7.0 | 7.08 | 6.48 | 6.92 | 8825.0 |
| 2001-04-17 | BOSS | ETF | 27.4 | 27.4 | 26.0 | 26.0 | 100.0 |
| 2001-04-17 | CEF | ETF | 3.17 | 3.17 | 3.1 | 3.13 | 18300.0 |
| 2001-04-17 | CHB | ETF | 4.89 | 4.93 | 4.85 | 4.92 | 55700.0 |
| 2001-04-17 | CNXT | ETF | 8.24 | 9.35 | 8.18 | 9.04 | 4791500.0 |
| 2001-04-17 | CSB | ETF | 1.45000004768372 | 1.45000004768372 | 1.39999997615814 | 1.39999997615814 | 42100.0 |
| 2001-04-17 | DGT | ETF | 70.31 | 70.31 | 70.31 | 70.31 | 100.0 |
| 2001-04-17 | EWA | ETF | 9.0 | 9.1 | 9.0 | 9.0 | 2500.0 |
| 2001-04-17 | EWC | ETF | 11.2 | 11.4 | 11.2 | 11.4 | 7700.0 |
| 2001-04-17 | EWD | ETF | 13.9 | 13.9 | 13.6 | 13.85 | 1300.0 |
| 2001-04-17 | EWG | ETF | 16.57 | 16.85 | 16.57 | 16.85 | 20300.0 |
| 2001-04-17 | EWH | ETF | 10.36 | 10.44 | 10.27 | 10.32 | 13800.0 |
| 2001-04-17 | EWI | ETF | 38.66 | 39.0 | 38.66 | 39.0 | 25450.0 |
| 2001-04-17 | EWJ | ETF | 41.4 | 41.6 | 41.16 | 41.4 | 88850.0 |
| 2001-04-17 | EWL | ETF | 14.15 | 14.25 | 14.0 | 14.25 | 2200.0 |
| 2001-04-17 | EWM | ETF | 16.4 | 16.4 | 16.08 | 16.12 | 172350.0 |
| 2001-04-17 | EWN | ETF | 19.8 | 19.91 | 19.8 | 19.91 | 700.0 |
| 2001-04-17 | EWO | ETF | 8.08 | 8.08 | 8.08 | 8.08 | 200.0 |
| 2001-04-17 | EWP | ETF | 23.3 | 23.3 | 23.3 | 23.3 | 200.0 |
| 2001-04-17 | EWQ | ETF | 20.65 | 21.1 | 20.65 | 21.1 | 1800.0 |
| 2001-04-17 | EWS | ETF | 10.16 | 10.22 | 10.08 | 10.12 | 3600.0 |
| 2001-04-17 | EWT | ETF | 22.7 | 22.7 | 22.44 | 22.44 | 350.0 |
| 2001-04-17 | EWU | ETF | 32.2 | 32.36 | 31.9 | 32.36 | 10000.0 |
| 2001-04-17 | EWW | ETF | 14.95 | 15.2 | 14.81 | 15.2 | 76100.0 |
| 2001-04-17 | EWY | ETF | 12.18 | 12.43 | 12.15 | 12.43 | 49400.0 |
| 2001-04-17 | EWZ | ETF | 14.85 | 14.85 | 14.55 | 14.55 | 4900.0 |
| 2001-04-17 | EZU | ETF | 31.125 | 31.475 | 31.125 | 31.475 | 16400.0 |
| 2001-04-17 | FCTR | ETF | 15.68 | 15.75 | 15.4 | 15.41 | 26900.0 |
| 2001-04-17 | FMAR | ETF | 6.5 | 6.5 | 6.0 | 6.0 | 5400.0 |
| 2001-04-17 | GLDB | ETF | 6.5 | 6.54 | 6.5 | 6.53 | 62900.0 |
| 2001-04-17 | GSIG | ETF | 9.0 | 9.1 | 8.67 | 8.93 | 57900.0 |
| 2001-04-17 | IBB | ETF | 26.1833 | 27.4667 | 26.1833 | 27.3667 | 25500.0 |
| 2001-04-17 | ICF | ETF | 19.23 | 19.325 | 19.23 | 19.325 | 12400.0 |
| 2001-04-17 | IDU | ETF | 41.875 | 42.36 | 41.875 | 42.36 | 35200.0 |
| 2001-04-17 | IEV | ETF | 32.325 | 32.675 | 32.325 | 32.65 | 85600.0 |
| 2001-04-17 | IGLD | ETF | 96.0 | 96.0 | 96.0 | 96.0 | 2.0 |
| 2001-04-17 | IGM | ETF | 9.1833 | 9.1917 | 8.9583 | 9.0417 | 61200.0 |
| 2001-04-17 | IJH | ETF | 9.383 | 9.496 | 9.383 | 9.481 | 264000.0 |
| 2001-04-17 | IJJ | ETF | 20.915 | 21.025 | 20.89 | 21.0 | 31200.0 |
| 2001-04-17 | IJK | ETF | 13.07 | 13.2675 | 13.07 | 13.25 | 124000.0 |
| 2001-04-17 | IJR | ETF | 16.9083 | 17.1667 | 16.9083 | 17.1667 | 889800.0 |
| 2001-04-17 | IJS | ETF | 18.8375 | 18.9725 | 18.8375 | 18.9725 | 25200.0 |
| 2001-04-17 | IJT | ETF | 17.325 | 17.4325 | 17.285 | 17.4125 | 51200.0 |
| 2001-04-17 | IOO | ETF | 31.49 | 31.49 | 31.12 | 31.145 | 81600.0 |
| 2001-04-17 | IUSG | ETF | 20.99 | 21.015 | 20.985 | 20.985 | 1200.0 |
> showing 50 of 96 rows — these rows as CSV