PREVIEW / etf_daily / 2009-04-27
file: by_date/etf_daily/2009/2009-04-27.parquet size: 29 KB rows: 650
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-27 | SPY | ETF | 85.68 | 87.01 | 85.54 | 85.84 | 289581600.0 |
| 2009-04-27 | QQQ | ETF | 33.42 | 34.06 | 33.35 | 33.73 | 120749086.0 |
| 2009-04-27 | IWM | ETF | 46.84 | 47.79 | 46.61 | 47.11 | 49385100.0 |
| 2009-04-27 | DIA | ETF | 79.77 | 81.23 | 79.66 | 80.26 | 17582800.0 |
| 2009-04-27 | GLD | ETF | 89.33 | 89.79 | 88.94 | 89.01 | 7147600.0 |
| 2009-04-27 | TLT | ETF | 101.07 | 101.19 | 100.06 | 101.0 | 2294600.0 |
| 2009-04-27 | AAXJ | ETF | 36.35 | 36.91 | 36.24 | 36.24 | 238200.0 |
| 2009-04-27 | ACWI | ETF | 31.16 | 31.47 | 30.95 | 31.06 | 146400.0 |
| 2009-04-27 | ACWX | ETF | 29.44 | 29.64 | 29.12 | 29.25 | 50197.0 |
| 2009-04-27 | ADRE | ETF | 29.75 | 29.9592 | 29.3778 | 29.49 | 295995.0 |
| 2009-04-27 | AFK | ETF | 21.42 | 21.554 | 21.0 | 21.33 | 6099.0 |
| 2009-04-27 | AGG | ETF | 101.58 | 101.83 | 101.25 | 101.6 | 614400.0 |
| 2009-04-27 | AGQ | ETF | 77.86 | 78.2 | 75.04 | 75.62 | 81450.0 |
| 2009-04-27 | AGZ | ETF | 107.752 | 108.5 | 107.62 | 108.5 | 4589.0 |
| 2009-04-27 | AIA | ETF | 27.89 | 27.89 | 27.26 | 27.28 | 20265.0 |
| 2009-04-27 | AIQ | ETF | 39.2 | 39.95 | 37.25 | 39.35 | 188920.0 |
| 2009-04-27 | AIS | ETF | 0.4 | 0.42 | 0.39 | 0.41 | 22958.0 |
| 2009-04-27 | AIVI | ETF | 31.65 | 31.65 | 30.92 | 31.13 | 6200.0 |
| 2009-04-27 | AMJ | ETF | 20.77 | 21.06 | 20.5299 | 21.0 | 125046.0 |
| 2009-04-27 | AOA | ETF | 23.45 | 23.71 | 22.95 | 23.38 | 2900.0 |
| 2009-04-27 | AOK | ETF | 25.34 | 25.34 | 25.3 | 25.3 | 1290.0 |
| 2009-04-27 | AOM | ETF | 24.72 | 24.758 | 24.6554 | 24.758 | 902.0 |
| 2009-04-27 | AOR | ETF | 24.36 | 24.73 | 24.22 | 24.22 | 6450.0 |
| 2009-04-27 | ARB | ETF | 21.02 | 22.45 | 20.77 | 21.94 | 942427.0 |
| 2009-04-27 | BAL | ETF | 29.2 | 29.92 | 29.2 | 29.92 | 4800.0 |
| 2009-04-27 | BBH | ETF | 29.73 | 30.14 | 29.73 | 30.0633 | 450000.0 |
| 2009-04-27 | BIL | ETF | 91.7 | 91.78 | 91.7 | 91.76 | 151000.0 |
| 2009-04-27 | BITS | ETF | 17.6 | 17.6 | 17.44 | 17.6 | 1005.0 |
| 2009-04-27 | BIV | ETF | 76.48 | 76.84 | 76.48 | 76.81 | 94400.0 |
| 2009-04-27 | BJK | ETF | 19.01 | 20.46 | 18.5 | 19.1 | 26700.0 |
| 2009-04-27 | BKF | ETF | 28.42 | 28.69 | 28.04 | 28.1 | 62807.0 |
| 2009-04-27 | BLV | ETF | 73.23 | 73.31 | 72.65 | 73.31 | 23200.0 |
| 2009-04-27 | BMVP | ETF | 10.2667 | 10.4833 | 10.2667 | 10.4 | 13913.0 |
| 2009-04-27 | BND | ETF | 77.12 | 77.4 | 77.11 | 77.4 | 405700.0 |
| 2009-04-27 | BNE | ETF | 4.8 | 5.06 | 4.6801 | 4.97 | 133859.0 |
| 2009-04-27 | BOSS | ETF | 15.6 | 15.6 | 15.6 | 15.6 | 200.0 |
| 2009-04-27 | BSV | ETF | 78.73 | 79.05 | 78.65 | 78.98 | 212900.0 |
| 2009-04-27 | BTF | ETF | 45.199999999999996 | 45.722500000000004 | 45.0 | 45.65 | 6396.200000000001 |
| 2009-04-27 | BWX | ETF | 25.68 | 25.8 | 25.5 | 25.515 | 222086.0 |
| 2009-04-27 | BWZ | ETF | 33.15 | 33.15 | 33.1 | 33.1 | 2355.0 |
| 2009-04-27 | CBON | ETF | 2.3 | 2.32 | 2.3 | 2.3 | 16545.0 |
| 2009-04-27 | CEF | ETF | 11.44 | 11.59 | 11.4 | 11.41 | 667700.0 |
| 2009-04-27 | CGO | ETF | 9.64 | 9.74 | 9.6176 | 9.69 | 10365.0 |
| 2009-04-27 | CGW | ETF | 13.43 | 13.58 | 13.27 | 13.39 | 34578.0 |
| 2009-04-27 | CHB | ETF | 0.6 | 0.62 | 0.57 | 0.58 | 451131.0 |
| 2009-04-27 | CHI | ETF | 9.24 | 9.44 | 9.2 | 9.4 | 114963.0 |
| 2009-04-27 | CHIC | ETF | 12.12 | 12.3 | 11.85 | 12.03 | 492737.0 |
| 2009-04-27 | CHW | ETF | 6.12 | 6.32 | 6.11 | 6.26 | 185642.0 |
| 2009-04-27 | CHY | ETF | 8.99 | 9.15 | 8.9 | 9.14 | 157670.0 |
| 2009-04-27 | CMF | ETF | 52.95 | 53.045 | 52.55 | 53.005 | 12120.0 |
> showing 50 of 650 rows — these rows as CSV