PREVIEW / etf_daily / 2009-05-14
file: by_date/etf_daily/2009/2009-05-14.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-05-14 | SPY | ETF | 88.72 | 90.12 | 88.5 | 89.44 | 260098700.0 |
| 2009-05-14 | QQQ | ETF | 33.1 | 33.7 | 33.08 | 33.39 | 140021617.0 |
| 2009-05-14 | IWM | ETF | 47.39 | 48.75 | 47.06 | 47.94 | 72813500.0 |
| 2009-05-14 | DIA | ETF | 83.12 | 83.97 | 82.94 | 83.39 | 15029400.0 |
| 2009-05-14 | GLD | ETF | 90.9 | 91.26 | 90.7 | 91.03 | 8023400.0 |
| 2009-05-14 | TLT | ETF | 97.6 | 98.25 | 97.3 | 98.07 | 1704600.0 |
| 2009-05-14 | AAXJ | ETF | 40.83 | 41.15 | 40.06 | 40.91 | 578000.0 |
| 2009-05-14 | ACWI | ETF | 32.84 | 33.43 | 32.8 | 33.22 | 38700.0 |
| 2009-05-14 | ACWX | ETF | 31.48 | 32.07 | 31.42 | 31.86 | 42988.0 |
| 2009-05-14 | ADRE | ETF | 32.4 | 32.98 | 32.06 | 32.85 | 103235.0 |
| 2009-05-14 | AFK | ETF | 24.01 | 24.23 | 24.0 | 24.23 | 3688.0 |
| 2009-05-14 | AGG | ETF | 102.05 | 102.08 | 101.69 | 101.96 | 453900.0 |
| 2009-05-14 | AGQ | ETF | 87.7 | 89.64 | 86.66 | 88.9 | 105000.0 |
| 2009-05-14 | AGZ | ETF | 108.18 | 108.27 | 108.17 | 108.27 | 6257.0 |
| 2009-05-14 | AIA | ETF | 30.1 | 30.83 | 30.1 | 30.6999 | 23417.0 |
| 2009-05-14 | AIQ | ETF | 37.65 | 38.0 | 32.05 | 35.8 | 374729.0 |
| 2009-05-14 | AIS | ETF | 0.52 | 0.54 | 0.52 | 0.53 | 19560.0 |
| 2009-05-14 | AIVI | ETF | 33.38 | 34.1 | 33.38 | 33.96 | 9300.0 |
| 2009-05-14 | AMJ | ETF | 21.15 | 21.46 | 21.0 | 21.46 | 37944.0 |
| 2009-05-14 | AOA | ETF | 24.07 | 24.42 | 24.0 | 24.35 | 2700.0 |
| 2009-05-14 | AOK | ETF | 25.3901 | 25.56 | 25.3901 | 25.54 | 4508.0 |
| 2009-05-14 | AOM | ETF | 25.2618 | 25.37 | 25.2618 | 25.35 | 1467.0 |
| 2009-05-14 | AOR | ETF | 24.85 | 24.97 | 24.81 | 24.81 | 5296.0 |
| 2009-05-14 | ARB | ETF | 19.11 | 19.46 | 18.75 | 19.16 | 148084.0 |
| 2009-05-14 | BAL | ETF | 32.87 | 33.3 | 32.87 | 33.3 | 450.0 |
| 2009-05-14 | BBH | ETF | 29.49 | 30.03 | 29.49 | 29.58 | 522900.0 |
| 2009-05-14 | BIL | ETF | 91.68 | 91.72 | 91.68 | 91.7 | 232850.0 |
| 2009-05-14 | BITS | ETF | 17.92 | 18.24 | 16.24 | 17.4 | 7094.0 |
| 2009-05-14 | BIV | ETF | 77.51 | 77.51 | 77.01 | 77.39 | 79100.0 |
| 2009-05-14 | BJK | ETF | 20.33 | 21.09 | 19.94 | 20.47 | 27200.0 |
| 2009-05-14 | BKF | ETF | 31.05 | 32.06 | 31.03 | 31.99 | 65813.0 |
| 2009-05-14 | BLV | ETF | 73.79 | 73.82 | 73.2 | 73.57 | 18500.0 |
| 2009-05-14 | BMVP | ETF | 10.37 | 10.56 | 10.33 | 10.47 | 13794.0 |
| 2009-05-14 | BND | ETF | 77.64 | 77.77 | 77.52 | 77.62 | 396300.0 |
| 2009-05-14 | BNE | ETF | 4.51 | 5.15 | 4.25 | 5.02 | 238488.0 |
| 2009-05-14 | BOSS | ETF | 17.4 | 17.4 | 17.4 | 17.4 | 200.0 |
| 2009-05-14 | BRF | ETF | 23.68 | 24.49 | 23.68 | 24.45 | 31423.0 |
| 2009-05-14 | BSV | ETF | 79.21 | 79.4 | 79.14 | 79.25 | 259900.0 |
| 2009-05-14 | BTF | ETF | 46.95 | 47.449999999999996 | 45.99999999999999 | 47.35 | 7783.200000000001 |
| 2009-05-14 | BWX | ETF | 26.525 | 26.575 | 26.435 | 26.575 | 221226.0 |
| 2009-05-14 | BWZ | ETF | 34.24 | 34.34 | 34.17 | 34.34 | 1745.0 |
| 2009-05-14 | CBON | ETF | 1.4201 | 1.43 | 1.26 | 1.35 | 39966.0 |
| 2009-05-14 | CEF | ETF | 11.26 | 11.45 | 11.26 | 11.44 | 579700.0 |
| 2009-05-14 | CEW | ETF | 20.1 | 20.18 | 20.0672 | 20.17 | 13004.0 |
| 2009-05-14 | CGO | ETF | 10.0 | 10.28 | 10.0 | 10.12 | 45703.0 |
| 2009-05-14 | CGW | ETF | 14.04 | 14.382 | 14.04 | 14.34 | 62382.0 |
| 2009-05-14 | CHB | ETF | 0.45 | 0.51 | 0.45 | 0.49 | 657009.0 |
| 2009-05-14 | CHI | ETF | 9.8 | 10.14 | 9.54 | 9.9101 | 267868.0 |
| 2009-05-14 | CHIC | ETF | 10.56 | 11.19 | 10.18 | 10.81 | 167918.0 |
| 2009-05-14 | CHW | ETF | 6.66 | 6.66 | 6.1 | 6.32 | 300785.0 |
> showing 50 of 650 rows — these rows as CSV