PREVIEW / etf_daily / 2009-08-04
file: by_date/etf_daily/2009/2009-08-04.parquet size: 29 KB rows: 672
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-08-04 | SPY | ETF | 99.99 | 100.84 | 99.78 | 100.7 | 176714600.0 |
| 2009-08-04 | QQQ | ETF | 39.86 | 40.19 | 39.77 | 40.04 | 100690726.0 |
| 2009-08-04 | IWM | ETF | 56.21 | 57.32 | 56.16 | 57.11 | 41223700.0 |
| 2009-08-04 | DIA | ETF | 92.59 | 93.24 | 92.54 | 93.19 | 12338900.0 |
| 2009-08-04 | GLD | ETF | 94.18 | 95.25 | 93.99 | 94.68 | 11548600.0 |
| 2009-08-04 | TLT | ETF | 93.63 | 93.72 | 91.67 | 92.32 | 3832200.0 |
| 2009-08-04 | AAXJ | ETF | 50.99 | 51.36 | 50.68 | 51.02 | 278500.0 |
| 2009-08-04 | ACWI | ETF | 38.31 | 38.66 | 38.26 | 38.55 | 62400.0 |
| 2009-08-04 | ACWX | ETF | 37.43 | 37.75 | 37.3894 | 37.6699 | 31639.0 |
| 2009-08-04 | ADRE | ETF | 39.05 | 39.43 | 38.88 | 39.23 | 136324.0 |
| 2009-08-04 | AFK | ETF | 28.08 | 28.48 | 28.06 | 28.44 | 66926.0 |
| 2009-08-04 | AGG | ETF | 102.79 | 102.86 | 102.14 | 102.24 | 629900.0 |
| 2009-08-04 | AGQ | ETF | 89.62 | 93.8 | 88.62 | 91.58 | 138900.0 |
| 2009-08-04 | AGZ | ETF | 107.26 | 107.685 | 106.8327 | 106.94 | 11319.0 |
| 2009-08-04 | AIA | ETF | 36.65 | 36.98 | 36.545 | 36.6936 | 154253.0 |
| 2009-08-04 | AIQ | ETF | 26.75 | 27.7995 | 26.05 | 26.9 | 281936.0 |
| 2009-08-04 | AIS | ETF | 0.86 | 0.91 | 0.86 | 0.9 | 132590.0 |
| 2009-08-04 | AIVI | ETF | 39.41 | 39.79 | 39.25 | 39.35 | 17300.0 |
| 2009-08-04 | AMJ | ETF | 25.22 | 25.45 | 25.1992 | 25.23 | 199665.0 |
| 2009-08-04 | AOA | ETF | 27.3 | 27.52 | 27.28 | 27.51 | 8400.0 |
| 2009-08-04 | AOK | ETF | 26.3044 | 26.37 | 26.3044 | 26.37 | 2399.0 |
| 2009-08-04 | AOM | ETF | 26.67 | 27.09 | 26.67 | 26.81 | 11159.0 |
| 2009-08-04 | AOR | ETF | 27.19 | 27.22 | 26.93 | 27.19 | 13927.0 |
| 2009-08-04 | ARB | ETF | 16.5 | 16.74 | 16.36 | 16.71 | 139322.0 |
| 2009-08-04 | BAL | ETF | 32.5 | 32.5 | 32.2 | 32.2 | 2504.0 |
| 2009-08-04 | BBH | ETF | 34.0967 | 34.22 | 33.87 | 34.2 | 507900.0 |
| 2009-08-04 | BIL | ETF | 91.72 | 91.72 | 91.68 | 91.72 | 239900.0 |
| 2009-08-04 | BITS | ETF | 22.6 | 23.0 | 22.44 | 22.92 | 4075.0 |
| 2009-08-04 | BIV | ETF | 78.22 | 78.22 | 77.55 | 77.68 | 86400.0 |
| 2009-08-04 | BJK | ETF | 23.42 | 24.29 | 23.08 | 23.96 | 73000.0 |
| 2009-08-04 | BKF | ETF | 39.75 | 40.29 | 39.6312 | 40.08 | 242629.0 |
| 2009-08-04 | BLV | ETF | 76.2 | 76.37 | 75.16 | 75.75 | 31300.0 |
| 2009-08-04 | BMVP | ETF | 11.62 | 11.72 | 11.62 | 11.69 | 18312.0 |
| 2009-08-04 | BND | ETF | 78.2 | 78.3 | 77.7 | 77.86 | 485900.0 |
| 2009-08-04 | BNE | ETF | 8.31 | 8.4 | 8.09 | 8.09 | 128533.0 |
| 2009-08-04 | BOSS | ETF | 17.45 | 17.45 | 17.45 | 17.45 | 200.0 |
| 2009-08-04 | BRF | ETF | 35.3 | 36.13 | 35.2501 | 35.77 | 437667.0 |
| 2009-08-04 | BSV | ETF | 79.29 | 79.29 | 78.95 | 79.15 | 349200.0 |
| 2009-08-04 | BTF | ETF | 56.349999999999994 | 57.8 | 55.599999999999994 | 57.0 | 13302.400000000001 |
| 2009-08-04 | BWX | ETF | 28.27 | 28.36 | 28.125 | 28.155 | 357120.0 |
| 2009-08-04 | BWZ | ETF | 36.1 | 36.18 | 36.03 | 36.18 | 5700.0 |
| 2009-08-04 | BZQ | ETF | 6996.8 | 7008.0 | 6724.8 | 6827.2 | 11.25 |
| 2009-08-04 | CBON | ETF | 0.75 | 0.79 | 0.62 | 0.64 | 127481.0 |
| 2009-08-04 | CEF | ETF | 12.14 | 12.35 | 12.08 | 12.22 | 859200.0 |
| 2009-08-04 | CEW | ETF | 21.47 | 21.492 | 21.4 | 21.42 | 10283.0 |
| 2009-08-04 | CGO | ETF | 12.78 | 12.92 | 12.66 | 12.862 | 38411.0 |
| 2009-08-04 | CGW | ETF | 16.57 | 16.73 | 16.528 | 16.689 | 44742.0 |
| 2009-08-04 | CHB | ETF | 0.5 | 0.5 | 0.49 | 0.49 | 1165624.0 |
| 2009-08-04 | CHI | ETF | 11.21 | 11.49 | 11.1901 | 11.29 | 192130.0 |
| 2009-08-04 | CHIC | ETF | 14.92 | 15.21 | 14.76 | 15.1 | 114357.0 |
> showing 50 of 672 rows — these rows as CSV