PREVIEW / etf_daily / 2009-07-24
file: by_date/etf_daily/2009/2009-07-24.parquet size: 29 KB rows: 659
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-07-24 | SPY | ETF | 97.2 | 98.14 | 96.69 | 98.06 | 154003100.0 |
| 2009-07-24 | QQQ | ETF | 38.93 | 39.37 | 38.7799 | 39.05 | 109312234.0 |
| 2009-07-24 | IWM | ETF | 54.17 | 54.87 | 53.96 | 54.81 | 31293500.0 |
| 2009-07-24 | DIA | ETF | 90.4 | 91.03 | 90.07 | 90.97 | 10895100.0 |
| 2009-07-24 | GLD | ETF | 93.48 | 93.71 | 93.33 | 93.41 | 4734000.0 |
| 2009-07-24 | TLT | ETF | 91.0 | 91.45 | 90.77 | 91.45 | 1765300.0 |
| 2009-07-24 | AAXJ | ETF | 49.34 | 49.34 | 48.25 | 49.03 | 255200.0 |
| 2009-07-24 | ACWI | ETF | 36.92 | 37.21 | 36.74 | 37.21 | 298400.0 |
| 2009-07-24 | ACWX | ETF | 35.88 | 36.1 | 35.664 | 36.094 | 44024.0 |
| 2009-07-24 | ADRE | ETF | 37.8 | 37.8999 | 37.3601 | 37.81 | 103365.0 |
| 2009-07-24 | AFK | ETF | 27.9 | 27.9 | 27.38 | 27.768 | 44838.0 |
| 2009-07-24 | AGG | ETF | 102.2 | 102.55 | 102.11 | 102.39 | 579900.0 |
| 2009-07-24 | AGQ | ETF | 82.5 | 83.68 | 82.04 | 83.52 | 66950.0 |
| 2009-07-24 | AGZ | ETF | 107.47 | 107.59 | 107.422 | 107.59 | 5317.0 |
| 2009-07-24 | AIA | ETF | 35.4 | 35.69 | 35.22 | 35.53 | 31094.0 |
| 2009-07-24 | AIQ | ETF | 31.8 | 33.6 | 31.75 | 33.3 | 40953.0 |
| 2009-07-24 | AIS | ETF | 0.9 | 0.9 | 0.82 | 0.88 | 390384.0 |
| 2009-07-24 | AIVI | ETF | 38.1 | 38.1 | 37.29 | 37.75 | 16200.0 |
| 2009-07-24 | AMJ | ETF | 24.38 | 24.64 | 24.21 | 24.611 | 106378.0 |
| 2009-07-24 | AOA | ETF | 26.51 | 26.71 | 26.4 | 26.71 | 16400.0 |
| 2009-07-24 | AOK | ETF | 26.011 | 26.1 | 25.44 | 26.03 | 6794.0 |
| 2009-07-24 | AOM | ETF | 26.31 | 26.37 | 26.06 | 26.36 | 27856.0 |
| 2009-07-24 | AOR | ETF | 26.26 | 26.58 | 26.26 | 26.58 | 7084.0 |
| 2009-07-24 | ARB | ETF | 17.4 | 17.82 | 17.03 | 17.74 | 229717.0 |
| 2009-07-24 | BAL | ETF | 31.99 | 32.07 | 30.95 | 31.0025 | 10803.0 |
| 2009-07-24 | BBH | ETF | 32.9867 | 33.6633 | 32.9867 | 33.6533 | 445800.0 |
| 2009-07-24 | BIL | ETF | 91.72 | 91.72 | 91.7 | 91.7 | 815800.0 |
| 2009-07-24 | BITS | ETF | 22.12 | 22.64 | 22.0 | 22.64 | 786.0 |
| 2009-07-24 | BIV | ETF | 77.37 | 77.57 | 77.29 | 77.47 | 118800.0 |
| 2009-07-24 | BJK | ETF | 22.21 | 22.67 | 22.16 | 22.36 | 12100.0 |
| 2009-07-24 | BKF | ETF | 38.16 | 38.48 | 37.54 | 38.4 | 229839.0 |
| 2009-07-24 | BLV | ETF | 73.81 | 74.18 | 73.66 | 73.77 | 4100.0 |
| 2009-07-24 | BMVP | ETF | 11.41 | 11.46 | 11.36 | 11.45 | 60300.0 |
| 2009-07-24 | BND | ETF | 77.79 | 77.88 | 77.6 | 77.8 | 417900.0 |
| 2009-07-24 | BNE | ETF | 8.0 | 8.04 | 7.84 | 7.95 | 168758.0 |
| 2009-07-24 | BRF | ETF | 31.79 | 32.78 | 31.545 | 31.98 | 217764.0 |
| 2009-07-24 | BSV | ETF | 79.28 | 79.39 | 79.16 | 79.24 | 275200.0 |
| 2009-07-24 | BTF | ETF | 51.74999999999999 | 52.699999999999996 | 51.3 | 52.5 | 5383.200000000001 |
| 2009-07-24 | BWX | ETF | 27.725 | 27.815 | 27.6376 | 27.815 | 340134.0 |
| 2009-07-24 | BWZ | ETF | 35.73 | 35.7455 | 35.73 | 35.734 | 1139.0 |
| 2009-07-24 | BZQ | ETF | 7868.8 | 7950.4 | 7832.0 | 7832.0 | 25.75 |
| 2009-07-24 | CBON | ETF | 0.7 | 0.75 | 0.69 | 0.69 | 13896.0 |
| 2009-07-24 | CEF | ETF | 11.97 | 12.0 | 11.9 | 11.93 | 396500.0 |
| 2009-07-24 | CEW | ETF | 21.3 | 21.79 | 21.13 | 21.32 | 43404.0 |
| 2009-07-24 | CGO | ETF | 12.2 | 12.67 | 11.66 | 12.3 | 46058.0 |
| 2009-07-24 | CGW | ETF | 16.11 | 16.39 | 16.03 | 16.376 | 41894.0 |
| 2009-07-24 | CHB | ETF | 0.321 | 0.34 | 0.31 | 0.33 | 876480.0 |
| 2009-07-24 | CHI | ETF | 10.89 | 11.23 | 10.87 | 11.05 | 150253.0 |
| 2009-07-24 | CHIC | ETF | 14.47 | 14.48 | 13.75 | 14.1 | 422260.0 |
| 2009-07-24 | CHW | ETF | 6.86 | 6.97 | 6.8 | 6.97 | 193854.0 |
> showing 50 of 659 rows — these rows as CSV