PREVIEW / etf_daily / 2009-08-14
file: by_date/etf_daily/2009/2009-08-14.parquet size: 29 KB rows: 671
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-08-14 | SPY | ETF | 101.52 | 101.6 | 99.7 | 100.79 | 199616100.0 |
| 2009-08-14 | QQQ | ETF | 39.89 | 39.96 | 39.28 | 39.63 | 124480151.0 |
| 2009-08-14 | IWM | ETF | 57.5 | 57.55 | 55.82 | 56.41 | 60224900.0 |
| 2009-08-14 | DIA | ETF | 94.07 | 94.12 | 92.5 | 93.41 | 10846500.0 |
| 2009-08-14 | GLD | ETF | 93.84 | 93.91 | 92.4 | 93.0 | 6189400.0 |
| 2009-08-14 | TLT | ETF | 93.3 | 94.2 | 93.21 | 93.35 | 4410400.0 |
| 2009-08-14 | AAXJ | ETF | 50.3 | 50.3 | 48.97 | 49.53 | 213000.0 |
| 2009-08-14 | ACWI | ETF | 38.76 | 38.8 | 38.03 | 38.37 | 73100.0 |
| 2009-08-14 | ACWX | ETF | 37.67 | 37.67 | 37.03 | 37.29 | 30116.0 |
| 2009-08-14 | ADRE | ETF | 39.01 | 39.01 | 38.12 | 38.36 | 111002.0 |
| 2009-08-14 | AFK | ETF | 27.7 | 27.7 | 27.33 | 27.45 | 26045.0 |
| 2009-08-14 | AGG | ETF | 103.17 | 103.44 | 103.02 | 103.13 | 453600.0 |
| 2009-08-14 | AGQ | ETF | 96.5 | 96.6 | 90.98 | 92.12 | 97200.0 |
| 2009-08-14 | AGZ | ETF | 107.32 | 108.03 | 107.32 | 107.655 | 10844.0 |
| 2009-08-14 | AIA | ETF | 36.52 | 36.59 | 35.71 | 35.9984 | 12580.0 |
| 2009-08-14 | AIQ | ETF | 26.25 | 26.6 | 25.75 | 26.25 | 73712.0 |
| 2009-08-14 | AIS | ETF | 0.99 | 0.99 | 0.92 | 0.958 | 177089.0 |
| 2009-08-14 | AIVI | ETF | 39.55 | 39.55 | 38.76 | 39.18 | 20100.0 |
| 2009-08-14 | AMJ | ETF | 24.52 | 24.5899 | 24.286 | 24.34 | 227463.0 |
| 2009-08-14 | AOA | ETF | 27.88 | 27.88 | 27.33 | 27.47 | 10500.0 |
| 2009-08-14 | AOK | ETF | 26.22 | 26.72 | 26.22 | 26.406 | 13308.0 |
| 2009-08-14 | AOM | ETF | 26.8194 | 26.98 | 26.78 | 26.78 | 12863.0 |
| 2009-08-14 | AOR | ETF | 27.25 | 27.25 | 27.08 | 27.084 | 3567.0 |
| 2009-08-14 | ARB | ETF | 16.48 | 16.53 | 15.97 | 16.08 | 115579.0 |
| 2009-08-14 | BAL | ETF | 33.07 | 33.07 | 31.52 | 31.5283 | 23390.0 |
| 2009-08-14 | BBH | ETF | 33.2667 | 33.35 | 32.5867 | 33.06 | 239700.0 |
| 2009-08-14 | BIL | ETF | 91.7 | 91.74 | 91.68 | 91.74 | 129500.0 |
| 2009-08-14 | BITS | ETF | 21.6 | 21.92 | 20.84 | 21.44 | 2026.0 |
| 2009-08-14 | BIV | ETF | 78.69 | 78.88 | 78.33 | 78.63 | 91000.0 |
| 2009-08-14 | BJK | ETF | 23.73 | 23.73 | 22.98 | 23.2 | 11600.0 |
| 2009-08-14 | BKF | ETF | 39.42 | 39.42 | 38.24 | 38.68 | 112143.0 |
| 2009-08-14 | BLV | ETF | 76.61 | 76.99 | 76.3 | 76.56 | 28500.0 |
| 2009-08-14 | BMVP | ETF | 11.6334 | 11.6367 | 11.5067 | 11.58 | 15561.0 |
| 2009-08-14 | BND | ETF | 78.37 | 78.5 | 78.17 | 78.36 | 640800.0 |
| 2009-08-14 | BNE | ETF | 6.07 | 6.27 | 5.96 | 6.27 | 411538.0 |
| 2009-08-14 | BRF | ETF | 35.95 | 36.22 | 34.8207 | 35.02 | 120345.0 |
| 2009-08-14 | BSV | ETF | 79.54 | 79.63 | 79.37 | 79.52 | 217200.0 |
| 2009-08-14 | BTF | ETF | 59.949999999999996 | 60.0 | 57.99999999999999 | 58.49999999999999 | 17744.4 |
| 2009-08-14 | BWX | ETF | 28.055 | 28.11 | 27.91 | 28.005 | 366898.0 |
| 2009-08-14 | BWZ | ETF | 35.7464 | 35.87 | 35.64 | 35.87 | 4169.0 |
| 2009-08-14 | BZQ | ETF | 6729.6 | 7088.0 | 6729.6 | 7041.6 | 10.75 |
| 2009-08-14 | CBON | ETF | 1.05 | 1.0884 | 0.88 | 0.9015 | 81656.0 |
| 2009-08-14 | CEF | ETF | 12.01 | 12.05 | 11.96 | 12.01 | 1697200.0 |
| 2009-08-14 | CEW | ETF | 21.3 | 21.3399 | 21.2003 | 21.2355 | 6716.0 |
| 2009-08-14 | CGO | ETF | 13.4 | 13.42 | 13.14 | 13.15 | 35615.0 |
| 2009-08-14 | CGW | ETF | 16.55 | 16.55 | 16.2 | 16.38 | 31517.0 |
| 2009-08-14 | CHB | ETF | 0.5356 | 0.56 | 0.4306 | 0.44 | 5222940.0 |
| 2009-08-14 | CHI | ETF | 11.36 | 11.4 | 11.24 | 11.32 | 131114.0 |
| 2009-08-14 | CHIC | ETF | 14.08 | 14.45 | 13.75 | 14.04 | 368974.0 |
| 2009-08-14 | CHW | ETF | 7.41 | 7.41 | 7.28 | 7.3351 | 267234.0 |
> showing 50 of 671 rows — these rows as CSV