PREVIEW / etf_daily / 2005-06-22
file: by_date/etf_daily/2005/2005-06-22.parquet size: 15 KB rows: 267
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-22 | SPY | ETF | 121.68 | 121.94 | 121.07 | 121.57 | 46310100.0 |
| 2005-06-22 | QQQ | ETF | 38.0 | 38.1 | 37.63 | 37.81 | 75517520.0 |
| 2005-06-22 | IWM | ETF | 63.97 | 64.22 | 63.49 | 64.01 | 15672300.0 |
| 2005-06-22 | DIA | ETF | 106.21 | 106.33 | 105.67 | 106.02 | 3443200.0 |
| 2005-06-22 | GLD | ETF | 43.66 | 43.76 | 43.53 | 43.72 | 1258500.0 |
| 2005-06-22 | TLT | ETF | 95.49 | 96.09 | 95.26 | 96.01 | 952200.0 |
| 2005-06-22 | AAA | ETF | 57.57 | 57.9 | 57.39 | 57.39 | 4000.0 |
| 2005-06-22 | ADRE | ETF | 90.75 | 92.19 | 89.62 | 91.74 | 7180.0 |
| 2005-06-22 | AFK | ETF | 26.26 | 26.32 | 26.194 | 26.25 | 6000.0 |
| 2005-06-22 | AGG | ETF | 103.05 | 103.27 | 102.71 | 103.26 | 71600.0 |
| 2005-06-22 | AIQ | ETF | 52.2 | 52.2 | 51.4 | 51.5 | 14940.0 |
| 2005-06-22 | AIS | ETF | 1.05 | 1.09 | 0.9515 | 1.0 | 291000.0 |
| 2005-06-22 | ARB | ETF | 43.84 | 44.0 | 43.05 | 43.07 | 220000.0 |
| 2005-06-22 | BAB | ETF | 50.47 | 51.08 | 50.47 | 50.91 | 28000.0 |
| 2005-06-22 | BBH | ETF | 56.4033 | 56.6967 | 55.9433 | 56.0333 | 1312800.0 |
| 2005-06-22 | BCM | ETF | 61.38 | 62.28 | 61.25 | 62.26 | 14400.0 |
| 2005-06-22 | BIS | ETF | 622.4 | 622.4 | 616.0 | 617.6 | 13.75 |
| 2005-06-22 | BITS | ETF | 13.6 | 13.6 | 12.8 | 12.8 | 2406.0 |
| 2005-06-22 | BKF | ETF | 38.55 | 38.69 | 37.7 | 37.9 | 134000.0 |
| 2005-06-22 | BNE | ETF | 13.95 | 14.28 | 13.9 | 14.27 | 149400.0 |
| 2005-06-22 | BRF | ETF | 15.45 | 15.6 | 15.45 | 15.6 | 6600.0 |
| 2005-06-22 | BTF | ETF | 86.4 | 86.75 | 85.85000000000001 | 86.5 | 2420.0 |
| 2005-06-22 | CBON | ETF | 32.0 | 32.0 | 29.85 | 30.44 | 27742.0 |
| 2005-06-22 | CDC | ETF | 6.95 | 7.0 | 6.94 | 6.94 | 3800.0 |
| 2005-06-22 | CDL | ETF | 11.95 | 12.12 | 11.8 | 12.01 | 396300.0 |
| 2005-06-22 | CEF | ETF | 5.36 | 5.39 | 5.32 | 5.35 | 259200.0 |
| 2005-06-22 | CEW | ETF | 26.46 | 26.5 | 26.46 | 26.5 | 500.0 |
| 2005-06-22 | CHB | ETF | 10.0 | 10.0 | 9.66 | 9.95 | 390000.0 |
| 2005-06-22 | CHI | ETF | 19.47 | 19.55 | 19.42 | 19.44 | 72600.0 |
| 2005-06-22 | CHIC | ETF | 12.81 | 12.91 | 12.52 | 12.69 | 228537.0 |
| 2005-06-22 | CHIR | ETF | 35.4399 | 35.76 | 35.0301 | 35.3601 | 971254.0 |
| 2005-06-22 | CHY | ETF | 16.23 | 16.25 | 16.16 | 16.24 | 176900.0 |
| 2005-06-22 | CIZ | ETF | 22.6 | 22.6 | 22.6 | 22.6 | 200.0 |
| 2005-06-22 | CN | ETF | 28.35 | 28.59 | 28.35 | 28.54 | 41700.0 |
| 2005-06-22 | CNXT | ETF | 1.65 | 1.75 | 1.64 | 1.67 | 8006339.0 |
| 2005-06-22 | CPST | ETF | 1.32 | 1.38 | 1.23 | 1.35 | 1160631.0 |
| 2005-06-22 | CSB | ETF | 30.4 | 30.6 | 30.3 | 30.47 | 10800.0 |
| 2005-06-22 | CSQ | ETF | 13.8 | 13.88 | 13.76 | 13.79 | 373400.0 |
| 2005-06-22 | CTEC | ETF | 50.49999999999999 | 52.599999999999994 | 50.49999999999999 | 51.699999999999996 | 25595.600000000002 |
| 2005-06-22 | CURE | ETF | 0.265 | 0.265 | 0.25 | 0.2512 | 417944.0 |
| 2005-06-22 | CYA | ETF | 140.0 | 143.2 | 139.0 | 142.0 | 245.0 |
| 2005-06-22 | CYB | ETF | 3.15 | 3.2 | 3.05 | 3.19 | 31500.0 |
| 2005-06-22 | DGT | ETF | 64.26 | 64.44 | 64.26 | 64.3 | 1000.0 |
| 2005-06-22 | DIG | ETF | 12.375 | 12.375 | 12.375 | 12.375 | 2640.0 |
| 2005-06-22 | DIV | ETF | 13.75 | 13.85 | 13.7 | 13.85 | 11800.0 |
| 2005-06-22 | DRIV | ETF | 31.63 | 31.99 | 30.8 | 31.12 | 968474.0 |
| 2005-06-22 | DSI | ETF | 5.975 | 5.975 | 5.865 | 5.865 | 3200.0 |
| 2005-06-22 | DUSA | ETF | 9.4 | 9.4 | 8.56 | 8.915 | 425337.0 |
| 2005-06-22 | DVY | ETF | 62.55 | 62.6 | 62.15 | 62.44 | 379000.0 |
| 2005-06-22 | EDEN | ETF | 0.66 | 0.728 | 0.65 | 0.728 | 5984.0 |
> showing 50 of 267 rows — these rows as CSV