PREVIEW / etf_daily / 2024-06-07
file: by_date/etf_daily/2024/2024-06-07.parquet size: 120 KB rows: 3,369
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 |
|---|---|---|---|---|---|---|---|
| 2024-06-07 | SPY | ETF | 533.66 | 536.89 | 532.54 | 534.01 | 43224500.0 |
| 2024-06-07 | QQQ | ETF | 463.0 | 465.74 | 461.84 | 462.96 | 25829720.0 |
| 2024-06-07 | IWM | ETF | 201.53 | 203.17 | 200.68 | 201.2 | 26036000.0 |
| 2024-06-07 | DIA | ETF | 388.88 | 391.62 | 387.89 | 388.49 | 1952000.0 |
| 2024-06-07 | GLD | ETF | 215.07 | 215.19 | 211.54 | 211.6 | 12195100.0 |
| 2024-06-07 | TLT | ETF | 91.83 | 91.83 | 91.4 | 91.5 | 35240500.0 |
| 2024-06-07 | AAA | ETF | 25.07 | 25.1 | 25.052 | 25.075 | 5400.0 |
| 2024-06-07 | AAAU | ETF | 23.02 | 23.02 | 22.64 | 22.64 | 3698000.0 |
| 2024-06-07 | AADR | ETF | 63.36 | 63.36 | 63.3 | 63.3 | 300.0 |
| 2024-06-07 | AAPB | ETF | 21.96 | 22.47 | 21.8515 | 22.47 | 189536.0 |
| 2024-06-07 | AAPD | ETF | 20.01 | 20.07 | 19.8 | 19.81 | 139866.0 |
| 2024-06-07 | AAPR | ETF | 25.03 | 25.06 | 24.95 | 24.95 | 55666.0 |
| 2024-06-07 | AAPU | ETF | 28.34 | 29.0 | 28.19 | 29.0 | 625109.0 |
| 2024-06-07 | AAPX | ETF | 25.83 | 26.2 | 25.49 | 26.13 | 23625.0 |
| 2024-06-07 | AAPY | ETF | 25.561 | 25.767 | 25.56 | 25.767 | 283.0 |
| 2024-06-07 | AAXJ | ETF | 71.42 | 71.53 | 71.01 | 71.15 | 286200.0 |
| 2024-06-07 | ABCS | ETF | 26.24 | 26.24 | 26.2 | 26.21 | 1725.0 |
| 2024-06-07 | ABEQ | ETF | 30.39 | 30.44 | 30.306 | 30.306 | 5900.0 |
| 2024-06-07 | ACES | ETF | 30.96 | 31.29 | 30.5 | 30.63 | 103200.0 |
| 2024-06-07 | ACIO | ETF | 36.85 | 37.0 | 36.812 | 36.86 | 86700.0 |
| 2024-06-07 | ACSI | ETF | 54.058 | 54.058 | 54.058 | 54.058 | 100.0 |
| 2024-06-07 | ACT | ETF | 29.84 | 30.08 | 29.655 | 29.85 | 176338.0 |
| 2024-06-07 | ACTV | ETF | 32.8 | 32.8 | 32.59 | 32.64 | 9700.0 |
| 2024-06-07 | ACVF | ETF | 40.355 | 40.63 | 40.355 | 40.44 | 3300.0 |
| 2024-06-07 | ACWF | ETF | 42.17 | 42.29 | 42.08 | 42.08 | 10522.0 |
| 2024-06-07 | ACWI | ETF | 112.41 | 112.55 | 111.9 | 111.98 | 2217600.0 |
| 2024-06-07 | ACWV | ETF | 105.28 | 105.54 | 104.92 | 105.01 | 87500.0 |
| 2024-06-07 | ACWX | ETF | 54.5 | 54.56 | 54.19 | 54.25 | 688900.0 |
| 2024-06-07 | ADFI | ETF | 8.45 | 8.48 | 8.45 | 8.48 | 4600.0 |
| 2024-06-07 | ADIV | ETF | 14.706 | 14.706 | 14.704 | 14.704 | 300.0 |
| 2024-06-07 | ADME | ETF | 42.75 | 42.84 | 42.735 | 42.75 | 5200.0 |
| 2024-06-07 | ADVE | ETF | 32.84 | 32.8597 | 32.7582 | 32.7582 | 460.0 |
| 2024-06-07 | AEMB | ETF | 38.195 | 38.195 | 38.195 | 38.195 | 100.0 |
| 2024-06-07 | AESR | ETF | 16.01 | 16.07 | 15.93 | 16.009 | 6100.0 |
| 2024-06-07 | AETH | ETF | 49.82 | 50.04 | 47.72 | 48.2723 | 6467.0 |
| 2024-06-07 | AFIF | ETF | 9.06 | 9.14 | 9.06 | 9.14 | 3900.0 |
| 2024-06-07 | AFK | ETF | 15.7 | 15.72 | 15.4 | 15.5 | 21000.0 |
| 2024-06-07 | AFLG | ETF | 31.061 | 31.16 | 31.061 | 31.129 | 900.0 |
| 2024-06-07 | AFMC | ETF | 29.151 | 29.151 | 29.151 | 29.151 | 200.0 |
| 2024-06-07 | AFSM | ETF | 28.47 | 28.47 | 28.3 | 28.3 | 500.0 |
| 2024-06-07 | AFTY | ETF | 14.35 | 14.35 | 14.3 | 14.3 | 300.0 |
| 2024-06-07 | AGG | ETF | 96.82 | 96.82 | 96.62 | 96.62 | 5365000.0 |
| 2024-06-07 | AGGH | ETF | 20.9 | 20.9 | 20.825 | 20.9 | 70977.0 |
| 2024-06-07 | AGGS | ETF | 40.765 | 40.765 | 40.7235 | 40.7235 | 480.0 |
| 2024-06-07 | AGGY | ETF | 43.0 | 43.01 | 42.95 | 42.98 | 48200.0 |
| 2024-06-07 | AGMI | ETF | 26.84 | 26.84 | 25.8 | 25.8256 | 1857.0 |
| 2024-06-07 | AGNG | ETF | 30.29 | 30.369 | 30.26 | 30.31 | 4400.0 |
| 2024-06-07 | AGOX | ETF | 27.05 | 27.19 | 26.96 | 27.025 | 11400.0 |
| 2024-06-07 | AGQ | ETF | 39.63 | 39.67 | 37.58 | 37.76 | 3485600.0 |
| 2024-06-07 | AGQI | ETF | 14.46 | 14.5 | 14.42 | 14.4247 | 21428.0 |
> showing 50 of 3,369 rows — these rows as CSV