PREVIEW / etf_daily / 2006-01-25
file: by_date/etf_daily/2006/2006-01-25.parquet size: 16 KB rows: 303
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-01-25 | SPY | ETF | 127.04 | 127.18 | 125.84 | 126.66 | 87747700.0 |
| 2006-01-25 | QQQ | ETF | 41.64 | 41.67 | 41.08 | 41.26 | 99830921.0 |
| 2006-01-25 | IWM | ETF | 71.39 | 71.6 | 70.77 | 71.38 | 32586600.0 |
| 2006-01-25 | DIA | ETF | 107.28 | 107.52 | 106.6 | 107.15 | 9525900.0 |
| 2006-01-25 | GLD | ETF | 56.22 | 56.53 | 55.74 | 56.14 | 10005200.0 |
| 2006-01-25 | TLT | ETF | 91.51 | 91.57 | 90.79 | 90.9 | 1204500.0 |
| 2006-01-25 | AAA | ETF | 54.9 | 55.02 | 54.68 | 54.8 | 1500.0 |
| 2006-01-25 | ADRE | ETF | 127.0 | 127.36 | 125.504 | 125.7 | 53508.0 |
| 2006-01-25 | AFK | ETF | 25.35 | 25.43 | 25.33 | 25.34 | 6000.0 |
| 2006-01-25 | AGG | ETF | 100.93 | 100.93 | 100.4 | 100.68 | 162600.0 |
| 2006-01-25 | AIQ | ETF | 25.0 | 25.0 | 23.8 | 24.8 | 15260.0 |
| 2006-01-25 | AIS | ETF | 1.57 | 1.59 | 1.5 | 1.51 | 309900.0 |
| 2006-01-25 | AOM | ETF | 5.56 | 5.77 | 5.54 | 5.77 | 22600.0 |
| 2006-01-25 | ARB | ETF | 40.15 | 40.2 | 39.4 | 39.55 | 314600.0 |
| 2006-01-25 | BAB | ETF | 56.95 | 57.32 | 56.79 | 57.2 | 24800.0 |
| 2006-01-25 | BBC | ETF | 19.0 | 19.95 | 18.0 | 18.2 | 375900.0 |
| 2006-01-25 | BBH | ETF | 65.2633 | 65.4267 | 64.7667 | 64.8667 | 1335600.0 |
| 2006-01-25 | BCM | ETF | 68.15 | 68.6 | 67.85 | 68.07 | 23900.0 |
| 2006-01-25 | BITS | ETF | 15.08 | 15.56 | 15.08 | 15.56 | 2460.0 |
| 2006-01-25 | BKF | ETF | 13.25 | 13.83 | 12.66 | 13.75 | 136400.0 |
| 2006-01-25 | BNE | ETF | 14.68 | 14.75 | 14.64 | 14.72 | 138200.0 |
| 2006-01-25 | BOSS | ETF | 30.0 | 33.08 | 30.0 | 33.08 | 100.0 |
| 2006-01-25 | BRF | ETF | 15.41 | 15.41 | 15.34 | 15.34 | 1500.0 |
| 2006-01-25 | BTF | ETF | 85.1 | 85.1 | 84.30699999999999 | 84.94999999999999 | 6540.0 |
| 2006-01-25 | CBON | ETF | 31.27 | 31.45 | 30.21 | 30.37 | 15544.0 |
| 2006-01-25 | CDL | ETF | 12.3 | 12.32 | 11.94 | 12.0 | 3272800.0 |
| 2006-01-25 | CEF | ETF | 7.26 | 7.33 | 7.23 | 7.26 | 522400.0 |
| 2006-01-25 | CEW | ETF | 26.25 | 26.25 | 26.25 | 26.25 | 100.0 |
| 2006-01-25 | CFO | ETF | 10.07 | 10.2 | 10.06 | 10.1 | 10400.0 |
| 2006-01-25 | CGO | ETF | 14.3 | 14.3 | 14.05 | 14.3 | 42900.0 |
| 2006-01-25 | CHB | ETF | 13.67 | 13.71 | 13.3 | 13.55 | 556300.0 |
| 2006-01-25 | CHI | ETF | 20.26 | 20.49 | 20.26 | 20.42 | 110800.0 |
| 2006-01-25 | CHIC | ETF | 15.76 | 16.28 | 15.66 | 16.19 | 997577.0 |
| 2006-01-25 | CHIR | ETF | 44.67 | 44.73 | 44.64 | 44.7099 | 744430.0 |
| 2006-01-25 | CHY | ETF | 16.17 | 16.37 | 16.17 | 16.31 | 103500.0 |
| 2006-01-25 | CIZ | ETF | 23.75 | 24.05 | 23.45 | 24.05 | 11700.0 |
| 2006-01-25 | CN | ETF | 33.86 | 33.95 | 33.6 | 33.8 | 26400.0 |
| 2006-01-25 | CNXT | ETF | 3.37 | 3.401 | 3.2 | 3.27 | 27053228.0 |
| 2006-01-25 | COMB | ETF | 8.3527 | 8.3527 | 8.3527 | 8.3527 | 125.0 |
| 2006-01-25 | CPI | ETF | 30.1 | 30.1 | 30.1 | 30.1 | 600.0 |
| 2006-01-25 | CPST | ETF | 3.78 | 3.8 | 3.5 | 3.56 | 3858848.0 |
| 2006-01-25 | CSA | ETF | 17.75 | 17.94 | 17.75 | 17.94 | 4800.0 |
| 2006-01-25 | CSB | ETF | 32.77 | 32.77 | 32.46 | 32.52 | 3300.0 |
| 2006-01-25 | CSM | ETF | 2.4675 | 2.4675 | 2.4675 | 2.4675 | 400.0 |
| 2006-01-25 | CSQ | ETF | 13.92 | 13.99 | 13.84 | 13.88 | 356000.0 |
| 2006-01-25 | CTEC | ETF | 54.74999999999999 | 55.3 | 52.24999999999999 | 53.349999999999994 | 43591.8 |
| 2006-01-25 | CURE | ETF | 0.0338 | 0.035 | 0.0336 | 0.0338 | 868312.0 |
| 2006-01-25 | CYB | ETF | 4.26 | 4.4 | 4.26 | 4.37 | 22700.0 |
| 2006-01-25 | DGT | ETF | 65.83 | 65.83 | 65.58 | 65.7 | 1300.0 |
| 2006-01-25 | DIG | ETF | 17.1875 | 17.1875 | 17.1125 | 17.1875 | 2960.0 |
> showing 50 of 303 rows — these rows as CSV