PREVIEW / etf_daily / 2009-05-19
file: by_date/etf_daily/2009/2009-05-19.parquet size: 29 KB rows: 656
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-05-19 | SPY | ETF | 91.18 | 91.97 | 90.81 | 91.12 | 206102200.0 |
| 2009-05-19 | QQQ | ETF | 34.14 | 34.74 | 33.95 | 34.4 | 129086394.0 |
| 2009-05-19 | IWM | ETF | 49.37 | 49.96 | 48.8 | 49.38 | 55704100.0 |
| 2009-05-19 | DIA | ETF | 84.94 | 85.39 | 84.63 | 84.74 | 17908900.0 |
| 2009-05-19 | GLD | ETF | 90.64 | 91.35 | 90.57 | 90.96 | 9630300.0 |
| 2009-05-19 | TLT | ETF | 96.19 | 96.47 | 95.71 | 96.01 | 1624300.0 |
| 2009-05-19 | AAXJ | ETF | 43.56 | 43.86 | 43.13 | 43.47 | 349200.0 |
| 2009-05-19 | ACWI | ETF | 34.15 | 34.55 | 34.03 | 34.26 | 110500.0 |
| 2009-05-19 | ACWX | ETF | 33.05 | 33.47 | 32.998 | 33.17 | 69167.0 |
| 2009-05-19 | ADRE | ETF | 34.45 | 34.99 | 34.26 | 34.69 | 283366.0 |
| 2009-05-19 | AFK | ETF | 24.3 | 24.65 | 24.3 | 24.65 | 900.0 |
| 2009-05-19 | AGG | ETF | 101.85 | 102.05 | 101.8 | 101.98 | 586100.0 |
| 2009-05-19 | AGQ | ETF | 88.06 | 92.1 | 87.68 | 90.96 | 114500.0 |
| 2009-05-19 | AGZ | ETF | 107.8 | 107.86 | 107.35 | 107.81 | 4885.0 |
| 2009-05-19 | AIA | ETF | 31.97 | 32.59 | 31.97 | 32.26 | 15503.0 |
| 2009-05-19 | AIQ | ETF | 35.65 | 36.6 | 35.0 | 35.45 | 46309.0 |
| 2009-05-19 | AIS | ETF | 0.6114 | 0.6114 | 0.53 | 0.55 | 66018.0 |
| 2009-05-19 | AIVI | ETF | 34.72 | 35.34 | 34.72 | 35.05 | 5600.0 |
| 2009-05-19 | AMJ | ETF | 22.0 | 22.15 | 21.8 | 22.06 | 143320.0 |
| 2009-05-19 | AOA | ETF | 24.97 | 25.01 | 24.97 | 24.98 | 1600.0 |
| 2009-05-19 | AOK | ETF | 25.98 | 25.98 | 25.66 | 25.71 | 4580.0 |
| 2009-05-19 | AOM | ETF | 25.6 | 25.8074 | 25.5768 | 25.8074 | 8181.0 |
| 2009-05-19 | AOR | ETF | 25.3032 | 25.4 | 24.7101 | 25.34 | 4274.0 |
| 2009-05-19 | ARB | ETF | 19.92 | 20.72 | 19.63 | 20.37 | 205324.0 |
| 2009-05-19 | BAL | ETF | 32.03 | 32.104 | 31.5 | 32.104 | 7355.0 |
| 2009-05-19 | BBH | ETF | 29.8033 | 29.92 | 29.5467 | 29.8267 | 296100.0 |
| 2009-05-19 | BIL | ETF | 91.7 | 91.74 | 91.68 | 91.74 | 122100.0 |
| 2009-05-19 | BITS | ETF | 17.96 | 18.32 | 17.2 | 18.1996 | 1050.0 |
| 2009-05-19 | BIV | ETF | 77.23 | 77.23 | 76.73 | 77.02 | 127200.0 |
| 2009-05-19 | BJK | ETF | 20.89 | 22.26 | 20.89 | 21.51 | 48700.0 |
| 2009-05-19 | BKF | ETF | 34.32 | 34.6402 | 33.802 | 34.08 | 359814.0 |
| 2009-05-19 | BLV | ETF | 73.87 | 73.87 | 72.71 | 73.11 | 21400.0 |
| 2009-05-19 | BMVP | ETF | 10.6567 | 10.7967 | 10.615 | 10.7044 | 27675.0 |
| 2009-05-19 | BND | ETF | 77.42 | 77.56 | 77.26 | 77.54 | 362400.0 |
| 2009-05-19 | BNE | ETF | 5.73 | 5.87 | 5.43 | 5.74 | 185143.0 |
| 2009-05-19 | BOSS | ETF | 16.55 | 17.28 | 16.55 | 17.0 | 600.0 |
| 2009-05-19 | BRF | ETF | 25.99 | 26.89 | 25.69 | 26.31 | 101209.0 |
| 2009-05-19 | BSV | ETF | 79.13 | 79.2 | 78.95 | 79.11 | 336600.0 |
| 2009-05-19 | BTF | ETF | 47.599999999999994 | 48.05 | 47.3505 | 47.8 | 9333.2 |
| 2009-05-19 | BWX | ETF | 26.525 | 26.615 | 26.445 | 26.505 | 222584.0 |
| 2009-05-19 | BWZ | ETF | 34.32 | 34.4425 | 34.2501 | 34.4425 | 1880.0 |
| 2009-05-19 | CBON | ETF | 1.22 | 1.379 | 1.21 | 1.3 | 32047.0 |
| 2009-05-19 | CEF | ETF | 11.48 | 11.7 | 11.43 | 11.6 | 758200.0 |
| 2009-05-19 | CEW | ETF | 20.42 | 20.55 | 20.3501 | 20.54 | 208135.0 |
| 2009-05-19 | CGO | ETF | 10.41 | 10.55 | 10.2504 | 10.42 | 38367.0 |
| 2009-05-19 | CGW | ETF | 14.73 | 15.15 | 14.73 | 15.03 | 41566.0 |
| 2009-05-19 | CHB | ETF | 0.5 | 0.5 | 0.46 | 0.47 | 367957.0 |
| 2009-05-19 | CHI | ETF | 10.28 | 10.34 | 10.16 | 10.25 | 186978.0 |
| 2009-05-19 | CHIC | ETF | 10.92 | 11.44 | 10.57 | 10.59 | 273742.0 |
| 2009-05-19 | CHW | ETF | 6.56 | 6.71 | 6.53 | 6.63 | 172116.0 |
> showing 50 of 656 rows — these rows as CSV