PREVIEW / etf_daily / 2009-04-30
file: by_date/etf_daily/2009/2009-04-30.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-30 | SPY | ETF | 88.55 | 89.02 | 86.92 | 87.42 | 301419800.0 |
| 2009-04-30 | QQQ | ETF | 34.37 | 34.9 | 34.04 | 34.28 | 144120353.0 |
| 2009-04-30 | IWM | ETF | 49.75 | 50.24 | 48.45 | 48.52 | 67809000.0 |
| 2009-04-30 | DIA | ETF | 82.73 | 83.06 | 81.35 | 81.67 | 17496500.0 |
| 2009-04-30 | GLD | ETF | 86.83 | 87.78 | 86.54 | 87.27 | 9713800.0 |
| 2009-04-30 | TLT | ETF | 97.98 | 98.36 | 97.39 | 98.08 | 2778100.0 |
| 2009-04-30 | AAXJ | ETF | 38.98 | 39.29 | 38.54 | 38.84 | 146700.0 |
| 2009-04-30 | ACWI | ETF | 32.23 | 32.42 | 31.73 | 31.95 | 415000.0 |
| 2009-04-30 | ACWX | ETF | 30.43 | 30.65 | 29.98 | 30.19 | 22103.0 |
| 2009-04-30 | ADRE | ETF | 31.55 | 31.55 | 30.85 | 31.06 | 279106.0 |
| 2009-04-30 | AFK | ETF | 21.93 | 21.93 | 21.05 | 21.93 | 1400.0 |
| 2009-04-30 | AGG | ETF | 101.33 | 101.64 | 100.96 | 101.64 | 760700.0 |
| 2009-04-30 | AGQ | ETF | 69.5 | 71.06 | 67.84 | 69.44 | 132100.0 |
| 2009-04-30 | AGZ | ETF | 107.64 | 108.04 | 107.64 | 107.75 | 5966.0 |
| 2009-04-30 | AIA | ETF | 29.26 | 29.77 | 28.43 | 29.5411 | 55587.0 |
| 2009-04-30 | AIQ | ETF | 43.85 | 45.0 | 39.35 | 39.35 | 169054.0 |
| 2009-04-30 | AIS | ETF | 0.4 | 0.42 | 0.3999 | 0.42 | 205837.0 |
| 2009-04-30 | AIVI | ETF | 32.5 | 32.73 | 31.98 | 32.2 | 7700.0 |
| 2009-04-30 | AMJ | ETF | 21.92 | 21.92 | 21.16 | 21.21 | 5974.0 |
| 2009-04-30 | AOA | ETF | 24.25 | 24.25 | 23.92 | 23.93 | 5200.0 |
| 2009-04-30 | AOK | ETF | 25.37 | 25.5132 | 25.216 | 25.35 | 4370.0 |
| 2009-04-30 | AOM | ETF | 25.49 | 25.49 | 24.62 | 24.9501 | 10416.0 |
| 2009-04-30 | AOR | ETF | 24.85 | 25.29 | 24.5 | 24.5501 | 11305.0 |
| 2009-04-30 | ARB | ETF | 21.39 | 21.81 | 20.81 | 20.82 | 408629.0 |
| 2009-04-30 | BAL | ETF | 30.01 | 30.4321 | 29.96 | 30.4321 | 3500.0 |
| 2009-04-30 | BBH | ETF | 30.4733 | 30.7533 | 29.36 | 29.54 | 852900.0 |
| 2009-04-30 | BIL | ETF | 91.76 | 91.78 | 91.72 | 91.76 | 183900.0 |
| 2009-04-30 | BITS | ETF | 17.8 | 17.8 | 16.72 | 17.64 | 1212.0 |
| 2009-04-30 | BIV | ETF | 76.39 | 76.67 | 76.22 | 76.67 | 58200.0 |
| 2009-04-30 | BJK | ETF | 20.16 | 20.6 | 20.01 | 20.32 | 37800.0 |
| 2009-04-30 | BKF | ETF | 30.0 | 30.86 | 29.08 | 29.09 | 116034.0 |
| 2009-04-30 | BLV | ETF | 72.51 | 72.51 | 71.75 | 72.0 | 10700.0 |
| 2009-04-30 | BMVP | ETF | 10.62 | 10.68 | 10.43 | 10.46 | 17882.0 |
| 2009-04-30 | BND | ETF | 77.05 | 77.25 | 77.02 | 77.23 | 487600.0 |
| 2009-04-30 | BNE | ETF | 5.5 | 6.07 | 5.1 | 5.11 | 296643.0 |
| 2009-04-30 | BOSS | ETF | 14.37 | 14.91 | 14.37 | 14.58 | 100.0 |
| 2009-04-30 | BSV | ETF | 78.93 | 79.05 | 78.81 | 78.94 | 144000.0 |
| 2009-04-30 | BTF | ETF | 47.099999999999994 | 47.5 | 46.449999999999996 | 47.0 | 11307.0 |
| 2009-04-30 | BWX | ETF | 25.84 | 25.925 | 25.745 | 25.805 | 392002.0 |
| 2009-04-30 | BWZ | ETF | 33.26 | 33.26 | 33.22 | 33.24 | 418.0 |
| 2009-04-30 | CBON | ETF | 2.46 | 2.5 | 2.24 | 2.25 | 78520.0 |
| 2009-04-30 | CEF | ETF | 11.2 | 11.29 | 11.06 | 11.2 | 685200.0 |
| 2009-04-30 | CGO | ETF | 9.86 | 9.99 | 9.78 | 9.78 | 24780.0 |
| 2009-04-30 | CGW | ETF | 13.86 | 14.02 | 13.68 | 13.75 | 47875.0 |
| 2009-04-30 | CHB | ETF | 0.6 | 0.6 | 0.55 | 0.58 | 491436.0 |
| 2009-04-30 | CHI | ETF | 9.45 | 9.55 | 9.06 | 9.06 | 216822.0 |
| 2009-04-30 | CHIC | ETF | 12.5 | 12.97 | 12.17 | 12.55 | 425867.0 |
| 2009-04-30 | CHW | ETF | 6.51 | 6.54 | 6.35 | 6.42 | 204785.0 |
| 2009-04-30 | CHY | ETF | 9.13 | 9.2 | 8.9 | 8.9 | 269808.0 |
| 2009-04-30 | CMF | ETF | 52.385 | 52.39 | 52.34 | 52.375 | 18730.0 |
> showing 50 of 650 rows — these rows as CSV