PREVIEW / etf_daily / 2009-06-22
file: by_date/etf_daily/2009/2009-06-22.parquet size: 29 KB rows: 664
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-06-22 | SPY | ETF | 91.14 | 91.19 | 89.25 | 89.28 | 251913600.0 |
| 2009-06-22 | QQQ | ETF | 35.8 | 35.89 | 35.02 | 35.08 | 137714814.0 |
| 2009-06-22 | IWM | ETF | 50.99 | 51.03 | 49.4 | 49.49 | 54877300.0 |
| 2009-06-22 | DIA | ETF | 84.58 | 84.77 | 83.32 | 83.32 | 20652400.0 |
| 2009-06-22 | GLD | ETF | 90.41 | 90.64 | 90.13 | 90.54 | 12956300.0 |
| 2009-06-22 | TLT | ETF | 92.44 | 92.91 | 92.06 | 92.58 | 3952300.0 |
| 2009-06-22 | AAXJ | ETF | 42.01 | 43.23 | 41.75 | 42.4 | 325700.0 |
| 2009-06-22 | ACWI | ETF | 34.42 | 34.47 | 33.66 | 33.72 | 103200.0 |
| 2009-06-22 | ACWX | ETF | 33.28 | 33.28 | 32.52 | 32.52 | 119562.0 |
| 2009-06-22 | ADRE | ETF | 33.8 | 33.81 | 32.68 | 32.68 | 322991.0 |
| 2009-06-22 | AFK | ETF | 27.5 | 27.5 | 26.01 | 26.2501 | 13168.0 |
| 2009-06-22 | AGG | ETF | 101.56 | 101.64 | 101.25 | 101.39 | 516800.0 |
| 2009-06-22 | AGQ | ETF | 84.1 | 85.16 | 82.54 | 83.02 | 125050.0 |
| 2009-06-22 | AGZ | ETF | 107.2 | 107.2 | 106.29 | 107.05 | 11865.0 |
| 2009-06-22 | AIA | ETF | 31.98 | 31.98 | 30.3169 | 30.49 | 47307.0 |
| 2009-06-22 | AIQ | ETF | 37.85 | 37.85 | 36.25 | 36.8 | 30389.0 |
| 2009-06-22 | AIS | ETF | 0.72 | 0.72 | 0.67 | 0.7 | 60510.0 |
| 2009-06-22 | AIVI | ETF | 35.7 | 35.7 | 33.29 | 33.33 | 27400.0 |
| 2009-06-22 | AMJ | ETF | 22.01 | 22.01 | 21.25 | 21.35 | 113582.0 |
| 2009-06-22 | AOA | ETF | 25.0 | 25.0 | 24.64 | 24.64 | 11400.0 |
| 2009-06-22 | AOK | ETF | 25.48 | 25.54 | 25.33 | 25.54 | 1990.0 |
| 2009-06-22 | AOM | ETF | 25.5 | 26.09 | 25.385 | 25.385 | 2491.0 |
| 2009-06-22 | AOR | ETF | 25.2895 | 25.29 | 25.0932 | 25.12 | 1804.0 |
| 2009-06-22 | ARB | ETF | 17.86 | 17.99 | 16.45 | 16.46 | 261603.0 |
| 2009-06-22 | BAL | ETF | 28.75 | 28.78 | 28.54 | 28.73 | 2798.0 |
| 2009-06-22 | BBH | ETF | 31.0133 | 31.0133 | 30.4567 | 30.5767 | 722700.0 |
| 2009-06-22 | BIL | ETF | 91.76 | 91.76 | 91.72 | 91.76 | 214900.0 |
| 2009-06-22 | BITS | ETF | 17.68 | 19.52 | 17.68 | 18.4 | 2578.0 |
| 2009-06-22 | BIV | ETF | 76.22 | 76.32 | 75.99 | 76.14 | 74900.0 |
| 2009-06-22 | BJK | ETF | 20.16 | 20.5 | 20.11 | 20.2 | 9600.0 |
| 2009-06-22 | BKF | ETF | 34.75 | 34.76 | 33.36 | 33.58 | 211812.0 |
| 2009-06-22 | BLV | ETF | 73.6 | 73.61 | 72.96 | 73.4 | 17100.0 |
| 2009-06-22 | BMVP | ETF | 10.8 | 10.82 | 10.63 | 10.63 | 20387.0 |
| 2009-06-22 | BND | ETF | 77.13 | 77.15 | 76.93 | 76.93 | 336200.0 |
| 2009-06-22 | BNE | ETF | 6.57 | 6.57 | 6.05 | 6.05 | 133314.0 |
| 2009-06-22 | BRF | ETF | 27.45 | 27.45 | 25.88 | 25.88 | 57750.0 |
| 2009-06-22 | BSV | ETF | 78.71 | 78.94 | 78.69 | 78.9 | 317000.0 |
| 2009-06-22 | BTF | ETF | 46.849999999999994 | 47.099999999999994 | 45.949999999999996 | 45.949999999999996 | 11417.6 |
| 2009-06-22 | BWX | ETF | 26.75 | 27.0 | 26.75 | 26.8 | 353082.0 |
| 2009-06-22 | BWZ | ETF | 34.85 | 34.85 | 34.7269 | 34.8 | 2865.0 |
| 2009-06-22 | BZQ | ETF | 10043.2 | 10596.8 | 10043.2 | 10596.8 | 15.75 |
| 2009-06-22 | CBON | ETF | 1.5 | 1.5 | 1.26 | 1.26 | 7500.0 |
| 2009-06-22 | CEF | ETF | 11.85 | 11.92 | 11.74 | 11.82 | 905000.0 |
| 2009-06-22 | CEW | ETF | 20.6 | 20.6 | 20.5 | 20.5 | 33895.0 |
| 2009-06-22 | CGO | ETF | 11.43 | 11.45 | 11.11 | 11.2 | 24441.0 |
| 2009-06-22 | CGW | ETF | 15.49 | 15.49 | 14.9 | 14.98 | 102214.0 |
| 2009-06-22 | CHB | ETF | 0.37 | 0.37 | 0.34 | 0.34 | 371241.0 |
| 2009-06-22 | CHI | ETF | 10.52 | 10.52 | 10.19 | 10.3307 | 118127.0 |
| 2009-06-22 | CHIC | ETF | 11.96 | 11.99 | 11.52 | 11.62 | 226155.0 |
| 2009-06-22 | CHW | ETF | 6.89 | 6.89 | 6.54 | 6.5848 | 200604.0 |
> showing 50 of 664 rows — these rows as CSV