PREVIEW / etf_daily / 2006-05-24
file: by_date/etf_daily/2006/2006-05-24.parquet size: 17 KB rows: 325
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-24 | SPY | ETF | 125.68 | 126.89 | 124.76 | 126.17 | 168405000.0 |
| 2006-05-24 | QQQ | ETF | 38.53 | 39.04 | 38.23 | 38.85 | 234998203.0 |
| 2006-05-24 | IWM | ETF | 70.49 | 71.37 | 69.11 | 70.72 | 124700200.0 |
| 2006-05-24 | DIA | ETF | 110.85 | 111.57 | 110.19 | 111.13 | 15372400.0 |
| 2006-05-24 | GLD | ETF | 64.83 | 65.16 | 63.22 | 64.06 | 11065600.0 |
| 2006-05-24 | TLT | ETF | 84.81 | 85.0 | 84.53 | 84.6 | 1226300.0 |
| 2006-05-24 | AAA | ETF | 58.74 | 58.83 | 58.18 | 58.64 | 9100.0 |
| 2006-05-24 | ADRE | ETF | 122.6 | 123.15 | 118.33 | 120.61 | 196096.0 |
| 2006-05-24 | AFK | ETF | 25.16 | 25.21 | 25.05 | 25.11 | 9700.0 |
| 2006-05-24 | AGG | ETF | 98.19 | 98.42 | 98.01 | 98.01 | 192300.0 |
| 2006-05-24 | AIQ | ETF | 30.2 | 30.45 | 28.65 | 29.05 | 34240.0 |
| 2006-05-24 | AIS | ETF | 1.25 | 1.25 | 1.17 | 1.21 | 160900.0 |
| 2006-05-24 | AOM | ETF | 7.4 | 7.41 | 7.0 | 7.16 | 59400.0 |
| 2006-05-24 | ARB | ETF | 38.81 | 40.13 | 38.65 | 39.87 | 637300.0 |
| 2006-05-24 | BAB | ETF | 63.23 | 63.26 | 62.0 | 62.77 | 50700.0 |
| 2006-05-24 | BBC | ETF | 11.3 | 11.54 | 11.0001 | 11.07 | 241000.0 |
| 2006-05-24 | BBH | ETF | 56.6667 | 57.3467 | 55.8233 | 57.13 | 4022100.0 |
| 2006-05-24 | BCM | ETF | 71.28 | 72.05 | 71.09 | 71.85 | 22800.0 |
| 2006-05-24 | BITS | ETF | 25.2 | 26.48 | 24.36 | 25.68 | 15166.0 |
| 2006-05-24 | BKF | ETF | 7.75 | 7.84 | 7.61 | 7.74 | 49400.0 |
| 2006-05-24 | BNE | ETF | 14.34 | 14.63 | 14.04 | 14.58 | 307800.0 |
| 2006-05-24 | BRF | ETF | 13.95 | 14.0 | 13.92 | 13.94 | 22900.0 |
| 2006-05-24 | BTF | ETF | 88.75 | 88.94999999999999 | 88.69999999999999 | 88.69999999999999 | 460.0 |
| 2006-05-24 | CBON | ETF | 31.9 | 32.38 | 31.9 | 32.3 | 25153.0 |
| 2006-05-24 | CDL | ETF | 9.92 | 9.94 | 9.58 | 9.72 | 693600.0 |
| 2006-05-24 | CEF | ETF | 8.85 | 9.0 | 8.8 | 8.86 | 822000.0 |
| 2006-05-24 | CEW | ETF | 25.75 | 25.75 | 25.75 | 25.75 | 400.0 |
| 2006-05-24 | CFO | ETF | 10.05 | 10.05 | 10.02 | 10.02 | 17500.0 |
| 2006-05-24 | CGO | ETF | 14.25 | 14.25 | 13.94 | 14.0 | 30600.0 |
| 2006-05-24 | CHB | ETF | 12.97 | 13.36 | 12.52 | 12.99 | 1110700.0 |
| 2006-05-24 | CHI | ETF | 19.7 | 19.84 | 19.66 | 19.82 | 100200.0 |
| 2006-05-24 | CHIC | ETF | 21.13 | 21.4 | 19.86 | 20.43 | 677980.0 |
| 2006-05-24 | CHY | ETF | 16.47 | 16.5 | 16.42 | 16.46 | 153900.0 |
| 2006-05-24 | CIL | ETF | 25.9 | 25.95 | 25.9 | 25.92 | 10000.0 |
| 2006-05-24 | CN | ETF | 31.45 | 31.59 | 30.7 | 31.3 | 58200.0 |
| 2006-05-24 | CNXT | ETF | 3.13 | 3.16 | 2.87 | 2.91 | 30830711.0 |
| 2006-05-24 | COMB | ETF | 10.0 | 10.0 | 9.75 | 9.75 | 13635.0 |
| 2006-05-24 | CPI | ETF | 31.1 | 31.1 | 31.1 | 31.1 | 500.0 |
| 2006-05-24 | CPST | ETF | 2.95 | 3.59 | 2.85 | 3.36 | 7153952.0 |
| 2006-05-24 | CSA | ETF | 18.65 | 18.69 | 18.24 | 18.4 | 4800.0 |
| 2006-05-24 | CSB | ETF | 29.4 | 29.54 | 29.14 | 29.44 | 8800.0 |
| 2006-05-24 | CSQ | ETF | 13.78 | 13.78 | 13.51 | 13.67 | 387800.0 |
| 2006-05-24 | CTEC | ETF | 64.19999999999999 | 65.7 | 63.699999999999996 | 64.6 | 35196.4 |
| 2006-05-24 | CYB | ETF | 5.75 | 5.77 | 5.51 | 5.77 | 105800.0 |
| 2006-05-24 | DBC | ETF | 25.73 | 25.81 | 25.25 | 25.36 | 402700.0 |
| 2006-05-24 | DGT | ETF | 66.72 | 66.72 | 66.25 | 66.6 | 800.0 |
| 2006-05-24 | DIG | ETF | 17.7625 | 17.7625 | 17.5875 | 17.5875 | 8080.0 |
| 2006-05-24 | DIV | ETF | 11.65 | 11.73 | 11.64 | 11.73 | 11600.0 |
| 2006-05-24 | DRIV | ETF | 45.22 | 46.57 | 44.25 | 46.1 | 763020.0 |
| 2006-05-24 | DSI | ETF | 6.35 | 6.395 | 6.35 | 6.395 | 21200.0 |
> showing 50 of 325 rows — these rows as CSV