PREVIEW / etf_daily / 2009-05-06
file: by_date/etf_daily/2009/2009-05-06.parquet size: 29 KB rows: 654
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-06 | SPY | ETF | 91.68 | 92.2 | 90.61 | 92.14 | 291941000.0 |
| 2009-05-06 | QQQ | ETF | 35.32 | 35.34 | 34.46 | 35.03 | 178840474.0 |
| 2009-05-06 | IWM | ETF | 50.93 | 51.22 | 49.5 | 50.49 | 87550000.0 |
| 2009-05-06 | DIA | ETF | 85.05 | 85.27 | 84.19 | 85.2 | 18357600.0 |
| 2009-05-06 | GLD | ETF | 89.46 | 89.69 | 88.84 | 89.54 | 11334900.0 |
| 2009-05-06 | TLT | ETF | 97.12 | 98.0 | 97.0 | 97.08 | 2045900.0 |
| 2009-05-06 | AAXJ | ETF | 42.65 | 42.99 | 41.88 | 42.51 | 350000.0 |
| 2009-05-06 | ACWI | ETF | 33.94 | 34.16 | 33.46 | 34.07 | 257800.0 |
| 2009-05-06 | ACWX | ETF | 32.5 | 32.6 | 32.0 | 32.54 | 62695.0 |
| 2009-05-06 | ADRE | ETF | 34.05 | 34.46 | 33.82 | 34.144 | 392045.0 |
| 2009-05-06 | AFK | ETF | 23.16 | 23.705 | 23.16 | 23.7 | 3548.0 |
| 2009-05-06 | AGG | ETF | 101.38 | 101.7 | 101.29 | 101.44 | 833700.0 |
| 2009-05-06 | AGQ | ETF | 85.14 | 86.5 | 84.5 | 85.06 | 130000.0 |
| 2009-05-06 | AGZ | ETF | 108.12 | 108.35 | 107.576 | 108.22 | 16726.0 |
| 2009-05-06 | AIA | ETF | 31.61 | 32.26 | 31.4925 | 32.04 | 38180.0 |
| 2009-05-06 | AIQ | ETF | 39.5 | 39.65 | 38.6 | 38.75 | 32907.0 |
| 2009-05-06 | AIS | ETF | 0.47 | 0.49 | 0.4301 | 0.48 | 176674.0 |
| 2009-05-06 | AIVI | ETF | 33.94 | 34.31 | 33.59 | 34.11 | 11400.0 |
| 2009-05-06 | AMJ | ETF | 21.9 | 21.9 | 21.74 | 21.85 | 32671.0 |
| 2009-05-06 | AOA | ETF | 24.61 | 24.95 | 24.61 | 24.92 | 4500.0 |
| 2009-05-06 | AOK | ETF | 25.58 | 25.6099 | 25.58 | 25.6099 | 2000.0 |
| 2009-05-06 | AOM | ETF | 25.85 | 25.89 | 25.02 | 25.5561 | 22280.0 |
| 2009-05-06 | AOR | ETF | 25.01 | 25.36 | 24.71 | 25.32 | 21855.0 |
| 2009-05-06 | ARB | ETF | 21.1 | 21.29 | 20.72 | 20.95 | 286327.0 |
| 2009-05-06 | BAL | ETF | 32.66 | 32.85 | 32.41 | 32.72 | 2850.0 |
| 2009-05-06 | BBH | ETF | 29.39 | 29.39 | 28.5367 | 28.95 | 937800.0 |
| 2009-05-06 | BIL | ETF | 91.66 | 91.74 | 91.66 | 91.66 | 97050.0 |
| 2009-05-06 | BITS | ETF | 18.44 | 18.44 | 18.2 | 18.4 | 525.0 |
| 2009-05-06 | BIV | ETF | 76.48 | 76.6 | 76.25 | 76.49 | 138500.0 |
| 2009-05-06 | BJK | ETF | 23.46 | 23.46 | 21.95 | 22.5 | 15600.0 |
| 2009-05-06 | BKF | ETF | 32.96 | 32.96 | 32.28 | 32.84 | 176895.0 |
| 2009-05-06 | BLV | ETF | 72.78 | 72.8 | 72.17 | 72.25 | 15000.0 |
| 2009-05-06 | BMVP | ETF | 10.77 | 10.8 | 10.61 | 10.74 | 26591.0 |
| 2009-05-06 | BND | ETF | 76.93 | 77.29 | 76.93 | 77.21 | 550900.0 |
| 2009-05-06 | BNE | ETF | 5.93 | 6.24 | 5.64 | 5.66 | 198706.0 |
| 2009-05-06 | BOSS | ETF | 15.7 | 15.87 | 15.7 | 15.87 | 200.0 |
| 2009-05-06 | BSV | ETF | 78.86 | 79.02 | 78.8 | 78.95 | 189800.0 |
| 2009-05-06 | BTF | ETF | 48.349999999999994 | 48.949999999999996 | 47.5995 | 48.949999999999996 | 18421.0 |
| 2009-05-06 | BWX | ETF | 26.085 | 26.205 | 25.97 | 26.205 | 224464.0 |
| 2009-05-06 | BWZ | ETF | 33.51 | 33.51 | 33.51 | 33.51 | 2500.0 |
| 2009-05-06 | CBON | ETF | 2.0 | 2.0 | 1.81 | 1.84 | 40015.0 |
| 2009-05-06 | CEF | ETF | 11.72 | 11.85 | 11.41 | 11.41 | 1155000.0 |
| 2009-05-06 | CEW | ETF | 20.07 | 20.21 | 20.0699 | 20.2 | 15002.0 |
| 2009-05-06 | CGO | ETF | 10.22 | 10.53 | 10.22 | 10.53 | 82983.0 |
| 2009-05-06 | CGW | ETF | 14.51 | 14.6 | 14.27 | 14.45 | 43409.0 |
| 2009-05-06 | CHB | ETF | 0.59 | 0.6 | 0.56 | 0.57 | 616741.0 |
| 2009-05-06 | CHI | ETF | 9.9 | 10.05 | 9.86 | 10.05 | 187066.0 |
| 2009-05-06 | CHIC | ETF | 12.57 | 12.68 | 12.08 | 12.38 | 244201.0 |
| 2009-05-06 | CHW | ETF | 6.67 | 6.82 | 6.62 | 6.81 | 196656.0 |
| 2009-05-06 | CHY | ETF | 9.66 | 9.75 | 9.62 | 9.73 | 296221.0 |
> showing 50 of 654 rows — these rows as CSV